… MySQL Consulting, MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL Consulting Team and MySQL Support Team can work together to audit… our customers’ MySQL 5.6 test and production environments, and address any performance issues that might arise. Our MySQL Training team…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… binary logs I could see this table is actually an audit table for changes to the Foo table. The trail is… As you can see from the above, the updates were performed in a different order, with the inserts being assigned a…
Post: Percona welcomes Ewen Fortune and Piotr Biel
October 1, 2008 By 5 Comments
… 10g Administrator Certified Professional (OCP), a Certified MySQL 5.0 DBA (CMDBA), and a Certified MySQL 5.1 Cluster DBA (CMCDBA). Like… performance, and easier to manage. Other recent accomplishments that come to mind include helping clients move to new data centers and performance audits…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.18, including all the bug …commit patch from MariaDB and is making the performance improvements that group commit brings available to users…versions up to and including 4.6, were audited and fixed. Bug fixed: #878164 (Laurynas Biveinis) …
Post: Adventures in archiving
February 11, 2013 By 16 Comments
… short this table was some 25 million rows of application audit data with an on disk size of 345GB recorded solely… following options for further testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of… to be aware that Archive does not have good performance. e.g. mysql> select id from archive_table order by id desc…
Post: Percona XtraDB Cluster: SElinux is not always the culprit !
December 20, 2012 By 5 Comments
… should, my first reflex is to have a look at audit.log. But recently I faced another problem: the node joined… you want to check is there is a profile for mysql, you can run the following command : root@testmachine:~# apparmor_status…: We often advise to disable SElinux and AppArmor on dedicated MySQL servers to avoid the performance overhead
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
…is also filed in MySQL bug tracker, but not fixed in upstream MySQL at the time of … in |myisamchk|, CREATE INDEX and ALTER TABLE performance. Bug Fixed: #878404 (Alexey Kopytov) The atomic … expanded diagnostics and compiler warnings. We have audited and fixed these warnings for Percona Server 5…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… them (though they were in pain) and 37Signals When doing Performance Audit we tend to look at the required capacity and data… the availability of the application is only related to the MySQL redundancy for very high quality/high scale applications. I’ve seen applications having no downtime running for years on single MySQL server (which just does not crash) as well as complex…
Post: Daniel Nichter and Percona join forces on Maatkit
July 25, 2008 By 1 Comment
Daniel Nichter, the author of several very useful MySQL tools, has joined with Percona to continue to improve Maatkit — … on daily. Daniel is a skilled Perl programmer who understands MySQL. He is in a perfect position to move the project… on an unreleased tool we will use to make our performance audits more efficient. As a result, we’ll be able to…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… adjustment of the file offset and the write operation are performed as an atomic step. So we can pretty easily see… sat down and wrote an audit plugin. It turns out I had to extend the MySQL plugin API to be able to… the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query…
