…easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full …cannot consider any one of these factors (schema, queries, indexing) in isolation, because they are tightly bound together, … to improve a lot, and a simple mental calculation can then tell me how much total gain …
Post: Announcing Percona XtraDB Cluster 5.5.27-23.6
September 7, 2012 By Leave a Comment
… Cluster supports tunable buffer size for fast index creation in InnoDB. This value was calculated based on the merge block size (which was hardcoded to 1 MB) and the minimum index record size…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…the manual: The cache miss rate can be calculated as Key_reads/Key_read_requests. [Note: …a key_buffer_size that is large enough to hold your working set — the index blocks that …InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size…
Comment: How to decrease InnoDB shutdown times
May 14, 2009 By 20 Comments
…ADAPTIVE HASH INDEX ————————————- Ibuf: size 4185, free list len 3748, seg size 7934, 65171060 inserts, 65171060 merged recs, 10552858 merges Hash table size …this means that Innodb_buffer_pool_pages_dirty should be 0 and stay at 0. Please note this calculation works most of…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… does this have to do with InnoDB? Data clustering. InnoDB‘s primary keys define the physical … planning. Don’t get fooled into calculating the wrong thing. Be Creative With Table …indexes less than half the size. In real life this technique often makes the table+index much less than half the size…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… on indexes with large key sizes. But we’ll address that soon. No Clustering Index Support Clustered indexes are…t happened yet. It’s worth noting that InnoDB allows a transaction to overwrite changes that… writes Interbase used to checksum pages, but calculating the checksum took about 15% of the…
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
…innodb_persistent_stats_root_page. Bug fixed #1013644 (Laurynas Biveinis). 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
… inserts become really slow. I guess this is due to index maintenance. Therefore, I wonder how I best restructure the DB… memory, improve index maintanance performance, etc.)? Could it, for example, help to increase “key_buffer_size“? Also, which storage engine (MyISAM?, InnoDB?) is… equal structure and select the table to insert to by calculating a hash-value on (id1, id2)? Is there maybe built…
