… course PCIe still provides better numbers, but the question is how much MySQL can use. In his keynote Mark Callaghan mentioned… the performance variance we see it is a good question how does it affect MySQL performance, and I am going to run…-9. It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend my…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… async mode allows to see maximal possible throughput, it does not show reliable latency though, as it appears there…see I gather metrics every 10 sec to see how stable the performance is, and it really helps … It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… async mode allows to see maximal possible throughput, it does not show reliable latency though, as it appears there…see I gather metrics every 10 sec to see how stable the performance is, and it really helps … It will be the same as my talk on Percona Live MySQL Conference 2012, if you did not attend…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… giving a webinar where I will explain what Percona XtraDB Cluster is and how does it work, you still have time to register… unsyncronised slaves. Percona XtraDB Cluster is fully compatible with MySQL or Percona Server in the following meaning: Data compatibility. Percona XtraDB Cluster works… application changes required to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… Here is example how it can look: mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ … solution which does FLUSH TABLES WITH…no-lock option with Percona Xtrabackup. Many other…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…” output on Linux. It helps me to understand how this memory allocation happens – does it grows slowly and never ending which would… see these tables going away if you close connection. In Percona Server you can do better as you can query temporary… I’m using the information from Percona Server again which provides a lot more insight about how memory is used. I would…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… you use this technique ? The problem comes from the fact how MySQL’s Transactions work with DDL, In particular ALTER TABLE… original table and rename such temporary table to original name. How does data visibility works in this case ? DDLs are not transactional… duration of operation. You can also use Percona Xtrabackup, LVM or other database backup approach which does not relay on transaction visibility.
Comment: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
Great to see more development activity for this project. How do you feel MariaDB differs from Percona Server (or does it at all)?
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…their products or services. Independence and objectivity are core Percona values. How do we balance the interests of all involved while maintaining… that meets our standards for balanced and objective reporting. However, Percona does the writing, not the vendor. Sometimes vendors suggest wording, but…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… and generally keeping in touch with what the lead consultant does. We want two sets of eyes on things whenever possible…’ll usually capture two of these. It looks like this: [percona@db1 ~]$ mysqladmin ext -ri10 +———————————–+———————-+ | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174… is where you need to really know how to write queries and how EXPLAIN works. At Percona, we have peer training constantly on…
