by Daniel Guzmán Burgos | Dec 19, 2019 | Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins. Plugins are an easy...
by Brian Sumpter | Dec 19, 2019 | Cloud, Insight for DBAs, MySQL
As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon RDS....
by Sveta Smirnova | Dec 19, 2019 | MySQL, Webinars
by Yves Trudeau | Dec 18, 2019 | Insight for DBAs, MySQL, Storage Engine
The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an...
by David Quilty | Dec 18, 2019 | MySQL, Percona Software, Webinars
This talk uncovers which tools/plugins/settings you need to use to comply with PCI/DSS when using MySQL. Gain a solid grasp of the possibilities, as well as the limitations, MySQL offers to someone looking to become PCI/DSS certified. Please join Percona Support...
by Mike Benshoof | Dec 18, 2019 | Cloud, Database Trends, MySQL
When we think about the cloud, often we consider many of the benefits: scalability, elasticity, agility, and flexible pricing. As great as these features are, security also remains a business-critical concern. In an on-premise environment, every aspect of security is...
by David Quilty | Dec 17, 2019 | MySQL, Percona Software, Webinars
MySQL has been ranked as the second most popular database since 2012 according to DB-Engines. Three features help it retain its top position: replication, storage engines, and NoSQL support. During this webinar, we’ll discuss the MySQL architecture surrounding...
by Robert Golebiowski | Dec 9, 2019 | MySQL, Percona Software, Security
It has been possible to enable Transparent Data Encryption (TDE) in Percona Server for MySQL/MySQL for a while now, but have you ever wondered how it works under the hood and what kind of implications TDE can have on your server instance? In this blog posts series, we...
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...
