mysql VIRT High value
mysql VIRT High value
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
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
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: mysql VIRT High value
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
You should check what queries cause increased mysql usage.
Try check what queries:
You try to check my mysql cheatsheet ;) https://wiki.balinskis.lt/mysql
Try check what queries:
Code: Select all
mysql -e 'show processlist;'