mysql VIRT High value

[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

[grayfolk]

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/

[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