… we have mysql> set max_heap_table_size=1000000000; Query OK, 0 rows affected (0.00 sec) mysql> set tmp_table_size=1000000000; Query OK, 0… on Linux Performance of Disk MyISAM tables may not scale proportionally with table size, even when all data fits in memory MEMORY temporary tables can…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… current performance, future performance, …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: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_connect_errorsblogpercona.commanual max_connectionsblogpercona.commanual max_delayed_threadsblogpercona.commanual max_error_countblogpercona.commanual max_heap_table_sizeblogpercona.commanual max_insert_delayed_threadsblogpercona.commanual max_join_sizeblogpercona.commanual max…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…=100 table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M…log for a little bit lless of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without restricting…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… and even though there is max_heap_table_size to restrict size of each table total size is unrestricted. Note you can create tables as TEMPORARY so they… to ALTER 100 different tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size… Neither IO alignment nor file size made any difference. Adding LVM here reduced single-thread performance by 5-10%. …
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max_connect… (mysqlhotcopy is not available, for instance) and eking performance out of an InnoDB table for raw SELECT speed will take a committee…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table… next step, read detailed investigation what is the reason of performance drop in next post. And last one workload I tried…
Comment: Choosing innodb_buffer_pool_size
March 30, 2010 By 38 Comments
… to adjust: max_connections (> 100) wait_timeout (< 28800) interactive_timeout ( 64M) tmp_table_size (> 128M) max_heap_table_size (> 128M) innodb_buffer_pool_size (>= 123G) The … the innodb_buffer_pool_size more than the memory on the system. Any thoughts to increase performance/decrease disk I/…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 27, 2008 By 34 Comments
… & slow query log enabled, max_used_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 and have improved performance…
