Follow the below steps and reslove the issue :- In cPanel >> mysql databases, it’s display database size as “zero” even if it is not. You just need to make the below changes to fix it : # cat /var/cpanel/cpanel.config | grep disk_usage_include_sqldbs disk_usage_include_sqldbs=0 Now we can see disk_usage_include_sqldbs=0 ( … Continue reading
Check MySQL Server is up and down Mysql is UP : # mysqladmin -u root ping mysqld is alive Mysql is DOWN : # mysqladmin -u root ping mysqladmin: connect to server at ‘localhost’ failed error: ‘Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)’ Check that mysqld is … Continue reading
If you want to check the server version of the mysql, this command also displays the current status of the mysql server. # mysqladmin -u root version mysqladmin Ver 8.42 Distrib 5.1.63, for unknown-linux-gnu on x86_64 Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a … Continue reading
See the List of all mysqladmin flush commands Examples :- # mysqladmin -u root flush-hosts # mysqladmin -u root flush-logs # mysqladmin -u root flush-privileges # mysqladmin -u root flush-status # mysqladmin -u root flush-tables # mysqladmin -u root flush-threads flush-hosts: It is flush all information in the host cache. … Continue reading
You can user combine process-list, status and version command using one command. To get all the output together as shown below. # mysqladmin -u root process status version +—–+————–+———–+————–+———+——+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +—–+————–+———–+————–+———+——+——-+——————+ | 95 | … Continue reading