Optimiser mon My.cnf pour un gros forum

Optimiser mon My.cnf pour un gros forum - SQL/NoSQL - Programmation

Marsh Posté le 23-04-2010 à 07:49:23    

Bonjour
Je souhaite optimiser mon my.cnf pour un gros forum phpbb, je dispose d'un serveur puissant avec 4GB de RAM mais je doute fortement que ma conf soit optimisee
 
des conseils?
 

Code :
  1. # The MySQL database server configuration file.
  2. #
  3. # You can copy this to one of:
  4. # - "/etc/mysql/my.cnf" to set global options,
  5. # - "~/.my.cnf" to set user-specific options.
  6. #
  7. # One can use all long options that the program supports.
  8. # Run program with --help to get a list of available options and with
  9. # --print-defaults to see which it would actually understand and use.
  10. #
  11. # For explanations see
  12. # http://dev.mysql.com/doc/mysql/en/ [...] ables.html
  14. # This will be passed to all mysql clients
  15. # It has been reported that passwords should be enclosed with ticks/quotes
  16. # escpecially if they contain "#" chars...
  17. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  18. [client]
  19. port            = 3306
  20. socket          = /var/run/mysqld/mysqld.sock
  22. # Here is entries for some specific programs
  23. # The following values assume you have at least 32M ram
  25. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  26. [mysqld_safe]
  27. socket          = /var/run/mysqld/mysqld.sock
  28. nice            = 0
  30. [mysqld]
  31. #
  32. # * Basic Settings
  33. #
  34. user            = mysql
  35. pid-file        = /var/run/mysqld/mysqld.pid
  36. socket          = /var/run/mysqld/mysqld.sock
  37. port            = 3306
  38. basedir         = /usr
  39. datadir         = /var/lib/mysql
  40. tmpdir          = /tmp
  41. language        = /usr/share/mysql/english
  42. skip-external-locking
  43. #
  44. # Instead of skip-networking the default is now to listen only on
  45. # localhost which is more compatible and is not less secure.
  46. bind-address            = 127.0.0.1
  47. #
  48. # * Fine Tuning
  49. #
  50. key_buffer              = 128M
  51. max_allowed_packet      = 16M
  52. thread_stack            = 128K
  53. thread_cache_size       = 8
  54. # This replaces the startup script and checks MyISAM tables if needed
  55. # the first time they are touched
  56. myisam-recover          = BACKUP
  57. max_connections        = 1100
  58. table_cache            = 400
  59. # This replaces the startup script and checks MyISAM tables if needed
  60. # the first time they are touched
  61. myisam-recover          = BACKUP
  62. max_connections        = 1100
  63. table_cache            = 400
  64. #thread_concurrency     = 10
  65. #
  66. # * Query Cache Configuration
  67. #
  68. query_cache_limit       = 1M
  69. query_cache_size        = 16M
  70. #
  71. # * Logging and Replication
  72. #
  73. # Both location gets rotated by the cronjob.
  74. # Be aware that this log type is a performance killer.
  75. #log            = /var/log/mysql/mysql.log
  76. #
  77. # Error logging goes to syslog. This is a Debian improvement :)
  78. #
  79. # Here you can see queries with especially long duration
  80. #log_slow_queries       = /var/log/mysql/mysql-slow.log
  81. #long_query_time = 2
  82. #log-queries-not-using-indexes
  83. #
  84. # The following can be used as easy to replay backup logs or for replication.
  85. # note: if you are setting up a replication slave, see README.Debian about
  86. #       other settings you may need to change.
  87. #server-id              = 1
  88. #log_bin                        = /var/log/mysql/mysql-bin.log
  89. expire_logs_days        = 10
  90. max_binlog_size         = 100M
  91. #binlog_do_db           = include_database_name
  92. #binlog_ignore_db       = include_database_name
  93. #
  94. # * BerkeleyDB
  95. #
  96. # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
  97. skip-bdb
  98. #
  99. # * InnoDB
  100. #
  101. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  102. # Read the manual for more InnoDB related options. There are many!
  103. # You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
  104. #skip-innodb
  105. #
  106. # * Security Features
  107. #
  108. # Read the manual, too, if you want chroot!
  109. # chroot = /var/lib/mysql/
  110. #
  111. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  112. #
  113. # ssl-ca=/etc/mysql/cacert.pem
  114. # ssl-cert=/etc/mysql/server-cert.pem
  115. # ssl-key=/etc/mysql/server-key.pem
  119. [mysqldump]
  120. quick
  121. quote-names
  122. max_allowed_packet      = 16M
  124. [mysql]
  125. #no-auto-rehash # faster start of mysql but no tab completition
  127. [isamchk]
  128. key_buffer              = 16M
  130. #
  131. # * NDB Cluster
  132. #
  133. # See /usr/share/doc/mysql-server-*/README.Debian for more information.
  134. #
  135. # The following configuration is read by the NDB Data Nodes (ndbd processes)
  136. # not from the NDB Management Nodes (ndb_mgmd processes).
  137. #
  138. # [MYSQL_CLUSTER]
  139. # ndb-connectstring=127.0.0.1
  142. #
  143. # * IMPORTANT: Additional settings that can override those from this file!
  144. #   The files must end with '.cnf', otherwise they'll be ignored.
  145. #
  146. !includedir /etc/mysql/conf.d/


 
Merci d'avance !


---------------
un blog sur Asterisk
Reply

Marsh Posté le 23-04-2010 à 07:49:23   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed