… as 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.6 becomes approximately equal to that of MySQL 5…
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.6… thing to note is that more read_ahead is done when the buffer size used by MRR, is set to 4M, which obviously means…
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: 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: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…read_buffer_size, read_rnd_buffer_size – Variables used as read buffer for MyISAM tables for Full Table Scan (read_buffer) and for reading rows in sorted order (read_rnd_buffer_size…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-level=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_TRANS…-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… makes it better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my…_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…buffer_size, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL… much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory …read_buffer,sort_buffer, tmp_table_size etc Many variabes can be set…
Post: Are larger buffers always better ?
June 6, 2006 By 9 Comments
… values. read_buffer_size and read_rnd_buffer_size – These are buffers used by MyISAM to perform reads, in different scenarios. So should we go ahead and set them to… 5 MyISAM will allocate the buffer and populate if fully when MySQL will read only 5 rows from the buffer and throw away the…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size…size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size…
