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 kill unresponsive ssh session using escape sequence
  2. CSS – round toggle switch using checkbox and label
  3. Git – rename local branch
  4. How to find mysql query rate on Linux
  5. AngularJS format date using date filter
  6. Chrome – copy any request as cURL including headers
  7. Javascript in header vs footer
  8. prevent wordpress xmlrpc.php attack
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged ,