… = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… (max_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128 M Of 21559 temp tables, 44% were created on disk Perhaps you should increase your tmp_table_size and/or max_heap_table_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests… –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… set the max_heap_table_size system variable to impose a maximum size on MEMORY tables. For individual tables, you can also specify a MAX_ROWS table option… “disk-tmp-table-size” introduced to set maximum expected on-disk temporary table size and avoid mix-up of tmp_table_size and max_heap_table_size ChangeSet@1…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… overhead do on disk temporary tables cause compared to MEMORY tables. To have things comparable I used medium size table and types which can…) 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… 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…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…_buffer_size for example) are allocated to their full size immediately as soon as they are needed, but others are effectively a “max size” and the corresponding buffers are allocated only as big as needed (key_buffer_size). There are many… static int 14184 join_init_cache(THD *thd,JOIN_TAB *tables,uint table_count) 14185 { … snip … 14268 cache->length=length+blobs*sizeof…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
…size | page_no | max_size | curr_size | +———+———-+———-+———+————+———–+ | 0 | 0 | 0 | 6 | 4294967294 | 134528 | +———+———-+———-+———+————+———–+ 1 row in set (0.00 sec) The curr_size specifies current size… Innodb table at that…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual 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_length…
