Page 1 of 1

mysql VIRT High value

Posted: Fri Mar 08, 2019 1:44 pm
by elbahy
i have just one site at vps with vestacp control panel

i created this server 3 days ago

while this three days database has connection error for 5 times

when reboot server , it work fine

i don't know the reason to this issue

Image

Image

Re: mysql VIRT High value

Posted: Fri Mar 08, 2019 7:52 pm
by grayfolk
elbahy wrote:
Fri Mar 08, 2019 1:44 pm

i don't know the reason to this issue
1. Use mysql tune facilities like https://github.com/major/MySQLTuner-perl.
2. Use phpMyAdmin Advisor.

Also see https://haydenjames.io/mysql-performanc ... pts-tools/

Re: mysql VIRT High value

Posted: Thu Apr 25, 2019 10:51 pm
by dreiggy
You should check what queries cause increased mysql usage.

Try check what queries:

Code: Select all

mysql -e 'show processlist;'
You try to check my mysql cheatsheet ;) https://wiki.balinskis.lt/mysql