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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the difference between




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 : Are there any similar scripts that list important stats and display recommendations

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

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.


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


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.