Value like:
show variables where Value like '%pem%' OR Value like '%key%'\G
extract all variables:
show variables\G
show global variables:
show global variables\G
The most crucial ones are:
show variables where Variable_name like 'innodb_file_per_table';
which has to be:
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| innodb_file_per_table | ON |
+-----------------------+-------+
Another way to export variables:
mysql -uzabbix -p <<< 'show variables\G' > ~/mysql.vars.log
