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. Mysql find slave lag
  4. CSS – !important examples
  5. Enable query log without restarting mysql on Linux
  6. viewport and media queries for mobile browsers – quick introduction
  7. migrate multiple mysql databases using mysqldump on Linux
  8. How to check the performance of a plugin using mysql query log
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged ,