The slow query log consists of SQL statements that took more than long_query_time seconds to execute and required at least min_examined_row_limit rows to be examined. It is very helpful in troubleshooting bad queries. Add the following to /etc/my.cnf file to enable the slow query log: Code: log-slow-queries=/var/lib/mysql/slow.log After that, then do the following commands to […]
Month: September 2013
Iptables problems on VPSes
You might have come across issues with csf on VPSes. CSF requires at least these iptables modules to work properly: ip_tables ipt_state ipt_multiport iptable_filter ipt_limit ipt_LOG ipt_REJECT ipt_conntrack ip_conntrack ip_conntrack_ftp iptable_mangle Other modules for additional functionality: ipt_owner ipt_recent iptable_nat ipt_REDIRECT You can check the hosting environment using : /etc/csf/csftest.pl This should run without any FATAL […]
locate: can not open `/var/lib/mlocate/mlocate.db’: No such file or directory
The locate command is a very useful command to find the exact path/location of files in Linux if you know the file name. You can install it using yum and the package is mlocate.Quote can not open `/var/lib/mlocate/mlocate.db’: No such file or directory It is a common issue while using locate command, and the error […]