Skip to content

Instantly share code, notes, and snippets.

@vicendominguez

vicendominguez/vmsqlstat.sh

Last active August 29, 2015 13:56
Show Gist options
  • Save vicendominguez/8820412 to your computer and use it in GitHub Desktop.
Save vicendominguez/8820412 to your computer and use it in GitHub Desktop.
Download ZIP
watching queries per second (vmstat style) on MySQL
Raw
vmsqlstat.sh
mysqladmin ext -ri 1 |grep -i -e queries -e \-
Raw
zoutput
+-----------------------------------+--------------+
+-----------------------------------+--------------+
| Qcache_queries_in_cache | 5282 |
| Queries | 669070336 |
| Slow_queries | 2950563 |
+-----------------------------------+--------------+
+-----------------------------------+--------------+
+-----------------------------------+--------------+
| Innodb_data_pending_fsyncs | -1 |
| Qcache_free_memory | -2440 |
| Qcache_queries_in_cache | 1 |
| Queries | 211 |
| Slow_queries | 0 |
+-----------------------------------+--------------+
+-----------------------------------+--------------+
+-----------------------------------+--------------+
| Qcache_queries_in_cache | 0 |
| Queries | 177 |
| Slow_queries | 0 |
+-----------------------------------+--------------+
+-----------------------------------+--------------+
+-----------------------------------+--------------+
| Innodb_data_pending_fsyncs | -1 |
| Innodb_os_log_pending_fsyncs | -1 |
| Qcache_queries_in_cache | 0 |
| Queries | 133 |
| Slow_queries | 0 |
+-----------------------------------+--------------+
+-----------------------------------+--------------+
+-----------------------------------+--------------+
| Open_files | -8 |
| Qcache_queries_in_cache | 0 |
| Queries | 687 |
| Slow_queries | 0 |
+-----------------------------------+--------------+
+-----------------------------------+--------------+
+-----------------------------------+--------------+
| Open_files | -2 |
| Qcache_queries_in_cache | -13 |
| Qcache_total_blocks | -12 |
| Queries | 544 |
| Slow_queries | 0 |
+-----------------------------------+--------------+
+-----------------------------------+--------------+
+-----------------------------------+--------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment