by Krunal Bauskar | Jul 21, 2017 | MySQL, Percona Software
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance. Introduction Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is...
by Vadim Tkachenko | Jun 22, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks:...
by Peter Zaitsev | Jun 9, 2017 | Cloud, Insight for DBAs, Monitoring, MySQL
In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar. First, we want to thank everybody for attending the June 7, 2017 webinar. The recording and slides for the webinar are...
by Dave Avery | May 22, 2017 | MongoDB, Monitoring, Percona Software, Webinars
Join Percona’s Senior Technical Services Engineer Bimal Kharel on Tuesday, May 23, 2017, as he presents a webinar on MongoDB monitoring called How to Help Your DBA’s Sleep Better at Night at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now Are you trying...
by Vadim Tkachenko | Apr 22, 2017 | Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL
In this blog, we’ll look at how to achieve better-than-linear scaling. Scalability is the capability of a system, network or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth. For example, we consider a system...
by Krunal Bauskar | Apr 19, 2017 | MySQL, Percona Software
In this blog post, we’ll look at the actions and efforts Percona experts took to scale Percona XtraDB Cluster. Introduction When we first started analyzing Percona XtraDB Cluster performance, it was pretty bad. We would see contention even with 16 threads....
by Alexey Stroganov | Mar 29, 2017 | Insight for DBAs, MySQL
In this blog, we’ll look at evaluating the performance of an SST data transfer without encryption. A State Snapshot Transfer (SST) operation is an important part of Percona XtraDB Cluster. It’s used to provision the joining node with all the necessary...
by Peter Zaitsev | Mar 22, 2017 | Benchmarks, Hardware and Storage, MySQL
In this blog post, I’ll take a look at the performance of the Samsung 960 Pro SSD NVME. First, I know the Samsung 960 Pro is a consumer SSD NVME drive, not intended for sustained data center workloads. But the AnandTech review looked good enough that I...
by Federico Razzoli | Mar 2, 2017 | MariaDB, MySQL
The MariaDB subquery cache feature added in MariaDB 5.3 is not widely known. Let’s see what it is and how it works. What is a subquery cache? The MariaDB subquery cache optimizes the execution of correlated subqueries. Correlated subqueries refer to a value from...
by Sveta Smirnova | Mar 1, 2017 | MySQL, Open Source
In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results. The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I expected my tests would...
by Sveta Smirnova | Jan 26, 2017 | MySQL, Open Source
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...
by Dave Avery | Jan 23, 2017 | MySQL, Webinars
Please join Laurynas Biveinis, Percona’s Technical Director – Engineering, on January 25, 2017, at 7 am EST (UTC-8) as he discusses “Percona Server for MySQL 5.7: Key Performance Algorithms.” In this webinar, Laurynas will discuss selected areas of InnoDB...
by Peter Zaitsev | Jan 13, 2017 | Insight for DBAs, MySQL
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...
by Anastasia Raspopina | Jan 6, 2017 | Benchmarks, MySQL, Open Source, Percona Live, PostgreSQL
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...
by Muhammad Irfan | Aug 19, 2016 | MySQL, Webinars
Thank you for attending my 22nd July 2016 webinar titled “Top Most Overlooked MySQL Performance Optimizations”. In this blog, I will provide answers to the Q & A for that webinar. For hardware, which disk raid level do you suggest? Is raid5 suggested...
by George O. Lorch III | Aug 17, 2016 | MySQL
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...
by Vadim Tkachenko | Aug 10, 2016 | Benchmarks, MySQL
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...
by Dave Avery | Jul 19, 2016 | MySQL
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...
by Roel Van de Paar | Jun 3, 2016 | MySQL
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...
by Sveta Smirnova | May 20, 2016 | Insight for DBAs, MySQL, Webinars
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...