Advertisement
bslinger

Untitled

Jun 25th, 2019
294
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.53 KB | None | 0 0
  1. Variable_name Value
  2. Aborted_clients 1643658
  3. Aborted_connects 1
  4. Binlog_cache_disk_use 3315486
  5. Binlog_cache_use 185602840
  6. Binlog_stmt_cache_disk_use 0
  7. Binlog_stmt_cache_use 429
  8. Bytes_received 756155492158
  9. Bytes_sent 11132841594750
  10. Com_admin_commands 424
  11. Com_assign_to_keycache 0
  12. Com_alter_db 0
  13. Com_alter_db_upgrade 0
  14. Com_alter_event 0
  15. Com_alter_function 0
  16. Com_alter_procedure 0
  17. Com_alter_server 0
  18. Com_alter_table 0
  19. Com_alter_tablespace 0
  20. Com_alter_user 0
  21. Com_analyze 0
  22. Com_begin 0
  23. Com_binlog 0
  24. Com_call_procedure 0
  25. Com_change_db 6136461
  26. Com_change_master 0
  27. Com_check 0
  28. Com_checksum 0
  29. Com_commit 5159
  30. Com_create_db 0
  31. Com_create_event 0
  32. Com_create_function 0
  33. Com_create_index 0
  34. Com_create_procedure 0
  35. Com_create_server 0
  36. Com_create_table 0
  37. Com_create_trigger 0
  38. Com_create_udf 0
  39. Com_create_user 0
  40. Com_create_view 0
  41. Com_dealloc_sql 0
  42. Com_delete 25195
  43. Com_delete_multi 10
  44. Com_do 0
  45. Com_drop_db 0
  46. Com_drop_event 0
  47. Com_drop_function 0
  48. Com_drop_index 0
  49. Com_drop_procedure 0
  50. Com_drop_server 0
  51. Com_drop_table 0
  52. Com_drop_trigger 0
  53. Com_drop_user 0
  54. Com_drop_view 0
  55. Com_empty_query 0
  56. Com_execute_sql 0
  57. Com_flush 5596
  58. Com_get_diagnostics 0
  59. Com_grant 1
  60. Com_ha_close 0
  61. Com_ha_open 0
  62. Com_ha_read 0
  63. Com_help 0
  64. Com_insert 1413668
  65. Com_insert_select 0
  66. Com_install_plugin 0
  67. Com_kill 0
  68. Com_load 0
  69. Com_lock_tables 0
  70. Com_optimize 0
  71. Com_preload_keys 0
  72. Com_prepare_sql 0
  73. Com_purge 5130
  74. Com_purge_before_date 0
  75. Com_release_savepoint 0
  76. Com_rename_table 0
  77. Com_rename_user 0
  78. Com_repair 0
  79. Com_replace 0
  80. Com_replace_select 0
  81. Com_reset 0
  82. Com_resignal 0
  83. Com_revoke 0
  84. Com_revoke_all 0
  85. Com_rollback 0
  86. Com_rollback_to_savepoint 0
  87. Com_savepoint 0
  88. Com_select 975061885
  89. Com_set_option 12273713
  90. Com_signal 0
  91. Com_show_binlog_events 0
  92. Com_show_binlogs 0
  93. Com_show_charsets 0
  94. Com_show_collations 0
  95. Com_show_create_db 0
  96. Com_show_create_event 0
  97. Com_show_create_func 0
  98. Com_show_create_proc 0
  99. Com_show_create_table 1
  100. Com_show_create_trigger 0
  101. Com_show_databases 7
  102. Com_show_engine_logs 0
  103. Com_show_engine_mutex 0
  104. Com_show_engine_status 0
  105. Com_show_events 0
  106. Com_show_errors 0
  107. Com_show_fields 180
  108. Com_show_function_code 0
  109. Com_show_function_status 0
  110. Com_show_grants 1
  111. Com_show_keys 0
  112. Com_show_master_status 19
  113. Com_show_open_tables 0
  114. Com_show_plugins 0
  115. Com_show_privileges 0
  116. Com_show_procedure_code 0
  117. Com_show_procedure_status 0
  118. Com_show_processlist 0
  119. Com_show_profile 0
  120. Com_show_profiles 0
  121. Com_show_relaylog_events 0
  122. Com_show_slave_hosts 2
  123. Com_show_slave_status 2
  124. Com_show_status 4911
  125. Com_show_storage_engines 2
  126. Com_show_table_status 19
  127. Com_show_tables 3
  128. Com_show_triggers 0
  129. Com_show_variables 5134
  130. Com_show_warnings 737
  131. Com_slave_start 0
  132. Com_slave_stop 0
  133. Com_stmt_close 1172035368
  134. Com_stmt_execute 1172143411
  135. Com_stmt_fetch 0
  136. Com_stmt_prepare 1172499881
  137. Com_stmt_reprepare 0
  138. Com_stmt_reset 0
  139. Com_stmt_send_long_data 0
  140. Com_truncate 0
  141. Com_uninstall_plugin 0
  142. Com_unlock_tables 19
  143. Com_update 184165096
  144. Com_update_multi 0
  145. Com_xa_commit 0
  146. Com_xa_end 0
  147. Com_xa_prepare 0
  148. Com_xa_recover 0
  149. Com_xa_rollback 0
  150. Com_xa_start 0
  151. Compression OFF
  152. Connection_errors_accept 0
  153. Connection_errors_internal 0
  154. Connection_errors_max_connections 0
  155. Connection_errors_peer_address 0
  156. Connection_errors_select 0
  157. Connection_errors_tcpwrap 0
  158. Connections 6142643
  159. Created_tmp_disk_tables 192006082
  160. Created_tmp_files 783991
  161. Created_tmp_tables 192210395
  162. Delayed_errors 0
  163. Delayed_insert_threads 0
  164. Delayed_writes 0
  165. Flush_commands 1
  166. Handler_commit 1345636853
  167. Handler_delete 19303
  168. Handler_discover 0
  169. Handler_external_lock 2706045793
  170. Handler_mrr_init 0
  171. Handler_prepare 371170238
  172. Handler_read_first 3265862
  173. Handler_read_key 13244986042
  174. Handler_read_last 4385
  175. Handler_read_next 37104217364
  176. Handler_read_prev 28327
  177. Handler_read_rnd 1175004394
  178. Handler_read_rnd_next 1429084021814
  179. Handler_rollback 846
  180. Handler_savepoint 0
  181. Handler_savepoint_rollback 0
  182. Handler_update 205329581
  183. Handler_write 426970983
  184. Innodb_buffer_pool_dump_status not started
  185. Innodb_buffer_pool_load_status not started
  186. Innodb_buffer_pool_pages_data 706238
  187. Innodb_buffer_pool_bytes_data 11571003392
  188. Innodb_buffer_pool_pages_dirty 6136
  189. Innodb_buffer_pool_bytes_dirty 100532224
  190. Innodb_buffer_pool_pages_flushed 177804361
  191. Innodb_buffer_pool_pages_free 6394
  192. Innodb_buffer_pool_pages_misc 25992
  193. Innodb_buffer_pool_pages_total 738624
  194. Innodb_buffer_pool_read_ahead_rnd 0
  195. Innodb_buffer_pool_read_ahead 42937844
  196. Innodb_buffer_pool_read_ahead_evicted 43304
  197. Innodb_buffer_pool_read_requests 253571758641
  198. Innodb_buffer_pool_reads 1525046085
  199. Innodb_buffer_pool_wait_free 662
  200. Innodb_buffer_pool_write_requests 1943755170
  201. Innodb_data_fsyncs 131010539
  202. Innodb_data_pending_fsyncs 1
  203. Innodb_data_pending_reads 1
  204. Innodb_data_pending_writes 0
  205. Innodb_data_read 25689843077120
  206. Innodb_data_reads 1568001855
  207. Innodb_data_writes 288261442
  208. Innodb_data_written 6542449596928
  209. Innodb_dblwr_pages_written 177805023
  210. Innodb_dblwr_writes 8922059
  211. Innodb_have_atomic_builtins ON
  212. Innodb_log_waits 0
  213. Innodb_log_write_requests 1410935186
  214. Innodb_log_writes 101217909
  215. Innodb_os_log_fsyncs 101557560
  216. Innodb_os_log_pending_fsyncs 1
  217. Innodb_os_log_pending_writes 0
  218. Innodb_os_log_written 716224526848
  219. Innodb_page_size 16384
  220. Innodb_pages_created 30293541
  221. Innodb_pages_read 1568051903
  222. Innodb_pages_written 177805023
  223. Innodb_row_lock_current_waits 1
  224. Innodb_row_lock_time 13402596
  225. Innodb_row_lock_time_avg 454
  226. Innodb_row_lock_time_max 48118
  227. Innodb_row_lock_waits 29508
  228. Innodb_rows_deleted 22652
  229. Innodb_rows_inserted 1526137
  230. Innodb_rows_read 1476638021343
  231. Innodb_rows_updated 188893003
  232. Innodb_num_open_files 77
  233. Innodb_truncated_status_writes 0
  234. Innodb_available_undo_logs 128
  235. Key_blocks_not_flushed 0
  236. Key_blocks_unused 13391
  237. Key_blocks_used 40
  238. Key_read_requests 263597061
  239. Key_reads 24
  240. Key_write_requests 199188405
  241. Key_writes 0
  242. Last_query_cost 0.000000
  243. Last_query_partial_plans 0
  244. Max_used_connections 701
  245. Not_flushed_delayed_rows 0
  246. Open_files 379
  247. Open_streams 0
  248. Open_table_definitions 241
  249. Open_tables 2000
  250. Opened_files 768876530
  251. Opened_table_definitions 697
  252. Opened_tables 19934
  253. Performance_schema_accounts_lost 0
  254. Performance_schema_cond_classes_lost 0
  255. Performance_schema_cond_instances_lost 0
  256. Performance_schema_digest_lost 0
  257. Performance_schema_file_classes_lost 0
  258. Performance_schema_file_handles_lost 0
  259. Performance_schema_file_instances_lost 0
  260. Performance_schema_hosts_lost 0
  261. Performance_schema_locker_lost 0
  262. Performance_schema_mutex_classes_lost 0
  263. Performance_schema_mutex_instances_lost 0
  264. Performance_schema_rwlock_classes_lost 0
  265. Performance_schema_rwlock_instances_lost 0
  266. Performance_schema_session_connect_attrs_lost 0
  267. Performance_schema_socket_classes_lost 0
  268. Performance_schema_socket_instances_lost 0
  269. Performance_schema_stage_classes_lost 0
  270. Performance_schema_statement_classes_lost 0
  271. Performance_schema_table_handles_lost 0
  272. Performance_schema_table_instances_lost 0
  273. Performance_schema_thread_classes_lost 0
  274. Performance_schema_thread_instances_lost 0
  275. Performance_schema_users_lost 0
  276. Prepared_stmt_count 62
  277. Qcache_free_blocks 1
  278. Qcache_free_memory 1031360
  279. Qcache_hits 0
  280. Qcache_inserts 0
  281. Qcache_lowmem_prunes 0
  282. Qcache_not_cached 974781988
  283. Qcache_queries_in_cache 0
  284. Qcache_total_blocks 1
  285. Queries 3528137303
  286. Questions 1183596725
  287. Rsa_public_key ""
  288. Select_full_join 6151
  289. Select_full_range_join 0
  290. Select_range 95512676
  291. Select_range_check 0
  292. Select_scan 3378414
  293. Slave_heartbeat_period 0.000
  294. Slave_last_heartbeat ""
  295. Slave_open_temp_tables 0
  296. Slave_received_heartbeats 0
  297. Slave_retried_transactions 0
  298. Slave_running OFF
  299. Slow_launch_threads 0
  300. Slow_queries 3992629
  301. Sort_merge_passes 82900
  302. Sort_range 1277469
  303. Sort_rows 244173221
  304. Sort_scan 192054944
  305. Ssl_accept_renegotiates 0
  306. Ssl_accepts 0
  307. Ssl_callback_cache_hits 0
  308. Ssl_cipher ""
  309. Ssl_cipher_list ""
  310. Ssl_client_connects 0
  311. Ssl_connect_renegotiates 0
  312. Ssl_ctx_verify_depth 18446744073709551615
  313. Ssl_ctx_verify_mode 5
  314. Ssl_default_timeout 0
  315. Ssl_finished_accepts 0
  316. Ssl_finished_connects 0
  317. Ssl_server_not_after ""
  318. Ssl_server_not_before ""
  319. Ssl_session_cache_hits 0
  320. Ssl_session_cache_misses 0
  321. Ssl_session_cache_mode SERVER
  322. Ssl_session_cache_overflows 0
  323. Ssl_session_cache_size 128
  324. Ssl_session_cache_timeouts 0
  325. Ssl_sessions_reused 0
  326. Ssl_used_session_cache_entries 0
  327. Ssl_verify_depth 0
  328. Ssl_verify_mode 0
  329. Ssl_version ""
  330. Table_locks_immediate 1352611796
  331. Table_locks_waited 0
  332. Table_open_cache_hits 2705565654
  333. Table_open_cache_misses 19934
  334. Table_open_cache_overflows 17825
  335. Tc_log_max_pages_used 0
  336. Tc_log_page_size 0
  337. Tc_log_page_waits 0
  338. Threads_cached 12
  339. Threads_connected 304
  340. Threads_created 448780
  341. Threads_running 2
  342. Uptime 1539124
  343. Uptime_since_flush_status 1539124
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement