Advertisement
Guest User

SHOW GLOBAL STATUS

a guest
Apr 22nd, 2020
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.29 KB | None | 0 0
  1.  
  2. SHOW GLOBAL STATUS;
  3. Variable_name
  4. Value
  5. Aborted_clients
  6. 0
  7. Aborted_connects
  8. 0
  9. Binlog_cache_disk_use
  10. 181
  11. Binlog_cache_use
  12. 50942
  13. Binlog_stmt_cache_disk_use
  14. 0
  15. Binlog_stmt_cache_use
  16. 16
  17. Bytes_received
  18. 945512244
  19. Bytes_sent
  20. 27166489390
  21. Com_admin_commands
  22. 0
  23. Com_assign_to_keycache
  24. 0
  25. Com_alter_db
  26. 0
  27. Com_alter_db_upgrade
  28. 0
  29. Com_alter_event
  30. 0
  31. Com_alter_function
  32. 0
  33. Com_alter_instance
  34. 0
  35. Com_alter_procedure
  36. 0
  37. Com_alter_server
  38. 0
  39. Com_alter_table
  40. 0
  41. Com_alter_tablespace
  42. 0
  43. Com_alter_user
  44. 0
  45. Com_analyze
  46. 0
  47. Com_begin
  48. 0
  49. Com_binlog
  50. 0
  51. Com_call_procedure
  52. 0
  53. Com_change_db
  54. 43211
  55. Com_change_master
  56. 0
  57. Com_change_repl_filter
  58. 0
  59. Com_check
  60. 0
  61. Com_checksum
  62. 0
  63. Com_commit
  64. 0
  65. Com_create_db
  66. 0
  67. Com_create_event
  68. 0
  69. Com_create_function
  70. 0
  71. Com_create_index
  72. 0
  73. Com_create_procedure
  74. 0
  75. Com_create_server
  76. 0
  77. Com_create_table
  78. 0
  79. Com_create_trigger
  80. 0
  81. Com_create_udf
  82. 0
  83. Com_create_user
  84. 0
  85. Com_create_view
  86. 0
  87. Com_dealloc_sql
  88. 0
  89. Com_delete
  90. 178
  91. Com_delete_multi
  92. 0
  93. Com_do
  94. 0
  95. Com_drop_db
  96. 0
  97. Com_drop_event
  98. 0
  99. Com_drop_function
  100. 0
  101. Com_drop_index
  102. 0
  103. Com_drop_procedure
  104. 0
  105. Com_drop_server
  106. 0
  107. Com_drop_table
  108. 0
  109. Com_drop_trigger
  110. 0
  111. Com_drop_user
  112. 0
  113. Com_drop_view
  114. 0
  115. Com_empty_query
  116. 0
  117. Com_execute_sql
  118. 0
  119. Com_explain_other
  120. 0
  121. Com_flush
  122. 0
  123. Com_get_diagnostics
  124. 0
  125. Com_grant
  126. 0
  127. Com_ha_close
  128. 0
  129. Com_ha_open
  130. 0
  131. Com_ha_read
  132. 0
  133. Com_help
  134. 0
  135. Com_insert
  136. 49151
  137. Com_insert_select
  138. 0
  139. Com_install_plugin
  140. 0
  141. Com_kill
  142. 0
  143. Com_load
  144. 128
  145. Com_lock_tables
  146. 84
  147. Com_optimize
  148. 0
  149. Com_preload_keys
  150. 0
  151. Com_prepare_sql
  152. 0
  153. Com_purge
  154. 0
  155. Com_purge_before_date
  156. 0
  157. Com_release_savepoint
  158. 0
  159. Com_rename_table
  160. 0
  161. Com_rename_user
  162. 0
  163. Com_repair
  164. 0
  165. Com_replace
  166. 0
  167. Com_replace_select
  168. 0
  169. Com_reset
  170. 0
  171. Com_resignal
  172. 0
  173. Com_revoke
  174. 0
  175. Com_revoke_all
  176. 0
  177. Com_rollback
  178. 0
  179. Com_rollback_to_savepoint
  180. 0
  181. Com_savepoint
  182. 0
  183. Com_select
  184. 4228647
  185. Com_set_option
  186. 134216
  187. Com_signal
  188. 0
  189. Com_show_binlog_events
  190. 0
  191. Com_show_binlogs
  192. 1
  193. Com_show_charsets
  194. 0
  195. Com_show_collations
  196. 0
  197. Com_show_create_db
  198. 0
  199. Com_show_create_event
  200. 0
  201. Com_show_create_func
  202. 0
  203. Com_show_create_proc
  204. 0
  205. Variable_name
  206. Value
  207.  
  208. Com_show_create_table
  209. 2246
  210. Com_show_create_trigger
  211. 0
  212. Com_show_databases
  213. 1
  214. Com_show_engine_logs
  215. 0
  216. Com_show_engine_mutex
  217. 0
  218. Com_show_engine_status
  219. 1
  220. Com_show_events
  221. 0
  222. Com_show_errors
  223. 0
  224. Com_show_fields
  225. 4492
  226. Com_show_function_code
  227. 0
  228. Com_show_function_status
  229. 0
  230. Com_show_grants
  231. 0
  232. Com_show_keys
  233. 0
  234. Com_show_master_status
  235. 0
  236. Com_show_open_tables
  237. 0
  238. Com_show_plugins
  239. 0
  240. Com_show_privileges
  241. 0
  242. Com_show_procedure_code
  243. 0
  244. Com_show_procedure_status
  245. 0
  246. Com_show_processlist
  247. 24
  248. Com_show_profile
  249. 0
  250. Com_show_profiles
  251. 0
  252. Com_show_relaylog_events
  253. 0
  254. Com_show_slave_hosts
  255. 0
  256. Com_show_slave_status
  257. 0
  258. Com_show_status
  259. 2
  260. Com_show_storage_engines
  261. 0
  262. Com_show_table_status
  263. 2246
  264. Com_show_tables
  265. 84
  266. Com_show_triggers
  267. 2246
  268. Com_show_variables
  269. 288
  270. Com_show_warnings
  271. 26
  272. Com_show_create_user
  273. 0
  274. Com_shutdown
  275. 0
  276. Com_slave_start
  277. 0
  278. Com_slave_stop
  279. 0
  280. Com_group_replication_start
  281. 0
  282. Com_group_replication_stop
  283. 0
  284. Com_stmt_execute
  285. 4356428
  286. Com_stmt_close
  287. 4356427
  288. Com_stmt_fetch
  289. 0
  290. Com_stmt_prepare
  291. 4356428
  292. Com_stmt_reset
  293. 0
  294. Com_stmt_send_long_data
  295. 0
  296. Com_truncate
  297. 16
  298. Com_uninstall_plugin
  299. 0
  300. Com_unlock_tables
  301. 84
  302. Com_update
  303. 1619
  304. Com_update_multi
  305. 0
  306. Com_xa_commit
  307. 0
  308. Com_xa_end
  309. 0
  310. Com_xa_prepare
  311. 0
  312. Com_xa_recover
  313. 0
  314. Com_xa_rollback
  315. 0
  316. Com_xa_start
  317. 0
  318. Com_stmt_reprepare
  319. 1
  320. Connection_errors_accept
  321. 0
  322. Connection_errors_internal
  323. 0
  324. Connection_errors_max_connections
  325. 0
  326. Connection_errors_peer_address
  327. 0
  328. Connection_errors_select
  329. 0
  330. Connection_errors_tcpwrap
  331. 0
  332. Connections
  333. 41161
  334. Created_tmp_disk_tables
  335. 6906
  336. Created_tmp_files
  337. 198
  338. Created_tmp_tables
  339. 18358
  340. Delayed_errors
  341. 0
  342. Delayed_insert_threads
  343. 0
  344. Delayed_writes
  345. 0
  346. Flush_commands
  347. 1
  348. Handler_commit
  349. 4328269
  350. Handler_delete
  351. 289895
  352. Handler_discover
  353. 0
  354. Handler_external_lock
  355. 9103523
  356. Handler_mrr_init
  357. 0
  358. Handler_prepare
  359. 101884
  360. Handler_read_first
  361. 3102652
  362. Handler_read_key
  363. 27583695
  364. Handler_read_last
  365. 0
  366. Handler_read_next
  367. 2074195
  368. Handler_read_prev
  369. 0
  370. Handler_read_rnd
  371. 22904990
  372. Handler_read_rnd_next
  373. 4114074059
  374. Handler_rollback
  375. 0
  376. Handler_savepoint
  377. 0
  378. Handler_savepoint_rollback
  379. 0
  380. Handler_update
  381. 1512
  382. Handler_write
  383. 1143585
  384. Innodb_buffer_pool_dump_status
  385. Dumping of buffer pool not started
  386. Innodb_buffer_pool_load_status
  387. Buffer pool(s) load completed at 200421 21:11:28
  388. Innodb_buffer_pool_resize_status
  389. Innodb_buffer_pool_pages_data
  390. 256
  391. Innodb_buffer_pool_bytes_data
  392. 4194304
  393. Innodb_buffer_pool_pages_dirty
  394. 0
  395. Innodb_buffer_pool_bytes_dirty
  396. 0
  397. Innodb_buffer_pool_pages_flushed
  398. 72409
  399. Innodb_buffer_pool_pages_free
  400. 374
  401. Innodb_buffer_pool_pages_misc
  402. 10
  403. Innodb_buffer_pool_pages_total
  404. 640
  405. Innodb_buffer_pool_read_ahead_rnd
  406. 0
  407. Variable_name
  408. Value
  409.  
  410. Innodb_buffer_pool_read_ahead
  411. 1247717
  412. Innodb_buffer_pool_read_ahead_evicted
  413. 269668
  414. Innodb_buffer_pool_read_requests
  415. 1424193774
  416. Innodb_buffer_pool_reads
  417. 3069973
  418. Innodb_buffer_pool_wait_free
  419. 317
  420. Innodb_buffer_pool_write_requests
  421. 2019108
  422. Innodb_data_fsyncs
  423. 73875
  424. Innodb_data_pending_fsyncs
  425. 0
  426. Innodb_data_pending_reads
  427. 0
  428. Innodb_data_pending_writes
  429. 0
  430. Innodb_data_read
  431. 70742774272
  432. Innodb_data_reads
  433. 4322331
  434. Innodb_data_writes
  435. 137869
  436. Innodb_data_written
  437. 2668980224
  438. Innodb_dblwr_pages_written
  439. 72216
  440. Innodb_dblwr_writes
  441. 4924
  442. Innodb_log_waits
  443. 0
  444. Innodb_log_write_requests
  445. 564316
  446. Innodb_log_writes
  447. 57496
  448. Innodb_os_log_fsyncs
  449. 59316
  450. Innodb_os_log_pending_fsyncs
  451. 0
  452. Innodb_os_log_pending_writes
  453. 0
  454. Innodb_os_log_written
  455. 294125056
  456. Innodb_page_size
  457. 16384
  458. Innodb_pages_created
  459. 5227
  460. Innodb_pages_read
  461. 4317689
  462. Innodb_pages_written
  463. 72677
  464. Innodb_row_lock_current_waits
  465. 0
  466. Innodb_row_lock_time
  467. 0
  468. Innodb_row_lock_time_avg
  469. 0
  470. Innodb_row_lock_time_max
  471. 0
  472. Innodb_row_lock_waits
  473. 0
  474. Innodb_rows_deleted
  475. 289895
  476. Innodb_rows_inserted
  477. 473611
  478. Innodb_rows_read
  479. 4138750389
  480. Innodb_rows_updated
  481. 1512
  482. Innodb_num_open_files
  483. 400
  484. Innodb_truncated_status_writes
  485. 0
  486. Innodb_available_undo_logs
  487. 128
  488. Key_blocks_not_flushed
  489. 0
  490. Key_blocks_unused
  491. 107171
  492. Key_blocks_used
  493. 3
  494. Key_read_requests
  495. 8
  496. Key_reads
  497. 5
  498. Key_write_requests
  499. 0
  500. Key_writes
  501. 0
  502. Locked_connects
  503. 0
  504. Max_execution_time_exceeded
  505. 0
  506. Max_execution_time_set
  507. 0
  508. Max_execution_time_set_failed
  509. 0
  510. Max_used_connections
  511. 62
  512. Max_used_connections_time
  513. 2020-04-21 21:57:37
  514. Not_flushed_delayed_rows
  515. 0
  516. Ongoing_anonymous_transaction_count
  517. 0
  518. Open_files
  519. 2
  520. Open_streams
  521. 0
  522. Open_table_definitions
  523. 600
  524. Open_tables
  525. 400
  526. Opened_files
  527. 4000
  528. Opened_table_definitions
  529. 3551
  530. Opened_tables
  531. 102048
  532. Performance_schema_accounts_lost
  533. 0
  534. Performance_schema_cond_classes_lost
  535. 0
  536. Performance_schema_cond_instances_lost
  537. 0
  538. Performance_schema_digest_lost
  539. 10266
  540. Performance_schema_file_classes_lost
  541. 0
  542. Performance_schema_file_handles_lost
  543. 0
  544. Performance_schema_file_instances_lost
  545. 0
  546. Performance_schema_hosts_lost
  547. 0
  548. Performance_schema_index_stat_lost
  549. 0
  550. Performance_schema_locker_lost
  551. 0
  552. Performance_schema_memory_classes_lost
  553. 0
  554. Performance_schema_metadata_lock_lost
  555. 0
  556. Performance_schema_mutex_classes_lost
  557. 0
  558. Performance_schema_mutex_instances_lost
  559. 0
  560. Performance_schema_nested_statement_lost
  561. 0
  562. Performance_schema_prepared_statements_lost
  563. 0
  564. Performance_schema_program_lost
  565. 0
  566. Performance_schema_rwlock_classes_lost
  567. 0
  568. Performance_schema_rwlock_instances_lost
  569. 0
  570. Performance_schema_session_connect_attrs_lost
  571. 0
  572. Performance_schema_socket_classes_lost
  573. 0
  574. Performance_schema_socket_instances_lost
  575. 0
  576. Performance_schema_stage_classes_lost
  577. 0
  578. Performance_schema_statement_classes_lost
  579. 0
  580. Performance_schema_table_handles_lost
  581. 0
  582. Performance_schema_table_instances_lost
  583. 0
  584. Performance_schema_table_lock_stat_lost
  585. 0
  586. Performance_schema_thread_classes_lost
  587. 0
  588. Performance_schema_thread_instances_lost
  589. 0
  590. Performance_schema_users_lost
  591. 0
  592. Prepared_stmt_count
  593. 0
  594. Qcache_free_blocks
  595. 1
  596. Qcache_free_memory
  597. 67091584
  598. Qcache_hits
  599. 0
  600. Qcache_inserts
  601. 0
  602. Qcache_lowmem_prunes
  603. 0
  604. Qcache_not_cached
  605. 4224154
  606. Qcache_queries_in_cache
  607. 0
  608. Qcache_total_blocks
  609. 1
  610. Variable_name
  611. Value
  612.  
  613. Queries
  614. 13223054
  615. Questions
  616. 4510199
  617. Rsa_public_key
  618. -----BEGIN PUBLIC KEY-----
  619. MIIBIjANBgkqhkiG9w0BAQE...
  620. Select_full_join
  621. 4471
  622. Select_full_range_join
  623. 0
  624. Select_range
  625. 18898
  626. Select_range_check
  627. 0
  628. Select_scan
  629. 3090085
  630. Slave_open_temp_tables
  631. 0
  632. Slow_launch_threads
  633. 0
  634. Slow_queries
  635. 0
  636. Sort_merge_passes
  637. 50
  638. Sort_range
  639. 7952
  640. Sort_rows
  641. 55652781
  642. Sort_scan
  643. 766726
  644. Ssl_accept_renegotiates
  645. 0
  646. Ssl_accepts
  647. 0
  648. Ssl_callback_cache_hits
  649. 0
  650. Ssl_cipher
  651. Ssl_cipher_list
  652. Ssl_client_connects
  653. 0
  654. Ssl_connect_renegotiates
  655. 0
  656. Ssl_ctx_verify_depth
  657. 18446744073709551615
  658. Ssl_ctx_verify_mode
  659. 5
  660. Ssl_default_timeout
  661. 0
  662. Ssl_finished_accepts
  663. 0
  664. Ssl_finished_connects
  665. 0
  666. Ssl_server_not_after
  667. Dec 24 16:51:37 2029 GMT
  668. Ssl_server_not_before
  669. Dec 27 16:51:37 2019 GMT
  670. Ssl_session_cache_hits
  671. 0
  672. Ssl_session_cache_misses
  673. 0
  674. Ssl_session_cache_mode
  675. SERVER
  676. Ssl_session_cache_overflows
  677. 0
  678. Ssl_session_cache_size
  679. 128
  680. Ssl_session_cache_timeouts
  681. 0
  682. Ssl_sessions_reused
  683. 0
  684. Ssl_used_session_cache_entries
  685. 0
  686. Ssl_verify_depth
  687. 0
  688. Ssl_verify_mode
  689. 0
  690. Ssl_version
  691. Table_locks_immediate
  692. 389
  693. Table_locks_waited
  694. 0
  695. Table_open_cache_hits
  696. 9009786
  697. Table_open_cache_misses
  698. 102048
  699. Table_open_cache_overflows
  700. 101603
  701. Tc_log_max_pages_used
  702. 0
  703. Tc_log_page_size
  704. 0
  705. Tc_log_page_waits
  706. 0
  707. Threads_cached
  708. 60
  709. Threads_connected
  710. 2
  711. Threads_created
  712. 62
  713. Threads_running
  714. 1
  715. Uptime
  716. 47874
  717. Uptime_since_flush_status
  718. 47874
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement