Tag - mysql

change-timezone-for-MySQL-on-a-cPanel-server

How to change timezone for MySQL on a cPanel server

For many of the websites there will be different time elements used for displaying time. It will use the server time this, but in some cases we need to have different time for the website and it is not possible to change the server time. So in that case we can change the timezone for MySQL to keep the website updated with the required timezone. For that first you need to know the function that will display the timezone for MySQL, [...]

Read more...
How-to-check-mysql-processlist

How to check mysql processlist on a cPanel server

There are different ways for checking mysql processlist from a cPanel server. As you all know for most of the production server it is needed to check mysql process list for checking the currently running queries and for finding slow queries that slow down the website loading speed. You can check MySQL process list from command line in the following ways, Enter into mysql from command line using the command, mysql After that use the command, show processlist; For example: root@srv24x7 [~]# mysql Welcome to the MySQL [...]

Read more...