How to enable Logs in MySQL

Logs are the best part to start troubleshooting.In this article we will show you how to enable the different type of logs into MySQL server: Error Log: It contains all the information about MySQL errors.To enable MySQL error log edit MySQL configuration file and update following setting as per your requirements. [mysqld] log_error = /var/log/mysql/error.log […]

Continue Reading…

How to check MySQL database size

This article will guide you to calculate size of tables and database in MySQL servers though sql queries. MySQL stored all the information related to tables in database in information_schema database. We will use information_schema table to find databases and tables size. To check single database size in MySQL we may run this query,Please change ‘testdb‘ with your actual database […]

Continue Reading…