June 18, 2013

Post: Troubleshooting MySQL Memory Usage

…where memory could be allocated but it is a lot larger problems with MySQL 5.5…test TABLE_NAME: tmp ENGINE: MEMORY NAME: #sql516_1c42_1 TABLE_ROWS: 2 AVG_ROW…Innodb run away memory allocation is Dictionary cache though there could be other reasons too. Memory Leaks There are many kinds of memory leaks

Post: Announcing Percona Server for MySQL version 5.1.67-14.4

MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1…). Upstream bug #67983 was causing a memory leak on a filtered slave. Bug fixed … another command line option innodb_changed_pages_limit. MySQL option handling would…

Post: MySQL Binaries Percona build10

…| ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control …we fixed potential memory leaks in microslow and userstats patches, the leak appeared under some workloads. The -percona release includes: | innodb_check_defrag….

Post: 10+ Ways to Crash or Overload MySQL

…be created in memory. Memory Tables If you can create memory tables …mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table Cache LeakInnodbMySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1

Comment: How much memory can MySQL use in the worst case?

… reported this issue around 5.0.27 to mysql, and they indeed find one memory leak. Unfortunately this didn’… 20926208 | +—————————————-+ | 1214764508 | +—————————————-+ That’s 1.2GB for 1.5 week of uptime, ouch. We have about 300 innodb tables. But …