Re: MySQL 5.0.44 with Innodb Max memory problem :-(

2010-07-22 Thread Ken Menzel
On 7/21/2010 12:16 PM, Nunzio Daveri wrote: database is around 150GB with over 5,000 tables. To make things worse, if I shutdown MySQL, top-c still says all the memory is still used? Is this a bug, why would it say all the memory is used when I turn off MySQL. The weird thing is that when I rebo

MySQL 5.0.44 with Innodb Max memory problem :-(

2010-07-21 Thread Nunzio Daveri
Hello Gurus, I just inhereted a Sun 2 U Server with 2 Intel Quad Core CPU's and 16 GB of ram. Here is the problem. The machine is constantly at 99% Memory utilization and we get random row locking, we are only using InnoDB. The database is around 150GB with over 5,000 tables. To make things wors