…in-…how…to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql…cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache…settings out-of-box, but I am ready to…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…how often you write to…cached, as opposed to a single table, where probably only recently read records will be cached, resulting in…Mysql can fire off one thread per partition (at least I have seen this happen in a MyIsam environment on similar sized…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…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…how to align files properly. 4. Partition table and file system properly aligned; sunit/swidth set…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to provide any reasonable answer to… growth of Threads_Created variable I boost it higher. The goal is not to have threads created in normal operation. query_cache_size If …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…in most cases you do not know where exactly memory is allocated. This was not much of the problem in MySQL…Threads 425080 (406936 + 18144) Dictionary memory allocated 2623331 Buffer pool size 7864319 Buffer pool size…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…to periodically go through battery learning cycle which switches RAID cache in…to be longer, because it has to happen in the single thread. In…in data size can be the difference between slave never lags and slave never is able to catch up. MySQL…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
…to set it to 1000 or even higher. You may also need to increase net.core.somaxconn kernel setting…thread or take one out of the thread cache. From this point on MySQL processes network communication in multiple threads…sizing your tcp_max_syn_backlog and back_log value to…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…to ease hardware evaluation for things which are important for MySQL. To prepare small 128MB single file working set…in controller cache and flushed to the disk in background – in this case there is little difference if we use one thread or multiple threads…
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…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…
