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.
With vibrant colors, cheerful graphics, and a sprinkle of festive magic, your website can instantly create an emotional connection and…
The world of artificial intelligence is evolving faster than ever — and one of the biggest breakthroughs is here. Sora,…
Black Friday 2025 is here — the biggest shopping moment of the year, where customers expect unbeatable prices, fast performance,…
When you move or delete a page on your WordPress website, visitors — and search engines — can easily hit…
Introduction Artificial Intelligence has made remarkable strides — from writing poetry to generating code. Yet, most AIs still act like…