… was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in… a complete explanation of why TEXT coverts to MEDIUMTEXT] Maybe something changed since this article was originally written, but right now it seems…
Comment: Performance Schema overhead
June 12, 2013 By 22 Comments
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
Comment: Minimizing Downtime from Lengthy AWS Outages
June 12, 2013 By 7 Comments
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
Slow Query should be run on as-needed basis, and re-actively not pro-actively. …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…0.00 sec) In previous versions of MySQL, you can create two indexes with the same …can‘t MySQL enforce this kind of constraints? For many reasons: the first one because it would break 99% of all applications out…of the two indexes was unique or a foreign key. This is the output of our tool when run…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…a MySQL HA Solution” webinar. If you weren’t able to make it but are …of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this… servers are seeing. But, if you can connect and run a simple query and receive …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…you‘re laughing, if not don’t despair, you just have a bit more work ahead of you. Most of…prefer to create this once so that the command line is shorter …> If you‘re looking for other examples you can find a more comprehensive example here. Running… out there. java -jar schemaSpy_5.0.0.jar -t mysql …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the … than just running the query in a suboptimal form. Q: Doesn’t the primary …t clear, because I didn’t present the details of all the tables and columns. It turned out this solution was 150x faster for this…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…command is not present any more 
It’s still possible to find the command…now you are able to stop maintenance mode: [root@percona2 percona]# pcs property set maintenance-mode=false You can…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…this involves a lot of data you don’t need too, and isn’t flexible at all. The specific problem of… runs with increasing levels of concurrency), but initially, I would think the advantage of the…can be set to control what is logged by the plugin: – audit_record_cmds : This is the list of commands you…
