by David Quilty | Sep 23, 2024 | Insight for DBAs, MySQL
When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing...
by David Quilty | Jul 17, 2024 | Insight for DBAs, MySQL
Have you ever waited far too long for a MySQL query to finish and wondered if there’s a better way? If you manage a MySQL database or build apps that depend on one, you know how slow queries can grind everything to a halt. Users get frustrated, response times creep...
by Sveta Smirnova | Dec 29, 2021 | Insight for Developers, MySQL, Webinars
First I want to thank everyone who attended my November 16, 2021 webinar “MySQL Performance for DevOps“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide during the webinar. Q:...
by Vadim Tkachenko | Aug 1, 2018 | Benchmarks, Insight for DBAs, MySQL, Open Source, Storage Engine
The main focus of a previous blog post was the performance of MyRocks when using fast SSD devices. However, I figured that MyRocks would be beneficial for use in cloud workloads, where storage is either slow or expensive. In that earlier post, we demonstrated the...
by Vadim Tkachenko | Jul 13, 2018 | Benchmarks, MySQL, Percona Software
Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel...
by David Ducos | Jun 19, 2018 | Insight for DBAs, MySQL
Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not...
by Sveta Smirnova | Jun 5, 2018 | Benchmarks, MySQL
If you attended my latest Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar you learned how I exploit benchmarking tools to replicate locking issues and crashes. But I told you nothing about proper use of these tools: for reliable benchmarks. I...
by Sveta Smirnova | Jun 4, 2018 | Benchmarks, MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar. First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides...
by Sveta Smirnova | Jun 15, 2016 | MySQL, Webinars
In this blog, I provide answers to the Q & A for the Troubleshooting hardware resource usage webinar. First, I want to thank everybody who attended the May 26 webinar. The recording and slides for the webinar are available here. Below is the list of your questions...
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 | Apr 16, 2016 | MySQL
In this blog, I will provide answers to the Webinar Q & A for Introduction to Troubleshooting Performance: What Affects Query Execution? First, I want to thank you for attending the April, 7 webinar. This webinar is the third in the “MySQL...
by Stephane Combaudon | Apr 27, 2015 | Insight for DBAs, MySQL
I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize various kinds of single-table...
by Jon Tobin | Feb 25, 2015 | MySQL
In Mo’ Data, Mo’ Problems, we explored the paradox that “Big Data” projects pose to organizations and how Tokutek is taking an innovative approach to solving those problems. In this post, we’re going to talk about another hot topic in IT, “The Cloud,” and how...
by Jon Tobin | Jan 22, 2015 | MySQL
Welcome to blog #2 in a series about the benefits of the Fractal Tree. In this post, I’ll be explaining Big Data, why it poses such a problem and how Tokutek can help. Given the fact that I am a lifelong fan of both Hip-hop and Big Data, the title was a no-brainer...
by Peter Zaitsev | Jan 19, 2015 | Benchmarks, MySQL, Percona Software
A few days ago I wrote about MySQL performance implications of InnoDB isolation modes and I touched briefly upon the bizarre performance regression I found with InnoDB handling a large amount of versions for a single row. Today I wanted to look a bit deeper into the...
by Peter Zaitsev | Nov 18, 2014 | Benchmarks, MySQL
Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was...
by Vadim Tkachenko | Jun 18, 2014 | Insight for DBAs, MySQL, Percona Software, Webinars
We recently released a new version of Percona Cloud Tools with MySQL monitoring capabilities. Join me June 25 and learn the details about all of the great new features inside Percona Cloud Tools – which is now free in beta. The webinar is titled...
by Ryan Lowe | Apr 7, 2014 | Insight for DBAs, MySQL, Webinars
Next Wednesday, I will present a webinar about MySQL performance profiling tools that every MySQL DBA should know. Application performance is a key aspect of ensuring a good experience for your end users. But finding and fixing performance bottlenecks is difficult in...
by Alexey Kopytov | Apr 12, 2013 | Benchmarks, MySQL
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection...
by Peter Zaitsev | Mar 27, 2013 | Benchmarks, MySQL, Percona Live
A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim’s post on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an...
