…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: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-demo i686 ICE 3.5.2pl1 32bit. Requires m1.small or greater. snap-…mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size…table innodb-write-io-threads=4 join-buffer-size=16M key-buffer-size=64M local-infile=on lock-…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… MyISAM storage engine. The benchmarks are done with MySQL 5.0.45 on 32bit Fedora Core 6 on Pentium 4 box – something… default key_buffer_size which is not large enough to fit all key blocks from temporary table index, so we get a lot of key… same queries: mysql> set global key_buffer_size=8000000; Query OK, 0 rows affected (0.03 sec) mysql> set global max_heap_table_size=1000000000; Query…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…are any restrictions on Innodb Buffer Size you can use. Typically you would see restriction applying only on 32bit systems but we …System needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be …
Comment: Percona build7 with latest patches
November 20, 2008 By 26 Comments
… current conf: (for MySQL 32bit) [mysqld] max_connections=2000 key_buffer_size=200M low_priority_updates=1 table_cache = 8000 sort_buffer_size = 2097152 innodb_file_per_table innodb_log_file_size=500M innodb_buffer_pool_size…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… We still see people running 32bit Linux on 64bit capable…MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer_pool_size…good performance innodb_log_buffer_size=4M 4M is …key, having primary key in all indexes (so keep primary key short), fast lookups by primary keys…
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
…when data size is small enough to fit in memory and so buffer pool. I tested very simple table, having with about 20.000 rows in it on 32bit…pad` char(8) default NULL, PRIMARY KEY (`id`), KEY `i` (`i`), KEY `c` (`c`) ) ENGINE=…so there is no need for MySQL to request next row matching index…
