…my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query… : 11 cpu MHz : 1995.022 cache size : 4096 KB physical id : 1 siblings…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…_query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql |…my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql…cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… production servers, with powerful hardware and heavy query workloads. Both have a key_buffer_size of 4GB. Now can you tell which… multiple key caches. But I’ll give the simple version here. In my opinion, you should choose a key_buffer_size that is… authoritative — the “key cache hit ratio.” This is a shame. When you are new to MySQL, trying to configure my.cnf, and you have…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA…_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld/mysqld.sock innodb_…= 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… in normal operation. query_cache_size If your application is read intensive and you do not have application level caches this can be great… workload specific. If you have simple queries there is no reason to increase sort_buffer_size even if you have 64GB of… I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…size). There are many examples of this. What about join_buffer_size? I saw a my.cnf with a 128M join_buffer_size…size, cache->length); 14272 if (!(cache->buff=(uchar*) my_malloc(size,MYF(0)))) 14273 DBUG_RETURN(1); /* Don’t use cache */ /* purecov: inspected */ 14274 cache->end=cache->buff+size…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…expect to deliver huge wins. If MySQL is actually badly configured, you … the InnoDB buffer pool size or log file size, and not using InnoDB… include what happens when you have query cache contention, DNS problems, or very slow…at your my.cnf file. It’s sometimes possible to look at the my.cnf …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific…long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size = 2000M…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… newbie to MySQL and am not getting the high insert throughput as in this benchmark. Could you post the my.cnf file used…_connections=100 query_cache_size=0 table_cache=256 tmp_table_size=93M thread_cache_size=8 #*** MyISAM Specific options myisam_max_sort_file_size=100G myisam_max…
