Thanks for the post. A newbie comment here, I noticed that the inclusion of a function (user defined) in a query excludes it from PROFILES. Any workaround?
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 9, 2012 By 10 Comments
I deleted comment from someone with name “mr unhappy”. The comment did not provide constructive feedback. If you have problem with …
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… above, we were using Linux 2.6.32, as my blog says. We’re now on 2.6.38, and whenever…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… to be turned and still couldn’t beat ext4: http://blog.tsunanet.net/2011/09/ext4-2x-faster-than-xfs.html…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…
Comment: ext4 vs xfs on SSD
April 25, 2012 By 23 Comments
… for a disagreement, I do not often see discussion in comments, but this is what makes it interesting. I am in…
Comment: Working with large data sets in MySQL
March 16, 2012 By 12 Comments
Sheyda, Blog comments is not a proper place for question. I encourage you to submit question on forums instead http://forum.percona.com/
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 6 Comments
Peter, The above comment was written long time ago, when I was just hired … in turn means “choose depth 7″. Is this what your blog boils down to? At the time when I implemented the…
Comment: How to recover a single InnoDB table from a Full Backup
April 11, 2012 By 7 Comments
Hi, consider this comment about foreign key and transportable tablespaces : “To export tables that are in a foreign key relationship you must export and import all the tables together” Source : http://blogs.innodb.com/wp/2012/04/innodb-transportable-tablespaces/
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read… 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…
