…how well your tables and indexes fit to buffer pool…innodb_buffer_pool_pages_index GROUP BY index_id) bp JOIN innodb_sys_indexes ON id = index_id JOIN innodb_sys_tables ON table_id = innodb_sys_tables…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…readers a little bit. This fits well with our philosophy of … keeping in touch with what the lead consultant does. We…in big units, so it’s hard to read. If the InnoDB buffer pool… Almighty Percona, here’s your money” in reply. If the client…the query or the table. We explain how to interpret what …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes in…Innodb on Solaris? HT: Yes, if your ‘write working set’ fits in 16 GB. I mean, if the database buffer pool can buffer…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…how effective is MRR when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool…InnoDB buffer pool size is set to 1G and the buffer pool was not warmed up, so that it does…in the table above you can with default buffer…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…innodb_buffer_pool_size and large innodb_log_file_size to perform load effectively Load Options There two main ways to load data in…in single table was taking a week due to amount of indexes and the fact they poorly fit in…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
…buffer or Innodb innodb_buffer_pool it does not really matter. In both cases trying to come up with constant “good” hit rate is looking for trouble. Well…table scan and you have 100 rows per page you will get 1 miss per page and 99 hits, making your…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…Innodb tables which makes it 200MB in total which easily fits in buffer pool. Fitting of the working set in buffer…your durability requirements this is best thing to do if not you would either use MyISAM table as counter table (can well…tables for this purpose, how do you deal with Table Locks in…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…buffer pool size of 1G, while benchmark on in-memory workload was performed with a buffer pool…how the joins perform for each test case. Test Case A – Join a small table that fits in memory to a large table…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… up a row in another table based on a text… everyone how do you maintain your performance in the …Innodb with a 256M buffer pool, or roughly with 9% of the total data in…and lean and performs well. The issue is… Cassandra. My Application does the following: A.)… No matter how much you want it to fit, …
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
…well possible to see limited gains – if your working set already fits in…in buffer pool so they start to compete on hot latches and performance go down. Now back to original question – how…table. Having such workload you would likely see no IO and a lot of CPU idle and not because of internal Innodb…
