To enable slow query log in cPanel server, you can use following steps. Its pretty simple.
Add following to following to /etc/my.cnf file on server.
# vi /etc/my.cnf
log-slow-queries=/var/lib/mysql/slow.log
After that, do the following commands to create the file with the right ownership and file permissions:
# touch /var/lib/mysql/slow.log
# chmod 660 /var/lib/mysql/slow.log
# chown mysql:mysql /var/lib/mysql/slow.log
Restart the mysql server and check the logs in /var/lib/mysql/slow.log.
In the world of digital marketing, getting attention is only half the battle. The real goal is to convince people…
Introduction In today's digital world, understanding website bandwidth is essential for anyone running a website. Whether you own a blog,…
Artificial intelligence is changing the tech world at lightning speed. From automated chatbots to AI-generated applications, many people are now…
Introduction to Bot Traffic Bot traffic refers to visits to a website that come from automated software programs rather than…
Windows may look like a point-and-click operating system, but under the hood, commands still do a lot of the heavy…