… sec, as garbage collector kicks in, we see a performance drop to around 300 MiB/sec with some … underutilized. With the performance variance we see it is a good question how does it affect MySQL performance, and I am… a webinary “MySQL and SSD” on May-9. It will be the same as my talk on Percona…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…possible throughput, it does not show reliable latency though, as it appears there is no a reliable way in …I gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some…giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk on Percona Live…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…possible throughput, it does not show reliable latency though, as it appears there is no a reliable way in …I gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some…giving a webinary “MySQL and SSD” on May-9. It will be the same as my talk on Percona Live…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…how MySQL’s Transactions work with DDL, In particular ALTER TABLE. When ALTER TABLE is Performed… show tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | | B | | C | +——————–+ 3 rows … use Percona Xtrabackup, LVM or other database backup approach which does…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…us how we do a performance audit (it’s our most popular service). I thought I should write a blog…some ORM system, such as Class::DBI, which does $dbh->ping before each and every query. Why…informative and fun trip through the world of a typical Percona performance audit, although as you’ve seen there…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…a white paper.” The deliverable will be to produce something publishable that meets our standards for balanced and objective reporting. However, Percona does…a vendor wants to use the results of Percona‘s research in part, but not perform the full and balanced disclosure that Percona would perform…how…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
…performance transactional storage engine Maatkit, which is a toolkit that provides advanced functionality for MySQL. We have a…Percona codebase. Percona‘s relationship to the rest of the community is that of a peer, not a… our patches. OurDelta does so — it is a great example of how the community can…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… And as a result, one of the most common questions we hear is how to build high-performance systems to do…s a fair chance they will talk about how hard they have to work on I/O capacity. What does …doing a lot of things right. When I know enough to have a real opinion (or when other Percona people…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 11 Comments
…does not provide any information of this type, Percona… | test | a | c | 7976 | 0 | 0 | 13.73 | | test | a | PRIMARY | …how buffer pool is affected by batch jobs, alter tables, optimize table etc – the lasting impact these may have on system performance…
Post: Open Development vs Making a Big Splash
May 21, 2009 By 28 Comments
…Does it remind you something ? Yes! this is exactly how Innodb Plugin was released last year or MySQL 5.4 performance…respect and this is how I think Open Source development should be done. At Percona I think we…around it. There is no big news just a slow process. I would argue however releasing …
