On 9 Jun 2009, at 22:43, Daniel Ouellet wrote:
If I may asked, why would you really want to get a 2GB buffer?
The app generates a lot of database traffic, as well as doing some
fairly large transactional queries, hence the need for InnoDB. MySQL
queries keep failing with lack of memory errors:
090609 17:23:42 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 1048548 bytes)
090609 17:25:10 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 260160 bytes)
090609 17:25:11 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 260160 bytes)
090609 17:25:11 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 260160 bytes)
090609 17:25:11 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 260208 bytes)
090609 17:25:11 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 1048548 bytes)
090609 17:25:23 [ERROR] /usr/local/libexec/mysqld: Out of memory
(Needed 260464 bytes)
And bouncing the MySQL server seems to bring it back to life. If I
can't change the hard limits on the OS, is there something I can do to
MySQL to make it happier?
G.
--
Bought to you by the Department of Redundancy Department's Recursion
Division of Recursion
http://playr.co.uk/
