Catégorie : my.cnf values

Solution : mettre read_buffer_size à 1

Pour table_cache, on peut compter 512 octets par table.

http://www.linuxweblog.com/tune-my.cnf Had to do some fine tuning of MySQL 4.1.9 and here is what my.cnf file looks like for a 2GHz machine with 1GB of memory. [mysqld] socket=/path/to/mysql.sock datadir=/var/lib/mysql skip-locking skip-innodb # MySQL 4.x has query caching available. # Enable it for vast improvement and it may be all you need to tweak. query_cache_type=1 query_cache_limit=1M…

The thread cache hit rate can be calculated with Threads_created/Connections. Ideally you want the threads cached to be able to handle all connections. So a stable (zero growth) or low Threads_created status variable is the goal. Depending on your specific situation, in some case this value can be very high (like 150+). For an idea…

thread_concurrency should follow: number of CPU’s*2 for thread_concurrency thread_concurrency -> the number of processes which will run AT SAME TIME. In all modern OSs possible to run a lot of tasks simultaneously. But in real one processor will perform ONE task at once but very frequently switch between tasks. If you have few CPUs it…