…performance for FlashCache vs. vCache with a 10% dirty threshold versus the same metrics at a 50% dirty threshold. Time-…size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…, you are generally bound by either the working set size versus the buffer pool size, or the sheer volume of I/O activity you… to EBS, even if the working set size is not larger than the buffer pool size. As a result, if you’re going…. But I need to at least mention the existence of key advantages at the technical level. These include EBS volume snapshots…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…many pages were read from disk versus how many page requests their were: …* POOL_ID: 0 POOL_SIZE: 8192 * POOL_SIZE: 8191 FREE_BUFFERS: 1024 * FREE_BUFFERS: 1024 DATABASE_PAGES: 7163…(10), KEY(LO_OrderKey, LO_LineNumber), KEY(LO_CustKey), KEY(LO_SuppKey), KEY(LO_PartKey), KEY(LO_OrderDateKey), KEY…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… is the importance of the size of the buffer used for sorting the secondary key tuples. If the buffer size is large enough only a… is the combined size of the secondary key tuples fetched, and N is the buffer size. In MySQL 5.6 the buffer size used by MRR… at random locations versus memory access at sequential locations. In fact there is extra cost added by the buffering step introduced by…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
….805849 | | restoring secondary keys | 53.885502 | . . . +——————————+———–+ 19 rows in set (0.00 sec) So, as expected, a small buffer pool had a… about 178 MB index size after fast index creation as reported by SHOW TABLE STATUS versus 265 MB index size with the optimization…
Comment: What to tune in MySQL Server after installation
October 23, 2006 By 118 Comments
… reviewed to iteratively tune this parameters. For instance, INNODB_BUFFER_POOL_SIZE… how can I evaluate hit ratios to determine if this… it’s from this, versus from disk sorts, or myISAM queries not using the query cache and key cache? I’ve noticed… tool you can see hit ratios for query cache and key cache in myISAM. Are there underlying sql commands I can…
