API tools faq
paste
Advertisement
Guest User

SHOW GLOBAL STATUS MySQL

a guest
Feb 18th, 2022
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.19 KB | None | 0 0
raw download clone embed print report
  1. *************************** 1. row ***************************
  2. Variable_name: Aborted_clients
  3. Value: 8
  4. *************************** 2. row ***************************
  5. Variable_name: Aborted_connects
  6. Value: 1
  7. *************************** 3. row ***************************
  8. Variable_name: Acl_cache_items_count
  9. Value: 4
  10. *************************** 4. row ***************************
  11. Variable_name: Binlog_cache_disk_use
  12. Value: 13
  13. *************************** 5. row ***************************
  14. Variable_name: Binlog_cache_use
  15. Value: 15821
  16. *************************** 6. row ***************************
  17. Variable_name: Binlog_stmt_cache_disk_use
  18. Value: 0
  19. *************************** 7. row ***************************
  20. Variable_name: Binlog_stmt_cache_use
  21. Value: 0
  22. *************************** 8. row ***************************
  23. Variable_name: Bytes_received
  24. Value: 33034815
  25. *************************** 9. row ***************************
  26. Variable_name: Bytes_sent
  27. Value: 161003843
  28. *************************** 10. row ***************************
  29. Variable_name: Caching_sha2_password_rsa_public_key
  30. Value: -----BEGIN PUBLIC KEY-----
  31. blabla
  32. -----END PUBLIC KEY-----
  33.  
  34. *************************** 11. row ***************************
  35. Variable_name: Com_admin_commands
  36. Value: 93650
  37. *************************** 12. row ***************************
  38. Variable_name: Com_assign_to_keycache
  39. Value: 0
  40. *************************** 13. row ***************************
  41. Variable_name: Com_alter_db
  42. Value: 0
  43. *************************** 14. row ***************************
  44. Variable_name: Com_alter_event
  45. Value: 0
  46. *************************** 15. row ***************************
  47. Variable_name: Com_alter_function
  48. Value: 0
  49. *************************** 16. row ***************************
  50. Variable_name: Com_alter_instance
  51. Value: 0
  52. *************************** 17. row ***************************
  53. Variable_name: Com_alter_procedure
  54. Value: 0
  55. *************************** 18. row ***************************
  56. Variable_name: Com_alter_resource_group
  57. Value: 0
  58. *************************** 19. row ***************************
  59. Variable_name: Com_alter_server
  60. Value: 0
  61. *************************** 20. row ***************************
  62. Variable_name: Com_alter_table
  63. Value: 16
  64. *************************** 21. row ***************************
  65. Variable_name: Com_alter_tablespace
  66. Value: 0
  67. *************************** 22. row ***************************
  68. Variable_name: Com_alter_user
  69. Value: 0
  70. *************************** 23. row ***************************
  71. Variable_name: Com_alter_user_default_role
  72. Value: 0
  73. *************************** 24. row ***************************
  74. Variable_name: Com_analyze
  75. Value: 0
  76. *************************** 25. row ***************************
  77. Variable_name: Com_begin
  78. Value: 3
  79. *************************** 26. row ***************************
  80. Variable_name: Com_binlog
  81. Value: 0
  82. *************************** 27. row ***************************
  83. Variable_name: Com_call_procedure
  84. Value: 0
  85. *************************** 28. row ***************************
  86. Variable_name: Com_change_db
  87. Value: 120
  88. *************************** 29. row ***************************
  89. Variable_name: Com_change_master
  90. Value: 0
  91. *************************** 30. row ***************************
  92. Variable_name: Com_change_repl_filter
  93. Value: 0
  94. *************************** 31. row ***************************
  95. Variable_name: Com_check
  96. Value: 0
  97. *************************** 32. row ***************************
  98. Variable_name: Com_checksum
  99. Value: 0
  100. *************************** 33. row ***************************
  101. Variable_name: Com_clone
  102. Value: 0
  103. *************************** 34. row ***************************
  104. Variable_name: Com_commit
  105. Value: 16
  106. *************************** 35. row ***************************
  107. Variable_name: Com_create_db
  108. Value: 2
  109. *************************** 36. row ***************************
  110. Variable_name: Com_create_event
  111. Value: 0
  112. *************************** 37. row ***************************
  113. Variable_name: Com_create_function
  114. Value: 0
  115. *************************** 38. row ***************************
  116. Variable_name: Com_create_index
  117. Value: 0
  118. *************************** 39. row ***************************
  119. Variable_name: Com_create_procedure
  120. Value: 528
  121. *************************** 40. row ***************************
  122. Variable_name: Com_create_role
  123. Value: 0
  124. *************************** 41. row ***************************
  125. Variable_name: Com_create_server
  126. Value: 0
  127. *************************** 42. row ***************************
  128. Variable_name: Com_create_table
  129. Value: 504
  130. *************************** 43. row ***************************
  131. Variable_name: Com_create_resource_group
  132. Value: 0
  133. *************************** 44. row ***************************
  134. Variable_name: Com_create_trigger
  135. Value: 0
  136. *************************** 45. row ***************************
  137. Variable_name: Com_create_udf
  138. Value: 0
  139. *************************** 46. row ***************************
  140. Variable_name: Com_create_user
  141. Value: 0
  142. *************************** 47. row ***************************
  143. Variable_name: Com_create_view
  144. Value: 0
  145. *************************** 48. row ***************************
  146. Variable_name: Com_create_spatial_reference_system
  147. Value: 0
  148. *************************** 49. row ***************************
  149. Variable_name: Com_dealloc_sql
  150. Value: 0
  151. *************************** 50. row ***************************
  152. Variable_name: Com_delete
  153. Value: 0
  154. *************************** 51. row ***************************
  155. Variable_name: Com_delete_multi
  156. Value: 0
  157. *************************** 52. row ***************************
  158. Variable_name: Com_do
  159. Value: 0
  160. *************************** 53. row ***************************
  161. Variable_name: Com_drop_db
  162. Value: 1
  163. *************************** 54. row ***************************
  164. Variable_name: Com_drop_event
  165. Value: 0
  166. *************************** 55. row ***************************
  167. Variable_name: Com_drop_function
  168. Value: 0
  169. *************************** 56. row ***************************
  170. Variable_name: Com_drop_index
  171. Value: 0
  172. *************************** 57. row ***************************
  173. Variable_name: Com_drop_procedure
  174. Value: 1584
  175. *************************** 58. row ***************************
  176. Variable_name: Com_drop_resource_group
  177. Value: 0
  178. *************************** 59. row ***************************
  179. Variable_name: Com_drop_role
  180. Value: 0
  181. *************************** 60. row ***************************
  182. Variable_name: Com_drop_server
  183. Value: 0
  184. *************************** 61. row ***************************
  185. Variable_name: Com_drop_spatial_reference_system
  186. Value: 0
  187. *************************** 62. row ***************************
  188. Variable_name: Com_drop_table
  189. Value: 0
  190. *************************** 63. row ***************************
  191. Variable_name: Com_drop_trigger
  192. Value: 0
  193. *************************** 64. row ***************************
  194. Variable_name: Com_drop_user
  195. Value: 0
  196. *************************** 65. row ***************************
  197. Variable_name: Com_drop_view
  198. Value: 0
  199. *************************** 66. row ***************************
  200. Variable_name: Com_empty_query
  201. Value: 0
  202. *************************** 67. row ***************************
  203. Variable_name: Com_execute_sql
  204. Value: 0
  205. *************************** 68. row ***************************
  206. Variable_name: Com_explain_other
  207. Value: 0
  208. *************************** 69. row ***************************
  209. Variable_name: Com_flush
  210. Value: 89
  211. *************************** 70. row ***************************
  212. Variable_name: Com_get_diagnostics
  213. Value: 0
  214. *************************** 71. row ***************************
  215. Variable_name: Com_grant
  216. Value: 0
  217. *************************** 72. row ***************************
  218. Variable_name: Com_grant_roles
  219. Value: 0
  220. *************************** 73. row ***************************
  221. Variable_name: Com_ha_close
  222. Value: 0
  223. *************************** 74. row ***************************
  224. Variable_name: Com_ha_open
  225. Value: 0
  226. *************************** 75. row ***************************
  227. Variable_name: Com_ha_read
  228. Value: 0
  229. *************************** 76. row ***************************
  230. Variable_name: Com_help
  231. Value: 0
  232. *************************** 77. row ***************************
  233. Variable_name: Com_import
  234. Value: 0
  235. *************************** 78. row ***************************
  236. Variable_name: Com_insert
  237. Value: 15787
  238. *************************** 79. row ***************************
  239. Variable_name: Com_insert_select
  240. Value: 0
  241. *************************** 80. row ***************************
  242. Variable_name: Com_install_component
  243. Value: 0
  244. *************************** 81. row ***************************
  245. Variable_name: Com_install_plugin
  246. Value: 0
  247. *************************** 82. row ***************************
  248. Variable_name: Com_kill
  249. Value: 2
  250. *************************** 83. row ***************************
  251. Variable_name: Com_load
  252. Value: 0
  253. *************************** 84. row ***************************
  254. Variable_name: Com_lock_instance
  255. Value: 0
  256. *************************** 85. row ***************************
  257. Variable_name: Com_lock_tables
  258. Value: 9
  259. *************************** 86. row ***************************
  260. Variable_name: Com_optimize
  261. Value: 0
  262. *************************** 87. row ***************************
  263. Variable_name: Com_preload_keys
  264. Value: 0
  265. *************************** 88. row ***************************
  266. Variable_name: Com_prepare_sql
  267. Value: 0
  268. *************************** 89. row ***************************
  269. Variable_name: Com_purge
  270. Value: 0
  271. *************************** 90. row ***************************
  272. Variable_name: Com_purge_before_date
  273. Value: 1
  274. *************************** 91. row ***************************
  275. Variable_name: Com_release_savepoint
  276. Value: 0
  277. *************************** 92. row ***************************
  278. Variable_name: Com_rename_table
  279. Value: 0
  280. *************************** 93. row ***************************
  281. Variable_name: Com_rename_user
  282. Value: 0
  283. *************************** 94. row ***************************
  284. Variable_name: Com_repair
  285. Value: 0
  286. *************************** 95. row ***************************
  287. Variable_name: Com_replace
  288. Value: 0
  289. *************************** 96. row ***************************
  290. Variable_name: Com_replace_select
  291. Value: 0
  292. *************************** 97. row ***************************
  293. Variable_name: Com_reset
  294. Value: 0
  295. *************************** 98. row ***************************
  296. Variable_name: Com_resignal
  297. Value: 0
  298. *************************** 99. row ***************************
  299. Variable_name: Com_restart
  300. Value: 0
  301. *************************** 100. row ***************************
  302. Variable_name: Com_revoke
  303. Value: 0
  304. *************************** 101. row ***************************
  305. Variable_name: Com_revoke_all
  306. Value: 0
  307. *************************** 102. row ***************************
  308. Variable_name: Com_revoke_roles
  309. Value: 0
  310. *************************** 103. row ***************************
  311. Variable_name: Com_rollback
  312. Value: 24057
  313. *************************** 104. row ***************************
  314. Variable_name: Com_rollback_to_savepoint
  315. Value: 0
  316. *************************** 105. row ***************************
  317. Variable_name: Com_savepoint
  318. Value: 0
  319. *************************** 106. row ***************************
  320. Variable_name: Com_select
  321. Value: 40940
  322. *************************** 107. row ***************************
  323. Variable_name: Com_set_option
  324. Value: 3315
  325. *************************** 108. row ***************************
  326. Variable_name: Com_set_password
  327. Value: 0
  328. *************************** 109. row ***************************
  329. Variable_name: Com_set_resource_group
  330. Value: 0
  331. *************************** 110. row ***************************
  332. Variable_name: Com_set_role
  333. Value: 0
  334. *************************** 111. row ***************************
  335. Variable_name: Com_signal
  336. Value: 0
  337. *************************** 112. row ***************************
  338. Variable_name: Com_show_binlog_events
  339. Value: 0
  340. *************************** 113. row ***************************
  341. Variable_name: Com_show_binlogs
  342. Value: 0
  343. *************************** 114. row ***************************
  344. Variable_name: Com_show_charsets
  345. Value: 0
  346. *************************** 115. row ***************************
  347. Variable_name: Com_show_collations
  348. Value: 0
  349. *************************** 116. row ***************************
  350. Variable_name: Com_show_create_db
  351. Value: 0
  352. *************************** 117. row ***************************
  353. Variable_name: Com_show_create_event
  354. Value: 0
  355. *************************** 118. row ***************************
  356. Variable_name: Com_show_create_func
  357. Value: 0
  358. *************************** 119. row ***************************
  359. Variable_name: Com_show_create_proc
  360. Value: 0
  361. *************************** 120. row ***************************
  362. Variable_name: Com_show_create_table
  363. Value: 118
  364. *************************** 121. row ***************************
  365. Variable_name: Com_show_create_trigger
  366. Value: 0
  367. *************************** 122. row ***************************
  368. Variable_name: Com_show_databases
  369. Value: 3
  370. *************************** 123. row ***************************
  371. Variable_name: Com_show_engine_logs
  372. Value: 0
  373. *************************** 124. row ***************************
  374. Variable_name: Com_show_engine_mutex
  375. Value: 0
  376. *************************** 125. row ***************************
  377. Variable_name: Com_show_engine_status
  378. Value: 2614
  379. *************************** 126. row ***************************
  380. Variable_name: Com_show_events
  381. Value: 0
  382. *************************** 127. row ***************************
  383. Variable_name: Com_show_errors
  384. Value: 0
  385. *************************** 128. row ***************************
  386. Variable_name: Com_show_fields
  387. Value: 590
  388. *************************** 129. row ***************************
  389. Variable_name: Com_show_function_code
  390. Value: 0
  391. *************************** 130. row ***************************
  392. Variable_name: Com_show_function_status
  393. Value: 0
  394. *************************** 131. row ***************************
  395. Variable_name: Com_show_grants
  396. Value: 0
  397. *************************** 132. row ***************************
  398. Variable_name: Com_show_keys
  399. Value: 0
  400. *************************** 133. row ***************************
  401. Variable_name: Com_show_master_status
  402. Value: 2
  403. *************************** 134. row ***************************
  404. Variable_name: Com_show_open_tables
  405. Value: 0
  406. *************************** 135. row ***************************
  407. Variable_name: Com_show_plugins
  408. Value: 0
  409. *************************** 136. row ***************************
  410. Variable_name: Com_show_privileges
  411. Value: 0
  412. *************************** 137. row ***************************
  413. Variable_name: Com_show_procedure_code
  414. Value: 0
  415. *************************** 138. row ***************************
  416. Variable_name: Com_show_procedure_status
  417. Value: 0
  418. *************************** 139. row ***************************
  419. Variable_name: Com_show_processlist
  420. Value: 2
  421. *************************** 140. row ***************************
  422. Variable_name: Com_show_profile
  423. Value: 0
  424. *************************** 141. row ***************************
  425. Variable_name: Com_show_profiles
  426. Value: 0
  427. *************************** 142. row ***************************
  428. Variable_name: Com_show_relaylog_events
  429. Value: 0
  430. *************************** 143. row ***************************
  431. Variable_name: Com_show_slave_hosts
  432. Value: 0
  433. *************************** 144. row ***************************
  434. Variable_name: Com_show_slave_status
  435. Value: 5228
  436. *************************** 145. row ***************************
  437. Variable_name: Com_show_status
  438. Value: 5231
  439. *************************** 146. row ***************************
  440. Variable_name: Com_show_storage_engines
  441. Value: 0
  442. *************************** 147. row ***************************
  443. Variable_name: Com_show_table_status
  444. Value: 118
  445. *************************** 148. row ***************************
  446. Variable_name: Com_show_tables
  447. Value: 4
  448. *************************** 149. row ***************************
  449. Variable_name: Com_show_triggers
  450. Value: 118
  451. *************************** 150. row ***************************
  452. Variable_name: Com_show_variables
  453. Value: 13088
  454. *************************** 151. row ***************************
  455. Variable_name: Com_show_warnings
  456. Value: 0
  457. *************************** 152. row ***************************
  458. Variable_name: Com_show_create_user
  459. Value: 0
  460. *************************** 153. row ***************************
  461. Variable_name: Com_shutdown
  462. Value: 0
  463. *************************** 154. row ***************************
  464. Variable_name: Com_slave_start
  465. Value: 0
  466. *************************** 155. row ***************************
  467. Variable_name: Com_slave_stop
  468. Value: 0
  469. *************************** 156. row ***************************
  470. Variable_name: Com_group_replication_start
  471. Value: 0
  472. *************************** 157. row ***************************
  473. Variable_name: Com_group_replication_stop
  474. Value: 0
  475. *************************** 158. row ***************************
  476. Variable_name: Com_stmt_execute
  477. Value: 804
  478. *************************** 159. row ***************************
  479. Variable_name: Com_stmt_close
  480. Value: 804
  481. *************************** 160. row ***************************
  482. Variable_name: Com_stmt_fetch
  483. Value: 0
  484. *************************** 161. row ***************************
  485. Variable_name: Com_stmt_prepare
  486. Value: 804
  487. *************************** 162. row ***************************
  488. Variable_name: Com_stmt_reset
  489. Value: 0
  490. *************************** 163. row ***************************
  491. Variable_name: Com_stmt_send_long_data
  492. Value: 0
  493. *************************** 164. row ***************************
  494. Variable_name: Com_truncate
  495. Value: 0
  496. *************************** 165. row ***************************
  497. Variable_name: Com_uninstall_component
  498. Value: 0
  499. *************************** 166. row ***************************
  500. Variable_name: Com_uninstall_plugin
  501. Value: 0
  502. *************************** 167. row ***************************
  503. Variable_name: Com_unlock_instance
  504. Value: 0
  505. *************************** 168. row ***************************
  506. Variable_name: Com_unlock_tables
  507. Value: 9
  508. *************************** 169. row ***************************
  509. Variable_name: Com_update
  510. Value: 0
  511. *************************** 170. row ***************************
  512. Variable_name: Com_update_multi
  513. Value: 0
  514. *************************** 171. row ***************************
  515. Variable_name: Com_xa_commit
  516. Value: 0
  517. *************************** 172. row ***************************
  518. Variable_name: Com_xa_end
  519. Value: 0
  520. *************************** 173. row ***************************
  521. Variable_name: Com_xa_prepare
  522. Value: 0
  523. *************************** 174. row ***************************
  524. Variable_name: Com_xa_recover
  525. Value: 0
  526. *************************** 175. row ***************************
  527. Variable_name: Com_xa_rollback
  528. Value: 0
  529. *************************** 176. row ***************************
  530. Variable_name: Com_xa_start
  531. Value: 0
  532. *************************** 177. row ***************************
  533. Variable_name: Com_stmt_reprepare
  534. Value: 0
  535. *************************** 178. row ***************************
  536. Variable_name: Connection_errors_accept
  537. Value: 0
  538. *************************** 179. row ***************************
  539. Variable_name: Connection_errors_internal
  540. Value: 0
  541. *************************** 180. row ***************************
  542. Variable_name: Connection_errors_max_connections
  543. Value: 0
  544. *************************** 181. row ***************************
  545. Variable_name: Connection_errors_peer_address
  546. Value: 0
  547. *************************** 182. row ***************************
  548. Variable_name: Connection_errors_select
  549. Value: 0
  550. *************************** 183. row ***************************
  551. Variable_name: Connection_errors_tcpwrap
  552. Value: 0
  553. *************************** 184. row ***************************
  554. Variable_name: Connections
  555. Value: 9846
  556. *************************** 185. row ***************************
  557. Variable_name: Created_tmp_disk_tables
  558. Value: 2614
  559. *************************** 186. row ***************************
  560. Variable_name: Created_tmp_files
  561. Value: 8
  562. *************************** 187. row ***************************
  563. Variable_name: Created_tmp_tables
  564. Value: 28373
  565. *************************** 188. row ***************************
  566. Variable_name: Current_tls_ca
  567. Value: /mysql/datadir/client_ca_cert.pem
  568. *************************** 189. row ***************************
  569. Variable_name: Current_tls_capath
  570. Value:
  571. *************************** 190. row ***************************
  572. Variable_name: Current_tls_cert
  573. Value: /mysql/datadir/server_cert.pem
  574. *************************** 191. row ***************************
  575. Variable_name: Current_tls_cipher
  576. Value: ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA
  577. *************************** 192. row ***************************
  578. Variable_name: Current_tls_ciphersuites
  579. Value:
  580. *************************** 193. row ***************************
  581. Variable_name: Current_tls_crl
  582. Value:
  583. *************************** 194. row ***************************
  584. Variable_name: Current_tls_crlpath
  585. Value:
  586. *************************** 195. row ***************************
  587. Variable_name: Current_tls_key
  588. Value: /mysql/datadir/server_pkey.pem
  589. *************************** 196. row ***************************
  590. Variable_name: Current_tls_version
  591. Value: TLSv1,TLSv1.1,TLSv1.2
  592. *************************** 197. row ***************************
  593. Variable_name: Delayed_errors
  594. Value: 0
  595. *************************** 198. row ***************************
  596. Variable_name: Delayed_insert_threads
  597. Value: 0
  598. *************************** 199. row ***************************
  599. Variable_name: Delayed_writes
  600. Value: 0
  601. *************************** 200. row ***************************
  602. Variable_name: Flush_commands
  603. Value: 3
  604. *************************** 201. row ***************************
  605. Variable_name: Handler_commit
  606. Value: 56632
  607. *************************** 202. row ***************************
  608. Variable_name: Handler_delete
  609. Value: 7096
  610. *************************** 203. row ***************************
  611. Variable_name: Handler_discover
  612. Value: 0
  613. *************************** 204. row ***************************
  614. Variable_name: Handler_external_lock
  615. Value: 266467
  616. *************************** 205. row ***************************
  617. Variable_name: Handler_mrr_init
  618. Value: 0
  619. *************************** 206. row ***************************
  620. Variable_name: Handler_prepare
  621. Value: 31968
  622. *************************** 207. row ***************************
  623. Variable_name: Handler_read_first
  624. Value: 14922
  625. *************************** 208. row ***************************
  626. Variable_name: Handler_read_key
  627. Value: 10249336
  628. *************************** 209. row ***************************
  629. Variable_name: Handler_read_last
  630. Value: 0
  631. *************************** 210. row ***************************
  632. Variable_name: Handler_read_next
  633. Value: 395077806
  634. *************************** 211. row ***************************
  635. Variable_name: Handler_read_prev
  636. Value: 0
  637. *************************** 212. row ***************************
  638. Variable_name: Handler_read_rnd
  639. Value: 1684
  640. *************************** 213. row ***************************
  641. Variable_name: Handler_read_rnd_next
  642. Value: 17585208
  643. *************************** 214. row ***************************
  644. Variable_name: Handler_rollback
  645. Value: 1723
  646. *************************** 215. row ***************************
  647. Variable_name: Handler_savepoint
  648. Value: 0
  649. *************************** 216. row ***************************
  650. Variable_name: Handler_savepoint_rollback
  651. Value: 0
  652. *************************** 217. row ***************************
  653. Variable_name: Handler_update
  654. Value: 33632
  655. *************************** 218. row ***************************
  656. Variable_name: Handler_write
  657. Value: 10597042
  658. *************************** 219. row ***************************
  659. Variable_name: Innodb_buffer_pool_dump_status
  660. Value: Dumping of buffer pool not started
  661. *************************** 220. row ***************************
  662. Variable_name: Innodb_buffer_pool_load_status
  663. Value: Buffer pool(s) load completed at 220217 11:30:06
  664. *************************** 221. row ***************************
  665. Variable_name: Innodb_buffer_pool_resize_status
  666. Value:
  667. *************************** 222. row ***************************
  668. Variable_name: Innodb_buffer_pool_pages_data
  669. Value: 4234
  670. *************************** 223. row ***************************
  671. Variable_name: Innodb_buffer_pool_bytes_data
  672. Value: 69369856
  673. *************************** 224. row ***************************
  674. Variable_name: Innodb_buffer_pool_pages_dirty
  675. Value: 0
  676. *************************** 225. row ***************************
  677. Variable_name: Innodb_buffer_pool_bytes_dirty
  678. Value: 0
  679. *************************** 226. row ***************************
  680. Variable_name: Innodb_buffer_pool_pages_flushed
  681. Value: 184757
  682. *************************** 227. row ***************************
  683. Variable_name: Innodb_buffer_pool_pages_free
  684. Value: 85838
  685. *************************** 228. row ***************************
  686. Variable_name: Innodb_buffer_pool_pages_misc
  687. Value: 40
  688. *************************** 229. row ***************************
  689. Variable_name: Innodb_buffer_pool_pages_total
  690. Value: 90112
  691. *************************** 230. row ***************************
  692. Variable_name: Innodb_buffer_pool_read_ahead_rnd
  693. Value: 0
  694. *************************** 231. row ***************************
  695. Variable_name: Innodb_buffer_pool_read_ahead
  696. Value: 49
  697. *************************** 232. row ***************************
  698. Variable_name: Innodb_buffer_pool_read_ahead_evicted
  699. Value: 0
  700. *************************** 233. row ***************************
  701. Variable_name: Innodb_buffer_pool_read_requests
  702. Value: 861949771
  703. *************************** 234. row ***************************
  704. Variable_name: Innodb_buffer_pool_reads
  705. Value: 2662
  706. *************************** 235. row ***************************
  707. Variable_name: Innodb_buffer_pool_wait_free
  708. Value: 0
  709. *************************** 236. row ***************************
  710. Variable_name: Innodb_buffer_pool_write_requests
  711. Value: 906041
  712. *************************** 237. row ***************************
  713. Variable_name: Innodb_data_fsyncs
  714. Value: 215393
  715. *************************** 238. row ***************************
  716. Variable_name: Innodb_data_pending_fsyncs
  717. Value: 18446744073709551615
  718. *************************** 239. row ***************************
  719. Variable_name: Innodb_data_pending_reads
  720. Value: 0
  721. *************************** 240. row ***************************
  722. Variable_name: Innodb_data_pending_writes
  723. Value: 0
  724. *************************** 241. row ***************************
  725. Variable_name: Innodb_data_read
  726. Value: 44487680
  727. *************************** 242. row ***************************
  728. Variable_name: Innodb_data_reads
  729. Value: 2974
  730. *************************** 243. row ***************************
  731. Variable_name: Innodb_data_writes
  732. Value: 365347
  733. *************************** 244. row ***************************
  734. Variable_name: Innodb_data_written
  735. Value: 6168067584
  736. *************************** 245. row ***************************
  737. Variable_name: Innodb_dblwr_pages_written
  738. Value: 182000
  739. *************************** 246. row ***************************
  740. Variable_name: Innodb_dblwr_writes
  741. Value: 18542
  742. *************************** 247. row ***************************
  743. Variable_name: Innodb_log_waits
  744. Value: 0
  745. *************************** 248. row ***************************
  746. Variable_name: Innodb_log_write_requests
  747. Value: 677220
  748. *************************** 249. row ***************************
  749. Variable_name: Innodb_log_writes
  750. Value: 138291
  751. *************************** 250. row ***************************
  752. Variable_name: Innodb_os_log_fsyncs
  753. Value: 112379
  754. *************************** 251. row ***************************
  755. Variable_name: Innodb_os_log_pending_fsyncs
  756. Value: 0
  757. *************************** 252. row ***************************
  758. Variable_name: Innodb_os_log_pending_writes
  759. Value: 0
  760. *************************** 253. row ***************************
  761. Variable_name: Innodb_os_log_written
  762. Value: 108566016
  763. *************************** 254. row ***************************
  764. Variable_name: Innodb_page_size
  765. Value: 16384
  766. *************************** 255. row ***************************
  767. Variable_name: Innodb_pages_created
  768. Value: 9365
  769. *************************** 256. row ***************************
  770. Variable_name: Innodb_pages_read
  771. Value: 2711
  772. *************************** 257. row ***************************
  773. Variable_name: Innodb_pages_written
  774. Value: 184767
  775. *************************** 258. row ***************************
  776. Variable_name: Innodb_row_lock_current_waits
  777. Value: 0
  778. *************************** 259. row ***************************
  779. Variable_name: Innodb_row_lock_time
  780. Value: 0
  781. *************************** 260. row ***************************
  782. Variable_name: Innodb_row_lock_time_avg
  783. Value: 0
  784. *************************** 261. row ***************************
  785. Variable_name: Innodb_row_lock_time_max
  786. Value: 0
  787. *************************** 262. row ***************************
  788. Variable_name: Innodb_row_lock_waits
  789. Value: 0
  790. *************************** 263. row ***************************
  791. Variable_name: Innodb_rows_deleted
  792. Value: 22840
  793. *************************** 264. row ***************************
  794. Variable_name: Innodb_rows_inserted
  795. Value: 191594
  796. *************************** 265. row ***************************
  797. Variable_name: Innodb_rows_read
  798. Value: 397278003
  799. *************************** 266. row ***************************
  800. Variable_name: Innodb_rows_updated
  801. Value: 33365
  802. *************************** 267. row ***************************
  803. Variable_name: Innodb_num_open_files
  804. Value: 137
  805. *************************** 268. row ***************************
  806. Variable_name: Innodb_truncated_status_writes
  807. Value: 0
  808. *************************** 269. row ***************************
  809. Variable_name: Innodb_undo_tablespaces_total
  810. Value: 2
  811. *************************** 270. row ***************************
  812. Variable_name: Innodb_undo_tablespaces_implicit
  813. Value: 2
  814. *************************** 271. row ***************************
  815. Variable_name: Innodb_undo_tablespaces_explicit
  816. Value: 0
  817. *************************** 272. row ***************************
  818. Variable_name: Innodb_undo_tablespaces_active
  819. Value: 2
  820. *************************** 273. row ***************************
  821. Variable_name: Key_blocks_not_flushed
  822. Value: 0
  823. *************************** 274. row ***************************
  824. Variable_name: Key_blocks_unused
  825. Value: 6698
  826. *************************** 275. row ***************************
  827. Variable_name: Key_blocks_used
  828. Value: 0
  829. *************************** 276. row ***************************
  830. Variable_name: Key_read_requests
  831. Value: 0
  832. *************************** 277. row ***************************
  833. Variable_name: Key_reads
  834. Value: 0
  835. *************************** 278. row ***************************
  836. Variable_name: Key_write_requests
  837. Value: 0
  838. *************************** 279. row ***************************
  839. Variable_name: Key_writes
  840. Value: 0
  841. *************************** 280. row ***************************
  842. Variable_name: Locked_connects
  843. Value: 0
  844. *************************** 281. row ***************************
  845. Variable_name: Max_execution_time_exceeded
  846. Value: 0
  847. *************************** 282. row ***************************
  848. Variable_name: Max_execution_time_set
  849. Value: 6
  850. *************************** 283. row ***************************
  851. Variable_name: Max_execution_time_set_failed
  852. Value: 0
  853. *************************** 284. row ***************************
  854. Variable_name: Max_used_connections
  855. Value: 14
  856. *************************** 285. row ***************************
  857. Variable_name: Max_used_connections_time
  858. Value: 2022-02-17 11:31:08
  859. *************************** 286. row ***************************
  860. Variable_name: Not_flushed_delayed_rows
  861. Value: 0
  862. *************************** 287. row ***************************
  863. Variable_name: Ongoing_anonymous_transaction_count
  864. Value: 0
  865. *************************** 288. row ***************************
  866. Variable_name: Open_files
  867. Value: 2
  868. *************************** 289. row ***************************
  869. Variable_name: Open_streams
  870. Value: 0
  871. *************************** 290. row ***************************
  872. Variable_name: Open_table_definitions
  873. Value: 186
  874. *************************** 291. row ***************************
  875. Variable_name: Open_tables
  876. Value: 872
  877. *************************** 292. row ***************************
  878. Variable_name: Opened_files
  879. Value: 30
  880. *************************** 293. row ***************************
  881. Variable_name: Opened_table_definitions
  882. Value: 556
  883. *************************** 294. row ***************************
  884. Variable_name: Opened_tables
  885. Value: 1575
  886. *************************** 295. row ***************************
  887. Variable_name: Performance_schema_accounts_lost
  888. Value: 0
  889. *************************** 296. row ***************************
  890. Variable_name: Performance_schema_cond_classes_lost
  891. Value: 0
  892. *************************** 297. row ***************************
  893. Variable_name: Performance_schema_cond_instances_lost
  894. Value: 0
  895. *************************** 298. row ***************************
  896. Variable_name: Performance_schema_digest_lost
  897. Value: 0
  898. *************************** 299. row ***************************
  899. Variable_name: Performance_schema_file_classes_lost
  900. Value: 0
  901. *************************** 300. row ***************************
  902. Variable_name: Performance_schema_file_handles_lost
  903. Value: 0
  904. *************************** 301. row ***************************
  905. Variable_name: Performance_schema_file_instances_lost
  906. Value: 0
  907. *************************** 302. row ***************************
  908. Variable_name: Performance_schema_hosts_lost
  909. Value: 0
  910. *************************** 303. row ***************************
  911. Variable_name: Performance_schema_index_stat_lost
  912. Value: 0
  913. *************************** 304. row ***************************
  914. Variable_name: Performance_schema_locker_lost
  915. Value: 0
  916. *************************** 305. row ***************************
  917. Variable_name: Performance_schema_memory_classes_lost
  918. Value: 0
  919. *************************** 306. row ***************************
  920. Variable_name: Performance_schema_metadata_lock_lost
  921. Value: 0
  922. *************************** 307. row ***************************
  923. Variable_name: Performance_schema_mutex_classes_lost
  924. Value: 0
  925. *************************** 308. row ***************************
  926. Variable_name: Performance_schema_mutex_instances_lost
  927. Value: 0
  928. *************************** 309. row ***************************
  929. Variable_name: Performance_schema_nested_statement_lost
  930. Value: 0
  931. *************************** 310. row ***************************
  932. Variable_name: Performance_schema_prepared_statements_lost
  933. Value: 0
  934. *************************** 311. row ***************************
  935. Variable_name: Performance_schema_program_lost
  936. Value: 0
  937. *************************** 312. row ***************************
  938. Variable_name: Performance_schema_rwlock_classes_lost
  939. Value: 0
  940. *************************** 313. row ***************************
  941. Variable_name: Performance_schema_rwlock_instances_lost
  942. Value: 0
  943. *************************** 314. row ***************************
  944. Variable_name: Performance_schema_session_connect_attrs_longest_seen
  945. Value: 0
  946. *************************** 315. row ***************************
  947. Variable_name: Performance_schema_session_connect_attrs_lost
  948. Value: 0
  949. *************************** 316. row ***************************
  950. Variable_name: Performance_schema_socket_classes_lost
  951. Value: 0
  952. *************************** 317. row ***************************
  953. Variable_name: Performance_schema_socket_instances_lost
  954. Value: 0
  955. *************************** 318. row ***************************
  956. Variable_name: Performance_schema_stage_classes_lost
  957. Value: 0
  958. *************************** 319. row ***************************
  959. Variable_name: Performance_schema_statement_classes_lost
  960. Value: 0
  961. *************************** 320. row ***************************
  962. Variable_name: Performance_schema_table_handles_lost
  963. Value: 0
  964. *************************** 321. row ***************************
  965. Variable_name: Performance_schema_table_instances_lost
  966. Value: 0
  967. *************************** 322. row ***************************
  968. Variable_name: Performance_schema_table_lock_stat_lost
  969. Value: 0
  970. *************************** 323. row ***************************
  971. Variable_name: Performance_schema_thread_classes_lost
  972. Value: 0
  973. *************************** 324. row ***************************
  974. Variable_name: Performance_schema_thread_instances_lost
  975. Value: 0
  976. *************************** 325. row ***************************
  977. Variable_name: Performance_schema_users_lost
  978. Value: 0
  979. *************************** 326. row ***************************
  980. Variable_name: Prepared_stmt_count
  981. Value: 0
  982. *************************** 327. row ***************************
  983. Variable_name: Queries
  984. Value: 219139
  985. *************************** 328. row ***************************
  986. Variable_name: Questions
  987. Value: 123880
  988. *************************** 329. row ***************************
  989. Variable_name: Rsa_public_key
  990. Value: -----BEGIN PUBLIC KEY-----
  991. blabla
  992. -----END PUBLIC KEY-----
  993.  
  994. *************************** 330. row ***************************
  995. Variable_name: Secondary_engine_execution_count
  996. Value: 0
  997. *************************** 331. row ***************************
  998. Variable_name: Select_full_join
  999. Value: 146
  1000. *************************** 332. row ***************************
  1001. Variable_name: Select_full_range_join
  1002. Value: 0
  1003. *************************** 333. row ***************************
  1004. Variable_name: Select_range
  1005. Value: 0
  1006. *************************** 334. row ***************************
  1007. Variable_name: Select_range_check
  1008. Value: 0
  1009. *************************** 335. row ***************************
  1010. Variable_name: Select_scan
  1011. Value: 48897
  1012. *************************** 336. row ***************************
  1013. Variable_name: Slave_open_temp_tables
  1014. Value: 0
  1015. *************************** 337. row ***************************
  1016. Variable_name: Slow_launch_threads
  1017. Value: 0
  1018. *************************** 338. row ***************************
  1019. Variable_name: Slow_queries
  1020. Value: 0
  1021. *************************** 339. row ***************************
  1022. Variable_name: Sort_merge_passes
  1023. Value: 0
  1024. *************************** 340. row ***************************
  1025. Variable_name: Sort_range
  1026. Value: 0
  1027. *************************** 341. row ***************************
  1028. Variable_name: Sort_rows
  1029. Value: 2171
  1030. *************************** 342. row ***************************
  1031. Variable_name: Sort_scan
  1032. Value: 2056
  1033. *************************** 343. row ***************************
  1034. Variable_name: Ssl_accept_renegotiates
  1035. Value: 0
  1036. *************************** 344. row ***************************
  1037. Variable_name: Ssl_accepts
  1038. Value: 0
  1039. *************************** 345. row ***************************
  1040. Variable_name: Ssl_callback_cache_hits
  1041. Value: 0
  1042. *************************** 346. row ***************************
  1043. Variable_name: Ssl_cipher
  1044. Value: ECDHE-RSA-AES128-GCM-SHA256
  1045. *************************** 347. row ***************************
  1046. Variable_name: Ssl_cipher_list
  1047. Value: ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES128-SHA:AES256-SHA:DES-CBC3-SHA
  1048. *************************** 348. row ***************************
  1049. Variable_name: Ssl_client_connects
  1050. Value: 0
  1051. *************************** 349. row ***************************
  1052. Variable_name: Ssl_connect_renegotiates
  1053. Value: 0
  1054. *************************** 350. row ***************************
  1055. Variable_name: Ssl_ctx_verify_depth
  1056. Value: 18446744073709551615
  1057. *************************** 351. row ***************************
  1058. Variable_name: Ssl_ctx_verify_mode
  1059. Value: 1
  1060. *************************** 352. row ***************************
  1061. Variable_name: Ssl_default_timeout
  1062. Value: 7200
  1063. *************************** 353. row ***************************
  1064. Variable_name: Ssl_finished_accepts
  1065. Value: 0
  1066. *************************** 354. row ***************************
  1067. Variable_name: Ssl_finished_connects
  1068. Value: 0
  1069. *************************** 355. row ***************************
  1070. Variable_name: Ssl_server_not_after
  1071. Value: Dec 15 10:44:59 2031 GMT
  1072. *************************** 356. row ***************************
  1073. Variable_name: Ssl_server_not_before
  1074. Value: Dec 17 10:43:59 2021 GMT
  1075. *************************** 357. row ***************************
  1076. Variable_name: Ssl_session_cache_hits
  1077. Value: 0
  1078. *************************** 358. row ***************************
  1079. Variable_name: Ssl_session_cache_misses
  1080. Value: 0
  1081. *************************** 359. row ***************************
  1082. Variable_name: Ssl_session_cache_mode
  1083. Value: SERVER
  1084. *************************** 360. row ***************************
  1085. Variable_name: Ssl_session_cache_overflows
  1086. Value: 0
  1087. *************************** 361. row ***************************
  1088. Variable_name: Ssl_session_cache_size
  1089. Value: 128
  1090. *************************** 362. row ***************************
  1091. Variable_name: Ssl_session_cache_timeouts
  1092. Value: 0
  1093. *************************** 363. row ***************************
  1094. Variable_name: Ssl_sessions_reused
  1095. Value: 0
  1096. *************************** 364. row ***************************
  1097. Variable_name: Ssl_used_session_cache_entries
  1098. Value: 0
  1099. *************************** 365. row ***************************
  1100. Variable_name: Ssl_verify_depth
  1101. Value: 18446744073709551615
  1102. *************************** 366. row ***************************
  1103. Variable_name: Ssl_verify_mode
  1104. Value: 1
  1105. *************************** 367. row ***************************
  1106. Variable_name: Ssl_version
  1107. Value: TLSv1.2
  1108. *************************** 368. row ***************************
  1109. Variable_name: Table_locks_immediate
  1110. Value: 20933
  1111. *************************** 369. row ***************************
  1112. Variable_name: Table_locks_waited
  1113. Value: 0
  1114. *************************** 370. row ***************************
  1115. Variable_name: Table_open_cache_hits
  1116. Value: 139534
  1117. *************************** 371. row ***************************
  1118. Variable_name: Table_open_cache_misses
  1119. Value: 1575
  1120. *************************** 372. row ***************************
  1121. Variable_name: Table_open_cache_overflows
  1122. Value: 0
  1123. *************************** 373. row ***************************
  1124. Variable_name: Tc_log_max_pages_used
  1125. Value: 0
  1126. *************************** 374. row ***************************
  1127. Variable_name: Tc_log_page_size
  1128. Value: 0
  1129. *************************** 375. row ***************************
  1130. Variable_name: Tc_log_page_waits
  1131. Value: 0
  1132. *************************** 376. row ***************************
  1133. Variable_name: Threads_cached
  1134. Value: 4
  1135. *************************** 377. row ***************************
  1136. Variable_name: Threads_connected
  1137. Value: 10
  1138. *************************** 378. row ***************************
  1139. Variable_name: Threads_created
  1140. Value: 14
  1141. *************************** 379. row ***************************
  1142. Variable_name: Threads_running
  1143. Value: 2
  1144. *************************** 380. row ***************************
  1145. Variable_name: Uptime
  1146. Value: 78404
  1147. *************************** 381. row ***************************
  1148. Variable_name: Uptime_since_flush_status
  1149. Value: 78404
  1150. *************************** 382. row ***************************
  1151. Variable_name: User_threads_connected
  1152. Value: 6
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!