… Based on MySQL 5.5.16, including all the bug fixes in it, Percona Server 5.5.16-…a new boolean option, –innodb-blocking-buffer-pool-restore (in 5.1 it is –innodb-blocking…key changes. This unnecessarily delays their creation in a mysqldump output, so –innodb-optimize-keys should ignore foreign key…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14… (Alexey Kopytov). There is no need to scan buffer pool for AHI entries after the B-trees…with –innodb-optimize-keys, it did not handle composite indexes correctly when verifying if the optimization is applicable with…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…key cache for improved scalability That’s really just a sampling. A good starting point for learning more is the MySQL…MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5.5… multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size…buffers etc all need memory. I would put this to 256M for small sized boxes to 5… have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… extra optimizations by optimizer knowing index is UNIQUE the drawback is insert buffer will not …key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary key…depend on application and can range from 5% of total size or less to …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…_64 Percona Server 5.5.11 with XtraDB. …mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer…=4 join-buffer-size=16M key-buffer-size=64M …optimizer-prune-level=0 partition=ON port=3306 read-buffer-size=512K read-rnd-buffer…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…And Application optimization. I call this Innodb Performance Optimization …MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer… in 5.0 and even more to come with MySQL 5….key, having primary key in all indexes (so keep primary key short), fast lookups by primary keys…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… you can tell which page size will be optimal – will allow to get maximum compression while limiting … in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases. Now In MySQL 5.1+ it is also possible to … areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully the patches …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…MySQL versions did not bother naming variables with storage engines prefix. This is why we have key_buffer, not “myisam_key_buffer…often confused. bulk_insert_buffer_size – Used by MyISAM tables only to optimize bulk inserts (multiple … not support it (HEAP/MEMORY). Note in 5.0 you now have very nice …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…and without it with different buffer pool sizes. Results are pretty…of data and index size: mysql> show table status like “sbtest” \G *************************** …which builds table with primary key only when creating a …which rebuilds the table or OPTIMIZE TABLE do not forget … with Percona Server 5.5…
