High MySQL memory load and Vswap usage

[browie]

Hi, last two days mysql use high memory and some time stop working. And VPS vSwap usage sometimes %100 . I've try stop mysql log but its not solve problem.
VPS Feature : 1 GB Ram / 4 Cpu core

 

[cPanelMichael]

Hello

Do you notice any particular databases or tables utilizing excessive resources when running a command such as "mysqladmin processlist"?

Thank you.

 

[browie]

Hi thank you for reply. Is that what you mean about process list ?

 

[cPanelMichael]

That's one method of reviewing MySQL activity, but I was referring to running the command via the command line. You may also want to try running a MySQL tuner:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.