How to see current mySql parameters and settings
Posted: Tue Jan 09, 2018 1:44 pm
Login to mySql server
Enter your password
Then enter following sql
Now enter following command by changing LIKE part as required
Te above command returns a table such as below.
You can also see Global and Session variables as below.
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%';