Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.82 KB | None | 0 0
  1. mysql> SHOW GLOBAL STATUS\G;
  2. *************************** 1. row ***************************
  3. Variable_name: Aborted_clients
  4. Value: 9679
  5. *************************** 2. row ***************************
  6. Variable_name: Aborted_connects
  7. Value: 371132
  8. *************************** 3. row ***************************
  9. Variable_name: Binlog_cache_disk_use
  10. Value: 0
  11. *************************** 4. row ***************************
  12. Variable_name: Binlog_cache_use
  13. Value: 0
  14. *************************** 5. row ***************************
  15. Variable_name: Binlog_stmt_cache_disk_use
  16. Value: 0
  17. *************************** 6. row ***************************
  18. Variable_name: Binlog_stmt_cache_use
  19. Value: 0
  20. *************************** 7. row ***************************
  21. Variable_name: Bytes_received
  22. Value: 375611005675
  23. *************************** 8. row ***************************
  24. Variable_name: Bytes_sent
  25. Value: 6948696360269
  26. *************************** 9. row ***************************
  27. Variable_name: Com_admin_commands
  28. Value: 8749143
  29. *************************** 10. row ***************************
  30. Variable_name: Com_assign_to_keycache
  31. Value: 0
  32. *************************** 11. row ***************************
  33. Variable_name: Com_alter_db
  34. Value: 0
  35. *************************** 12. row ***************************
  36. Variable_name: Com_alter_db_upgrade
  37. Value: 0
  38. *************************** 13. row ***************************
  39. Variable_name: Com_alter_event
  40. Value: 0
  41. *************************** 14. row ***************************
  42. Variable_name: Com_alter_function
  43. Value: 0
  44. *************************** 15. row ***************************
  45. Variable_name: Com_alter_procedure
  46. Value: 0
  47. *************************** 16. row ***************************
  48. Variable_name: Com_alter_server
  49. Value: 0
  50. *************************** 17. row ***************************
  51. Variable_name: Com_alter_table
  52. Value: 14514
  53. *************************** 18. row ***************************
  54. Variable_name: Com_alter_tablespace
  55. Value: 0
  56. *************************** 19. row ***************************
  57. Variable_name: Com_alter_user
  58. Value: 0
  59. *************************** 20. row ***************************
  60. Variable_name: Com_analyze
  61. Value: 0
  62. *************************** 21. row ***************************
  63. Variable_name: Com_begin
  64. Value: 94675964
  65. *************************** 22. row ***************************
  66. Variable_name: Com_binlog
  67. Value: 0
  68. *************************** 23. row ***************************
  69. Variable_name: Com_call_procedure
  70. Value: 0
  71. *************************** 24. row ***************************
  72. Variable_name: Com_change_db
  73. Value: 41923101
  74. *************************** 25. row ***************************
  75. Variable_name: Com_change_master
  76. Value: 0
  77. *************************** 26. row ***************************
  78. Variable_name: Com_check
  79. Value: 0
  80. *************************** 27. row ***************************
  81. Variable_name: Com_checksum
  82. Value: 0
  83. *************************** 28. row ***************************
  84. Variable_name: Com_commit
  85. Value: 94675959
  86. *************************** 29. row ***************************
  87. Variable_name: Com_create_db
  88. Value: 23
  89. *************************** 30. row ***************************
  90. Variable_name: Com_create_event
  91. Value: 0
  92. *************************** 31. row ***************************
  93. Variable_name: Com_create_function
  94. Value: 0
  95. *************************** 32. row ***************************
  96. Variable_name: Com_create_index
  97. Value: 0
  98. *************************** 33. row ***************************
  99. Variable_name: Com_create_procedure
  100. Value: 0
  101. *************************** 34. row ***************************
  102. Variable_name: Com_create_server
  103. Value: 0
  104. *************************** 35. row ***************************
  105. Variable_name: Com_create_table
  106. Value: 8801
  107. *************************** 36. row ***************************
  108. Variable_name: Com_create_trigger
  109. Value: 0
  110. *************************** 37. row ***************************
  111. Variable_name: Com_create_udf
  112. Value: 0
  113. *************************** 38. row ***************************
  114. Variable_name: Com_create_user
  115. Value: 0
  116. *************************** 39. row ***************************
  117. Variable_name: Com_create_view
  118. Value: 9
  119. *************************** 40. row ***************************
  120. Variable_name: Com_dealloc_sql
  121. Value: 0
  122. *************************** 41. row ***************************
  123. Variable_name: Com_delete
  124. Value: 27289251
  125. *************************** 42. row ***************************
  126. Variable_name: Com_delete_multi
  127. Value: 5303
  128. *************************** 43. row ***************************
  129. Variable_name: Com_do
  130. Value: 0
  131. *************************** 44. row ***************************
  132. Variable_name: Com_drop_db
  133. Value: 2
  134. *************************** 45. row ***************************
  135. Variable_name: Com_drop_event
  136. Value: 0
  137. *************************** 46. row ***************************
  138. Variable_name: Com_drop_function
  139. Value: 0
  140. *************************** 47. row ***************************
  141. Variable_name: Com_drop_index
  142. Value: 0
  143. *************************** 48. row ***************************
  144. Variable_name: Com_drop_procedure
  145. Value: 0
  146. *************************** 49. row ***************************
  147. Variable_name: Com_drop_server
  148. Value: 0
  149. *************************** 50. row ***************************
  150. Variable_name: Com_drop_table
  151. Value: 89
  152. *************************** 51. row ***************************
  153. Variable_name: Com_drop_trigger
  154. Value: 0
  155. *************************** 52. row ***************************
  156. Variable_name: Com_drop_user
  157. Value: 0
  158. *************************** 53. row ***************************
  159. Variable_name: Com_drop_view
  160. Value: 0
  161. *************************** 54. row ***************************
  162. Variable_name: Com_empty_query
  163. Value: 5
  164. *************************** 55. row ***************************
  165. Variable_name: Com_execute_sql
  166. Value: 0
  167. *************************** 56. row ***************************
  168. Variable_name: Com_flush
  169. Value: 2
  170. *************************** 57. row ***************************
  171. Variable_name: Com_get_diagnostics
  172. Value: 0
  173. *************************** 58. row ***************************
  174. Variable_name: Com_grant
  175. Value: 0
  176. *************************** 59. row ***************************
  177. Variable_name: Com_ha_close
  178. Value: 0
  179. *************************** 60. row ***************************
  180. Variable_name: Com_ha_open
  181. Value: 0
  182. *************************** 61. row ***************************
  183. Variable_name: Com_ha_read
  184. Value: 0
  185. *************************** 62. row ***************************
  186. Variable_name: Com_help
  187. Value: 0
  188. *************************** 63. row ***************************
  189. Variable_name: Com_insert
  190. Value: 32572833
  191. *************************** 64. row ***************************
  192. Variable_name: Com_insert_select
  193. Value: 87096
  194. *************************** 65. row ***************************
  195. Variable_name: Com_install_plugin
  196. Value: 0
  197. *************************** 66. row ***************************
  198. Variable_name: Com_kill
  199. Value: 1
  200. *************************** 67. row ***************************
  201. Variable_name: Com_load
  202. Value: 0
  203. *************************** 68. row ***************************
  204. Variable_name: Com_lock_tables
  205. Value: 1421
  206. *************************** 69. row ***************************
  207. Variable_name: Com_optimize
  208. Value: 0
  209. *************************** 70. row ***************************
  210. Variable_name: Com_preload_keys
  211. Value: 0
  212. *************************** 71. row ***************************
  213. Variable_name: Com_prepare_sql
  214. Value: 0
  215. *************************** 72. row ***************************
  216. Variable_name: Com_purge
  217. Value: 0
  218. *************************** 73. row ***************************
  219. Variable_name: Com_purge_before_date
  220. Value: 0
  221. *************************** 74. row ***************************
  222. Variable_name: Com_release_savepoint
  223. Value: 2
  224. *************************** 75. row ***************************
  225. Variable_name: Com_rename_table
  226. Value: 68
  227. *************************** 76. row ***************************
  228. Variable_name: Com_rename_user
  229. Value: 0
  230. *************************** 77. row ***************************
  231. Variable_name: Com_repair
  232. Value: 0
  233. *************************** 78. row ***************************
  234. Variable_name: Com_replace
  235. Value: 6549371
  236. *************************** 79. row ***************************
  237. Variable_name: Com_replace_select
  238. Value: 0
  239. *************************** 80. row ***************************
  240. Variable_name: Com_reset
  241. Value: 0
  242. *************************** 81. row ***************************
  243. Variable_name: Com_resignal
  244. Value: 0
  245. *************************** 82. row ***************************
  246. Variable_name: Com_revoke
  247. Value: 0
  248. *************************** 83. row ***************************
  249. Variable_name: Com_revoke_all
  250. Value: 0
  251. *************************** 84. row ***************************
  252. Variable_name: Com_rollback
  253. Value: 0
  254. *************************** 85. row ***************************
  255. Variable_name: Com_rollback_to_savepoint
  256. Value: 1325
  257. *************************** 86. row ***************************
  258. Variable_name: Com_savepoint
  259. Value: 5
  260. *************************** 87. row ***************************
  261. Variable_name: Com_select
  262. Value: 991823843
  263. *************************** 88. row ***************************
  264. Variable_name: Com_set_option
  265. Value: 13689686
  266. *************************** 89. row ***************************
  267. Variable_name: Com_signal
  268. Value: 0
  269. *************************** 90. row ***************************
  270. Variable_name: Com_show_binlog_events
  271. Value: 0
  272. *************************** 91. row ***************************
  273. Variable_name: Com_show_binlogs
  274. Value: 6959
  275. *************************** 92. row ***************************
  276. Variable_name: Com_show_charsets
  277. Value: 0
  278. *************************** 93. row ***************************
  279. Variable_name: Com_show_collations
  280. Value: 0
  281. *************************** 94. row ***************************
  282. Variable_name: Com_show_create_db
  283. Value: 1419
  284. *************************** 95. row ***************************
  285. Variable_name: Com_show_create_event
  286. Value: 0
  287. *************************** 96. row ***************************
  288. Variable_name: Com_show_create_func
  289. Value: 0
  290. *************************** 97. row ***************************
  291. Variable_name: Com_show_create_proc
  292. Value: 0
  293. *************************** 98. row ***************************
  294. Variable_name: Com_show_create_table
  295. Value: 469784
  296. *************************** 99. row ***************************
  297. Variable_name: Com_show_create_trigger
  298. Value: 0
  299. *************************** 100. row ***************************
  300. Variable_name: Com_show_databases
  301. Value: 5
  302. *************************** 101. row ***************************
  303. Variable_name: Com_show_engine_logs
  304. Value: 0
  305. *************************** 102. row ***************************
  306. Variable_name: Com_show_engine_mutex
  307. Value: 0
  308. *************************** 103. row ***************************
  309. Variable_name: Com_show_engine_status
  310. Value: 6942
  311. *************************** 104. row ***************************
  312. Variable_name: Com_show_events
  313. Value: 0
  314. *************************** 105. row ***************************
  315. Variable_name: Com_show_errors
  316. Value: 0
  317. *************************** 106. row ***************************
  318. Variable_name: Com_show_fields
  319. Value: 472092
  320. *************************** 107. row ***************************
  321. Variable_name: Com_show_function_code
  322. Value: 0
  323. *************************** 108. row ***************************
  324. Variable_name: Com_show_function_status
  325. Value: 0
  326. *************************** 109. row ***************************
  327. Variable_name: Com_show_grants
  328. Value: 7
  329. *************************** 110. row ***************************
  330. Variable_name: Com_show_keys
  331. Value: 1
  332. *************************** 111. row ***************************
  333. Variable_name: Com_show_master_status
  334. Value: 162
  335. *************************** 112. row ***************************
  336. Variable_name: Com_show_open_tables
  337. Value: 0
  338. *************************** 113. row ***************************
  339. Variable_name: Com_show_plugins
  340. Value: 1
  341. *************************** 114. row ***************************
  342. Variable_name: Com_show_privileges
  343. Value: 0
  344. *************************** 115. row ***************************
  345. Variable_name: Com_show_procedure_code
  346. Value: 0
  347. *************************** 116. row ***************************
  348. Variable_name: Com_show_procedure_status
  349. Value: 0
  350. *************************** 117. row ***************************
  351. Variable_name: Com_show_processlist
  352. Value: 7092
  353. *************************** 118. row ***************************
  354. Variable_name: Com_show_profile
  355. Value: 0
  356. *************************** 119. row ***************************
  357. Variable_name: Com_show_profiles
  358. Value: 0
  359. *************************** 120. row ***************************
  360. Variable_name: Com_show_relaylog_events
  361. Value: 0
  362. *************************** 121. row ***************************
  363. Variable_name: Com_show_slave_hosts
  364. Value: 1
  365. *************************** 122. row ***************************
  366. Variable_name: Com_show_slave_status
  367. Value: 8761067
  368. *************************** 123. row ***************************
  369. Variable_name: Com_show_status
  370. Value: 7107
  371. *************************** 124. row ***************************
  372. Variable_name: Com_show_storage_engines
  373. Value: 1
  374. *************************** 125. row ***************************
  375. Variable_name: Com_show_table_status
  376. Value: 466781
  377. *************************** 126. row ***************************
  378. Variable_name: Com_show_tables
  379. Value: 1461
  380. *************************** 127. row ***************************
  381. Variable_name: Com_show_triggers
  382. Value: 465489
  383. *************************** 128. row ***************************
  384. Variable_name: Com_show_variables
  385. Value: 7119
  386. *************************** 129. row ***************************
  387. Variable_name: Com_show_warnings
  388. Value: 0
  389. *************************** 130. row ***************************
  390. Variable_name: Com_slave_start
  391. Value: 0
  392. *************************** 131. row ***************************
  393. Variable_name: Com_slave_stop
  394. Value: 0
  395. *************************** 132. row ***************************
  396. Variable_name: Com_stmt_close
  397. Value: 0
  398. *************************** 133. row ***************************
  399. Variable_name: Com_stmt_execute
  400. Value: 0
  401. *************************** 134. row ***************************
  402. Variable_name: Com_stmt_fetch
  403. Value: 0
  404. *************************** 135. row ***************************
  405. Variable_name: Com_stmt_prepare
  406. Value: 0
  407. *************************** 136. row ***************************
  408. Variable_name: Com_stmt_reprepare
  409. Value: 0
  410. *************************** 137. row ***************************
  411. Variable_name: Com_stmt_reset
  412. Value: 0
  413. *************************** 138. row ***************************
  414. Variable_name: Com_stmt_send_long_data
  415. Value: 0
  416. *************************** 139. row ***************************
  417. Variable_name: Com_truncate
  418. Value: 507
  419. *************************** 140. row ***************************
  420. Variable_name: Com_uninstall_plugin
  421. Value: 0
  422. *************************** 141. row ***************************
  423. Variable_name: Com_unlock_tables
  424. Value: 1427
  425. *************************** 142. row ***************************
  426. Variable_name: Com_update
  427. Value: 43830477
  428. *************************** 143. row ***************************
  429. Variable_name: Com_update_multi
  430. Value: 2061
  431. *************************** 144. row ***************************
  432. Variable_name: Com_xa_commit
  433. Value: 0
  434. *************************** 145. row ***************************
  435. Variable_name: Com_xa_end
  436. Value: 0
  437. *************************** 146. row ***************************
  438. Variable_name: Com_xa_prepare
  439. Value: 0
  440. *************************** 147. row ***************************
  441. Variable_name: Com_xa_recover
  442. Value: 0
  443. *************************** 148. row ***************************
  444. Variable_name: Com_xa_rollback
  445. Value: 0
  446. *************************** 149. row ***************************
  447. Variable_name: Com_xa_start
  448. Value: 0
  449. *************************** 150. row ***************************
  450. Variable_name: Compression
  451. Value: OFF
  452. *************************** 151. row ***************************
  453. Variable_name: Connection_errors_accept
  454. Value: 0
  455. *************************** 152. row ***************************
  456. Variable_name: Connection_errors_internal
  457. Value: 0
  458. *************************** 153. row ***************************
  459. Variable_name: Connection_errors_max_connections
  460. Value: 0
  461. *************************** 154. row ***************************
  462. Variable_name: Connection_errors_peer_address
  463. Value: 0
  464. *************************** 155. row ***************************
  465. Variable_name: Connection_errors_select
  466. Value: 0
  467. *************************** 156. row ***************************
  468. Variable_name: Connection_errors_tcpwrap
  469. Value: 0
  470. *************************** 157. row ***************************
  471. Variable_name: Connections
  472. Value: 50255694
  473. *************************** 158. row ***************************
  474. Variable_name: Created_tmp_disk_tables
  475. Value: 58100771
  476. *************************** 159. row ***************************
  477. Variable_name: Created_tmp_files
  478. Value: 87768
  479. *************************** 160. row ***************************
  480. Variable_name: Created_tmp_tables
  481. Value: 165917864
  482. *************************** 161. row ***************************
  483. Variable_name: Delayed_errors
  484. Value: 0
  485. *************************** 162. row ***************************
  486. Variable_name: Delayed_insert_threads
  487. Value: 0
  488. *************************** 163. row ***************************
  489. Variable_name: Delayed_writes
  490. Value: 0
  491. *************************** 164. row ***************************
  492. Variable_name: Flush_commands
  493. Value: 1
  494. *************************** 165. row ***************************
  495. Variable_name: Handler_commit
  496. Value: 1187083598
  497. *************************** 166. row ***************************
  498. Variable_name: Handler_delete
  499. Value: 496106687
  500. *************************** 167. row ***************************
  501. Variable_name: Handler_discover
  502. Value: 0
  503. *************************** 168. row ***************************
  504. Variable_name: Handler_external_lock
  505. Value: 3769307500
  506. *************************** 169. row ***************************
  507. Variable_name: Handler_mrr_init
  508. Value: 0
  509. *************************** 170. row ***************************
  510. Variable_name: Handler_prepare
  511. Value: 0
  512. *************************** 171. row ***************************
  513. Variable_name: Handler_read_first
  514. Value: 224449498
  515. *************************** 172. row ***************************
  516. Variable_name: Handler_read_key
  517. Value: 137279808270
  518. *************************** 173. row ***************************
  519. Variable_name: Handler_read_last
  520. Value: 2288715
  521. *************************** 174. row ***************************
  522. Variable_name: Handler_read_next
  523. Value: 1052470718194
  524. *************************** 175. row ***************************
  525. Variable_name: Handler_read_prev
  526. Value: 8284386963
  527. *************************** 176. row ***************************
  528. Variable_name: Handler_read_rnd
  529. Value: 25432088710
  530. *************************** 177. row ***************************
  531. Variable_name: Handler_read_rnd_next
  532. Value: 300963194594
  533. *************************** 178. row ***************************
  534. Variable_name: Handler_rollback
  535. Value: 84
  536. *************************** 179. row ***************************
  537. Variable_name: Handler_savepoint
  538. Value: 5
  539. *************************** 180. row ***************************
  540. Variable_name: Handler_savepoint_rollback
  541. Value: 1325
  542. *************************** 181. row ***************************
  543. Variable_name: Handler_update
  544. Value: 6763880761
  545. *************************** 182. row ***************************
  546. Variable_name: Handler_write
  547. Value: 29909252802
  548. *************************** 183. row ***************************
  549. Variable_name: Innodb_buffer_pool_dump_status
  550. Value: not started
  551. *************************** 184. row ***************************
  552. Variable_name: Innodb_buffer_pool_load_status
  553. Value: not started
  554. *************************** 185. row ***************************
  555. Variable_name: Innodb_buffer_pool_pages_data
  556. Value: 1468682
  557. *************************** 186. row ***************************
  558. Variable_name: Innodb_buffer_pool_bytes_data
  559. Value: 24062885888
  560. *************************** 187. row ***************************
  561. Variable_name: Innodb_buffer_pool_pages_dirty
  562. Value: 6740
  563. *************************** 188. row ***************************
  564. Variable_name: Innodb_buffer_pool_bytes_dirty
  565. Value: 110428160
  566. *************************** 189. row ***************************
  567. Variable_name: Innodb_buffer_pool_pages_flushed
  568. Value: 150193054
  569. *************************** 190. row ***************************
  570. Variable_name: Innodb_buffer_pool_pages_free
  571. Value: 7853
  572. *************************** 191. row ***************************
  573. Variable_name: Innodb_buffer_pool_pages_misc
  574. Value: 96325
  575. *************************** 192. row ***************************
  576. Variable_name: Innodb_buffer_pool_pages_total
  577. Value: 1572860
  578. *************************** 193. row ***************************
  579. Variable_name: Innodb_buffer_pool_read_ahead_rnd
  580. Value: 0
  581. *************************** 194. row ***************************
  582. Variable_name: Innodb_buffer_pool_read_ahead
  583. Value: 17291749
  584. *************************** 195. row ***************************
  585. Variable_name: Innodb_buffer_pool_read_ahead_evicted
  586. Value: 5476
  587. *************************** 196. row ***************************
  588. Variable_name: Innodb_buffer_pool_read_requests
  589. Value: 1362527306367
  590. *************************** 197. row ***************************
  591. Variable_name: Innodb_buffer_pool_reads
  592. Value: 223908924
  593. *************************** 198. row ***************************
  594. Variable_name: Innodb_buffer_pool_wait_free
  595. Value: 0
  596. *************************** 199. row ***************************
  597. Variable_name: Innodb_buffer_pool_write_requests
  598. Value: 18574211377
  599. *************************** 200. row ***************************
  600. Variable_name: Innodb_data_fsyncs
  601. Value: 114987861
  602. *************************** 201. row ***************************
  603. Variable_name: Innodb_data_pending_fsyncs
  604. Value: 0
  605. *************************** 202. row ***************************
  606. Variable_name: Innodb_data_pending_reads
  607. Value: 0
  608. *************************** 203. row ***************************
  609. Variable_name: Innodb_data_pending_writes
  610. Value: 0
  611. *************************** 204. row ***************************
  612. Variable_name: Innodb_data_read
  613. Value: 4122428100608
  614. *************************** 205. row ***************************
  615. Variable_name: Innodb_data_reads
  616. Value: 252125047
  617. *************************** 206. row ***************************
  618. Variable_name: Innodb_data_writes
  619. Value: 232092316
  620. *************************** 207. row ***************************
  621. Variable_name: Innodb_data_written
  622. Value: 5477843815424
  623. *************************** 208. row ***************************
  624. Variable_name: Innodb_dblwr_pages_written
  625. Value: 150193054
  626. *************************** 209. row ***************************
  627. Variable_name: Innodb_dblwr_writes
  628. Value: 11959746
  629. *************************** 210. row ***************************
  630. Variable_name: Innodb_have_atomic_builtins
  631. Value: ON
  632. *************************** 211. row ***************************
  633. Variable_name: Innodb_log_waits
  634. Value: 0
  635. *************************** 212. row ***************************
  636. Variable_name: Innodb_log_write_requests
  637. Value: 1197205996
  638. *************************** 213. row ***************************
  639. Variable_name: Innodb_log_writes
  640. Value: 69362297
  641. *************************** 214. row ***************************
  642. Variable_name: Innodb_os_log_fsyncs
  643. Value: 69612464
  644. *************************** 215. row ***************************
  645. Variable_name: Innodb_os_log_pending_fsyncs
  646. Value: 0
  647. *************************** 216. row ***************************
  648. Variable_name: Innodb_os_log_pending_writes
  649. Value: 0
  650. *************************** 217. row ***************************
  651. Variable_name: Innodb_os_log_written
  652. Value: 556204107264
  653. *************************** 218. row ***************************
  654. Variable_name: Innodb_page_size
  655. Value: 16384
  656. *************************** 219. row ***************************
  657. Variable_name: Innodb_pages_created
  658. Value: 8949645
  659. *************************** 220. row ***************************
  660. Variable_name: Innodb_pages_read
  661. Value: 251614384
  662. *************************** 221. row ***************************
  663. Variable_name: Innodb_pages_written
  664. Value: 150193054
  665. *************************** 222. row ***************************
  666. Variable_name: Innodb_row_lock_current_waits
  667. Value: 0
  668. *************************** 223. row ***************************
  669. Variable_name: Innodb_row_lock_time
  670. Value: 0
  671. *************************** 224. row ***************************
  672. Variable_name: Innodb_row_lock_time_avg
  673. Value: 0
  674. *************************** 225. row ***************************
  675. Variable_name: Innodb_row_lock_time_max
  676. Value: 0
  677. *************************** 226. row ***************************
  678. Variable_name: Innodb_row_lock_waits
  679. Value: 0
  680. *************************** 227. row ***************************
  681. Variable_name: Innodb_rows_deleted
  682. Value: 496172364
  683. *************************** 228. row ***************************
  684. Variable_name: Innodb_rows_inserted
  685. Value: 539630268
  686. *************************** 229. row ***************************
  687. Variable_name: Innodb_rows_read
  688. Value: 1419279067224
  689. *************************** 230. row ***************************
  690. Variable_name: Innodb_rows_updated
  691. Value: 471373449
  692. *************************** 231. row ***************************
  693. Variable_name: Innodb_num_open_files
  694. Value: 2000
  695. *************************** 232. row ***************************
  696. Variable_name: Innodb_truncated_status_writes
  697. Value: 0
  698. *************************** 233. row ***************************
  699. Variable_name: Innodb_available_undo_logs
  700. Value: 128
  701. *************************** 234. row ***************************
  702. Variable_name: Key_blocks_not_flushed
  703. Value: 0
  704. *************************** 235. row ***************************
  705. Variable_name: Key_blocks_unused
  706. Value: 857368
  707. *************************** 236. row ***************************
  708. Variable_name: Key_blocks_used
  709. Value: 6797
  710. *************************** 237. row ***************************
  711. Variable_name: Key_read_requests
  712. Value: 20817794454
  713. *************************** 238. row ***************************
  714. Variable_name: Key_reads
  715. Value: 6841275
  716. *************************** 239. row ***************************
  717. Variable_name: Key_write_requests
  718. Value: 4140103768
  719. *************************** 240. row ***************************
  720. Variable_name: Key_writes
  721. Value: 48618
  722. *************************** 241. row ***************************
  723. Variable_name: Last_query_cost
  724. Value: 0.000000
  725. *************************** 242. row ***************************
  726. Variable_name: Last_query_partial_plans
  727. Value: 0
  728. *************************** 243. row ***************************
  729. Variable_name: Max_used_connections
  730. Value: 507
  731. *************************** 244. row ***************************
  732. Variable_name: Not_flushed_delayed_rows
  733. Value: 0
  734. *************************** 245. row ***************************
  735. Variable_name: Open_files
  736. Value: 23
  737. *************************** 246. row ***************************
  738. Variable_name: Open_streams
  739. Value: 0
  740. *************************** 247. row ***************************
  741. Variable_name: Open_table_definitions
  742. Value: 1965
  743. *************************** 248. row ***************************
  744. Variable_name: Open_tables
  745. Value: 2000
  746. *************************** 249. row ***************************
  747. Variable_name: Opened_files
  748. Value: 466154876
  749. *************************** 250. row ***************************
  750. Variable_name: Opened_table_definitions
  751. Value: 232734466
  752. *************************** 251. row ***************************
  753. Variable_name: Opened_tables
  754. Value: 280606491
  755. *************************** 252. row ***************************
  756. Variable_name: Performance_schema_accounts_lost
  757. Value: 0
  758. *************************** 253. row ***************************
  759. Variable_name: Performance_schema_cond_classes_lost
  760. Value: 0
  761. *************************** 254. row ***************************
  762. Variable_name: Performance_schema_cond_instances_lost
  763. Value: 0
  764. *************************** 255. row ***************************
  765. Variable_name: Performance_schema_digest_lost
  766. Value: 544989142
  767. *************************** 256. row ***************************
  768. Variable_name: Performance_schema_file_classes_lost
  769. Value: 0
  770. *************************** 257. row ***************************
  771. Variable_name: Performance_schema_file_handles_lost
  772. Value: 0
  773. *************************** 258. row ***************************
  774. Variable_name: Performance_schema_file_instances_lost
  775. Value: 479785988
  776. *************************** 259. row ***************************
  777. Variable_name: Performance_schema_hosts_lost
  778. Value: 0
  779. *************************** 260. row ***************************
  780. Variable_name: Performance_schema_locker_lost
  781. Value: 0
  782. *************************** 261. row ***************************
  783. Variable_name: Performance_schema_mutex_classes_lost
  784. Value: 0
  785. *************************** 262. row ***************************
  786. Variable_name: Performance_schema_mutex_instances_lost
  787. Value: 0
  788. *************************** 263. row ***************************
  789. Variable_name: Performance_schema_rwlock_classes_lost
  790. Value: 0
  791. *************************** 264. row ***************************
  792. Variable_name: Performance_schema_rwlock_instances_lost
  793. Value: 0
  794. *************************** 265. row ***************************
  795. Variable_name: Performance_schema_session_connect_attrs_lost
  796. Value: 0
  797. *************************** 266. row ***************************
  798. Variable_name: Performance_schema_socket_classes_lost
  799. Value: 0
  800. *************************** 267. row ***************************
  801. Variable_name: Performance_schema_socket_instances_lost
  802. Value: 0
  803. *************************** 268. row ***************************
  804. Variable_name: Performance_schema_stage_classes_lost
  805. Value: 0
  806. *************************** 269. row ***************************
  807. Variable_name: Performance_schema_statement_classes_lost
  808. Value: 0
  809. *************************** 270. row ***************************
  810. Variable_name: Performance_schema_table_handles_lost
  811. Value: 0
  812. *************************** 271. row ***************************
  813. Variable_name: Performance_schema_table_instances_lost
  814. Value: 82646217
  815. *************************** 272. row ***************************
  816. Variable_name: Performance_schema_thread_classes_lost
  817. Value: 0
  818. *************************** 273. row ***************************
  819. Variable_name: Performance_schema_thread_instances_lost
  820. Value: 0
  821. *************************** 274. row ***************************
  822. Variable_name: Performance_schema_users_lost
  823. Value: 0
  824. *************************** 275. row ***************************
  825. Variable_name: Prepared_stmt_count
  826. Value: 0
  827. *************************** 276. row ***************************
  828. Variable_name: Qcache_free_blocks
  829. Value: 1
  830. *************************** 277. row ***************************
  831. Variable_name: Qcache_free_memory
  832. Value: 201308616
  833. *************************** 278. row ***************************
  834. Variable_name: Qcache_hits
  835. Value: 0
  836. *************************** 279. row ***************************
  837. Variable_name: Qcache_inserts
  838. Value: 0
  839. *************************** 280. row ***************************
  840. Variable_name: Qcache_lowmem_prunes
  841. Value: 0
  842. *************************** 281. row ***************************
  843. Variable_name: Qcache_not_cached
  844. Value: 991333108
  845. *************************** 282. row ***************************
  846. Variable_name: Qcache_queries_in_cache
  847. Value: 0
  848. *************************** 283. row ***************************
  849. Variable_name: Qcache_total_blocks
  850. Value: 1
  851. *************************** 284. row ***************************
  852. Variable_name: Queries
  853. Value: 1356675214
  854. *************************** 285. row ***************************
  855. Variable_name: Questions
  856. Value: 1116739310
  857. *************************** 286. row ***************************
  858. Variable_name: Select_full_join
  859. Value: 9374444
  860. *************************** 287. row ***************************
  861. Variable_name: Select_full_range_join
  862. Value: 1403795
  863. *************************** 288. row ***************************
  864. Variable_name: Select_range
  865. Value: 80555255
  866. *************************** 289. row ***************************
  867. Variable_name: Select_range_check
  868. Value: 12471
  869. *************************** 290. row ***************************
  870. Variable_name: Select_scan
  871. Value: 240278122
  872. *************************** 291. row ***************************
  873. Variable_name: Slave_heartbeat_period
  874. Value: 1800.000
  875. *************************** 292. row ***************************
  876. Variable_name: Slave_last_heartbeat
  877. Value:
  878. *************************** 293. row ***************************
  879. Variable_name: Slave_open_temp_tables
  880. Value: 0
  881. *************************** 294. row ***************************
  882. Variable_name: Slave_received_heartbeats
  883. Value: 0
  884. *************************** 295. row ***************************
  885. Variable_name: Slave_retried_transactions
  886. Value: 0
  887. *************************** 296. row ***************************
  888. Variable_name: Slave_running
  889. Value: ON
  890. *************************** 297. row ***************************
  891. Variable_name: Slow_launch_threads
  892. Value: 0
  893. *************************** 298. row ***************************
  894. Variable_name: Slow_queries
  895. Value: 214492490
  896. *************************** 299. row ***************************
  897. Variable_name: Sort_merge_passes
  898. Value: 10722
  899. *************************** 300. row ***************************
  900. Variable_name: Sort_range
  901. Value: 137109489
  902. *************************** 301. row ***************************
  903. Variable_name: Sort_rows
  904. Value: 20677341490
  905. *************************** 302. row ***************************
  906. Variable_name: Sort_scan
  907. Value: 154602967
  908. *************************** 303. row ***************************
  909. Variable_name: Ssl_accept_renegotiates
  910. Value: 0
  911. *************************** 304. row ***************************
  912. Variable_name: Ssl_accepts
  913. Value: 0
  914. *************************** 305. row ***************************
  915. Variable_name: Ssl_callback_cache_hits
  916. Value: 0
  917. *************************** 306. row ***************************
  918. Variable_name: Ssl_cipher
  919. Value:
  920. *************************** 307. row ***************************
  921. Variable_name: Ssl_cipher_list
  922. Value:
  923. *************************** 308. row ***************************
  924. Variable_name: Ssl_client_connects
  925. Value: 0
  926. *************************** 309. row ***************************
  927. Variable_name: Ssl_connect_renegotiates
  928. Value: 0
  929. *************************** 310. row ***************************
  930. Variable_name: Ssl_ctx_verify_depth
  931. Value: 0
  932. *************************** 311. row ***************************
  933. Variable_name: Ssl_ctx_verify_mode
  934. Value: 0
  935. *************************** 312. row ***************************
  936. Variable_name: Ssl_default_timeout
  937. Value: 0
  938. *************************** 313. row ***************************
  939. Variable_name: Ssl_finished_accepts
  940. Value: 0
  941. *************************** 314. row ***************************
  942. Variable_name: Ssl_finished_connects
  943. Value: 0
  944. *************************** 315. row ***************************
  945. Variable_name: Ssl_server_not_after
  946. Value:
  947. *************************** 316. row ***************************
  948. Variable_name: Ssl_server_not_before
  949. Value:
  950. *************************** 317. row ***************************
  951. Variable_name: Ssl_session_cache_hits
  952. Value: 0
  953. *************************** 318. row ***************************
  954. Variable_name: Ssl_session_cache_misses
  955. Value: 0
  956. *************************** 319. row ***************************
  957. Variable_name: Ssl_session_cache_mode
  958. Value: NONE
  959. *************************** 320. row ***************************
  960. Variable_name: Ssl_session_cache_overflows
  961. Value: 0
  962. *************************** 321. row ***************************
  963. Variable_name: Ssl_session_cache_size
  964. Value: 0
  965. *************************** 322. row ***************************
  966. Variable_name: Ssl_session_cache_timeouts
  967. Value: 0
  968. *************************** 323. row ***************************
  969. Variable_name: Ssl_sessions_reused
  970. Value: 0
  971. *************************** 324. row ***************************
  972. Variable_name: Ssl_used_session_cache_entries
  973. Value: 0
  974. *************************** 325. row ***************************
  975. Variable_name: Ssl_verify_depth
  976. Value: 0
  977. *************************** 326. row ***************************
  978. Variable_name: Ssl_verify_mode
  979. Value: 0
  980. *************************** 327. row ***************************
  981. Variable_name: Ssl_version
  982. Value:
  983. *************************** 328. row ***************************
  984. Variable_name: Table_locks_immediate
  985. Value: 1763086518
  986. *************************** 329. row ***************************
  987. Variable_name: Table_locks_waited
  988. Value: 9595
  989. *************************** 330. row ***************************
  990. Variable_name: Table_open_cache_hits
  991. Value: 1484933399
  992. *************************** 331. row ***************************
  993. Variable_name: Table_open_cache_misses
  994. Value: 280604315
  995. *************************** 332. row ***************************
  996. Variable_name: Table_open_cache_overflows
  997. Value: 280587711
  998. *************************** 333. row ***************************
  999. Variable_name: Tc_log_max_pages_used
  1000. Value: 0
  1001. *************************** 334. row ***************************
  1002. Variable_name: Tc_log_page_size
  1003. Value: 0
  1004. *************************** 335. row ***************************
  1005. Variable_name: Tc_log_page_waits
  1006. Value: 0
  1007. *************************** 336. row ***************************
  1008. Variable_name: Threads_cached
  1009. Value: 93
  1010. *************************** 337. row ***************************
  1011. Variable_name: Threads_connected
  1012. Value: 5
  1013. *************************** 338. row ***************************
  1014. Variable_name: Threads_created
  1015. Value: 12463
  1016. *************************** 339. row ***************************
  1017. Variable_name: Threads_running
  1018. Value: 2
  1019. *************************** 340. row ***************************
  1020. Variable_name: Uptime
  1021. Value: 2280932
  1022. *************************** 341. row ***************************
  1023. Variable_name: Uptime_since_flush_status
  1024. Value: 2280932
  1025. 341 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement