…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
…_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-slow… this is default value I believe there was attempt to enable it and it did not make things better. max_heap_table_size=200M – I…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… – Each server side can hold value up to max_allowed_packet in size (1M by default) but there does not seems to be… as max_heap_table_size or max_prepared_stmt_count are designed to protect from typical application mistakes not from someone intentionally trying to bring MySQL…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… the query with default key_buffer_size which is not large enough to fit all key blocks from temporary table index, so we… (0.03 sec) mysql> set global max_heap_table_size=1000000000; Query OK, 0 rows affected (0.00 sec) mysql> set global tmp_table_size=1000000000; Query OK… 1M rows 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…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… (which are used by default) have to live in …not different MySQL configurations, I didn’t try out different MySQL versions …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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…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…checking for default users in the mysql.* tables, …
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…DEFAULT CHARSET=utf8 CNF ——- [mysqld] socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size…/lib/mysql/astdb01.as.osti.local-slow.log log-warnings=2 max_connect_errors=1000 max_connections=1000 max_heap_table_size=1073741824 …
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table…
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_…buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-…
