… needs to maintain, calculate and update more index statistics DML and even…index might be good for the query execution. Redundant suffixes on clustered index InnoDB uses a clustered index…in previous sections sometimes redundant keys can help us to improve the execution time and decrease the size…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… absence of innodb_log_file_size. I won’t give you a full rundown over every option in the … consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together, and… to improve a lot, and a simple mental calculation can then tell me how much total gain…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…The cache miss rate can be calculated as Key_reads/Key_read_requests….In my opinion, you should choose a key_buffer_size that is large enough to hold your working set — the index…InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…indexes with large key sizes. But we’ll address that soon. No Clustering Index Support Clustered indexes are problematic in…merit in real applications, which hasn’t happened yet. It’s worth noting that InnoDB … Interbase used to checksum pages, but calculating the checksum took about 15% of …
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…any OLTP workloads they have. back_log is calculated based on max_connections. You’re right that…startup. join_buffer_size is bigger to help queries that don’t use indexes and that do use… innodb_purge_batch_size is a performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb…
Post: Announcing Percona Server 5.5.27-29.0
October 11, 2012 By Leave a Comment
…978036 introduced the innodb_sys_stats_root_page debugging option (only present in debug builds), rendering the previously-existing innodb_sys_stats…). Multiple adaptive hash index partitions would cause overly large hash index. Fixed by changing the way partition sizes are calculated initially. Bug …
Comment: Why MySQL could be slow with large tables ?
September 24, 2008 By 141 Comments
… possible in memory, improve index maintanance performance, etc.)? Could it, for example, help to increase “key_buffer_size“? Also, which storage engine (MyISAM?, InnoDB… table to insert to by calculating a hash-value on (id1, id2)? Is there maybe built-in functionality to do such splitting…
