by Yves Trudeau | Sep 19, 2019 | Hardware and Storage
Last year, I wrote a post focused on the performance of the 3D_XPoint technology and sold under the Optane brand. Those devices are outperforming regular flash devices and have higher endurance. In the context of this post, I found they are also very good at handling...
by Dmitriy Kostiuk | Sep 19, 2019 | Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL®, MongoDB®, and PostgreSQL® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis...
by Dmitriy Kostiuk | Sep 19, 2019 | Monitoring, Percona Software
We are pleased to announce the General Availability of PMM2, our latest software release! Created specifically to support open source software users, Percona Monitoring and Management (PMM) is a leading, free, open-source platform that allows you to actively manage...
by Borys Belinsky | Sep 18, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the release of Percona XtraDB Cluster 5.7.27-31.39 on September 18, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.27-31.39 is now the current release, based on the...
by Borys Belinsky | Sep 17, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.6.45-28.36 is now the current release, based on the...
by David Quilty | Sep 13, 2019 | Percona Software, Webinars
Please join Percona Senior Support Engineer Juan Pablo Arruti as he presents his talk “Percona XtraBackup vs Mariabackup vs MySQL Enterprise Backup” on Tuesday, September 17th, 2019 at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). View the Recording There are few ways...
by Dmitriy Kostiuk | Sep 9, 2019 | Monitoring, Percona Software
We are pleased to announce our 7th Beta release of PMM 2! Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. This release includes the following improvements: Query...
by Stephen Thorn | Sep 9, 2019 | Monitoring, MySQL, Percona Software, Storage Engine
One of the great things about working at Percona is the constant innovation that occurs as a result of a deep level of technical expertise. A more recent conversation about the Information Schema table: here. The README.md has installation instructions. Download the...
by Agustín | Aug 29, 2019 | MySQL, Open Source
In this short blog post, we will check how to use here and https://dbsake.readthedocs.io/en/latest/commands/uncache.html (Updated: Check LeFred’s comments below for more insight on this.) As an added bonus, DBSake has a fincore tool you can use! vmtouch –...
by Patrick Birch | Aug 20, 2019 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 5.6.45-86.1 on August 20, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the 5.6.45, and including all...
by Patrick Birch | Aug 15, 2019 | MySQL, Percona Software
Percona announces the release of Percona Server for MySQL 8.0.16-7 on August 15, 2019 (downloads are available here and from the Percona Software Repositories). This release is based on MySQL 8.0.16. It includes all bug fixes in these releases. Percona Server for...
by Peter Zaitsev | Aug 14, 2019 | MySQL, Percona Software
While we often run MySQL on larger scale systems in Production for Test and Dev, sometimes we want to run MySQL on the tiniest cloud instances possible or just run it on our laptops. In these cases, MySQL 8 and MySQL 5.7 memory consumption is quite important. In...
by Marco Tusa | Aug 13, 2019 | Insight for DBAs, MySQL
by Vinicius Grippa | Aug 1, 2019 | MySQL
In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, building the standby replica from scratch. The clone plugin permits cloning data locally or from a...
by marcos.albe | Jul 23, 2019 | MySQL
ERROR 1040…again A pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other...
by Alexey Stroganov | Jul 19, 2019 | MySQL
See part one of this series here. This post is part two of my series “Assessing MySQL Performance Amongst AWS Options”, taking a look at how current Amazon RDS services – Amazon Aurora and Amazon RDS for MySQL – compare with Percona Server with InnoDB and...
by Corrado Pandiani | Jul 17, 2019 | Insight for DBAs, MySQL
I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious issue because of the continuous outages of the service, as the customer had to constantly restart the server and wait for the next outage. What was...
by Carlos Tutte | Jul 5, 2019 | MySQL
During our work in support, we see this again and again: “I try to connect to MySQL and am getting a 1045 error”, and most times it comes accompanied with “…but I am sure my user and password are OK”. So we decided it was worth...
by Satya Bodapati | Jun 27, 2019 | MySQL
In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying “there is one disadvantage.” Beginning in MySQL 5.6, many DDLs including ALTER TABLE ADD INDEX became “ONLINE”. Meaning, when the...
by Borys Belinsky | Jun 26, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories. Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the...