by David Quilty | Dec 3, 2019 | MySQL, Webinars
MySQL does its best to return requested bytes as fast as possible. However, it needs human help to identify what is important and should be accessed in the first place. Queries, written smartly, can significantly outperform automatically generated ones. Indexes and...
by Mykola Marzhan | Nov 26, 2019 | Benchmarks, Cloud, Hardware and Storage, MySQL
Making backups over the network can be done in two ways: either save on disk and transfer or just transfer without saving. Both ways have their strong and weak points. The second way, particularly, is highly dependent on the upload speed, which would either reduce or...
by Yves Trudeau | Nov 22, 2019 | Insight for DBAs, Insight for Developers, MySQL
If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are just a few examples: Storing UUID and Generated Columns Storing UUID Values in MySQL Illustrating Primary Key models in InnoDB and their impact on disk usage MySQL UUID...
by Peter Zaitsev | Nov 22, 2019 | Monitoring, MySQL, Percona Software
As Grafana powers our star product – Percona Monitoring and Management (PMM) – we have developed a lot of experience creating Grafana Dashboards over the last few years. In this article, I will share some of the considerations for designing Grafana...
by Agustín | Nov 20, 2019 | MySQL, Percona Software
In this blog post, we will see how to use perf (a.k.a.: perf_events) together with Flame Graphs. They are used to generate a graphical representation of what functions are being called within our software of choice. Percona Server for MySQL is used here, but it can be...
by Peter Zaitsev | Nov 19, 2019 | MySQL
I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions. In this blog series, I will look into how you can install MySQL, MariaDB, or...
by Tibor Korocz | Nov 4, 2019 | Cloud, MySQL
Recently I was doing some small testing by using EC2 instances on AWS and I noticed the execution time and performance highly depend on which time of the day I am running my scripts. I was using t3.xlarge instance type as I didn’t need many CPUs and memory for...
by Daniel Guzmán Burgos | Nov 1, 2019 | Insight for DBAs, MariaDB, MySQL
Some say that the best password is the one you don’t have to remember. That’s possible with MySQL, thanks to the auth_socket plugin and its MariaDB version unix_socket. Neither of these plugins is new, and some words have been written about the auth_socket on...
by Tibor Korocz | Oct 30, 2019 | MySQL, Percona Software
In MySQL 8.0.18 there is a new feature called how it works under the hood. The high-level basics are the following: if there is a join, it will create an in-memory hash table based on one of the tables and will read the other table row by row, calculate a hash, and do...
by Corrado Pandiani | Oct 29, 2019 | Insight for Developers, MySQL, Open Source, Percona Software
by Tibor Korocz | Oct 28, 2019 | MySQL
In MySQL 8.0.18 there is a new feature called Explain Analyze when for many years we mostly had only the traditional Explain. I know there are different formats, but those based on the same information just show it in a different format with some extra details. But...
by Peter Zaitsev | Oct 23, 2019 | Monitoring, MySQL
MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do. MySQL Workbench Licensing MySQL Workbench is similar to MySQL Server and is an...
by Ramesh Sivaraman | Oct 15, 2019 | MySQL, Percona Software
This blog post will help you configure a 3-node Percona XtraDB Cluster using a binary tarball on your local machine. Configuration files are auto-generated with mostly default configurations except for port/IP address details. The tool has the handy script to create...
by Dmitriy Kostiuk | Oct 9, 2019 | Monitoring, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring your database performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®,...
by Kenn Takara | Oct 4, 2019 | Insight for DBAs, MySQL, Percona Software
Starting with the experimental release of Percona XtraDB Cluster 8.0, we have made changes to the SST process to make the process more robust and easier to use. mysqldump and rsync are no longer supported SST methods. Support for mysqldump was deprecated starting with...
by Borys Belinsky | Oct 1, 2019 | Insight for DBAs, MySQL, Percona Software, ProxySQL
Percona is happy to announce the first experimental binary of Percona XtraDB Cluster 8.0 on October 1, 2019. This is a major step for tuning Percona XtraDB Cluster to be more cloud- and user-friendly. This release combines the updated and feature-rich Galera 4, with...
by Daniel Guzmán Burgos | Sep 27, 2019 | MySQL
MySQL Shell is a pretty nice piece of software. Is not just another mysql client but it is also a tool that offers scripting capabilities for JavaScript and Python. And one of the coolest things you can do with it is to check if your MySQL 5.7 server is ready for an...
by Walter Garcia | Sep 26, 2019 | Insight for DBAs, MySQL, Percona Software
In a previous post, I showed you how to compile Percona Mysql 5.7 on Raspberry PI 3. Now, I’ll show you how to compile and run the latest version of Percona XtraDB Cluster 5.7.26. We will need at least 3 RaspberryPi 3 boards, and I recommend you use an external...
by Mike Benshoof | Sep 23, 2019 | Insight for DBAs, MySQL
If you have been around MySQL for any length of time, you are probably aware that choosing the correct data types and optimizing your schema are actually important tasks. A few years back at Percona Live 2016, I gave an introductory talk on schema review and...
