EmergencyEMERGENCY? Get 24/7 Help Now!

Benchmark MongoDB with sysbench

 | May 13, 2016 |  Posted In: Benchmarks, MongoDB

Benchmark MongoDB with sysbench

In this blog post, we’ll discuss how to benchmark MongoDB with sysbench. In an earlier post, I mentioned our use of sysbench-mongodb (via this fork) to run benchmarks of MongoDB servers. I now want to share our work extending sysbench to make it work with MongoDB. If you’re not familiar with sysbench, it’s a great project developed […]

Read More

The MySQL query cache: Worst enemy or best friend?

 | August 7, 2015 |  Posted In: Benchmarks, MySQL

During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful. That was counter-intuitive for me as I’ve always expected the […]

Read More

Q&A: High availability when using MySQL in the cloud

 | June 19, 2015 |  Posted In: Cloud and MySQL, MySQL, Percona XtraDB Cluster, Technical Webinars

Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that page. We had several excellent questions and we didn’t have time […]

Read More

Update on the InnoDB double-write buffer and EXT4 transactions

 | June 17, 2015 |  Posted In: Benchmarks, Hardware and Storage, InnoDB, MySQL

IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data. In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance significantly, by 55%, without putting data at risk. Many people commented on the post mentioning […]

Read More

MySQL benchmarks on eXFlash DIMMs

 | January 26, 2015 |  Posted In: Benchmarks, MySQL

In this blog post, we will discuss MySQL performance on eXFlash DIMMs. Earlier we measured the IO performance of these storage devices with sysbench fileio. Environment The benchmarking environment was the same as the one we did sysbench fileio in. CPU: 2x Intel Xeon E5-2690 (hyper threading enabled) FusionIO driver version: 3.2.6 build 1212 Operating […]

Read More

Monitoring MySQL flow control in Percona XtraDB Cluster 5.6

 | July 25, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona XtraDB Cluster

Monitoring flow control in a Galera cluster is very important. If you do not, you will not understand why writes may sometimes be stalled. Percona XtraDB Cluster 5.6 provides 2 status variables for such monitoring: wsrep_flow_control_paused and wsrep_flow_control_paused_ns. Which one should you use? What is flow control? Flow control does not exist with regular MySQL replication, […]

Read More

ScaleArc: Benchmarking with sysbench

 | March 31, 2014 |  Posted In: Benchmarks, Insight for DBAs, MySQL, Percona Live, Percona MySQL Consulting

ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by Uday Sawant (ScaleArc) and myself. You can also download the report directly as a PDF here. The goal of these benchmarks is to identify the potential overhead of the ScaleArc […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.