… be avoided. The changes Percona‘s performance audits typically suggest can be really significant, and can completely change the performance profile and workload of… informative and fun trip through the world of a typical Percona performance audit, although as you’ve seen there really isn’t any…
Post: Percona is hiring performance experts
February 13, 2009 By 2 Comments
… see at the Percona Performance Conference) we’d like to talk with you. What’s it like to work at Percona? To begin… all remote DBA, nor is it all urgent troubleshooting or performance audits; it’s everything you can imagine, and it’s never… systems like you do at some consulting companies. The successful Percona consultant has a combination of experience, aptitude and attitude. You…
Post: Percona welcomes Ewen Fortune and Piotr Biel
October 1, 2008 By 5 Comments
… course. Ewen has been a consultant and contractor before joining Percona, and has many years of experience in Oracle, MySQL, Unix… performance, and easier to manage. Other recent accomplishments that come to mind include helping clients move to new data centers and performance audits…
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… striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were… than a second without worry about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO…
Post: Daniel Nichter and Percona join forces on Maatkit
July 25, 2008 By 1 Comment
… author of several very useful MySQL tools, has joined with Percona to continue to improve Maatkit — the “other” toolkit we rely… leadership role in Percona. Right now he’s working on an unreleased tool we will use to make our performance audits more efficient…
Post: Tools to use for MySQL Performance Review
May 31, 2008 By 3 Comments
… the command what does that. Initially I thought creating internal Percona Wiki page, but thought there is no reason this information… 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 Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… and the replication binlog. Percona has imported the group commit patch from MariaDB and is making the performance improvements that group commit brings available to users of Percona Server 5.5. See the… including 4.6, were audited and fixed. Bug fixed: #878164 (Laurynas Biveinis) Testsuite stability fix for the percona_status_wait_query_cache…
Post: Percona Server 5.1.60-13.1
December 16, 2011 By Leave a Comment
… a great improvement in |myisamchk|, CREATE INDEX and ALTER TABLE performance. Bug Fixed: #878404 (Alexey Kopytov) The atomic operations used in… has expanded diagnostics and compiler warnings. We have audited and fixed these warnings for Percona Server 5.1, finding that the warnings…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
… native feature to perform this task – PROCEDURE ANALYSE Here is sample run of PROCEDURE ANALYSE on drupal schema of Percona web site…_fieldtype: TINYINT(3) UNSIGNED NOT NULL *************************** 3. row *************************** Field_name: percona_drupal.node.type Min_value: blog Max_value: webform Min… do an ALTER TABLE it provides very helpful information for performing schema audit.
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
… disclaimer. VoltDB is not a customer, and did not pay Percona or me to investigate VoltDB’s scalability or publish this… servers, and VoltDB should provide even higher performance on faster machines. I did not audit or repeat Tim’s benchmarks in the… 8 percent) to avoid unphysical parameters as a result of performing a regression against the full dataset. These are rather standard…
