… Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5…. innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_…using secondary indexes. While secondary indexes cause read performance to improve, but they have …
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11… mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…starting a new one. (If I read your graph correctly, you didn’t…-tree pretty efficiently. With a 55GB buffer pool, we would expect the primary… a memory wall. Given that Memory sizes are perhaps 10 times bigger than…wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… compared to MySQL 5.5 While with join_buffer_size set to 6M and read_rnd_buffer_size set to 6M, the query time for MySQL 5… Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… N is the buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by the variable read_rnd_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… I’ve discovered even read_buffer_size selection may be less than obvious. What do we generally hear about read_buffer_size tuning ? If you want… value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having… performanceread_buffer_sizeTime (sec)820045.216K44.832K45.664K43.4128K43.0256K51.9512K60.82M65.28M66.832M67.2 8200 bytes is the minimum size for read_buffer_size…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…constantly referring to the amazing MySQL manual, especially the option and variable reference table. ….commanual range_alloc_block_sizeblogpercona.commanual read_buffer_sizeblogpercona.commanual read_onlyblogpercona.commanual read_rnd_buffer_sizeblogpercona.commanual relay_logblogpercona.commanual …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… for documentation for read_rnd_buffer_size you would find descriptions such as “The read_rnd_buffer_size is used after a sort, when reading rows in… had name very similar to read_buffer_size which is currently only used by MyISAM tables I thought read_rnd_buffer_size is also MyISAM only… length can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer to optimize data retrieval – As data…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
Monty Taylor posted interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would … read buffers in the pool you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size…
