… fixed #1100159 (Laurynas Biveinis). Upstream bug #67983 was causing a memory leak on a filtered slave. Bug fixed #1042946 (Sergei Glushchenko). Percona… in start up errors. Fixed by renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #1105726 (Laurynas…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… Save on data conversion and copying Avoid SQL Injection Save memory on handling blobs There are also drawbacks and chewats of… include full statement text not only “Execute” but in SHOW INNODB STATUS you would still see statements without actual values – quite… multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL Server turned out to be prepare statements…
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.2
February 13, 2013 By Leave a Comment
… for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, InnoDB temporary tables still have this issue, probably…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… statement. Innodb Table Cache Leak – Innodb never shrinks its internal table cache (data dictionary) so by creating and accessing large amount of Innodb tables you can allocate large amount of memory on server. The size is typically…
Comment: What's up with HandlerSocket?
March 30, 2011 By 43 Comments
… in a single schema , I’ll get a out of memory err . it may because Handlersocket use one THD to deal… that time , the update still not be committed to the innodb engint. so it will lose some update . it may cause… safe . 3. innodb only have page buffer. this cause the leak of memory . 4. when the data are not in the memory, we have…
Comment: What's up with HandlerSocket?
March 28, 2011 By 43 Comments
… in a single schema , I’ll get a out of memory err . it may because Handlersocket use one THD to deal… that time , the update still not be committed to the innodb engint. so it will lose some update . it may cause… safe . 3. innodb only have page buffer. this cause the leak of memory . 4. when the data are not in the memory, we have…
Comment: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
I believe I am encountering the Innodb Table Cache Leak problem. Is it possible to release this memory in some way? Will FLUSH TABLES release this memory?
Comment: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… InnoDB shutdown. I have a number of servers which in the somewhat older (major release is still supported…) version of MySQL leak memory… crash recovery. Is there any good way to know when InnoDB is shutdown when MySQL is not yet?
