Many users new to MySQL will find themselves overwhelmed when tasked with configuring their system for best performance. It doesn't need to be intimidating, however. MySQL offers nearly 400 settings to consider, but a user should understand that most of the system's benefits can be achieved just by getting a few fundamental configurations right. The vast majority of optimizing configuration comes from selecting those very important options. Knowing where to look is the first step, and utilizing tools such as a monitoring product can be a huge boon.

Look Before You Leap

Even before beginning, a user should internalize a few ideas. First of all, while you should not be afraid to approach and adjust your server’s configuration, there are some common mistakes that it’s good to know about so you can avoid them.

The first thing to know is that …

Download PDF Presentation

At the recent New York Oracle Users Group summer general meeting I gave a presentation to the Oracle community on the MySQL product release cycle. Details included:

• Identifying the server product options covering community, enterprise and ecosystem.
• Describe MySQL enterprise products, features and support options.
• Describing the DMR, RC, GA, EOL and labs product lifecycle.
• Discussing the GA release frequency.
• Talking about the MySQL Upgrade path.

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 question:

> I am reading your article:
> https://www.percona.com/resources/technical-presentations/troubleshooting-locking-issues-percona-mysql-webinar

> Full table scan locks whole table.

> Some bad select (read) query can do full table scan on InnoDB, does it lock whole table please?

> My understanding was that SELECT (read) blocks another DML only in MyISAM.

To answer this question, we to need understand two different concepts: locking and …

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.50, MariaDB Connector/J 1.4.6, and MariaDB Connector/ODBC 2.0.11. See the release notes and changelogs for details on these releases. Download MariaDB 5.5.50 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 1.4.6 Release Notes Changelog […]

The post MariaDB 5.5.50 and updated connectors now available appeared first on MariaDB.org.

In this tutorial we will show you how to setup basic MySQL replication on two CentOS 7 servers, but the same steps should work on all RPM based systems. We will use two test CentOS 7 virtual servers for this tutorial with the following IP addresses: MASTER: 123.456.789.1 SLAVE: 123.456.789.2 Master Server: Login to the master server as user root ssh root@IP_Address and install MySQL server if it is not already installed yum install mysql-server mysql Start the MySQL server and enable it to start at boot time systemctl start mysql systemctl enable mysql Next, open the MySQL configuration file […]

How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes?

In my previous post I looked how to run Percona XtraDB Cluster in a Docker Swarm orchestration system, and today I want to review how can we do it in the more advanced Kubernetes environment.

There are already some existing posts from Patrick Galbraith (https://github.com/kubernetes/kubernetes/tree/release-1.2/examples/mysql-galera) and Raghavendra Prabhu (https://github.com/ronin13/pxc-kubernetes) on this topic. For this post, I …

 All you need for monitoring MySQL servers

Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server execution information while minimizing the impact on server performance. There is a trade-off between the time you can save by using Performance Schema and the load it adds to the server. It can optimize server performance and save time when used in an efficient manner.

You can also target …

All you need for monitoring MySQL servers. Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server execution information while minimizing the impact on server performance. There is a trade-off between the time you can save by using Performance Schema and the load it adds to the server. It can optimize server performance and save time when used in an efficient manner.

You can also target queries that …

In this blog, I provide answers to the Q & A for the Troubleshooting hardware resource usage webinar.

First, I want to thank everybody who attended the May 26 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with responses:

Q: How did you find the memory IO LEAK?

A: Do you mean the replication bug I was talking about in the webinar? I wrote about this bug …

Last week during the Oracle Users Group Leaders Summit in Bucharest I had the pleasure the meet the leaders for the MySQL Users Group from Azerbaijan,  Finland, Madrid and the Netherlands.

During some discussions, it appeared that some users are not aware of the Performance_Schema integration in MySQL Workbench. Indeed with WB you can enable PFS, add sys table if not present by default (<5.7).

You can use a default configuration or customize it and enable all the instruments and consumers you need.

When enabled, you can generate some useful reports

In case you are also not yet aware of it, the following dashboard is also available in MySQL Workbench

The latest version of MySQL Workbench has been released yesterday, June 13th : 6.3.7 GA