To get all the server variables run this query either in the SQL window of your preferred interface (PHPMyAdmin or other) or in the MySQL CLI interface
SHOW VARIABLES;
You can specify if you want the session variables or the global variables as follows:
Session variables:
SHOW SESSION VARIABLE...
To get the database server status run this query in either the SQL window of your preferred interface (PHPMyAdmin or other) or on the MySQL CLI interface.
SHOW STATUS;
You can specify whether you wish to receive the SESSION or GLOBAL status of your sever like so:
Session status:
SHOW SESSION S...
