EmergencyEMERGENCY? Get 24/7 Help Now!

A Mystery with open_files_limit

 | October 12, 2017 |  Posted In: Insight for DBAs, MySQL, Percona Server

open_files_limit

In this blog, we’ll look at a mystery around setting the open_file_limit variable in MySQL and Percona Server for MySQL. MySQL Server needs file descriptors to run. It uses them to open new connections, store tables in the cache, create temporary tables to resolve complicated queries and access persistent ones. If mysqld is not able […]

Read More

When mysqld kills mysqld

 | October 9, 2015 |  Posted In: Insight for DBAs, MySQL

The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion we had about that internally. Our client wanted Peter to identify the culprit behind periodic shutdowns. This proved to be […]

Read More

MySQL is crashing: a support engineer’s point of view

and  | August 17, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – […]

Read More

mysqld_multi: How to run multiple instances of MySQL

 | August 26, 2014 |  Posted In: Insight for DBAs, MySQL, Percona MySQL Support, Percona Server, Percona XtraBackup

The need to have multiple instances of MySQL (the well-known mysqld process) running in the same server concurrently in a transparent way, instead of having them executed in separate containers/virtual machines, is not very common. Yet from time to time the Percona Support team receives a request from a customer to assist in the configuration of […]

Read More

Systemtap solves phantom MySQLd SIGTERM / SIGKILL issue

 | July 18, 2014 |  Posted In: Insight for DBAs, MySQL, Percona Managed Services, Percona Remote DBA

The Percona Managed Services team recently faced a somewhat peculiar client issue. We’d receive pages about their MySQL service being unreachable. However, studying the logs showed nothing out of the ordinary…. for the most part it appeared to be a normal shutdown and there was nothing in anyone’s command history nor a cron task to speak […]

Read More