Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?
A.
Check the configuration files in the order in which they are read by the Mysql Server and
compare them with default values.
B.
Check the command-line options provided for the Mysql Server and compare them with default
values.
C.
Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
D.
Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with
default values.
Explanation:
Incomplete and difficult. Could be every answer… I would consider A, C.
I think answer should be C and D.
Even though parameter passed in command-line when start server, we can change the values later in mysql shell.
Agree, answer is C and D
http://dev.mysql.com/doc/refman/5.6/en/set-statement.html
If MySQL is running, any settings from A and B can have been overwritten by SET GLOBAL.
C and D list the current global settings
C is correct :
– Check output with SHOW GLOBAL VARIABLES;
– Compare it with default value
D isn’t correct
Error when you run the command INFORMATION_SCHEMA.GLOBAL_VARIABLES.
C & D is Correct…
C & D are correct.
Is the same result for:
– SHOW GLOBAL VARIABLES;
AND – SELECT * FROM INFORMATION_SCHEMA_GLOBAL_VARIABLES;
I think C & D
But in D, the correct sintax is:
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES;
C, D