API tools faq
paste
Advertisement
Guest User

show_global_variables

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