… files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE tblname IMPORT TABLESPACE Now, you have…=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of… audit trail support has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… more low concurrency SSB tests when Peter blogged about the importance of performance at low concurrency. The SSB The SSB tests…. Also, while it is labeled on the graphs, it is important to note that in all cases, lower times are better… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
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… queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite… result was a query that took half the time. An important conclusion of my presentation today is that sometimes you find…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… I have to export databases from mysql and import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
…, tutorial, and breakout session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special… viewing indicators such as inclusion in LinkedIn bios Oracle MySQL may diminish in importance within the ecosystem as alternatives including Percona Server…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… would mean for the MySQL ecosystem. A lot of focus was placed on the storage engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential Innodb successor. A “MySQL Network… available for MySQL. Facebook mentions they have over 1,800 MySQL Servers. MySQL Enterprise provides Monthly Rapid Updates [MRU] while Community MySQL versions updated…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back… companies and products in the MySQL space have been launched at this show. It is important for me to stay attuned to the new companies, products and other developments in the MySQL ecosystem – both…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin… consistent before applying the captured query traffic. This is an important step because update statements that match no rows or insert…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim… I want to target an opposite question: why MySQL performance at low concurrency is important for you. I decided to write about… at concurrency of 1 serves as an important baseline that offers the best response times (MySQL server does not use multiple threads…
