… = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size… good settings out-of-box, but I am ready to tune something if there are suggestions.
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… I bet the over vendors do the same thing of tuning database options for benchmark rather than running production reasonable options… MEMORY tables use in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table in its own…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… any level of tuning, from completely untuned …tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… such as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory… are allocated as single chunk at once others, for example tmp_table_size is rather maximum amount of memory MySQL will allocate for… own per thread or global memory allocations which are not tuned as buffers. Watch for these especially now with many storage…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 27, 2008 By 34 Comments
No one ever said tuning-primer.sh was supposed to be the “ultimate” tuning tool. It’s a “primer”, to be get… at certain things and not to be followed blindly. My tuning script started out as basically a check list of things…_connections != max_connection, thread_cache not exhausted, tmp_table_size not greater than max_heap_table_size, etc… Some people have had success with it…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_BUFFER_SIZE | 131072 | 262144 | | TMPDIR | /mnt/data/sandboxes/msb_5_5_30/tmp | /mnt/data/sandboxes/msb_5_6_10/tmp | | TABLE_OPEN_CACHE | 400 | 2000 | | INNODB_VERSION | 5.5.30 | 1.2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE… one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON by default. This…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock…=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock… small table PRIMARY KEY (which is what used by benchmark) is not pushed from buffer pool at all. For advanced tuning you…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). I did not use Scale Factor of 40 (InnoDB dataset size… optimizer is choosing the query execution plan, is not sufficiently tuned and it is recommended to turn this off. The query…_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… performance possible. At Percona we surely will be doing fine tuning for our Percona Server for MySQL version 5.6 release… –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num-threads=1 –oltp… phase should not increase with contention. Granted I have not tuned MySQL 5.6 for best performance going with defaults outside…
