High MySQL memory load and Vswap usage

browie

• December 08, 2015 18:38

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

  • December 09, 2015 01:11

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

  0
• 

  browie

  • December 09, 2015 09:18

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

  0
• 

  cPanelMichael

  • December 09, 2015 14:32

  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.

  0

Please sign in to leave a comment.