Mysql – get total queries since beginning

By on

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 |
+---------------+--------+

Suggested posts:

  1. How to find mysql query rate on Linux
  2. Mysql – display row count and size of tables
  3. Enable query log without restarting mysql on Linux
  4. migrate multiple mysql databases using mysqldump on Linux
  5. Mysql – get size of all databases
  6. How to check the performance of a plugin using mysql query log
  7. Mysql – how to enable query log
  8. Ubuntu – check if a service is upstart based
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged ,