Code: Select all
mysql -u username -p
Then enter following sql
Code: Select all
SELECT @@GLOBAL.innodb_data_file_path;
Code: Select all
mysql> SHOW VARIABLES LIKE 'auto%';
Code: Select all
+-----------------------------------------+---------------------------+
| Variable_name | Value |
+-----------------------------------------+---------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
Code: Select all
SHOW SESSION VARIABLES LIKE 'max_join_size';
SHOW GLOBAL VARIABLES LIKE '%size%';