… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as… in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: Sample datasets for benchmarking and testing
June 17, 2013 By 18 Comments
the links here are useful and informative…
Comment: How to calculate a good InnoDB log file size
June 14, 2013 By 38 Comments
According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…-sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys… for me, since I think proper audit trail support has been an important missing feature on the server, which has made using MySQL…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
…2.1 version to 2.1.3 if you’re using the Percona XtraBackup with Percona XtraDB Cluster. This release is…, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We recommend support for critical production deployments.
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… a problem before it occurs. For example, if you see a large number of long-running queries in the output of SHOW… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA… initial reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… addition to your summer vacation plans, give thought to MySQL training for you and your team. Summer is the time to brush… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday… 19, 2013 , 9am – 5pm We have a 10% discount code for use when ordering, register early and save even more as the…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… of constraints? For many reasons: the first one because it would break 99% of all applications out there that use MySQL, for which we… suffixes for secondary keys in InnoDB. As some of this redundancies could be necessary, depending on the query optimizer and the MySQL version… it does not detect all cases. For example: mysql> alter table test add index redundant (col2, id); Query OK, 0 rows affected (1…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
… solutions for each type of query objective, and show how you can use MySQL 5.6 built-in methods to analyze them for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and…
