…’ve seen situations where even under just a moderate load on the host system, DRBD can end up in … brewing. Or if you watch your MySQL server’s memory usage and you see that it’s starting to …up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
… with mysqldump, final size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY_BLOCK_SIZE=8 and to test fast… file for (case 1) – 43032M What if load data and indexes separately: load dump into table with default format and without indexes (case… conclusion – Fast Index creation allows to speedup load 2 times (even indexes fit into memory) – Load in compress format slower by 30-50% – Table…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… a good use for that memory anyway. Another thing you should keep into account is Innodb allocates more memory in structures related to buffer… can vary significantly depending on the load. Idle connections for example will consume significantly less memory than connections doing work with huge…
Post: Quickly preloading Innodb tables in the buffer pool
May 1, 2008 By 9 Comments
… the hacks 
So As I mentioned you can load Innodb Table Clustered Index in the buffer pool pretty … tables) but it does not preload indexes in memory neither it does externally stored objects – BLOB and … preload single large table you can chop it into several ranges and preload in parallel, such as…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… dataset does not fit into memory or if the caches are not warm, this also does not take into account locality of access… when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to… were already loaded in the buffer pool. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… It is well known it is important to load data in primary key order into Innodb tables for optimal performance, but effect does…. Innodb typically needs large innodb_buffer_pool_size and large innodb_log_file_size to perform load effectively Load Options There two main ways to load… indexes in memory) plus we loaded data in parallel and our rows were relatively long. In most cases I would expect load speed…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit… techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is not RLE, …spin a number of instances that evenly divides into 20 for best results. There is a helpful…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… see a “free space” in Innodb tablespace to grow significantly. Q6: Does Innodb policy replacement algorithm takes into account page position in btree… kernel’s buffer pool. In high load situations where INNODB is using most of the system’s memory the kernel can decide (incorrectly…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… do ? Use Innodb Table Instead Innodb is quite fast when it fits in memory so for most….memory_table. Note you should not be using STATEMENT level replication with INSERT … SELECT into this memory…; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run …
