Enable the slow query log

log-slow-queries=/var/lib/mysql/slow.log

touch /var/lib/mysql/slow.log
chmod 660 /var/lib/mysql/slow.log
chown mysql:mysql /var/lib/mysql/slow.log

mysqlcheck --auto-repair --check --optimize --all-databases
  • 1 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

Searching for Spammers

nbound spam to users Inbound spam is the scourge of the modern internet and, the inconvenience...

10 Tips for Improving Email Delivery

One of the most common problems that hosting providers face is the issue of user email not...

Using Custom RBL’s with Exim and cPanel

cPanel 11.28 introduces an way to easily implement your own RBLs for Exim to perform lookups...

User Databases Missing from cPanel

After upgrading to cPanel 11.28, a number of our users indicated that databases were missing...

Methods to Increase Security on suPHP - Restricting who can use php.ini files

The php.ini file under suPHP While suPHP has various security enhancements over DSO PHP such as...