…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…. The changes Percona’s performance audits typically suggest can be really significant, and can completely change the performance profile and workload of a…
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
There are some tools we commonly use doing performance review and optimization and we often ask each other where … be public instead. So now you can find our favorite MySQL Performance Review Tools on the site. This is just list of… on Open Source tools which are helpful for “in time” performance audit – for example you see no graphing software in this list…
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
…-level, senior experts in LAMP/Open-Source performance and scalability. Most of our work involves MySQL (at least peripherally, usually centrally) but… component that you might expect to see at the Percona Performance Conference) we’d like to talk with you. What’s… all remote DBA, nor is it all urgent troubleshooting or performance audits; it’s everything you can imagine, and it’s never…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
… immediately a question arises how much logging impacts on performance. When we do performance audit often we log every query to find not… take more than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld] user=root… than a second without worry about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
We were doing MySQL Performance evaluation on TPC-H queries for the client and they … publish results which are very interesting. This is obviously not audited TPC-H run, and it can’t be because we… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I…
Post: Election night
November 5, 2008 By Leave a Comment
… array of services enabling them to face the challenge: “Comprehensive MySQL Performance Audit“- to help you find the bottlenecks, to assist with architecture… Time Hire for MySQL“- to keep an eye on your system during whole period of event and to perform fast and proffesional…
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: 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…
