…size = 16M max_heap_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…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or for performance… all storage engines. key_buffer_size Key Buffer used to buffer Index blocks (row …buffer_size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer used to sort result set…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…buffers which are allocated at start and always where – these are key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…SETS_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE…BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql…on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size 70-80% of memory is a safe bet. I set…recovery time and good performance innodb_log_buffer_size=4M 4M is good…key, having primary key in all indexes (so keep primary key short), fast lookups by primary keys…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… cause MySQL to perform slowly or unpredictably. For write-heavy databases, you are generally bound by either the working set size versus the buffer pool size…. But I need to at least mention the existence of key advantages at the technical level. These include EBS volume snapshots…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated that memory to into key_buffer_size…Q: Were these tests performed on a single machine and a common/share set of disk? … Windows partition, and one for the MySQL data partition. I performed all the tests on this …
Post: Query Profiling with MySQL: Bypassing caches
September 12, 2007 By 6 Comments
… clean MySQL table cache (but not Innodb table meta data) or you can do “set global key_buffer_size=0; set global key_buffer_size=DEFAULT” to zero out key buffer… survive longer. Though few of us have SAN available for performance benchmarking 
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…strace) are great tools for MySQL Performance analyses. Too many…buffer is allocated the more pages needs to be set…used for Innodb Buffer Pool and Key Buffer but could …buffers in the pool you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…performance with a buffer pool much larger than the data size, so I configured the server with a 4GB buffer… rows in set (0.00 sec) mysql> select sq.*, pages / ((@@innodb_buffer_pool_size / 16384)) * 100 pct_buffer_pool…(10), KEY(C_Name), KEY(C_City), KEY(C_Region), KEY(C_Phone), KEY(C_MktSegment)…
