….6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1…NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` (…value. This is basically a quick sanity check of your schema for any significant errors…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…, pt-duplicate-key-checker will detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As… query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… for common patterns the MySQL designers know can be improved. But there’s a finite amount of engineer-years spent developing and… some more tips: Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at our…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special… tremendous amount of time and energy into development of MySQL with an engineering team of over 200 developers The release process is…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin… part of the graph lines up with the blue part. Check back Thursday for Part 2!
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
… major MySQL players are coming to the Percona Live MySQL Conference and Expo 2013. I am happy to see Oracle’s engineers coming with talks — and now with a great MySQL 5.6 release — and I have great confidence in MySQL‘s… the ones on my list to attend — but you can check all of them out for yourself. But I will say…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… 5M rows each (about 23GB). So it makes sense to check if the dataset size makes any difference. We first excluded…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=9 –oltp…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
Mark, There is no many steps if you are on the good platform (CentOS or Fedora). I do scripts/mysql_install_db –datadir=/data/mysql bin/mysqld –datadir=/data/mysql and it is all good. connect from mysql client and check SHOW ENGINES;
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
…people want to pay for. I haven’t checked out TokuDB yet, so it may be much…ever to have a MVCC/fully transactional storage engine outside Oracle that works. So MariaDB could profit… are already three well established companies in the MySQL Ecosystem: Percona, Oracle and MariaDB/SkySQL. Tokutek may…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… of problems in the server as well as the storage engine. For example, a pile-up of connections all trying to…), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly…
