June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

…where the parent table is known as id, and on the child tables they reference it as … that since I created the mysql.properties file in the same directory as the jar file, I …completed Relationships view of these three tables should look like this: Final Thoughts While I find the Relationships tab the

Post: MySQL Query Patterns, Optimized - Webinar questions followup

the session, but here are all the questions with my complete answers: Q: Can you compare thethe keywords were returned in a different order from what you specify in the query? The tuple comparison you’re referring…and Europe. Join Percona and the MySQL community at our events.  The next one is in …

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

the RPM packaging that prevented the server from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completedMySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the

Post: Percona XtraDB Cluster reference architecture with HaProxy

complete, seqno: 105 120619 13:21:17 [Note] Plugin ‘FEDERATED’ is disabled. 120619 13:21:17 InnoDB: Themysqlmysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql

Post: Ultimate MySQL variable and status reference list

referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want …_xa_rollbackblogpercona.commanual Com_xa_startblogpercona.commanual completion_typeblogpercona.commanual Compressionblogpercona.commanual concurrent_insertblogpercona.commanual …

Post: The four fundamental performance metrics

the most value for the effort? There’s a relationship known as Little’s Law, sometimes also referred to as thethe “area under the curve” — the blue-colored regions in the picture above. Finally, we can simply count the number of arrivals or completions

Post: How to Identify Bad Queries in MySQL

… I’m referring to the timestamp when the query executed, not merely the duration the query executed for, which has been available in MySQL for years. This is necessary for determining whether a group of queries completed

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

… whom the prudent move would be a migration to InnoDB, but due to their use of MyISAM FTS, the idea of a complete… are only a handful of references to FTS_DOC_ID found when searching the MySQL 5.6 manual, and the only page which appears… might have a hard time using the feature at all, because it could completely alter the behavior of my application unless I also…

Post: Shard-Query EC2 images available

the previous Shard-Query blog post. The data in the each image is split into 20 “shards”. This blog post will refer…. MySQL will fail to start on a micro instance, simply decrease the values in the /… is the complete InnoDB schema from one shard. The schema is duplicated 20 times (but not the ontime…

Post: How Percona does a MySQL Performance Audit

the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQLthe client’s developers are in the process of removing from the application completely