We can show mysql variables with the following;
SHOW VARIABLES WHERE variable_name = 'some_variable';
SHOW VARIABLES LIKE '%some_variable%'; 
Example, to show the number of days binary logs are retained for;
SHOW VARIABLES WHERE variable_name = 'expire_logs_days';
 
No comments:
Post a Comment
Note: only a member of this blog may post a comment.