Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the difference between

SHOW /*!50000 GLOBAL */ STATUS 

and

SHOW GLOBAL STATUS

I saw that in few scripts and tuning presentations the first command is being used. Is there a difference, If there is, what does the 50000 signify ?

Also, this seems to be a good script : https://raw.github.com/rackerhacker/MySQLTuner-perl/master/mysqltuner.pl Are there any similar scripts that list important stats and display recommendations

share|improve this question
1  
I'd recommend splitting the second part into a completely separate question. –  Matt Fenwick Mar 27 '12 at 17:43

1 Answer 1

The "50000" refers to a MySQL version -- it means that only version 5.0.0 and above should pay attention to that command. 5.0.0+ will see SHOW GLOBAL STATUS, while earlier versions will see just SHOW STATUS.

Example:

mysql> /*!50511 select 1 */;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

mysql> /*!50512 select 1 */;
Query OK, 0 rows affected (0.00 sec)

(I have MySQL 5.5.11 -- i.e. 5.05.11).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.