… I believe everyone felt the energy and enthusiasm. The positive comments on the Internet certainly seem to point that direction: Florian… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… revenue, c_acctbal, n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_custkey = o_custkey…_name, c_acctbal, c_phone, n_name, c_address, c_comment order by revenue desc LIMIT 20; In-memory workload Now… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M…
Post: Give feedback on a pt-online-schema-change update
March 14, 2012 By 2 Comments
… the newly rewritten pt-table-checksum. If you have any comments on it, please write to the mailing list with your…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn…, thanks for your help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on… last year; shortly after Oracle took it over. Can you comment on why this is happenign, and if it is happening…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 6 Comments
… above comment was written long time ago, when I was just hired at MySQL. The assumptions about what are typical MySQL may have… – 7! = 5040, while 8! = 40320. The worst-case complexity of MySQL‘s join optimizer is N!. The goal of this choice… the potential pitfalls with the change to plan pruning in MySQL 5.6. Ideally, the server should analyze the query and…
Comment: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
… matter look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list will… of your post. In the second event I find your comments rather disingenuous. Do you pay license fees for your operating…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 23, 2012 By 9 Comments
1. Percona Toolkit works for all flavors of MySQL. 2. I am the lead author of the second and … Something Wrong, but that is not a topic for this comment thread. You could try our forum or consulting/support services…
Comment: MariaDB 5.3 is released as GA!
March 13, 2012 By 17 Comments
… known for killing others softwares. They may not have killed MySQL completely at the moment, but it will happen someday in… way or another… Like said by others people in the comments : what is this private bug tracker things ? Don’t you…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
….00 sec) mysql> select count(*) from fact where val like “%c%”; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> /* comment*/ select count(*) from fact where val like “%c%”; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> /* another comment */ select…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is …different developers. Supporting different comments is especially important as many application put extra information in the comments to assist diagnosing the application…
