EmergencyEMERGENCY? Get 24/7 Help Now!

Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads

and  | January 6, 2017 |  Posted In: Benchmarks, InnoDB, MySQL, open source databases, OpenSource Databases on big machines, Percona Live

PostgreSQL and MySQL

This blog compares how PostgreSQL and MySQL handle millions of queries per second. Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer “yes.” However, assertions aren’t enough for well-grounded proof. That’s why in this blog post, we share the benchmark testing results from Alexander Korotkov (CEO of […]

Read More

TokuDB/PerconaFT fragmented data file performance improvements

 | August 17, 2016 |  Posted In: MySQL, TokuDB

fragmented data file performance

In this blog post, we’ll discuss how we’ve improved TokuDB and PerconaFT fragmented data file performance. Through our internal benchmarking and some user reports, we have found that with long term heavy write use TokuDB/PerconaFT performance can degrade significantly on large data files. Using smaller node sizes makes the problem worse (which is one of […]

Read More

Small innodb_page_size as a performance boost for SSD

 | August 10, 2016 |  Posted In: Benchmarks, InnoDB, MySQL

performance boost for SSD

In this blog post, we’ll discuss how a small innodb_page_size can create a performance boost for SSD. In my previous post Testing Samsung storage in tpcc-mysql benchmark of Percona Server I compared different Samsung devices. Most solid state drives (SSDs) use 4KiB as an internal page size, and the InnoDB default page size is 16KiB. I wondered […]

Read More

Upcoming Webinar Wednesday July 20, 11 am PDT: Practical MySQL Performance Optimization

 | July 19, 2016 |  Posted In: MySQL

MySQL Performance Optimization

Are you looking to improve your MySQL performance? Application success is often limited by poor MySQL performance. Please join Percona CEO and Founder Peter Zaitsev for this exclusive webinar on Wednesday, July 20th, 2016 at 11:00 AM PDT (UTC – 7) as he presents “Practical MySQL Performance Optimization“. Peter Zaitsev discusses how to get excellent […]

Read More

MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

 | June 3, 2016 |  Posted In: MySQL

binary logs make MySQL 5.7 slower

Researching a performance issue, we came to a startling discovery: MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings. Test server MySQL versions used: i7, 8 threads, SSD, Centos 7.2.1511 mysql-5.6.30-linux-glibc2.5-x86_64 mysql-5.7.12-linux-glibc2.5-x86_64 mysqld –options: --no-defaults --log-bin=mysql-bin --server-id=2 Run details: Sysbench version 0.5, 4 threads, socket file connection […]

Read More

Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A

 | May 20, 2016 |  Posted In: EXPLAIN, MySQL, Technical Webinars

InnoDB Troubleshooting

In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar. First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with […]

Read More

Percona Live 2016: Performance of Percona Server for MySQL on Intel Server Systems using HDD, SATA SSD, and NVMe SSD as Different Storage Mediums

 | April 19, 2016 |  Posted In: Percona Live

We’re moving along on the first day at Percona Live 2016, and I was able to attend a lecture from Intel’s Ken LeTourneau, Solutions Architect at Intel, on Performance of Percona Server for MySQL on Intel Server Systems using HDD, SATA SSD, and NVMe SSD as Different Storage Mediums. In this talk, Ken reviewed some benchmark testing […]

Read More

TokuDB impacts InnoDB Performance?

 | March 22, 2016 |  Posted In: MySQL

TokuDB impacts InnoDB performance

This blog discusses how TokuDB impacts InnoDB performance when the two run in the same environment. You would think MySQL storage engines are fairly independent of each other, even in the same environment. Enabling one, or changing its configuration, logically should have no impact on the performance of other engines (such as InnoDB) when they […]

Read More