MySQL 5.7 supports the Address Sanitizer, which checks for several memory
related software errors including memory leaks. It is
really nice to see support for the Address Sanitizer built into
MySQL. Unfortunately, when running the mysql tests included
in MySQL 5.7.9, the Address Sanitizer reports
several memory leaks, which causes some of the tests to
fail. Here are some of the memory leaks in the MySQL 5.7.9
software found by the Address Sanitizer.
Memory leaks in 'mysqlbinlog'Several of the 'mysqlbinlog' tests
fail due to memory leaks in the 'mysqlbinlog' client program.
Here are the details from the ' …
I just want to share about a strange behavior of one of our MySQL
server yesterday.
This server is a 5.1.50 MySQL server on debian 4.0 (Yes, I know…)
When a “mysqld got signal 6” error occurred yesterday,
the MySQL server crashed and didn’t want to restart.
Then, I found these informations in the error log file :
/usr/local/mysql/bin/mysqld: File '*** glibc detected *** malloc():memory corruption: 0x00002aac2d5ab460 ***' not found (Errcode: 2) 120306 17:19:47 [ERROR] Failed to open log (file '*** glibc detected *** malloc():memory corruption: 0x00002aac2d5ab460 ***', errno 2) 120306 17:19:47 [ERROR] Could not open log file 120306 17:19:47 [ERROR] Can't init tc log 120306 17:19:47 [ERROR] Aborting
120306 17:19:47 InnoDB: Starting shutdown... 120306 17:19:53 InnoDB: Shutdown completed; log sequence number 55 1061584593 120306 17:19:53 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
Great, let see …
[Read more]At Days of Wonder we are huge fans of MySQL (and since about a year of the various Open Query, Percona, Google or other community patches), up to the point we’re using MySQL for about everything in production.
But since we moved to 5.0, back 3 years ago our production databases which hold our website and online game systems has a unique issue: the mysqld process uses more and more RAM, up to the point where the kernel OOM decide to kill the process.
You’d certainly think we are complete morons because we didn’t do anything in the last 3 years to fix the issue
Unfortunately, I never couldn’t …
[Read more]