… Handler_read_key 508833 623738 622184 508913 507516 Handler_read_next 574320 574320 572889 574320 572889 Handler_read_rnd_next 136077 136094 136366 136163 136435 Innodb_buffer_pool_read_ahead 0 20920 23669 20920 23734 Innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… 1790641 1805995 Handler_read_next 2651500 2628103 2586036 2628103 2592816 2615612 Handler_read_rnd_next 23078 22780 22757 22867 23049 23221 Innodb_buffer_pool_read_ahead 1152 23231 130919 23228 130731 131497 Innodb_buffer_pool_read_requests…
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: What does Handler_read_rnd mean?
June 15, 2010 By 15 Comments
… was called the handler API, which is why the variables begin with Handler_. Handler_read_rnd counts the number of times the handler::rnd_pos() method is… the file. For InnoDB, it means to read a row based on a primary key value. Handler_read_rnd_next is incremented when handler::rnd_next() is…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Handler_prepareblogpercona.commanual Handler_read_firstblogpercona.commanual Handler_read_keyblogpercona.commanual Handler_read_lastblogpercona.commanual Handler_read_nextblogpercona.commanual Handler_read_prevblogpercona.commanual Handler_read_rndblogpercona.commanual Handler_read_rnd…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…Handler_commit’, ’19092941′ ‘Handler_delete’, ’0′ ‘Handler_discover’, ’0′ ‘Handler_read_first’, ’1100773′ ‘Handler_read_key’, ’2491307870′ ‘Handler_read_next’, ’1266206297′ ‘Handler_read_prev’, ’0′ ‘Handler_read_rnd‘, ’234159075′ ‘Handler_read_rnd_next’, ’2358572961′ ‘Handler…
Comment: How much memory can MySQL use in the worst case?
February 19, 2009 By 17 Comments
… are a few: Innodb_buffer_pool_reads 12 Handler_read_rnd 2,448 k(this increases steady as the server runs) Handler_read_rnd_next 105 M(this… i optimize the config for the server some….maybe use InnoDB since the database is 3NF and uses alot of selects…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 139 Comments
… select query with ORDER BY, LIMIT and with paging — Handler_read_rnd 12 M Handler_read_rnd_next 4,483 M Created_tmp_disk_tables 5…_tmp_tables 5,274 Created_tmp_files 37 k Key_reads 4,226 Key_write_requests 380 k Key_writes 367… configs? – do i switch table from MyISAM to InnoDB (if yes, how to configure InnoDB for best performance?) – what parameters i need…
