Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW GLOBAL STATUS\G
- *************************** 1. row ***************************
- Variable_name: Aborted_clients
- Value: 75104
- *************************** 2. row ***************************
- Variable_name: Aborted_connects
- Value: 16119
- *************************** 3. row ***************************
- Variable_name: Binlog_cache_disk_use
- Value: 0
- *************************** 4. row ***************************
- Variable_name: Binlog_cache_use
- Value: 0
- *************************** 5. row ***************************
- Variable_name: Bytes_received
- Value: 150349966254
- *************************** 6. row ***************************
- Variable_name: Bytes_sent
- Value: 191126939534
- *************************** 7. row ***************************
- Variable_name: Com_admin_commands
- Value: 0
- *************************** 8. row ***************************
- Variable_name: Com_assign_to_keycache
- Value: 0
- *************************** 9. row ***************************
- Variable_name: Com_alter_db
- Value: 0
- *************************** 10. row ***************************
- Variable_name: Com_alter_db_upgrade
- Value: 0
- *************************** 11. row ***************************
- Variable_name: Com_alter_event
- Value: 0
- *************************** 12. row ***************************
- Variable_name: Com_alter_function
- Value: 0
- *************************** 13. row ***************************
- Variable_name: Com_alter_procedure
- Value: 0
- *************************** 14. row ***************************
- Variable_name: Com_alter_server
- Value: 0
- *************************** 15. row ***************************
- Variable_name: Com_alter_table
- Value: 1
- *************************** 16. row ***************************
- Variable_name: Com_alter_tablespace
- Value: 0
- *************************** 17. row ***************************
- Variable_name: Com_analyze
- Value: 0
- *************************** 18. row ***************************
- Variable_name: Com_backup_table
- Value: 0
- *************************** 19. row ***************************
- Variable_name: Com_begin
- Value: 157939712
- *************************** 20. row ***************************
- Variable_name: Com_binlog
- Value: 0
- *************************** 21. row ***************************
- Variable_name: Com_call_procedure
- Value: 0
- *************************** 22. row ***************************
- Variable_name: Com_change_db
- Value: 69
- *************************** 23. row ***************************
- Variable_name: Com_change_master
- Value: 0
- *************************** 24. row ***************************
- Variable_name: Com_check
- Value: 0
- *************************** 25. row ***************************
- Variable_name: Com_checksum
- Value: 0
- *************************** 26. row ***************************
- Variable_name: Com_commit
- Value: 9321
- *************************** 27. row ***************************
- Variable_name: Com_create_db
- Value: 0
- *************************** 28. row ***************************
- Variable_name: Com_create_event
- Value: 0
- *************************** 29. row ***************************
- Variable_name: Com_create_function
- Value: 0
- *************************** 30. row ***************************
- Variable_name: Com_create_index
- Value: 2
- *************************** 31. row ***************************
- Variable_name: Com_create_procedure
- Value: 0
- *************************** 32. row ***************************
- Variable_name: Com_create_server
- Value: 0
- *************************** 33. row ***************************
- Variable_name: Com_create_table
- Value: 1
- *************************** 34. row ***************************
- Variable_name: Com_create_trigger
- Value: 0
- *************************** 35. row ***************************
- Variable_name: Com_create_udf
- Value: 0
- *************************** 36. row ***************************
- Variable_name: Com_create_user
- Value: 0
- *************************** 37. row ***************************
- Variable_name: Com_create_view
- Value: 0
- *************************** 38. row ***************************
- Variable_name: Com_dealloc_sql
- Value: 0
- *************************** 39. row ***************************
- Variable_name: Com_delete
- Value: 48244
- *************************** 40. row ***************************
- Variable_name: Com_delete_multi
- Value: 0
- *************************** 41. row ***************************
- Variable_name: Com_do
- Value: 0
- *************************** 42. row ***************************
- Variable_name: Com_drop_db
- Value: 0
- *************************** 43. row ***************************
- Variable_name: Com_drop_event
- Value: 0
- *************************** 44. row ***************************
- Variable_name: Com_drop_function
- Value: 0
- *************************** 45. row ***************************
- Variable_name: Com_drop_index
- Value: 3
- *************************** 46. row ***************************
- Variable_name: Com_drop_procedure
- Value: 0
- *************************** 47. row ***************************
- Variable_name: Com_drop_server
- Value: 0
- *************************** 48. row ***************************
- Variable_name: Com_drop_table
- Value: 1
- *************************** 49. row ***************************
- Variable_name: Com_drop_trigger
- Value: 0
- *************************** 50. row ***************************
- Variable_name: Com_drop_user
- Value: 0
- *************************** 51. row ***************************
- Variable_name: Com_drop_view
- Value: 0
- *************************** 52. row ***************************
- Variable_name: Com_empty_query
- Value: 0
- *************************** 53. row ***************************
- Variable_name: Com_execute_sql
- Value: 0
- *************************** 54. row ***************************
- Variable_name: Com_flush
- Value: 0
- *************************** 55. row ***************************
- Variable_name: Com_grant
- Value: 0
- *************************** 56. row ***************************
- Variable_name: Com_ha_close
- Value: 0
- *************************** 57. row ***************************
- Variable_name: Com_ha_open
- Value: 0
- *************************** 58. row ***************************
- Variable_name: Com_ha_read
- Value: 0
- *************************** 59. row ***************************
- Variable_name: Com_help
- Value: 0
- *************************** 60. row ***************************
- Variable_name: Com_insert
- Value: 17722859
- *************************** 61. row ***************************
- Variable_name: Com_insert_select
- Value: 2
- *************************** 62. row ***************************
- Variable_name: Com_install_plugin
- Value: 0
- *************************** 63. row ***************************
- Variable_name: Com_kill
- Value: 0
- *************************** 64. row ***************************
- Variable_name: Com_load
- Value: 0
- *************************** 65. row ***************************
- Variable_name: Com_load_master_data
- Value: 0
- *************************** 66. row ***************************
- Variable_name: Com_load_master_table
- Value: 0
- *************************** 67. row ***************************
- Variable_name: Com_lock_tables
- Value: 0
- *************************** 68. row ***************************
- Variable_name: Com_optimize
- Value: 0
- *************************** 69. row ***************************
- Variable_name: Com_preload_keys
- Value: 0
- *************************** 70. row ***************************
- Variable_name: Com_prepare_sql
- Value: 0
- *************************** 71. row ***************************
- Variable_name: Com_purge
- Value: 0
- *************************** 72. row ***************************
- Variable_name: Com_purge_before_date
- Value: 0
- *************************** 73. row ***************************
- Variable_name: Com_release_savepoint
- Value: 0
- *************************** 74. row ***************************
- Variable_name: Com_rename_table
- Value: 1
- *************************** 75. row ***************************
- Variable_name: Com_rename_user
- Value: 0
- *************************** 76. row ***************************
- Variable_name: Com_repair
- Value: 0
- *************************** 77. row ***************************
- Variable_name: Com_replace
- Value: 0
- *************************** 78. row ***************************
- Variable_name: Com_replace_select
- Value: 0
- *************************** 79. row ***************************
- Variable_name: Com_reset
- Value: 0
- *************************** 80. row ***************************
- Variable_name: Com_restore_table
- Value: 0
- *************************** 81. row ***************************
- Variable_name: Com_revoke
- Value: 0
- *************************** 82. row ***************************
- Variable_name: Com_revoke_all
- Value: 0
- *************************** 83. row ***************************
- Variable_name: Com_rollback
- Value: 0
- *************************** 84. row ***************************
- Variable_name: Com_rollback_to_savepoint
- Value: 0
- *************************** 85. row ***************************
- Variable_name: Com_savepoint
- Value: 0
- *************************** 86. row ***************************
- Variable_name: Com_select
- Value: 351046682
- *************************** 87. row ***************************
- Variable_name: Com_set_option
- Value: 190853283
- *************************** 88. row ***************************
- Variable_name: Com_show_authors
- Value: 0
- *************************** 89. row ***************************
- Variable_name: Com_show_binlog_events
- Value: 0
- *************************** 90. row ***************************
- Variable_name: Com_show_binlogs
- Value: 10
- *************************** 91. row ***************************
- Variable_name: Com_show_charsets
- Value: 3
- *************************** 92. row ***************************
- Variable_name: Com_show_collations
- Value: 3
- *************************** 93. row ***************************
- Variable_name: Com_show_column_types
- Value: 0
- *************************** 94. row ***************************
- Variable_name: Com_show_contributors
- Value: 0
- *************************** 95. row ***************************
- Variable_name: Com_show_create_db
- Value: 0
- *************************** 96. row ***************************
- Variable_name: Com_show_create_event
- Value: 0
- *************************** 97. row ***************************
- Variable_name: Com_show_create_func
- Value: 0
- *************************** 98. row ***************************
- Variable_name: Com_show_create_proc
- Value: 0
- *************************** 99. row ***************************
- Variable_name: Com_show_create_table
- Value: 1
- *************************** 100. row ***************************
- Variable_name: Com_show_create_trigger
- Value: 0
- *************************** 101. row ***************************
- Variable_name: Com_show_databases
- Value: 15
- *************************** 102. row ***************************
- Variable_name: Com_show_engine_logs
- Value: 0
- *************************** 103. row ***************************
- Variable_name: Com_show_engine_mutex
- Value: 0
- *************************** 104. row ***************************
- Variable_name: Com_show_engine_status
- Value: 0
- *************************** 105. row ***************************
- Variable_name: Com_show_events
- Value: 0
- *************************** 106. row ***************************
- Variable_name: Com_show_errors
- Value: 0
- *************************** 107. row ***************************
- Variable_name: Com_show_fields
- Value: 124
- *************************** 108. row ***************************
- Variable_name: Com_show_function_status
- Value: 0
- *************************** 109. row ***************************
- Variable_name: Com_show_grants
- Value: 3
- *************************** 110. row ***************************
- Variable_name: Com_show_keys
- Value: 7
- *************************** 111. row ***************************
- Variable_name: Com_show_master_status
- Value: 0
- *************************** 112. row ***************************
- Variable_name: Com_show_new_master
- Value: 0
- *************************** 113. row ***************************
- Variable_name: Com_show_open_tables
- Value: 0
- *************************** 114. row ***************************
- Variable_name: Com_show_plugins
- Value: 49
- *************************** 115. row ***************************
- Variable_name: Com_show_privileges
- Value: 0
- *************************** 116. row ***************************
- Variable_name: Com_show_procedure_status
- Value: 0
- *************************** 117. row ***************************
- Variable_name: Com_show_processlist
- Value: 16562
- *************************** 118. row ***************************
- Variable_name: Com_show_profile
- Value: 0
- *************************** 119. row ***************************
- Variable_name: Com_show_profiles
- Value: 0
- *************************** 120. row ***************************
- Variable_name: Com_show_slave_hosts
- Value: 0
- *************************** 121. row ***************************
- Variable_name: Com_show_slave_status
- Value: 16536
- *************************** 122. row ***************************
- Variable_name: Com_show_status
- Value: 72179
- *************************** 123. row ***************************
- Variable_name: Com_show_storage_engines
- Value: 0
- *************************** 124. row ***************************
- Variable_name: Com_show_table_status
- Value: 24
- *************************** 125. row ***************************
- Variable_name: Com_show_tables
- Value: 75
- *************************** 126. row ***************************
- Variable_name: Com_show_triggers
- Value: 0
- *************************** 127. row ***************************
- Variable_name: Com_show_variables
- Value: 27075
- *************************** 128. row ***************************
- Variable_name: Com_show_warnings
- Value: 0
- *************************** 129. row ***************************
- Variable_name: Com_slave_start
- Value: 1
- *************************** 130. row ***************************
- Variable_name: Com_slave_stop
- Value: 1
- *************************** 131. row ***************************
- Variable_name: Com_stmt_close
- Value: 0
- *************************** 132. row ***************************
- Variable_name: Com_stmt_execute
- Value: 0
- *************************** 133. row ***************************
- Variable_name: Com_stmt_fetch
- Value: 0
- *************************** 134. row ***************************
- Variable_name: Com_stmt_prepare
- Value: 0
- *************************** 135. row ***************************
- Variable_name: Com_stmt_reprepare
- Value: 0
- *************************** 136. row ***************************
- Variable_name: Com_stmt_reset
- Value: 0
- *************************** 137. row ***************************
- Variable_name: Com_stmt_send_long_data
- Value: 0
- *************************** 138. row ***************************
- Variable_name: Com_truncate
- Value: 0
- *************************** 139. row ***************************
- Variable_name: Com_uninstall_plugin
- Value: 0
- *************************** 140. row ***************************
- Variable_name: Com_unlock_tables
- Value: 0
- *************************** 141. row ***************************
- Variable_name: Com_update
- Value: 152310036
- *************************** 142. row ***************************
- Variable_name: Com_update_multi
- Value: 0
- *************************** 143. row ***************************
- Variable_name: Com_xa_commit
- Value: 0
- *************************** 144. row ***************************
- Variable_name: Com_xa_end
- Value: 0
- *************************** 145. row ***************************
- Variable_name: Com_xa_prepare
- Value: 0
- *************************** 146. row ***************************
- Variable_name: Com_xa_recover
- Value: 0
- *************************** 147. row ***************************
- Variable_name: Com_xa_rollback
- Value: 0
- *************************** 148. row ***************************
- Variable_name: Com_xa_start
- Value: 0
- *************************** 149. row ***************************
- Variable_name: Compression
- Value: OFF
- *************************** 150. row ***************************
- Variable_name: Connections
- Value: 190967069
- *************************** 151. row ***************************
- Variable_name: Created_tmp_disk_tables
- Value: 75
- *************************** 152. row ***************************
- Variable_name: Created_tmp_files
- Value: 200159
- *************************** 153. row ***************************
- Variable_name: Created_tmp_tables
- Value: 81414
- *************************** 154. row ***************************
- Variable_name: Delayed_errors
- Value: 0
- *************************** 155. row ***************************
- Variable_name: Delayed_insert_threads
- Value: 0
- *************************** 156. row ***************************
- Variable_name: Delayed_writes
- Value: 0
- *************************** 157. row ***************************
- Variable_name: Flush_commands
- Value: 1
- *************************** 158. row ***************************
- Variable_name: Handler_commit
- Value: 566872737
- *************************** 159. row ***************************
- Variable_name: Handler_delete
- Value: 1627113
- *************************** 160. row ***************************
- Variable_name: Handler_discover
- Value: 0
- *************************** 161. row ***************************
- Variable_name: Handler_prepare
- Value: 0
- *************************** 162. row ***************************
- Variable_name: Handler_read_first
- Value: 46033
- *************************** 163. row ***************************
- Variable_name: Handler_read_key
- Value: 12645100414
- *************************** 164. row ***************************
- Variable_name: Handler_read_next
- Value: 6362731851
- *************************** 165. row ***************************
- Variable_name: Handler_read_prev
- Value: 547817725
- *************************** 166. row ***************************
- Variable_name: Handler_read_rnd
- Value: 3869089763
- *************************** 167. row ***************************
- Variable_name: Handler_read_rnd_next
- Value: 114044116
- *************************** 168. row ***************************
- Variable_name: Handler_rollback
- Value: 116630
- *************************** 169. row ***************************
- Variable_name: Handler_savepoint
- Value: 0
- *************************** 170. row ***************************
- Variable_name: Handler_savepoint_rollback
- Value: 0
- *************************** 171. row ***************************
- Variable_name: Handler_update
- Value: 152375601
- *************************** 172. row ***************************
- Variable_name: Handler_write
- Value: 76543315
- *************************** 173. row ***************************
- Variable_name: Innodb_buffer_pool_pages_data
- Value: 32751
- *************************** 174. row ***************************
- Variable_name: Innodb_buffer_pool_pages_dirty
- Value: 295
- *************************** 175. row ***************************
- Variable_name: Innodb_buffer_pool_pages_flushed
- Value: 60649537
- *************************** 176. row ***************************
- Variable_name: Innodb_buffer_pool_pages_free
- Value: 0
- *************************** 177. row ***************************
- Variable_name: Innodb_buffer_pool_pages_misc
- Value: 17
- *************************** 178. row ***************************
- Variable_name: Innodb_buffer_pool_pages_total
- Value: 32768
- *************************** 179. row ***************************
- Variable_name: Innodb_buffer_pool_read_ahead_rnd
- Value: 13527751
- *************************** 180. row ***************************
- Variable_name: Innodb_buffer_pool_read_ahead_seq
- Value: 4338111
- *************************** 181. row ***************************
- Variable_name: Innodb_buffer_pool_read_requests
- Value: 26839850476
- *************************** 182. row ***************************
- Variable_name: Innodb_buffer_pool_reads
- Value: 3342544086
- *************************** 183. row ***************************
- Variable_name: Innodb_buffer_pool_wait_free
- Value: 0
- *************************** 184. row ***************************
- Variable_name: Innodb_buffer_pool_write_requests
- Value: 968257194
- *************************** 185. row ***************************
- Variable_name: Innodb_data_fsyncs
- Value: 160260010
- *************************** 186. row ***************************
- Variable_name: Innodb_data_pending_fsyncs
- Value: 0
- *************************** 187. row ***************************
- Variable_name: Innodb_data_pending_reads
- Value: 8
- *************************** 188. row ***************************
- Variable_name: Innodb_data_pending_writes
- Value: 0
- *************************** 189. row ***************************
- Variable_name: Innodb_data_read
- Value: 67866279333888
- *************************** 190. row ***************************
- Variable_name: Innodb_data_reads
- Value: 3500875195
- *************************** 191. row ***************************
- Variable_name: Innodb_data_writes
- Value: 216262057
- *************************** 192. row ***************************
- Variable_name: Innodb_data_written
- Value: 2119293748224
- *************************** 193. row ***************************
- Variable_name: Innodb_dblwr_pages_written
- Value: 60649537
- *************************** 194. row ***************************
- Variable_name: Innodb_dblwr_writes
- Value: 764296
- *************************** 195. row ***************************
- Variable_name: Innodb_log_waits
- Value: 0
- *************************** 196. row ***************************
- Variable_name: Innodb_log_write_requests
- Value: 103111940
- *************************** 197. row ***************************
- Variable_name: Innodb_log_writes
- Value: 158460484
- *************************** 198. row ***************************
- Variable_name: Innodb_os_log_fsyncs
- Value: 158735317
- *************************** 199. row ***************************
- Variable_name: Innodb_os_log_pending_fsyncs
- Value: 0
- *************************** 200. row ***************************
- Variable_name: Innodb_os_log_pending_writes
- Value: 0
- *************************** 201. row ***************************
- Variable_name: Innodb_os_log_written
- Value: 131794496512
- *************************** 202. row ***************************
- Variable_name: Innodb_page_size
- Value: 16384
- *************************** 203. row ***************************
- Variable_name: Innodb_pages_created
- Value: 926889
- *************************** 204. row ***************************
- Variable_name: Innodb_pages_read
- Value: 4142237284
- *************************** 205. row ***************************
- Variable_name: Innodb_pages_written
- Value: 60649537
- *************************** 206. row ***************************
- Variable_name: Innodb_row_lock_current_waits
- Value: 0
- *************************** 207. row ***************************
- Variable_name: Innodb_row_lock_time
- Value: 0
- *************************** 208. row ***************************
- Variable_name: Innodb_row_lock_time_avg
- Value: 0
- *************************** 209. row ***************************
- Variable_name: Innodb_row_lock_time_max
- Value: 0
- *************************** 210. row ***************************
- Variable_name: Innodb_row_lock_waits
- Value: 0
- *************************** 211. row ***************************
- Variable_name: Innodb_rows_deleted
- Value: 1612576
- *************************** 212. row ***************************
- Variable_name: Innodb_rows_inserted
- Value: 15776694
- *************************** 213. row ***************************
- Variable_name: Innodb_rows_read
- Value: 11059190822
- *************************** 214. row ***************************
- Variable_name: Innodb_rows_updated
- Value: 147934033
- *************************** 215. row ***************************
- Variable_name: Key_blocks_not_flushed
- Value: 0
- *************************** 216. row ***************************
- Variable_name: Key_blocks_unused
- Value: 4258
- *************************** 217. row ***************************
- Variable_name: Key_blocks_used
- Value: 26792
- *************************** 218. row ***************************
- Variable_name: Key_read_requests
- Value: 3697379017
- *************************** 219. row ***************************
- Variable_name: Key_reads
- Value: 76394392
- *************************** 220. row ***************************
- Variable_name: Key_write_requests
- Value: 64736272
- *************************** 221. row ***************************
- Variable_name: Key_writes
- Value: 28182584
- *************************** 222. row ***************************
- Variable_name: Last_query_cost
- Value: 0.000000
- *************************** 223. row ***************************
- Variable_name: Max_used_connections
- Value: 1490
- *************************** 224. row ***************************
- Variable_name: Not_flushed_delayed_rows
- Value: 0
- *************************** 225. row ***************************
- Variable_name: Open_files
- Value: 27
- *************************** 226. row ***************************
- Variable_name: Open_streams
- Value: 0
- *************************** 227. row ***************************
- Variable_name: Open_table_definitions
- Value: 37
- *************************** 228. row ***************************
- Variable_name: Open_tables
- Value: 64
- *************************** 229. row ***************************
- Variable_name: Opened_files
- Value: 905357
- *************************** 230. row ***************************
- Variable_name: Opened_table_definitions
- Value: 59
- *************************** 231. row ***************************
- Variable_name: Opened_tables
- Value: 1244844
- *************************** 232. row ***************************
- Variable_name: Prepared_stmt_count
- Value: 0
- *************************** 233. row ***************************
- Variable_name: Qcache_free_blocks
- Value: 292
- *************************** 234. row ***************************
- Variable_name: Qcache_free_memory
- Value: 200361672
- *************************** 235. row ***************************
- Variable_name: Qcache_hits
- Value: 71621900
- *************************** 236. row ***************************
- Variable_name: Qcache_inserts
- Value: 311420920
- *************************** 237. row ***************************
- Variable_name: Qcache_lowmem_prunes
- Value: 0
- *************************** 238. row ***************************
- Variable_name: Qcache_not_cached
- Value: 39074128
- *************************** 239. row ***************************
- Variable_name: Qcache_queries_in_cache
- Value: 876
- *************************** 240. row ***************************
- Variable_name: Qcache_total_blocks
- Value: 2049
- *************************** 241. row ***************************
- Variable_name: Queries
- Value: 1132542481
- *************************** 242. row ***************************
- Variable_name: Questions
- Value: 804512299
- *************************** 243. row ***************************
- Variable_name: Rpl_status
- Value: NULL
- *************************** 244. row ***************************
- Variable_name: Select_full_join
- Value: 0
- *************************** 245. row ***************************
- Variable_name: Select_full_range_join
- Value: 0
- *************************** 246. row ***************************
- Variable_name: Select_range
- Value: 33639867
- *************************** 247. row ***************************
- Variable_name: Select_range_check
- Value: 0
- *************************** 248. row ***************************
- Variable_name: Select_scan
- Value: 180006
- *************************** 249. row ***************************
- Variable_name: Slave_open_temp_tables
- Value: 0
- *************************** 250. row ***************************
- Variable_name: Slave_retried_transactions
- Value: 0
- *************************** 251. row ***************************
- Variable_name: Slave_running
- Value: ON
- *************************** 252. row ***************************
- Variable_name: Slow_launch_threads
- Value: 0
- *************************** 253. row ***************************
- Variable_name: Slow_queries
- Value: 134649
- *************************** 254. row ***************************
- Variable_name: Sort_merge_passes
- Value: 101539
- *************************** 255. row ***************************
- Variable_name: Sort_range
- Value: 33727048
- *************************** 256. row ***************************
- Variable_name: Sort_rows
- Value: 120848426
- *************************** 257. row ***************************
- Variable_name: Sort_scan
- Value: 0
- *************************** 258. row ***************************
- Variable_name: Table_locks_immediate
- Value: 747488650
- *************************** 259. row ***************************
- Variable_name: Table_locks_waited
- Value: 114735
- *************************** 260. row ***************************
- Variable_name: Tc_log_max_pages_used
- Value: 0
- *************************** 261. row ***************************
- Variable_name: Tc_log_page_size
- Value: 0
- *************************** 262. row ***************************
- Variable_name: Tc_log_page_waits
- Value: 0
- *************************** 263. row ***************************
- Variable_name: Threads_cached
- Value: 27
- *************************** 264. row ***************************
- Variable_name: Threads_connected
- Value: 103
- *************************** 265. row ***************************
- Variable_name: Threads_created
- Value: 54326
- *************************** 266. row ***************************
- Variable_name: Threads_running
- Value: 16
- *************************** 267. row ***************************
- Variable_name: Uptime
- Value: 2760136
- *************************** 268. row ***************************
- Variable_name: Uptime_since_flush_status
- Value: 2760136
Add Comment
Please, Sign In to add comment