… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… attempts has been discussed on a previous post in our blog. Starting with 5.1, the new plugin API gives us… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB… warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib… InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql.com/doc/refman…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… engineering blog. Thanks again to Kyle Oppenheim at Groupon. And one more reminder that I’ll be at the Percona Live MySQL… a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to… practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and… your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… sessions including presentations on Oracle MySQL, Percona Server, and MariaDB during the Percona Live MySQL Conference. Percona Live MySQL Conference Keynotes Tuesday Peter… Ulin, Vice President of MySQL Engineering, Oracle Keynote Topic: “Driving MySQL Innovation” Wednesday Robert Hodges, CEO, Continuent “How MySQL Can Thrive in the…. And if you cannot make it this year, watch this blog following the conference and we’ll announce when and where…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… currently in the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… MySQL performance at low concurrency is important for you. I decided to write about this topic as a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much worse than Galera. As I illustrated in a blog…
