…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb…_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…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 = …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL (configuration A, listed at the…_stack = 192K tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…default_storage_engineblogpercona.commanual default_time_zoneblogpercona.commanual default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual defaults…commanual tmp_table_…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…defaults –verbose –help … timed-mutexes FALSE tmp-table-size 16777216 tmpdir /tmp transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size…
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…_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been increased…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…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… for default users in the mysql.* tables,…
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….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…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… single chunk at once others, for example tmp_table_size is rather maximum amount of memory MySQL will allocate for this operation. Note it… ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. For OLTP applications with simple queries memory consumption is often less than 1MB per thread with default…
