EmergencyEMERGENCY? Get 24/7 Help Now!

One Million Tables in MySQL 8.0

 | October 1, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 8.0

MySQL 8.0

In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million tables in MySQL? Is it even realistic? How does this happen? Usually, millions […]

Read More

Looking at Disk Utilization and Saturation

 | August 28, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

DIsk Utilization and Saturation small

In this blog post, I will look at disk utilization and saturation. In my previous blog post, I wrote about CPU utilization and saturation, the practical difference between them and how different CPU utilization and saturation impact response times. Now we will look at another critical component of database performance: the storage subsystem. In this post, I […]

Read More

Performance Schema Benchmarks: OLTP RW

 | January 26, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

Performance Schema Benchmarks

In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads. I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had performance issues. Many of these issues are fixed now, and the default options work quickly and […]

Read More

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More

Make MySQL 8.0 Better Through Better Benchmarking

 | December 2, 2016 |  Posted In: Benchmarks, MySQL

MySQL 8.0.1

This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I would like to see MySQL 8.0 perform better. Better performance […]

Read More

Testing Samsung storage in tpcc-mysql benchmark of Percona Server

 | July 26, 2016 |  Posted In: Benchmarks, MySQL

tpcc-mysql benchmark

This blog post will detail the results of Samsung storage in tpcc-mysql benchmark using Percona Server. I had an opportunity to test different Samsung storage devices under tpcc-mysql benchmark powered by Percona Server 5.7. You can find a summary with details here https://github.com/Percona-Lab-results/201607-tpcc-samsung-storage/blob/master/summary-tpcc-samsung.md I have in my possession: Samsung 850 Pro, 2TB: This is a SATA device and […]

Read More

Monitoring MongoDB Response Time

 | February 26, 2016 |  Posted In: MongoDB, Prometheus

In this blog post, we’ll discuss how using Prometheus can help with monitoring MongoDB response time. I am currently comparing the performance of different storage engines on Percona Server for MongoDB, using a slightly customized version of Tim Callaghan’s sysbench-mongodb. Since I’m interested in measuring response time for database operations, I created a very simple exporter of response time […]

Read More

InnoDB and TokuDB on AWS

 | February 1, 2016 |  Posted In: Benchmarks, InnoDB, TokuDB

In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a similar set-up (r3.xlarge instance, with general purpose ssd, io2000 and io3000 volumes) to his experiments. All the runs used 16 threads for sysbench, and the following […]

Read More

Using Cgroups to Limit MySQL and MongoDB memory usage

 | July 1, 2015 |  Posted In: InnoDB, MongoDB, MySQL

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am […]

Read More