by Sveta Smirnova | Jan 19, 2017 | Open Source
In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores. The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is READ COMMITTED, and is known to...
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 Peter Zaitsev | Dec 28, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll find out how to use Percona XtraBackup on a MySQL instance with a large number of tables. As of Percona Xtrabackup 2.4.5, you are required to have enough open files to open every single InnoDB tablespace in the instance you’re trying to...
by Peter Zaitsev | Dec 2, 2016 | Benchmarks, MySQL
This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general. Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL community, I...
by Peter Zaitsev | Nov 30, 2016 | MySQL
In this blog post, I’ll discuss how to use the InnoDB buffer pool pre-load feature in MySQL 5.7 Starting MySQL 5.6, you can configure MySQL to save the contents of your InnoDB buffer pool and load it on startup. Starting in MySQL 5.7, this is the default...
by Hrvoje Matijakovic | Nov 29, 2016 | MySQL
Percona announces the GA release of Percona XtraBackup 2.4.5 on November 29th, 2016. You can download it from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies...
by Hrvoje Matijakovic | Nov 28, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.16-10 on November 28, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.16, including all the bug fixes in it, Percona Server 5.7.16-10 is the...
by Hrvoje Matijakovic | Nov 18, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.53-38.4 on November 18, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server 5.5.53-38.4 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can...
by Peter Zaitsev | Nov 17, 2016 | MongoDB, MySQL, Percona Events
Let us know what you think about Percona, and what we should be thinking about for the future. Over the last ten years, Percona has grown considerably. We’ve moved from being a strictly MySQL company, to a company that supports MongoDB and other open source...
by Peter Zaitsev | Oct 19, 2016 | MongoDB, Monitoring, MySQL, Percona Software
As part of the release of Percona Monitoring and Management, we set up an extensive online Percona Monitoring and Management demo at pmmdemo.percona.com. The demo is pretty self-explanatory and easy to explore, but you will probably find it a lot more interesting with...
by Hrvoje Matijakovic | Oct 18, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.33, including all the bug fixes in it, Percona Server 5.6.33-79.0 is the...
by Alexander Rubin | Oct 12, 2016 | MySQL
This blog updates Stephane Combaudon’s blog on MySQL performance tuning and covers MySQL 5.7 performance tuning immediately after installation. A few years ago, Stephane Combaudon wrote a blog post on Ten MySQL performance tuning settings after installation that...
by Alexander Rubin | Oct 3, 2016 | MySQL
In this blog post, we’ll look at MySQL 8.0 general tablespaces. Introduction MySQL 8.0 (the DMR version is available now) has two great features (among others): The new data dictionary completely removed *.frm files, which is great The ability to create a...
by Sveta Smirnova | Sep 2, 2016 | MySQL, Webinars
In this blog, I will provide answers to the Q & A for the InnoDB Troubleshooting webinar. First, I want to thank everybody for attending the August 11 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I...
by Hrvoje Matijakovic | Aug 23, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.14-7 on August 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.7.14, including all the bug fixes in it, Percona Server 5.7.14-7 is the current...
by Hrvoje Matijakovic | Aug 19, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.51-38.1 on August 19, 2016. Based on MySQL 5.5.51, including all the bug fixes in it, Percona Server 5.5.51-38.1 is now the current stable release in the 5.5 series. Percona Server is open-source and free. You can...
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 | Aug 9, 2016 | MySQL, Percona Events, Webinars
Join Sveta Smirnova Thursday, August 11 at 10 am PDT (UTC-7) for a webinar on InnoDB Troubleshooting. InnoDB is one of the most popular database engines. This general-purpose storage engine is widely used, has been MySQL’s default engine since version 5.6, and...
by Hrvoje Matijakovic | Jul 7, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.31-77.0 on July 7th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server 5.6.31-77.0 is the...
by Sveta Smirnova | Jun 17, 2016 | MySQL
What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post. Recently I received a question from a user about one of my earlier blog posts. Since it wasn’t sent as a comment, I will answer it here. The...
