…Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size…tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306… –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report…–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
…@ted.mysql.internal +6 -0 BUG #4291 fix: new configuration 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…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… you want to run workers on them. Generate a cluster configuration There is a script provided to generate the shards.ini…_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: 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… intensive workload will do a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…-bit OS. Examining MySQL configuration Then I’…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
… you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so… 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… single chunk at once others, for example tmp_table_size is rather maximum amount of memory MySQL will allocate for this operation. Note it…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… available. The configuration Tom compares …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…tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have …_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = …
