InnoDB Performance Archives - Percona Database Performance Blog

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, MySQL 101, Percona Server for MySQL, Performance Schema, Technical Webinars Binary Log, binary logs, database monitoring, database performance, information schema, InnoDB Performance, InnoDB. monitoring, Linux, monitoring database, MySQL monitoring, Production, system variable, Troubleshooting MySQL Performance, Tuning Linux 0 Comments

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 […]

19 Jun 2018

Chunk Change: InnoDB Buffer Pool Resizing

By David Ducos InnoDB, Insight for DBAs, MySQL, open source databases, Percona Server for MySQL buffer pool, InnoDB buffer pool, InnoDB buffer pool size, InnoDB Performance, memory, Memory Usage, MySQL Performance 2 Comments

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 […]

06 Jan 2017

PostgreSQL and MySQL: Millions of Queries per Second

By Anastasia Raspopina and Sveta Smirnova Benchmarks, InnoDB, MySQL, open source databases, Percona Live, PostgreSQL benchmark, database performance, InnoDB Performance, OpenSource Databases on big machines, Performance, sysbench 18 Comments

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 […]

17 Feb 2012

The relationship between Innodb Log checkpointing and dirty Buffer pool pages

By Jay Janssen MySQL InnoDB, InnoDB Performance, Tuning 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 […]

15 Nov 2010

Shard-Query adds parallelism to queries

By Justin Swanhart Insight for Developers, MySQL InnoDB, InnoDB Performance, OLAP, Performance, sharding 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 […]

05 Jun 2006

InnoDB thread concurrency

By Vadim Tkachenko Insight for DBAs Bugs, GitHub, InnoDB, InnoDB Performance, InnoDB Thread Concurrency 6 Comments

InnoDB has a mechanism to regulate count of threads working inside InnoDB.
innodb_thread_concurrency is variable which set this count, and there are two friendly variables
innodb_thread_sleep_delay and innodb_concurrency_tickets. I’ll try to explain how it works.
MySQL has pluginable architecture which divides work between mysql common code
(parser, optimizer) and storage engine. From storage engine’s point of view it […]

04 Jun 2006

InnoDB page size

By Vadim Tkachenko Insight for DBAs GitHub, InnoDB, InnoDB Page Size, InnoDB Performance, Tips 5 Comments

As maybe you know InnoDB uses hard page size 16Kb for datafiles and for buffer pool.
However this size can be changed if you need it for your workload.
go to file innobase/include/univ.i, lines:

Shell

/* The universal page size of the database */
#define UNIV_PAGE_SIZE (2 * 8192) /* […]

12 May 2006

Mess with innodb_thread_concurrency

By Vadim Tkachenko Insight for DBAs GitHub, InnoDB, InnoDB Performance, InnoDB Thread Concurrency, MySQL Performance, Performance 1 Comment

In MySQL 5.0.19 the meaning of innodb_thread_concurrency variable was changed (yeah, again).
Now innodb_thread_concurrency=0 means unlimitied count of concurrent threads inside InnoDB. It’s logical, but there was long way. In MySQL versions below 5.0.8 for unlimited threads you had to set innodb_thread_concurrency over 500 (and default value for innodb_thread_concurrency was 8 ).
Starting with MySQL 5.0.8, […]

Tag - InnoDB Performance

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

Chunk Change: InnoDB Buffer Pool Resizing

PostgreSQL and MySQL: Millions of Queries per Second

The relationship between Innodb Log checkpointing and dirty Buffer pool pages

Shard-Query adds parallelism to queries

InnoDB thread concurrency

InnoDB page size

Mess with innodb_thread_concurrency

Upcoming Webinars

Services

Products

Solutions

Resources

More

Contact Us