Connect to your MySQL server and run the following: mysql> select table_name, round(((data_length + index_length) / (1024 * 1024)), 2) as `Size in MB` from information_schema.tables where table_schema = ‘YOUR_DB_NAME’ order by `Size in MB`; I work as a freelancer,… Read More
How to enable and analyse the slow query log on MySQL?
Set the following variables in your MySQL config file: slow_query_log = 1 (means true) long_query_time = 0 (means 0 seconds) log_queries_not_using_indexes = 1 (means true) log_output = FILE (default is TABLE) Setting long_query_time to 0 will instruct MySQL to log… Read More
How to install a MySQL NDB Cluster on Ubuntu?
Official documentation here. There are 3 different types of nodes for MySQL Cluster: NDB manager, NDB node and MySQL server. Please note the standard MySQL server does not support NDB tables, so the MySQL server must be the one compiled… Read More
How to fix login issues with a password-less root MySQL user?
If you installed MySQL without a root password, you will have difficulties to login as root. For example, you need to sudo first, and can’t login as a regular user. The solution to this problem is to create a new… Read More