…. Problem is: “original” pt-upgrade was too noisy and too complex. pt-upgrade 2.2 is far simpler and far easier…, MySQL, Perl, etc.) are either out of date or are known bad versions. For example, there are two versions of the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… which just makes things faster without adding complexity to the application (as memcached does for example). Query Cache is also one of… Pool and have multiple MySQL Query Cache instances hashed by query hash. It would help to reduce complexity dramatically. Fast Invalidation Right… I’m most unsure about though as MySQL Query Cache is most useful for complex expensive queries, for which tracking exact rows…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… me puzzled whenever it is user variables, complex stored procedures temporary tables or something else. … by various database operations is reasonable. For example if some INFORMATION_SCHEMA query were to … it which I’m sure hosting providers, MySQL as a Service vendors will especially appreciate …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…The full answer to this question will indeed require complex analyses as there are many possible ways query…found and returned up to the top level MySQL part for processing are counted the Rows_…to understand how much optimization is possible. For example I might have query which uses some index…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… the new features of MySQL 5.6, and actually is a great improvement over MySQL 5.5. For example, in this case, the… more complex optimization strategies. Even row-level operation counters are sometimes not enough. Do you want to know more about the MySQL 5.6 query optimization improvements in a practical way, with real-life examples? Do you want to…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… idea. It also often helps with monopolizing replication thread. For example if I need to delete old data instead of DELETE…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…is its flexibility but flexibility may results in complexity. With the help of people from the Pacemaker….2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/…set the quorum policy to ignore. Also, this example configuration has no stonith devices defined so …
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
… then the child is an orphan. For example, we have a parent table Foo …hundreds of foreign key relationships in any complex database. We can find all foreign …time: $ cat generate_foreign_key_checks.sql | mysql -N | mysql -E *************************** 1. row *************************** test.Bar.ID…
Post: How to use a smartphone for two-factor authentication with Percona Server for MySQL
February 24, 2013 By Leave a Comment
…and Verification Code (generated on my smartphone in Authentificator application) mysql -uvadim Password: Verification code: Authentificating against LDAP server is not…d/mysqld This was just an example, but to show a Percona Server’s feature: a complex authentication which satisfies Enterprise-grade…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. Store the ranges of values for various attributes, for example; or the presence or absence of values. You can… a complex query with many joins. I have never seen this approach scale well. Use The Best Technologies You Can MySQL is… out-of-the-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL, although we’re most famous…
