Index Virtual Machine

Q. What version of MySQL Server is installed with the CIS?

A. The MySQL Server version is MySQL Enterprise Commercial (Advanced) Edition Version 5.7.11.

Q. How do I view the logs in MySQL Server?

A. MySQL Server's log file can be found in the directory /var/lib/mysql.log. The main log file is named <host_name>.err. The error log can be found in the directory /var/lib/mysql/index.err.

If configured to do so, slow query logs can be found in the directory /var/lib/mysql/index-slow.log.

Note:

All ISR-related errors are found in the respective component logs.

Q. How do I log slow queries in MySQL Server?

A. To start logging slow queries without restarting mysql server, execute the following:
  1. At MySQL command prompt, enter set global slow_query_log=1.
  2. Enter set global long_query_time=1 (or whatever you want for query seconds).
  3. To verify the settings for these commands, use the following show variables: %slow% %length% By default, the slow query logs are stored in the directory /var/lib/mysql/index-slow.log.

Q. How do I find the data files in MySQL Server?

A. Data files for the 'ipcr_db' database are found in the directory /var/lib/mysql/ipcr_db/.