Page 1 of 1
Mysqld 1662MB RAM
Posted: Sat Nov 05, 2016 4:19 pm
by Niklas
Hi
Just wanted to check, it does not feel normal for one website with a 13MB database to need over 1,5GB of ram for mysqld. What do you guys think? In my mind it must be something seriously wrong with my server or vestacp installation?
Yours // Niklas
Re: Mysqld 1662MB RAM
Posted: Sun Nov 06, 2016 5:25 am
by mehargags
Well it'd not be proper to say that outright... depends on your site's payload and coding abilities and architecture.
What is usual visit count per day for your site ?
What CMS/Framework you use ?
What MySQL version you are using ? Are there any "Slow Queries" ? What does "show processlist;" command show up ?
Is SWAP enabled ?
dmesg | grep mysql ?
# optimise and Repair all your DB's
mysqlcheck --all-databases -o
mysqlcheck --all-databases --auto-repair
mysqlcheck --all-databases --analyze
# Clean logs
> /var/log/auth.log
> /var/log/mysql/error.log
> /var/log/mysql.log
> /var/log/mysql.err
# Then tail them for fresh error.
tail -f /var/log/mysql/error.log
Also consider upgrading to MariaDB 10.1 or PerconaDB. but if your app's queries are not optimized... you may consider re-developing the application