…let’s come to the MySQL configuration. MySQL Configuration I used Percona Server…buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer… why I have chosen to show “millions of rows” on the…indexes. While secondary indexes cause read performance to improve, but they…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…a new one. (If I read your graph correctly, you …pretty efficiently. With a 55GB buffer pool, we would expect … a newer version of iiBench showed that with 16GB of RAM… memory wall. Given that Memory sizes are perhaps 10 times …http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…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…can with default buffer size of 256K, MariaDB 5.5 shows that Handler_mrr_rowid_refills = 1, which means the buffer is small and…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
….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… shown by the high numbers of Innodb_buffer_pool_read_ahead when the buffers are sized appropriately, which shows that the IO access pattern has…
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
…ve discovered even read_buffer_size selection may be less than obvious. What do we generally hear about read_buffer_size tuning ? If you…things out I’ve created table with simple structure: mysql> show create table dt2 \G *************************** 1. row *************************** Table: dt2 …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…read_buffer_sizeblogpercona.commanual read_onlyblogpercona.commanual read_rnd_buffer…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
…fact read_buffer_size variable affects connection speed…show. Mmap allocation process can be split to two parts – first is finding the free region of required size…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…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…shows that accesses to the fields of buf_pool->stat are unprotected. These are buffer pool statistics counters: number of read… a previous read of size 8 by thread…show_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status_var*, char const*, st_table*, bool, Item*) (sql_show…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. …0 partition=ON port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_…
