MySQL 5.0.44 with Innodb Max memory problem :-(

--0-2040802451-1279728970=:47863
Content-Type: text/plain; charset=us-ascii

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 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 reboot it is fine and purring. When I start to create reports and
run a few SUPER THICK queries, is starts to eat up memory and CPU then once it
hits it's 12GB limit that I have setup in the my.cnf file it just stays there.
The coders are using indexing for several hundread tables so I am wondering if
it just loaded all of the index into memory based on my query and then it just
leaves it there, BUT if that is the case why is the OS still max'd out of memory
when I shutdown MySQL??? :-(


Any help, guidance or advise is much appreciated.

Nunzio



--0-2040802451-1279728970=:47863--

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

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 reboot it is fine and purring. When I start to create reports and

Are you sure it's MySQL using up all the memory? If you order top
output by size you don't see any other process eating up memory? This
is more of a system administration question than MySQL.


> Any help, guidance or advise is much appreciated.
>
> Nunzio
>
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org