Re: Mysql high cpu usage problem
Oh. But the relevant line is this:
Mem: 494M Active, 1034M Inact, 357M Wired, 97M Cache, 199M Buf, 21M Free
If you add all the numbers, you come over 2G. What I see from the line is that all memory is recognized, but 1034M are inactive (whatever this means). OTOH, the interpretation of this line might depend on the kernel version, which the OP did not mention. Unfortunately my 'top' shows a mem line with different fields. And /proc/meminfo shows even more fields.
I use a 2.6 kernel, have set HIGHMEM (definitely!) and have 1,3G inactive currently, though I copied a couple of MySQL trees. Gkrellm shows that almost all of the memory is used for the filesystem cache. This sounds logical after the copy. So 'inactive' cannot mean 'unrecognized'.
Regards,
Ingo
Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com