Mysql – get total queries since beginning

Total queries on mysql prompt:

mysql> SHOW STATUS like "Queries";
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| Queries       | 278583 |
+---------------+--------+
1 row in set (0.00 sec)


Total queries on shell prompt:

$mysql -u root  -e 'SHOW STATUS like "Queries"'
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| Queries       | 278583 |
+---------------+--------+
Share this article: share on Google+ share on facebook share on linkedin tweet this submit to reddit

Comments

Click here to write/view comments