Tag - InnoDB Performance

26 Jun 2018

Webinar 6/27: MySQL Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance

By Sveta Smirnova Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Software, Webinars , , , , , , , , , , , , , Comments Off
performance troubleshooting MySQL monitoring tools

Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4).
Register Now
 
During the MySQL Troubleshooting webinar series, I covered many monitoring and logging tools such as:

General, slow, audit, binary, error […]

Read more
19 Jun 2018

InnoDB Buffer Pool Resizing: Chunk Change

By David Ducos Insight for DBAs, MySQL , , , , , , 2 Comments
InnoDB Buffer Pool

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 dynamic and if it is incorrectly configured, could lead to undesired […]

Read more
06 Jan 2017

PostgreSQL and MySQL: Millions of Queries per Second

By Anastasia Raspopina and Sveta Smirnova Benchmarks, MySQL, Open Source, Percona Live, PostgreSQL , , , , , 28 Comments
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
17 Feb 2012

The relationship between Innodb Log checkpointing and dirty Buffer pool pages

By Jay Janssen MySQL , , 13 Comments

This is a time-honored topic, and there’s no shortage of articles on the topic on this blog. I wanted to write a post trying to condense and clarify those posts, as it has taken me a while to really understand this relationship.
Some basic facts

Most of us know that writing into Innodb updates buffer pool […]

Read more
15 Nov 2010

Shard-Query adds parallelism to queries

By Justin Swanhart Insight for Developers, MySQL , , , , 18 Comments

Preamble: On performance, workload and scalability:
MySQL has always been focused on OLTP workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit workloads that have high concurrency. Typical OLTP workloads feature numerous clients (perhaps hundreds or thousands) each reading and writing small chunks of data. The recent improvements to […]

Read more

Upcoming Webinars

All Webinars »


MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL

Terms of Use | Privacy | Copyright | Legal

Copyright © 2006-2020 Percona LLC.