Percona Services

MySQL Error: Too many connections

MySQL Error: Too many connections

Editor’s Note: Follow up to this post here MySQL 5.7 Performance Tuning After Installation.
We have always received quite a few questions here at wait_timeout is an important parameter to tune and discard unused or idle connections to minimize the number of active connections to your MySQL server – and this will ultimately help to […]

Read more

Percona XtraBackup – A workaround to the failed assertion bug

I recently conducted a test backup of my “master-slave” setup in my VirtualBox as I was migrating from Percona XtraBackup v2.2.0 rev. 4885. However, doing the backup on my slave, I encountered this problem:

Shell

[04] Compressing and streaming ./test/checksum.ibd
[01] Compressing and streaming ./mysql/slave_master_info.ibd
Assertion “to_read % cursor->page_size == 0” failed at fil_cur.cc:293
innobackupex: Error: The xtrabackup child […]

Read more

Innotop: A real-time, advanced investigation tool for MySQL

GUI monitoring tools for MySQL are not always suitable for all our needs or situations. Most of them are designed to provide historical views into what happens to our database over time rather then real-time insight into current MySQL server status. Excellent free tools for this include Nagios, etc. But each of them needs […]

Read more

Why is the ibdata1 file continuously growing in MySQL?

ibdata1 file

We often receive this question about the ibdata1 file in MySQL at Percona Support.
The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled.
After some research, you realize that most of the disk space is used by the […]

Read more

John Cesario of Go Daddy on Percona MySQL Training

Senior MySQL DBA John Cesario of Go Daddy spoke at Percona Live in April and shared his views on Percona MySQL Training. Here’s what he had to say:
“Go Daddy is passionate about helping our customers. Percona Innodb training gives us another tool to elevate our customer support to the next level. It gives us […]

Read more