API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 28th, 2020
515
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 164.89 KB | None | 0 0
raw download clone embed print report
  1. B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME
  2.  
  3. *************************** 1. row ***************************
  4. Variable_name: Aborted_clients
  5. Value: 0
  6. *************************** 2. row ***************************
  7. Variable_name: Aborted_connects
  8. Value: 1
  9. *************************** 3. row ***************************
  10. Variable_name: Binlog_cache_disk_use
  11. Value: 0
  12. *************************** 4. row ***************************
  13. Variable_name: Binlog_cache_use
  14. Value: 0
  15. *************************** 5. row ***************************
  16. Variable_name: Binlog_stmt_cache_disk_use
  17. Value: 0
  18. *************************** 6. row ***************************
  19. Variable_name: Binlog_stmt_cache_use
  20. Value: 0
  21. *************************** 7. row ***************************
  22. Variable_name: Bytes_received
  23. Value: 17294
  24. *************************** 8. row ***************************
  25. Variable_name: Bytes_sent
  26. Value: 286387
  27. *************************** 9. row ***************************
  28. Variable_name: Com_admin_commands
  29. Value: 1
  30. *************************** 10. row ***************************
  31. Variable_name: Com_assign_to_keycache
  32. Value: 0
  33. *************************** 11. row ***************************
  34. Variable_name: Com_alter_db
  35. Value: 0
  36. *************************** 12. row ***************************
  37. Variable_name: Com_alter_db_upgrade
  38. Value: 0
  39. *************************** 13. row ***************************
  40. Variable_name: Com_alter_event
  41. Value: 0
  42. *************************** 14. row ***************************
  43. Variable_name: Com_alter_function
  44. Value: 0
  45. *************************** 15. row ***************************
  46. Variable_name: Com_alter_instance
  47. Value: 0
  48. *************************** 16. row ***************************
  49. Variable_name: Com_alter_procedure
  50. Value: 0
  51. *************************** 17. row ***************************
  52. Variable_name: Com_alter_server
  53. Value: 0
  54. *************************** 18. row ***************************
  55. Variable_name: Com_alter_table
  56. Value: 0
  57. *************************** 19. row ***************************
  58. Variable_name: Com_alter_tablespace
  59. Value: 0
  60. *************************** 20. row ***************************
  61. Variable_name: Com_alter_user
  62. Value: 0
  63. *************************** 21. row ***************************
  64. Variable_name: Com_analyze
  65. Value: 0
  66. *************************** 22. row ***************************
  67. Variable_name: Com_begin
  68. Value: 0
  69. *************************** 23. row ***************************
  70. Variable_name: Com_binlog
  71. Value: 0
  72. *************************** 24. row ***************************
  73. Variable_name: Com_call_procedure
  74. Value: 63
  75. *************************** 25. row ***************************
  76. Variable_name: Com_change_db
  77. Value: 0
  78. *************************** 26. row ***************************
  79. Variable_name: Com_change_master
  80. Value: 0
  81. *************************** 27. row ***************************
  82. Variable_name: Com_change_repl_filter
  83. Value: 0
  84. *************************** 28. row ***************************
  85. Variable_name: Com_check
  86. Value: 0
  87. *************************** 29. row ***************************
  88. Variable_name: Com_checksum
  89. Value: 0
  90. *************************** 30. row ***************************
  91. Variable_name: Com_commit
  92. Value: 84
  93. *************************** 31. row ***************************
  94. Variable_name: Com_create_db
  95. Value: 0
  96. *************************** 32. row ***************************
  97. Variable_name: Com_create_event
  98. Value: 0
  99. *************************** 33. row ***************************
  100. Variable_name: Com_create_function
  101. Value: 0
  102. *************************** 34. row ***************************
  103. Variable_name: Com_create_index
  104. Value: 0
  105. *************************** 35. row ***************************
  106. Variable_name: Com_create_procedure
  107. Value: 0
  108. *************************** 36. row ***************************
  109. Variable_name: Com_create_server
  110. Value: 0
  111. *************************** 37. row ***************************
  112. Variable_name: Com_create_table
  113. Value: 33
  114. *************************** 38. row ***************************
  115. Variable_name: Com_create_trigger
  116. Value: 0
  117. *************************** 39. row ***************************
  118. Variable_name: Com_create_udf
  119. Value: 0
  120. *************************** 40. row ***************************
  121. Variable_name: Com_create_user
  122. Value: 0
  123. *************************** 41. row ***************************
  124. Variable_name: Com_create_view
  125. Value: 0
  126. *************************** 42. row ***************************
  127. Variable_name: Com_dealloc_sql
  128. Value: 0
  129. *************************** 43. row ***************************
  130. Variable_name: Com_delete
  131. Value: 3
  132. *************************** 44. row ***************************
  133. Variable_name: Com_delete_multi
  134. Value: 3
  135. *************************** 45. row ***************************
  136. Variable_name: Com_do
  137. Value: 0
  138. *************************** 46. row ***************************
  139. Variable_name: Com_drop_db
  140. Value: 0
  141. *************************** 47. row ***************************
  142. Variable_name: Com_drop_event
  143. Value: 0
  144. *************************** 48. row ***************************
  145. Variable_name: Com_drop_function
  146. Value: 0
  147. *************************** 49. row ***************************
  148. Variable_name: Com_drop_index
  149. Value: 0
  150. *************************** 50. row ***************************
  151. Variable_name: Com_drop_procedure
  152. Value: 0
  153. *************************** 51. row ***************************
  154. Variable_name: Com_drop_server
  155. Value: 0
  156. *************************** 52. row ***************************
  157. Variable_name: Com_drop_table
  158. Value: 18
  159. *************************** 53. row ***************************
  160. Variable_name: Com_drop_trigger
  161. Value: 0
  162. *************************** 54. row ***************************
  163. Variable_name: Com_drop_user
  164. Value: 0
  165. *************************** 55. row ***************************
  166. Variable_name: Com_drop_view
  167. Value: 0
  168. *************************** 56. row ***************************
  169. Variable_name: Com_empty_query
  170. Value: 0
  171. *************************** 57. row ***************************
  172. Variable_name: Com_execute_sql
  173. Value: 0
  174. *************************** 58. row ***************************
  175. Variable_name: Com_explain_other
  176. Value: 0
  177. *************************** 59. row ***************************
  178. Variable_name: Com_flush
  179. Value: 0
  180. *************************** 60. row ***************************
  181. Variable_name: Com_get_diagnostics
  182. Value: 0
  183. *************************** 61. row ***************************
  184. Variable_name: Com_grant
  185. Value: 0
  186. *************************** 62. row ***************************
  187. Variable_name: Com_ha_close
  188. Value: 0
  189. *************************** 63. row ***************************
  190. Variable_name: Com_ha_open
  191. Value: 0
  192. *************************** 64. row ***************************
  193. Variable_name: Com_ha_read
  194. Value: 0
  195. *************************** 65. row ***************************
  196. Variable_name: Com_help
  197. Value: 0
  198. *************************** 66. row ***************************
  199. Variable_name: Com_insert
  200. Value: 33
  201. *************************** 67. row ***************************
  202. Variable_name: Com_insert_select
  203. Value: 24
  204. *************************** 68. row ***************************
  205. Variable_name: Com_install_plugin
  206. Value: 0
  207. *************************** 69. row ***************************
  208. Variable_name: Com_kill
  209. Value: 0
  210. *************************** 70. row ***************************
  211. Variable_name: Com_load
  212. Value: 0
  213. *************************** 71. row ***************************
  214. Variable_name: Com_lock_tables
  215. Value: 0
  216. *************************** 72. row ***************************
  217. Variable_name: Com_optimize
  218. Value: 0
  219. *************************** 73. row ***************************
  220. Variable_name: Com_preload_keys
  221. Value: 0
  222. *************************** 74. row ***************************
  223. Variable_name: Com_prepare_sql
  224. Value: 0
  225. *************************** 75. row ***************************
  226. Variable_name: Com_purge
  227. Value: 0
  228. *************************** 76. row ***************************
  229. Variable_name: Com_purge_before_date
  230. Value: 0
  231. *************************** 77. row ***************************
  232. Variable_name: Com_release_savepoint
  233. Value: 0
  234. *************************** 78. row ***************************
  235. Variable_name: Com_rename_table
  236. Value: 0
  237. *************************** 79. row ***************************
  238. Variable_name: Com_rename_user
  239. Value: 0
  240. *************************** 80. row ***************************
  241. Variable_name: Com_repair
  242. Value: 0
  243. *************************** 81. row ***************************
  244. Variable_name: Com_replace
  245. Value: 0
  246. *************************** 82. row ***************************
  247. Variable_name: Com_replace_select
  248. Value: 0
  249. *************************** 83. row ***************************
  250. Variable_name: Com_reset
  251. Value: 0
  252. *************************** 84. row ***************************
  253. Variable_name: Com_resignal
  254. Value: 0
  255. *************************** 85. row ***************************
  256. Variable_name: Com_revoke
  257. Value: 0
  258. *************************** 86. row ***************************
  259. Variable_name: Com_revoke_all
  260. Value: 0
  261. *************************** 87. row ***************************
  262. Variable_name: Com_rollback
  263. Value: 0
  264. *************************** 88. row ***************************
  265. Variable_name: Com_rollback_to_savepoint
  266. Value: 0
  267. *************************** 89. row ***************************
  268. Variable_name: Com_savepoint
  269. Value: 0
  270. *************************** 90. row ***************************
  271. Variable_name: Com_select
  272. Value: 111
  273. *************************** 91. row ***************************
  274. Variable_name: Com_set_option
  275. Value: 177
  276. *************************** 92. row ***************************
  277. Variable_name: Com_signal
  278. Value: 0
  279. *************************** 93. row ***************************
  280. Variable_name: Com_show_binlog_events
  281. Value: 0
  282. *************************** 94. row ***************************
  283. Variable_name: Com_show_binlogs
  284. Value: 0
  285. *************************** 95. row ***************************
  286. Variable_name: Com_show_charsets
  287. Value: 0
  288. *************************** 96. row ***************************
  289. Variable_name: Com_show_collations
  290. Value: 0
  291. *************************** 97. row ***************************
  292. Variable_name: Com_show_create_db
  293. Value: 0
  294. *************************** 98. row ***************************
  295. Variable_name: Com_show_create_event
  296. Value: 0
  297. *************************** 99. row ***************************
  298. Variable_name: Com_show_create_func
  299. Value: 0
  300. *************************** 100. row ***************************
  301. Variable_name: Com_show_create_proc
  302. Value: 0
  303. *************************** 101. row ***************************
  304. Variable_name: Com_show_create_table
  305. Value: 0
  306. *************************** 102. row ***************************
  307. Variable_name: Com_show_create_trigger
  308. Value: 0
  309. *************************** 103. row ***************************
  310. Variable_name: Com_show_databases
  311. Value: 2
  312. *************************** 104. row ***************************
  313. Variable_name: Com_show_engine_logs
  314. Value: 0
  315. *************************** 105. row ***************************
  316. Variable_name: Com_show_engine_mutex
  317. Value: 0
  318. *************************** 106. row ***************************
  319. Variable_name: Com_show_engine_status
  320. Value: 6
  321. *************************** 107. row ***************************
  322. Variable_name: Com_show_events
  323. Value: 0
  324. *************************** 108. row ***************************
  325. Variable_name: Com_show_errors
  326. Value: 0
  327. *************************** 109. row ***************************
  328. Variable_name: Com_show_fields
  329. Value: 0
  330. *************************** 110. row ***************************
  331. Variable_name: Com_show_function_code
  332. Value: 0
  333. *************************** 111. row ***************************
  334. Variable_name: Com_show_function_status
  335. Value: 0
  336. *************************** 112. row ***************************
  337. Variable_name: Com_show_grants
  338. Value: 0
  339. *************************** 113. row ***************************
  340. Variable_name: Com_show_keys
  341. Value: 0
  342. *************************** 114. row ***************************
  343. Variable_name: Com_show_master_status
  344. Value: 0
  345. *************************** 115. row ***************************
  346. Variable_name: Com_show_open_tables
  347. Value: 0
  348. *************************** 116. row ***************************
  349. Variable_name: Com_show_plugins
  350. Value: 0
  351. *************************** 117. row ***************************
  352. Variable_name: Com_show_privileges
  353. Value: 0
  354. *************************** 118. row ***************************
  355. Variable_name: Com_show_procedure_code
  356. Value: 0
  357. *************************** 119. row ***************************
  358. Variable_name: Com_show_procedure_status
  359. Value: 0
  360. *************************** 120. row ***************************
  361. Variable_name: Com_show_processlist
  362. Value: 1
  363. *************************** 121. row ***************************
  364. Variable_name: Com_show_profile
  365. Value: 0
  366. *************************** 122. row ***************************
  367. Variable_name: Com_show_profiles
  368. Value: 0
  369. *************************** 123. row ***************************
  370. Variable_name: Com_show_relaylog_events
  371. Value: 0
  372. *************************** 124. row ***************************
  373. Variable_name: Com_show_slave_hosts
  374. Value: 1
  375. *************************** 125. row ***************************
  376. Variable_name: Com_show_slave_status
  377. Value: 1
  378. *************************** 126. row ***************************
  379. Variable_name: Com_show_status
  380. Value: 5
  381. *************************** 127. row ***************************
  382. Variable_name: Com_show_storage_engines
  383. Value: 1
  384. *************************** 128. row ***************************
  385. Variable_name: Com_show_table_status
  386. Value: 23
  387. *************************** 129. row ***************************
  388. Variable_name: Com_show_tables
  389. Value: 0
  390. *************************** 130. row ***************************
  391. Variable_name: Com_show_triggers
  392. Value: 0
  393. *************************** 131. row ***************************
  394. Variable_name: Com_show_variables
  395. Value: 2
  396. *************************** 132. row ***************************
  397. Variable_name: Com_show_warnings
  398. Value: 0
  399. *************************** 133. row ***************************
  400. Variable_name: Com_show_create_user
  401. Value: 0
  402. *************************** 134. row ***************************
  403. Variable_name: Com_shutdown
  404. Value: 0
  405. *************************** 135. row ***************************
  406. Variable_name: Com_slave_start
  407. Value: 0
  408. *************************** 136. row ***************************
  409. Variable_name: Com_slave_stop
  410. Value: 0
  411. *************************** 137. row ***************************
  412. Variable_name: Com_group_replication_start
  413. Value: 0
  414. *************************** 138. row ***************************
  415. Variable_name: Com_group_replication_stop
  416. Value: 0
  417. *************************** 139. row ***************************
  418. Variable_name: Com_stmt_execute
  419. Value: 0
  420. *************************** 140. row ***************************
  421. Variable_name: Com_stmt_close
  422. Value: 0
  423. *************************** 141. row ***************************
  424. Variable_name: Com_stmt_fetch
  425. Value: 0
  426. *************************** 142. row ***************************
  427. Variable_name: Com_stmt_prepare
  428. Value: 0
  429. *************************** 143. row ***************************
  430. Variable_name: Com_stmt_reset
  431. Value: 0
  432. *************************** 144. row ***************************
  433. Variable_name: Com_stmt_send_long_data
  434. Value: 0
  435. *************************** 145. row ***************************
  436. Variable_name: Com_truncate
  437. Value: 6
  438. *************************** 146. row ***************************
  439. Variable_name: Com_uninstall_plugin
  440. Value: 0
  441. *************************** 147. row ***************************
  442. Variable_name: Com_unlock_tables
  443. Value: 0
  444. *************************** 148. row ***************************
  445. Variable_name: Com_update
  446. Value: 24
  447. *************************** 149. row ***************************
  448. Variable_name: Com_update_multi
  449. Value: 9
  450. *************************** 150. row ***************************
  451. Variable_name: Com_xa_commit
  452. Value: 0
  453. *************************** 151. row ***************************
  454. Variable_name: Com_xa_end
  455. Value: 0
  456. *************************** 152. row ***************************
  457. Variable_name: Com_xa_prepare
  458. Value: 0
  459. *************************** 153. row ***************************
  460. Variable_name: Com_xa_recover
  461. Value: 0
  462. *************************** 154. row ***************************
  463. Variable_name: Com_xa_rollback
  464. Value: 0
  465. *************************** 155. row ***************************
  466. Variable_name: Com_xa_start
  467. Value: 0
  468. *************************** 156. row ***************************
  469. Variable_name: Com_stmt_reprepare
  470. Value: 0
  471. *************************** 157. row ***************************
  472. Variable_name: Connection_errors_accept
  473. Value: 0
  474. *************************** 158. row ***************************
  475. Variable_name: Connection_errors_internal
  476. Value: 0
  477. *************************** 159. row ***************************
  478. Variable_name: Connection_errors_max_connections
  479. Value: 0
  480. *************************** 160. row ***************************
  481. Variable_name: Connection_errors_peer_address
  482. Value: 0
  483. *************************** 161. row ***************************
  484. Variable_name: Connection_errors_select
  485. Value: 0
  486. *************************** 162. row ***************************
  487. Variable_name: Connection_errors_tcpwrap
  488. Value: 0
  489. *************************** 163. row ***************************
  490. Variable_name: Connections
  491. Value: 71
  492. *************************** 164. row ***************************
  493. Variable_name: Created_tmp_disk_tables
  494. Value: 104
  495. *************************** 165. row ***************************
  496. Variable_name: Created_tmp_files
  497. Value: 36
  498. *************************** 166. row ***************************
  499. Variable_name: Created_tmp_tables
  500. Value: 4238
  501. *************************** 167. row ***************************
  502. Variable_name: Delayed_errors
  503. Value: 0
  504. *************************** 168. row ***************************
  505. Variable_name: Delayed_insert_threads
  506. Value: 0
  507. *************************** 169. row ***************************
  508. Variable_name: Delayed_writes
  509. Value: 0
  510. *************************** 170. row ***************************
  511. Variable_name: Flush_commands
  512. Value: 1
  513. *************************** 171. row ***************************
  514. Variable_name: Handler_commit
  515. Value: 212
  516. *************************** 172. row ***************************
  517. Variable_name: Handler_delete
  518. Value: 819021
  519. *************************** 173. row ***************************
  520. Variable_name: Handler_discover
  521. Value: 0
  522. *************************** 174. row ***************************
  523. Variable_name: Handler_external_lock
  524. Value: 1777
  525. *************************** 175. row ***************************
  526. Variable_name: Handler_mrr_init
  527. Value: 0
  528. *************************** 176. row ***************************
  529. Variable_name: Handler_prepare
  530. Value: 0
  531. *************************** 177. row ***************************
  532. Variable_name: Handler_read_first
  533. Value: 1181139
  534. *************************** 178. row ***************************
  535. Variable_name: Handler_read_key
  536. Value: 132304115
  537. *************************** 179. row ***************************
  538. Variable_name: Handler_read_last
  539. Value: 3
  540. *************************** 180. row ***************************
  541. Variable_name: Handler_read_next
  542. Value: 53331011
  543. *************************** 181. row ***************************
  544. Variable_name: Handler_read_prev
  545. Value: 0
  546. *************************** 182. row ***************************
  547. Variable_name: Handler_read_rnd
  548. Value: 1898227
  549. *************************** 183. row ***************************
  550. Variable_name: Handler_read_rnd_next
  551. Value: 42295257933
  552. *************************** 184. row ***************************
  553. Variable_name: Handler_rollback
  554. Value: 0
  555. *************************** 185. row ***************************
  556. Variable_name: Handler_savepoint
  557. Value: 0
  558. *************************** 186. row ***************************
  559. Variable_name: Handler_savepoint_rollback
  560. Value: 0
  561. *************************** 187. row ***************************
  562. Variable_name: Handler_update
  563. Value: 40596591
  564. *************************** 188. row ***************************
  565. Variable_name: Handler_write
  566. Value: 41159682
  567. *************************** 189. row ***************************
  568. Variable_name: Innodb_buffer_pool_dump_status
  569. Value: Dumping of buffer pool not started
  570. *************************** 190. row ***************************
  571. Variable_name: Innodb_buffer_pool_load_status
  572. Value: Buffer pool(s) load completed at 201225 8:42:10
  573. *************************** 191. row ***************************
  574. Variable_name: Innodb_buffer_pool_resize_status
  575. Value:
  576. *************************** 192. row ***************************
  577. Variable_name: Innodb_buffer_pool_pages_data
  578. Value: 4539522
  579. *************************** 193. row ***************************
  580. Variable_name: Innodb_buffer_pool_bytes_data
  581. Value: 74375528448
  582. *************************** 194. row ***************************
  583. Variable_name: Innodb_buffer_pool_pages_dirty
  584. Value: 0
  585. *************************** 195. row ***************************
  586. Variable_name: Innodb_buffer_pool_bytes_dirty
  587. Value: 0
  588. *************************** 196. row ***************************
  589. Variable_name: Innodb_buffer_pool_pages_flushed
  590. Value: 497667
  591. *************************** 197. row ***************************
  592. Variable_name: Innodb_buffer_pool_pages_free
  593. Value: 1730660
  594. *************************** 198. row ***************************
  595. Variable_name: Innodb_buffer_pool_pages_misc
  596. Value: 20896
  597. *************************** 199. row ***************************
  598. Variable_name: Innodb_buffer_pool_pages_total
  599. Value: 6291078
  600. *************************** 200. row ***************************
  601. Variable_name: Innodb_buffer_pool_read_ahead_rnd
  602. Value: 0
  603. *************************** 201. row ***************************
  604. Variable_name: Innodb_buffer_pool_read_ahead
  605. Value: 2759110
  606. *************************** 202. row ***************************
  607. Variable_name: Innodb_buffer_pool_read_ahead_evicted
  608. Value: 0
  609. *************************** 203. row ***************************
  610. Variable_name: Innodb_buffer_pool_read_requests
  611. Value: 6055193436
  612. *************************** 204. row ***************************
  613. Variable_name: Innodb_buffer_pool_reads
  614. Value: 1561335
  615. *************************** 205. row ***************************
  616. Variable_name: Innodb_buffer_pool_wait_free
  617. Value: 0
  618. *************************** 206. row ***************************
  619. Variable_name: Innodb_buffer_pool_write_requests
  620. Value: 347436043
  621. *************************** 207. row ***************************
  622. Variable_name: Innodb_data_fsyncs
  623. Value: 61131
  624. *************************** 208. row ***************************
  625. Variable_name: Innodb_data_pending_fsyncs
  626. Value: 0
  627. *************************** 209. row ***************************
  628. Variable_name: Innodb_data_pending_reads
  629. Value: 0
  630. *************************** 210. row ***************************
  631. Variable_name: Innodb_data_pending_writes
  632. Value: 0
  633. *************************** 211. row ***************************
  634. Variable_name: Innodb_data_read
  635. Value: 70786322944
  636. *************************** 212. row ***************************
  637. Variable_name: Innodb_data_reads
  638. Value: 4320913
  639. *************************** 213. row ***************************
  640. Variable_name: Innodb_data_writes
  641. Value: 538039
  642. *************************** 214. row ***************************
  643. Variable_name: Innodb_data_written
  644. Value: 23821880320
  645. *************************** 215. row ***************************
  646. Variable_name: Innodb_dblwr_pages_written
  647. Value: 440930
  648. *************************** 216. row ***************************
  649. Variable_name: Innodb_dblwr_writes
  650. Value: 23397
  651. *************************** 217. row ***************************
  652. Variable_name: Innodb_log_waits
  653. Value: 0
  654. *************************** 218. row ***************************
  655. Variable_name: Innodb_log_write_requests
  656. Value: 17105509
  657. *************************** 219. row ***************************
  658. Variable_name: Innodb_log_writes
  659. Value: 8620
  660. *************************** 220. row ***************************
  661. Variable_name: Innodb_os_log_fsyncs
  662. Value: 9132
  663. *************************** 221. row ***************************
  664. Variable_name: Innodb_os_log_pending_fsyncs
  665. Value: 0
  666. *************************** 222. row ***************************
  667. Variable_name: Innodb_os_log_pending_writes
  668. Value: 0
  669. *************************** 223. row ***************************
  670. Variable_name: Innodb_os_log_written
  671. Value: 8443700736
  672. *************************** 224. row ***************************
  673. Variable_name: Innodb_page_size
  674. Value: 16384
  675. *************************** 225. row ***************************
  676. Variable_name: Innodb_pages_created
  677. Value: 438340
  678. *************************** 226. row ***************************
  679. Variable_name: Innodb_pages_read
  680. Value: 4320449
  681. *************************** 227. row ***************************
  682. Variable_name: Innodb_pages_written
  683. Value: 497667
  684. *************************** 228. row ***************************
  685. Variable_name: Innodb_row_lock_current_waits
  686. Value: 0
  687. *************************** 229. row ***************************
  688. Variable_name: Innodb_row_lock_time
  689. Value: 0
  690. *************************** 230. row ***************************
  691. Variable_name: Innodb_row_lock_time_avg
  692. Value: 0
  693. *************************** 231. row ***************************
  694. Variable_name: Innodb_row_lock_time_max
  695. Value: 0
  696. *************************** 232. row ***************************
  697. Variable_name: Innodb_row_lock_waits
  698. Value: 0
  699. *************************** 233. row ***************************
  700. Variable_name: Innodb_rows_deleted
  701. Value: 819021
  702. *************************** 234. row ***************************
  703. Variable_name: Innodb_rows_inserted
  704. Value: 42895457
  705. *************************** 235. row ***************************
  706. Variable_name: Innodb_rows_read
  707. Value: 42422942369
  708. *************************** 236. row ***************************
  709. Variable_name: Innodb_rows_updated
  710. Value: 260826
  711. *************************** 237. row ***************************
  712. Variable_name: Innodb_num_open_files
  713. Value: 455
  714. *************************** 238. row ***************************
  715. Variable_name: Innodb_truncated_status_writes
  716. Value: 0
  717. *************************** 239. row ***************************
  718. Variable_name: Innodb_available_undo_logs
  719. Value: 128
  720. *************************** 240. row ***************************
  721. Variable_name: Key_blocks_not_flushed
  722. Value: 0
  723. *************************** 241. row ***************************
  724. Variable_name: Key_blocks_unused
  725. Value: 13382
  726. *************************** 242. row ***************************
  727. Variable_name: Key_blocks_used
  728. Value: 14
  729. *************************** 243. row ***************************
  730. Variable_name: Key_read_requests
  731. Value: 388
  732. *************************** 244. row ***************************
  733. Variable_name: Key_reads
  734. Value: 17
  735. *************************** 245. row ***************************
  736. Variable_name: Key_write_requests
  737. Value: 0
  738. *************************** 246. row ***************************
  739. Variable_name: Key_writes
  740. Value: 0
  741. *************************** 247. row ***************************
  742. Variable_name: Locked_connects
  743. Value: 0
  744. *************************** 248. row ***************************
  745. Variable_name: Max_execution_time_exceeded
  746. Value: 0
  747. *************************** 249. row ***************************
  748. Variable_name: Max_execution_time_set
  749. Value: 0
  750. *************************** 250. row ***************************
  751. Variable_name: Max_execution_time_set_failed
  752. Value: 0
  753. *************************** 251. row ***************************
  754. Variable_name: Max_used_connections
  755. Value: 1
  756. *************************** 252. row ***************************
  757. Variable_name: Max_used_connections_time
  758. Value: 2020-12-25 08:59:17
  759. *************************** 253. row ***************************
  760. Variable_name: Not_flushed_delayed_rows
  761. Value: 0
  762. *************************** 254. row ***************************
  763. Variable_name: Ongoing_anonymous_transaction_count
  764. Value: 0
  765. *************************** 255. row ***************************
  766. Variable_name: Open_files
  767. Value: 52
  768. *************************** 256. row ***************************
  769. Variable_name: Open_streams
  770. Value: 0
  771. *************************** 257. row ***************************
  772. Variable_name: Open_table_definitions
  773. Value: 895
  774. *************************** 258. row ***************************
  775. Variable_name: Open_tables
  776. Value: 993
  777. *************************** 259. row ***************************
  778. Variable_name: Opened_files
  779. Value: 1498
  780. *************************** 260. row ***************************
  781. Variable_name: Opened_table_definitions
  782. Value: 937
  783. *************************** 261. row ***************************
  784. Variable_name: Opened_tables
  785. Value: 5898
  786. *************************** 262. row ***************************
  787. Variable_name: Performance_schema_accounts_lost
  788. Value: 0
  789. *************************** 263. row ***************************
  790. Variable_name: Performance_schema_cond_classes_lost
  791. Value: 0
  792. *************************** 264. row ***************************
  793. Variable_name: Performance_schema_cond_instances_lost
  794. Value: 0
  795. *************************** 265. row ***************************
  796. Variable_name: Performance_schema_digest_lost
  797. Value: 0
  798. *************************** 266. row ***************************
  799. Variable_name: Performance_schema_file_classes_lost
  800. Value: 0
  801. *************************** 267. row ***************************
  802. Variable_name: Performance_schema_file_handles_lost
  803. Value: 0
  804. *************************** 268. row ***************************
  805. Variable_name: Performance_schema_file_instances_lost
  806. Value: 0
  807. *************************** 269. row ***************************
  808. Variable_name: Performance_schema_hosts_lost
  809. Value: 0
  810. *************************** 270. row ***************************
  811. Variable_name: Performance_schema_index_stat_lost
  812. Value: 0
  813. *************************** 271. row ***************************
  814. Variable_name: Performance_schema_locker_lost
  815. Value: 0
  816. *************************** 272. row ***************************
  817. Variable_name: Performance_schema_memory_classes_lost
  818. Value: 0
  819. *************************** 273. row ***************************
  820. Variable_name: Performance_schema_metadata_lock_lost
  821. Value: 0
  822. *************************** 274. row ***************************
  823. Variable_name: Performance_schema_mutex_classes_lost
  824. Value: 0
  825. *************************** 275. row ***************************
  826. Variable_name: Performance_schema_mutex_instances_lost
  827. Value: 0
  828. *************************** 276. row ***************************
  829. Variable_name: Performance_schema_nested_statement_lost
  830. Value: 0
  831. *************************** 277. row ***************************
  832. Variable_name: Performance_schema_prepared_statements_lost
  833. Value: 0
  834. *************************** 278. row ***************************
  835. Variable_name: Performance_schema_program_lost
  836. Value: 0
  837. *************************** 279. row ***************************
  838. Variable_name: Performance_schema_rwlock_classes_lost
  839. Value: 0
  840. *************************** 280. row ***************************
  841. Variable_name: Performance_schema_rwlock_instances_lost
  842. Value: 0
  843. *************************** 281. row ***************************
  844. Variable_name: Performance_schema_session_connect_attrs_lost
  845. Value: 0
  846. *************************** 282. row ***************************
  847. Variable_name: Performance_schema_socket_classes_lost
  848. Value: 0
  849. *************************** 283. row ***************************
  850. Variable_name: Performance_schema_socket_instances_lost
  851. Value: 0
  852. *************************** 284. row ***************************
  853. Variable_name: Performance_schema_stage_classes_lost
  854. Value: 0
  855. *************************** 285. row ***************************
  856. Variable_name: Performance_schema_statement_classes_lost
  857. Value: 0
  858. *************************** 286. row ***************************
  859. Variable_name: Performance_schema_table_handles_lost
  860. Value: 0
  861. *************************** 287. row ***************************
  862. Variable_name: Performance_schema_table_instances_lost
  863. Value: 0
  864. *************************** 288. row ***************************
  865. Variable_name: Performance_schema_table_lock_stat_lost
  866. Value: 0
  867. *************************** 289. row ***************************
  868. Variable_name: Performance_schema_thread_classes_lost
  869. Value: 0
  870. *************************** 290. row ***************************
  871. Variable_name: Performance_schema_thread_instances_lost
  872. Value: 0
  873. *************************** 291. row ***************************
  874. Variable_name: Performance_schema_users_lost
  875. Value: 0
  876. *************************** 292. row ***************************
  877. Variable_name: Prepared_stmt_count
  878. Value: 0
  879. *************************** 293. row ***************************
  880. Variable_name: Qcache_free_blocks
  881. Value: 0
  882. *************************** 294. row ***************************
  883. Variable_name: Qcache_free_memory
  884. Value: 0
  885. *************************** 295. row ***************************
  886. Variable_name: Qcache_hits
  887. Value: 0
  888. *************************** 296. row ***************************
  889. Variable_name: Qcache_inserts
  890. Value: 0
  891. *************************** 297. row ***************************
  892. Variable_name: Qcache_lowmem_prunes
  893. Value: 0
  894. *************************** 298. row ***************************
  895. Variable_name: Qcache_not_cached
  896. Value: 0
  897. *************************** 299. row ***************************
  898. Variable_name: Qcache_queries_in_cache
  899. Value: 0
  900. *************************** 300. row ***************************
  901. Variable_name: Qcache_total_blocks
  902. Value: 0
  903. *************************** 301. row ***************************
  904. Variable_name: Queries
  905. Value: 1335
  906. *************************** 302. row ***************************
  907. Variable_name: Questions
  908. Value: 174
  909. *************************** 303. row ***************************
  910. Variable_name: Rsa_public_key
  911. Value: -----BEGIN PUBLIC KEY-----
  912. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuREQP9WbZGGHnx/ademb
  913. A59ltTYq2UZT8Sr4JhXMOAOeF7WEkTHblHsdWZfPZJSt3A0JYkAzBuRGWKRTZqjH
  914. m0YbfnM1j7ANakKMrkkrCP6w6KJesndQLCtgFi6hlTsLWrgDdqC7FoYDCm1gxV1R
  915. N5xT6qggEi678W7yRatzL+CY806KP6YVrE+6K3jiWpMwD1l8xm05jOA5DSeqFLNw
  916. v1GybTWz5087eAOILsD7P3no5eYwcjNd/lcvFMBcgftwfm2ew/Bh6hS5aN7w8VGB
  917. l8A4mm9fFYeDbvtl16nj6+Pgtf7e4xTWjj+0BQdnER/UdXAZyhXqregBY1lG83EF
  918. ewIDAQAB
  919. -----END PUBLIC KEY-----
  920.  
  921. *************************** 304. row ***************************
  922. Variable_name: Select_full_join
  923. Value: 324
  924. *************************** 305. row ***************************
  925. Variable_name: Select_full_range_join
  926. Value: 0
  927. *************************** 306. row ***************************
  928. Variable_name: Select_range
  929. Value: 21
  930. *************************** 307. row ***************************
  931. Variable_name: Select_range_check
  932. Value: 0
  933. *************************** 308. row ***************************
  934. Variable_name: Select_scan
  935. Value: 255
  936. *************************** 309. row ***************************
  937. Variable_name: Slave_open_temp_tables
  938. Value: 0
  939. *************************** 310. row ***************************
  940. Variable_name: Slow_launch_threads
  941. Value: 0
  942. *************************** 311. row ***************************
  943. Variable_name: Slow_queries
  944. Value: 0
  945. *************************** 312. row ***************************
  946. Variable_name: Sort_merge_passes
  947. Value: 939
  948. *************************** 313. row ***************************
  949. Variable_name: Sort_range
  950. Value: 0
  951. *************************** 314. row ***************************
  952. Variable_name: Sort_rows
  953. Value: 3465670
  954. *************************** 315. row ***************************
  955. Variable_name: Sort_scan
  956. Value: 122
  957. *************************** 316. row ***************************
  958. Variable_name: Ssl_accept_renegotiates
  959. Value: 0
  960. *************************** 317. row ***************************
  961. Variable_name: Ssl_accepts
  962. Value: 0
  963. *************************** 318. row ***************************
  964. Variable_name: Ssl_callback_cache_hits
  965. Value: 0
  966. *************************** 319. row ***************************
  967. Variable_name: Ssl_cipher
  968. Value:
  969. *************************** 320. row ***************************
  970. Variable_name: Ssl_cipher_list
  971. Value:
  972. *************************** 321. row ***************************
  973. Variable_name: Ssl_client_connects
  974. Value: 0
  975. *************************** 322. row ***************************
  976. Variable_name: Ssl_connect_renegotiates
  977. Value: 0
  978. *************************** 323. row ***************************
  979. Variable_name: Ssl_ctx_verify_depth
  980. Value: 18446744073709551615
  981. *************************** 324. row ***************************
  982. Variable_name: Ssl_ctx_verify_mode
  983. Value: 5
  984. *************************** 325. row ***************************
  985. Variable_name: Ssl_default_timeout
  986. Value: 0
  987. *************************** 326. row ***************************
  988. Variable_name: Ssl_finished_accepts
  989. Value: 0
  990. *************************** 327. row ***************************
  991. Variable_name: Ssl_finished_connects
  992. Value: 0
  993. *************************** 328. row ***************************
  994. Variable_name: Ssl_server_not_after
  995. Value: Dec 22 13:38:30 2030 GMT
  996. *************************** 329. row ***************************
  997. Variable_name: Ssl_server_not_before
  998. Value: Dec 24 13:38:30 2020 GMT
  999. *************************** 330. row ***************************
  1000. Variable_name: Ssl_session_cache_hits
  1001. Value: 0
  1002. *************************** 331. row ***************************
  1003. Variable_name: Ssl_session_cache_misses
  1004. Value: 0
  1005. *************************** 332. row ***************************
  1006. Variable_name: Ssl_session_cache_mode
  1007. Value: SERVER
  1008. *************************** 333. row ***************************
  1009. Variable_name: Ssl_session_cache_overflows
  1010. Value: 0
  1011. *************************** 334. row ***************************
  1012. Variable_name: Ssl_session_cache_size
  1013. Value: 128
  1014. *************************** 335. row ***************************
  1015. Variable_name: Ssl_session_cache_timeouts
  1016. Value: 0
  1017. *************************** 336. row ***************************
  1018. Variable_name: Ssl_sessions_reused
  1019. Value: 0
  1020. *************************** 337. row ***************************
  1021. Variable_name: Ssl_used_session_cache_entries
  1022. Value: 0
  1023. *************************** 338. row ***************************
  1024. Variable_name: Ssl_verify_depth
  1025. Value: 0
  1026. *************************** 339. row ***************************
  1027. Variable_name: Ssl_verify_mode
  1028. Value: 0
  1029. *************************** 340. row ***************************
  1030. Variable_name: Ssl_version
  1031. Value:
  1032. *************************** 341. row ***************************
  1033. Variable_name: Table_locks_immediate
  1034. Value: 210
  1035. *************************** 342. row ***************************
  1036. Variable_name: Table_locks_waited
  1037. Value: 0
  1038. *************************** 343. row ***************************
  1039. Variable_name: Table_open_cache_hits
  1040. Value: 3123
  1041. *************************** 344. row ***************************
  1042. Variable_name: Table_open_cache_misses
  1043. Value: 5898
  1044. *************************** 345. row ***************************
  1045. Variable_name: Table_open_cache_overflows
  1046. Value: 4861
  1047. *************************** 346. row ***************************
  1048. Variable_name: Tc_log_max_pages_used
  1049. Value: 0
  1050. *************************** 347. row ***************************
  1051. Variable_name: Tc_log_page_size
  1052. Value: 0
  1053. *************************** 348. row ***************************
  1054. Variable_name: Tc_log_page_waits
  1055. Value: 0
  1056. *************************** 349. row ***************************
  1057. Variable_name: Threads_cached
  1058. Value: 0
  1059. *************************** 350. row ***************************
  1060. Variable_name: Threads_connected
  1061. Value: 1
  1062. *************************** 351. row ***************************
  1063. Variable_name: Threads_created
  1064. Value: 1
  1065. *************************** 352. row ***************************
  1066. Variable_name: Threads_running
  1067. Value: 2
  1068. *************************** 353. row ***************************
  1069. Variable_name: Uptime
  1070. Value: 263074
  1071. *************************** 354. row ***************************
  1072. Variable_name: Uptime_since_flush_status
  1073. Value: 263074
  1074.  
  1075.  
  1076.  
  1077.  
  1078. =======================================================================================================================
  1079.  
  1080.  
  1081.  
  1082. C) SHOW GLOBAL VARIABLES;
  1083.  
  1084.  
  1085. *************************** 1. row ***************************
  1086. Variable_name: auto_generate_certs
  1087. Value: ON
  1088. *************************** 2. row ***************************
  1089. Variable_name: auto_increment_increment
  1090. Value: 1
  1091. *************************** 3. row ***************************
  1092. Variable_name: auto_increment_offset
  1093. Value: 1
  1094. *************************** 4. row ***************************
  1095. Variable_name: autocommit
  1096. Value: ON
  1097. *************************** 5. row ***************************
  1098. Variable_name: automatic_sp_privileges
  1099. Value: ON
  1100. *************************** 6. row ***************************
  1101. Variable_name: avoid_temporal_upgrade
  1102. Value: OFF
  1103. *************************** 7. row ***************************
  1104. Variable_name: back_log
  1105. Value: 65535
  1106. *************************** 8. row ***************************
  1107. Variable_name: basedir
  1108. Value: /usr/
  1109. *************************** 9. row ***************************
  1110. Variable_name: big_tables
  1111. Value: OFF
  1112. *************************** 10. row ***************************
  1113. Variable_name: bind_address
  1114. Value: 127.0.0.1
  1115. *************************** 11. row ***************************
  1116. Variable_name: binlog_cache_size
  1117. Value: 32768
  1118. *************************** 12. row ***************************
  1119. Variable_name: binlog_checksum
  1120. Value: CRC32
  1121. *************************** 13. row ***************************
  1122. Variable_name: binlog_direct_non_transactional_updates
  1123. Value: OFF
  1124. *************************** 14. row ***************************
  1125. Variable_name: binlog_error_action
  1126. Value: ABORT_SERVER
  1127. *************************** 15. row ***************************
  1128. Variable_name: binlog_format
  1129. Value: ROW
  1130. *************************** 16. row ***************************
  1131. Variable_name: binlog_group_commit_sync_delay
  1132. Value: 0
  1133. *************************** 17. row ***************************
  1134. Variable_name: binlog_group_commit_sync_no_delay_count
  1135. Value: 0
  1136. *************************** 18. row ***************************
  1137. Variable_name: binlog_gtid_simple_recovery
  1138. Value: ON
  1139. *************************** 19. row ***************************
  1140. Variable_name: binlog_max_flush_queue_time
  1141. Value: 0
  1142. *************************** 20. row ***************************
  1143. Variable_name: binlog_order_commits
  1144. Value: ON
  1145. *************************** 21. row ***************************
  1146. Variable_name: binlog_row_image
  1147. Value: FULL
  1148. *************************** 22. row ***************************
  1149. Variable_name: binlog_rows_query_log_events
  1150. Value: OFF
  1151. *************************** 23. row ***************************
  1152. Variable_name: binlog_stmt_cache_size
  1153. Value: 32768
  1154. *************************** 24. row ***************************
  1155. Variable_name: binlog_transaction_dependency_history_size
  1156. Value: 25000
  1157. *************************** 25. row ***************************
  1158. Variable_name: binlog_transaction_dependency_tracking
  1159. Value: COMMIT_ORDER
  1160. *************************** 26. row ***************************
  1161. Variable_name: block_encryption_mode
  1162. Value: aes-128-ecb
  1163. *************************** 27. row ***************************
  1164. Variable_name: bulk_insert_buffer_size
  1165. Value: 8388608
  1166. *************************** 28. row ***************************
  1167. Variable_name: character_set_client
  1168. Value: latin1
  1169. *************************** 29. row ***************************
  1170. Variable_name: character_set_connection
  1171. Value: latin1
  1172. *************************** 30. row ***************************
  1173. Variable_name: character_set_database
  1174. Value: latin1
  1175. *************************** 31. row ***************************
  1176. Variable_name: character_set_filesystem
  1177. Value: binary
  1178. *************************** 32. row ***************************
  1179. Variable_name: character_set_results
  1180. Value: latin1
  1181. *************************** 33. row ***************************
  1182. Variable_name: character_set_server
  1183. Value: latin1
  1184. *************************** 34. row ***************************
  1185. Variable_name: character_set_system
  1186. Value: utf8
  1187. *************************** 35. row ***************************
  1188. Variable_name: character_sets_dir
  1189. Value: /usr/share/mysql/charsets/
  1190. *************************** 36. row ***************************
  1191. Variable_name: check_proxy_users
  1192. Value: OFF
  1193. *************************** 37. row ***************************
  1194. Variable_name: collation_connection
  1195. Value: latin1_swedish_ci
  1196. *************************** 38. row ***************************
  1197. Variable_name: collation_database
  1198. Value: latin1_swedish_ci
  1199. *************************** 39. row ***************************
  1200. Variable_name: collation_server
  1201. Value: latin1_swedish_ci
  1202. *************************** 40. row ***************************
  1203. Variable_name: completion_type
  1204. Value: NO_CHAIN
  1205. *************************** 41. row ***************************
  1206. Variable_name: concurrent_insert
  1207. Value: AUTO
  1208. *************************** 42. row ***************************
  1209. Variable_name: connect_timeout
  1210. Value: 31536000
  1211. *************************** 43. row ***************************
  1212. Variable_name: core_file
  1213. Value: OFF
  1214. *************************** 44. row ***************************
  1215. Variable_name: datadir
  1216. Value: /var/lib/mysql/
  1217. *************************** 45. row ***************************
  1218. Variable_name: date_format
  1219. Value: %Y-%m-%d
  1220. *************************** 46. row ***************************
  1221. Variable_name: datetime_format
  1222. Value: %Y-%m-%d %H:%i:%s
  1223. *************************** 47. row ***************************
  1224. Variable_name: default_authentication_plugin
  1225. Value: mysql_native_password
  1226. *************************** 48. row ***************************
  1227. Variable_name: default_password_lifetime
  1228. Value: 0
  1229. *************************** 49. row ***************************
  1230. Variable_name: default_storage_engine
  1231. Value: InnoDB
  1232. *************************** 50. row ***************************
  1233. Variable_name: default_tmp_storage_engine
  1234. Value: InnoDB
  1235. *************************** 51. row ***************************
  1236. Variable_name: default_week_format
  1237. Value: 0
  1238. *************************** 52. row ***************************
  1239. Variable_name: delay_key_write
  1240. Value: ON
  1241. *************************** 53. row ***************************
  1242. Variable_name: delayed_insert_limit
  1243. Value: 100
  1244. *************************** 54. row ***************************
  1245. Variable_name: delayed_insert_timeout
  1246. Value: 300
  1247. *************************** 55. row ***************************
  1248. Variable_name: delayed_queue_size
  1249. Value: 1000
  1250. *************************** 56. row ***************************
  1251. Variable_name: disabled_storage_engines
  1252. Value:
  1253. *************************** 57. row ***************************
  1254. Variable_name: disconnect_on_expired_password
  1255. Value: ON
  1256. *************************** 58. row ***************************
  1257. Variable_name: div_precision_increment
  1258. Value: 4
  1259. *************************** 59. row ***************************
  1260. Variable_name: end_markers_in_json
  1261. Value: OFF
  1262. *************************** 60. row ***************************
  1263. Variable_name: enforce_gtid_consistency
  1264. Value: OFF
  1265. *************************** 61. row ***************************
  1266. Variable_name: eq_range_index_dive_limit
  1267. Value: 200
  1268. *************************** 62. row ***************************
  1269. Variable_name: event_scheduler
  1270. Value: ON
  1271. *************************** 63. row ***************************
  1272. Variable_name: expire_logs_days
  1273. Value: 0
  1274. *************************** 64. row ***************************
  1275. Variable_name: explicit_defaults_for_timestamp
  1276. Value: OFF
  1277. *************************** 65. row ***************************
  1278. Variable_name: flush
  1279. Value: OFF
  1280. *************************** 66. row ***************************
  1281. Variable_name: flush_time
  1282. Value: 0
  1283. *************************** 67. row ***************************
  1284. Variable_name: foreign_key_checks
  1285. Value: ON
  1286. *************************** 68. row ***************************
  1287. Variable_name: ft_boolean_syntax
  1288. Value: + -><()~*:""&|
  1289. *************************** 69. row ***************************
  1290. Variable_name: ft_max_word_len
  1291. Value: 84
  1292. *************************** 70. row ***************************
  1293. Variable_name: ft_min_word_len
  1294. Value: 4
  1295. *************************** 71. row ***************************
  1296. Variable_name: ft_query_expansion_limit
  1297. Value: 20
  1298. *************************** 72. row ***************************
  1299. Variable_name: ft_stopword_file
  1300. Value: (built-in)
  1301. *************************** 73. row ***************************
  1302. Variable_name: general_log
  1303. Value: OFF
  1304. *************************** 74. row ***************************
  1305. Variable_name: general_log_file
  1306. Value: /var/lib/mysql/wolf1.log
  1307. *************************** 75. row ***************************
  1308. Variable_name: group_concat_max_len
  1309. Value: 1024
  1310. *************************** 76. row ***************************
  1311. Variable_name: gtid_executed
  1312. Value:
  1313. *************************** 77. row ***************************
  1314. Variable_name: gtid_executed_compression_period
  1315. Value: 1000
  1316. *************************** 78. row ***************************
  1317. Variable_name: gtid_mode
  1318. Value: OFF
  1319. *************************** 79. row ***************************
  1320. Variable_name: gtid_owned
  1321. Value:
  1322. *************************** 80. row ***************************
  1323. Variable_name: gtid_purged
  1324. Value:
  1325. *************************** 81. row ***************************
  1326. Variable_name: have_compress
  1327. Value: YES
  1328. *************************** 82. row ***************************
  1329. Variable_name: have_crypt
  1330. Value: YES
  1331. *************************** 83. row ***************************
  1332. Variable_name: have_dynamic_loading
  1333. Value: YES
  1334. *************************** 84. row ***************************
  1335. Variable_name: have_geometry
  1336. Value: YES
  1337. *************************** 85. row ***************************
  1338. Variable_name: have_openssl
  1339. Value: YES
  1340. *************************** 86. row ***************************
  1341. Variable_name: have_profiling
  1342. Value: YES
  1343. *************************** 87. row ***************************
  1344. Variable_name: have_query_cache
  1345. Value: YES
  1346. *************************** 88. row ***************************
  1347. Variable_name: have_rtree_keys
  1348. Value: YES
  1349. *************************** 89. row ***************************
  1350. Variable_name: have_ssl
  1351. Value: YES
  1352. *************************** 90. row ***************************
  1353. Variable_name: have_statement_timeout
  1354. Value: YES
  1355. *************************** 91. row ***************************
  1356. Variable_name: have_symlink
  1357. Value: DISABLED
  1358. *************************** 92. row ***************************
  1359. Variable_name: host_cache_size
  1360. Value: 278
  1361. *************************** 93. row ***************************
  1362. Variable_name: hostname
  1363. Value: wolf1
  1364. *************************** 94. row ***************************
  1365. Variable_name: ignore_builtin_innodb
  1366. Value: OFF
  1367. *************************** 95. row ***************************
  1368. Variable_name: ignore_db_dirs
  1369. Value:
  1370. *************************** 96. row ***************************
  1371. Variable_name: init_connect
  1372. Value:
  1373. *************************** 97. row ***************************
  1374. Variable_name: init_file
  1375. Value:
  1376. *************************** 98. row ***************************
  1377. Variable_name: init_slave
  1378. Value:
  1379. *************************** 99. row ***************************
  1380. Variable_name: innodb_adaptive_flushing
  1381. Value: ON
  1382. *************************** 100. row ***************************
  1383. Variable_name: innodb_adaptive_flushing_lwm
  1384. Value: 10
  1385. *************************** 101. row ***************************
  1386. Variable_name: innodb_adaptive_hash_index
  1387. Value: ON
  1388. *************************** 102. row ***************************
  1389. Variable_name: innodb_adaptive_hash_index_parts
  1390. Value: 8
  1391. *************************** 103. row ***************************
  1392. Variable_name: innodb_adaptive_max_sleep_delay
  1393. Value: 150000
  1394. *************************** 104. row ***************************
  1395. Variable_name: innodb_api_bk_commit_interval
  1396. Value: 5
  1397. *************************** 105. row ***************************
  1398. Variable_name: innodb_api_disable_rowlock
  1399. Value: OFF
  1400. *************************** 106. row ***************************
  1401. Variable_name: innodb_api_enable_binlog
  1402. Value: OFF
  1403. *************************** 107. row ***************************
  1404. Variable_name: innodb_api_enable_mdl
  1405. Value: OFF
  1406. *************************** 108. row ***************************
  1407. Variable_name: innodb_api_trx_level
  1408. Value: 0
  1409. *************************** 109. row ***************************
  1410. Variable_name: innodb_autoextend_increment
  1411. Value: 64
  1412. *************************** 110. row ***************************
  1413. Variable_name: innodb_autoinc_lock_mode
  1414. Value: 1
  1415. *************************** 111. row ***************************
  1416. Variable_name: innodb_buffer_pool_chunk_size
  1417. Value: 268435456
  1418. *************************** 112. row ***************************
  1419. Variable_name: innodb_buffer_pool_dump_at_shutdown
  1420. Value: ON
  1421. *************************** 113. row ***************************
  1422. Variable_name: innodb_buffer_pool_dump_now
  1423. Value: OFF
  1424. *************************** 114. row ***************************
  1425. Variable_name: innodb_buffer_pool_dump_pct
  1426. Value: 25
  1427. *************************** 115. row ***************************
  1428. Variable_name: innodb_buffer_pool_filename
  1429. Value: ib_buffer_pool
  1430. *************************** 116. row ***************************
  1431. Variable_name: innodb_buffer_pool_instances
  1432. Value: 64
  1433. *************************** 117. row ***************************
  1434. Variable_name: innodb_buffer_pool_load_abort
  1435. Value: OFF
  1436. *************************** 118. row ***************************
  1437. Variable_name: innodb_buffer_pool_load_at_startup
  1438. Value: ON
  1439. *************************** 119. row ***************************
  1440. Variable_name: innodb_buffer_pool_load_now
  1441. Value: OFF
  1442. *************************** 120. row ***************************
  1443. Variable_name: innodb_buffer_pool_size
  1444. Value: 103079215104
  1445. *************************** 121. row ***************************
  1446. Variable_name: innodb_change_buffer_max_size
  1447. Value: 25
  1448. *************************** 122. row ***************************
  1449. Variable_name: innodb_change_buffering
  1450. Value: all
  1451. *************************** 123. row ***************************
  1452. Variable_name: innodb_checksum_algorithm
  1453. Value: crc32
  1454. *************************** 124. row ***************************
  1455. Variable_name: innodb_checksums
  1456. Value: ON
  1457. *************************** 125. row ***************************
  1458. Variable_name: innodb_cmp_per_index_enabled
  1459. Value: OFF
  1460. *************************** 126. row ***************************
  1461. Variable_name: innodb_commit_concurrency
  1462. Value: 0
  1463. *************************** 127. row ***************************
  1464. Variable_name: innodb_compression_failure_threshold_pct
  1465. Value: 5
  1466. *************************** 128. row ***************************
  1467. Variable_name: innodb_compression_level
  1468. Value: 6
  1469. *************************** 129. row ***************************
  1470. Variable_name: innodb_compression_pad_pct_max
  1471. Value: 50
  1472. *************************** 130. row ***************************
  1473. Variable_name: innodb_concurrency_tickets
  1474. Value: 5000
  1475. *************************** 131. row ***************************
  1476. Variable_name: innodb_data_file_path
  1477. Value: ibdata1:12M:autoextend
  1478. *************************** 132. row ***************************
  1479. Variable_name: innodb_data_home_dir
  1480. Value:
  1481. *************************** 133. row ***************************
  1482. Variable_name: innodb_deadlock_detect
  1483. Value: ON
  1484. *************************** 134. row ***************************
  1485. Variable_name: innodb_default_row_format
  1486. Value: dynamic
  1487. *************************** 135. row ***************************
  1488. Variable_name: innodb_disable_sort_file_cache
  1489. Value: OFF
  1490. *************************** 136. row ***************************
  1491. Variable_name: innodb_doublewrite
  1492. Value: ON
  1493. *************************** 137. row ***************************
  1494. Variable_name: innodb_fast_shutdown
  1495. Value: 1
  1496. *************************** 138. row ***************************
  1497. Variable_name: innodb_file_format
  1498. Value: Barracuda
  1499. *************************** 139. row ***************************
  1500. Variable_name: innodb_file_format_check
  1501. Value: ON
  1502. *************************** 140. row ***************************
  1503. Variable_name: innodb_file_format_max
  1504. Value: Barracuda
  1505. *************************** 141. row ***************************
  1506. Variable_name: innodb_file_per_table
  1507. Value: ON
  1508. *************************** 142. row ***************************
  1509. Variable_name: innodb_fill_factor
  1510. Value: 100
  1511. *************************** 143. row ***************************
  1512. Variable_name: innodb_flush_log_at_timeout
  1513. Value: 1
  1514. *************************** 144. row ***************************
  1515. Variable_name: innodb_flush_log_at_trx_commit
  1516. Value: 0
  1517. *************************** 145. row ***************************
  1518. Variable_name: innodb_flush_method
  1519. Value:
  1520. *************************** 146. row ***************************
  1521. Variable_name: innodb_flush_neighbors
  1522. Value: 1
  1523. *************************** 147. row ***************************
  1524. Variable_name: innodb_flush_sync
  1525. Value: ON
  1526. *************************** 148. row ***************************
  1527. Variable_name: innodb_flushing_avg_loops
  1528. Value: 30
  1529. *************************** 149. row ***************************
  1530. Variable_name: innodb_force_load_corrupted
  1531. Value: OFF
  1532. *************************** 150. row ***************************
  1533. Variable_name: innodb_force_recovery
  1534. Value: 0
  1535. *************************** 151. row ***************************
  1536. Variable_name: innodb_ft_aux_table
  1537. Value:
  1538. *************************** 152. row ***************************
  1539. Variable_name: innodb_ft_cache_size
  1540. Value: 8000000
  1541. *************************** 153. row ***************************
  1542. Variable_name: innodb_ft_enable_diag_print
  1543. Value: OFF
  1544. *************************** 154. row ***************************
  1545. Variable_name: innodb_ft_enable_stopword
  1546. Value: ON
  1547. *************************** 155. row ***************************
  1548. Variable_name: innodb_ft_max_token_size
  1549. Value: 84
  1550. *************************** 156. row ***************************
  1551. Variable_name: innodb_ft_min_token_size
  1552. Value: 3
  1553. *************************** 157. row ***************************
  1554. Variable_name: innodb_ft_num_word_optimize
  1555. Value: 2000
  1556. *************************** 158. row ***************************
  1557. Variable_name: innodb_ft_result_cache_limit
  1558. Value: 2000000000
  1559. *************************** 159. row ***************************
  1560. Variable_name: innodb_ft_server_stopword_table
  1561. Value:
  1562. *************************** 160. row ***************************
  1563. Variable_name: innodb_ft_sort_pll_degree
  1564. Value: 2
  1565. *************************** 161. row ***************************
  1566. Variable_name: innodb_ft_total_cache_size
  1567. Value: 640000000
  1568. *************************** 162. row ***************************
  1569. Variable_name: innodb_ft_user_stopword_table
  1570. Value:
  1571. *************************** 163. row ***************************
  1572. Variable_name: innodb_io_capacity
  1573. Value: 2500
  1574. *************************** 164. row ***************************
  1575. Variable_name: innodb_io_capacity_max
  1576. Value: 5000
  1577. *************************** 165. row ***************************
  1578. Variable_name: innodb_large_prefix
  1579. Value: ON
  1580. *************************** 166. row ***************************
  1581. Variable_name: innodb_lock_wait_timeout
  1582. Value: 50
  1583. *************************** 167. row ***************************
  1584. Variable_name: innodb_locks_unsafe_for_binlog
  1585. Value: OFF
  1586. *************************** 168. row ***************************
  1587. Variable_name: innodb_log_buffer_size
  1588. Value: 33554432
  1589. *************************** 169. row ***************************
  1590. Variable_name: innodb_log_checksums
  1591. Value: ON
  1592. *************************** 170. row ***************************
  1593. Variable_name: innodb_log_compressed_pages
  1594. Value: ON
  1595. *************************** 171. row ***************************
  1596. Variable_name: innodb_log_file_size
  1597. Value: 13958643712
  1598. *************************** 172. row ***************************
  1599. Variable_name: innodb_log_files_in_group
  1600. Value: 2
  1601. *************************** 173. row ***************************
  1602. Variable_name: innodb_log_group_home_dir
  1603. Value: ./
  1604. *************************** 174. row ***************************
  1605. Variable_name: innodb_log_write_ahead_size
  1606. Value: 8192
  1607. *************************** 175. row ***************************
  1608. Variable_name: innodb_lru_scan_depth
  1609. Value: 1024
  1610. *************************** 176. row ***************************
  1611. Variable_name: innodb_max_dirty_pages_pct
  1612. Value: 75.000000
  1613. *************************** 177. row ***************************
  1614. Variable_name: innodb_max_dirty_pages_pct_lwm
  1615. Value: 0.000000
  1616. *************************** 178. row ***************************
  1617. Variable_name: innodb_max_purge_lag
  1618. Value: 0
  1619. *************************** 179. row ***************************
  1620. Variable_name: innodb_max_purge_lag_delay
  1621. Value: 0
  1622. *************************** 180. row ***************************
  1623. Variable_name: innodb_max_undo_log_size
  1624. Value: 1073741824
  1625. *************************** 181. row ***************************
  1626. Variable_name: innodb_monitor_disable
  1627. Value:
  1628. *************************** 182. row ***************************
  1629. Variable_name: innodb_monitor_enable
  1630. Value:
  1631. *************************** 183. row ***************************
  1632. Variable_name: innodb_monitor_reset
  1633. Value:
  1634. *************************** 184. row ***************************
  1635. Variable_name: innodb_monitor_reset_all
  1636. Value:
  1637. *************************** 185. row ***************************
  1638. Variable_name: innodb_numa_interleave
  1639. Value: OFF
  1640. *************************** 186. row ***************************
  1641. Variable_name: innodb_old_blocks_pct
  1642. Value: 37
  1643. *************************** 187. row ***************************
  1644. Variable_name: innodb_old_blocks_time
  1645. Value: 1000
  1646. *************************** 188. row ***************************
  1647. Variable_name: innodb_online_alter_log_max_size
  1648. Value: 134217728
  1649. *************************** 189. row ***************************
  1650. Variable_name: innodb_open_files
  1651. Value: 2420
  1652. *************************** 190. row ***************************
  1653. Variable_name: innodb_optimize_fulltext_only
  1654. Value: OFF
  1655. *************************** 191. row ***************************
  1656. Variable_name: innodb_page_cleaners
  1657. Value: 4
  1658. *************************** 192. row ***************************
  1659. Variable_name: innodb_page_size
  1660. Value: 16384
  1661. *************************** 193. row ***************************
  1662. Variable_name: innodb_print_all_deadlocks
  1663. Value: OFF
  1664. *************************** 194. row ***************************
  1665. Variable_name: innodb_purge_batch_size
  1666. Value: 300
  1667. *************************** 195. row ***************************
  1668. Variable_name: innodb_purge_rseg_truncate_frequency
  1669. Value: 128
  1670. *************************** 196. row ***************************
  1671. Variable_name: innodb_purge_threads
  1672. Value: 4
  1673. *************************** 197. row ***************************
  1674. Variable_name: innodb_random_read_ahead
  1675. Value: OFF
  1676. *************************** 198. row ***************************
  1677. Variable_name: innodb_read_ahead_threshold
  1678. Value: 56
  1679. *************************** 199. row ***************************
  1680. Variable_name: innodb_read_io_threads
  1681. Value: 64
  1682. *************************** 200. row ***************************
  1683. Variable_name: innodb_read_only
  1684. Value: OFF
  1685. *************************** 201. row ***************************
  1686. Variable_name: innodb_replication_delay
  1687. Value: 0
  1688. *************************** 202. row ***************************
  1689. Variable_name: innodb_rollback_on_timeout
  1690. Value: OFF
  1691. *************************** 203. row ***************************
  1692. Variable_name: innodb_rollback_segments
  1693. Value: 128
  1694. *************************** 204. row ***************************
  1695. Variable_name: innodb_sort_buffer_size
  1696. Value: 1048576
  1697. *************************** 205. row ***************************
  1698. Variable_name: innodb_spin_wait_delay
  1699. Value: 6
  1700. *************************** 206. row ***************************
  1701. Variable_name: innodb_stats_auto_recalc
  1702. Value: ON
  1703. *************************** 207. row ***************************
  1704. Variable_name: innodb_stats_include_delete_marked
  1705. Value: OFF
  1706. *************************** 208. row ***************************
  1707. Variable_name: innodb_stats_method
  1708. Value: nulls_equal
  1709. *************************** 209. row ***************************
  1710. Variable_name: innodb_stats_on_metadata
  1711. Value: OFF
  1712. *************************** 210. row ***************************
  1713. Variable_name: innodb_stats_persistent
  1714. Value: ON
  1715. *************************** 211. row ***************************
  1716. Variable_name: innodb_stats_persistent_sample_pages
  1717. Value: 20
  1718. *************************** 212. row ***************************
  1719. Variable_name: innodb_stats_sample_pages
  1720. Value: 8
  1721. *************************** 213. row ***************************
  1722. Variable_name: innodb_stats_transient_sample_pages
  1723. Value: 8
  1724. *************************** 214. row ***************************
  1725. Variable_name: innodb_status_output
  1726. Value: OFF
  1727. *************************** 215. row ***************************
  1728. Variable_name: innodb_status_output_locks
  1729. Value: OFF
  1730. *************************** 216. row ***************************
  1731. Variable_name: innodb_strict_mode
  1732. Value: ON
  1733. *************************** 217. row ***************************
  1734. Variable_name: innodb_support_xa
  1735. Value: ON
  1736. *************************** 218. row ***************************
  1737. Variable_name: innodb_sync_array_size
  1738. Value: 1
  1739. *************************** 219. row ***************************
  1740. Variable_name: innodb_sync_spin_loops
  1741. Value: 30
  1742. *************************** 220. row ***************************
  1743. Variable_name: innodb_table_locks
  1744. Value: ON
  1745. *************************** 221. row ***************************
  1746. Variable_name: innodb_temp_data_file_path
  1747. Value: ibtmp1:12M:autoextend
  1748. *************************** 222. row ***************************
  1749. Variable_name: innodb_thread_concurrency
  1750. Value: 0
  1751. *************************** 223. row ***************************
  1752. Variable_name: innodb_thread_sleep_delay
  1753. Value: 10000
  1754. *************************** 224. row ***************************
  1755. Variable_name: innodb_tmpdir
  1756. Value:
  1757. *************************** 225. row ***************************
  1758. Variable_name: innodb_undo_directory
  1759. Value: ./
  1760. *************************** 226. row ***************************
  1761. Variable_name: innodb_undo_log_truncate
  1762. Value: OFF
  1763. *************************** 227. row ***************************
  1764. Variable_name: innodb_undo_logs
  1765. Value: 128
  1766. *************************** 228. row ***************************
  1767. Variable_name: innodb_undo_tablespaces
  1768. Value: 0
  1769. *************************** 229. row ***************************
  1770. Variable_name: innodb_use_native_aio
  1771. Value: ON
  1772. *************************** 230. row ***************************
  1773. Variable_name: innodb_version
  1774. Value: 5.7.32
  1775. *************************** 231. row ***************************
  1776. Variable_name: innodb_write_io_threads
  1777. Value: 64
  1778. *************************** 232. row ***************************
  1779. Variable_name: interactive_timeout
  1780. Value: 31536000
  1781. *************************** 233. row ***************************
  1782. Variable_name: internal_tmp_disk_storage_engine
  1783. Value: InnoDB
  1784. *************************** 234. row ***************************
  1785. Variable_name: join_buffer_size
  1786. Value: 1048576
  1787. *************************** 235. row ***************************
  1788. Variable_name: keep_files_on_create
  1789. Value: OFF
  1790. *************************** 236. row ***************************
  1791. Variable_name: key_buffer_size
  1792. Value: 16777216
  1793. *************************** 237. row ***************************
  1794. Variable_name: key_cache_age_threshold
  1795. Value: 300
  1796. *************************** 238. row ***************************
  1797. Variable_name: key_cache_block_size
  1798. Value: 1024
  1799. *************************** 239. row ***************************
  1800. Variable_name: key_cache_division_limit
  1801. Value: 100
  1802. *************************** 240. row ***************************
  1803. Variable_name: keyring_operations
  1804. Value: ON
  1805. *************************** 241. row ***************************
  1806. Variable_name: large_files_support
  1807. Value: ON
  1808. *************************** 242. row ***************************
  1809. Variable_name: large_page_size
  1810. Value: 0
  1811. *************************** 243. row ***************************
  1812. Variable_name: large_pages
  1813. Value: OFF
  1814. *************************** 244. row ***************************
  1815. Variable_name: lc_messages
  1816. Value: en_US
  1817. *************************** 245. row ***************************
  1818. Variable_name: lc_messages_dir
  1819. Value: /usr/share/mysql/
  1820. *************************** 246. row ***************************
  1821. Variable_name: lc_time_names
  1822. Value: en_US
  1823. *************************** 247. row ***************************
  1824. Variable_name: license
  1825. Value: GPL
  1826. *************************** 248. row ***************************
  1827. Variable_name: local_infile
  1828. Value: ON
  1829. *************************** 249. row ***************************
  1830. Variable_name: lock_wait_timeout
  1831. Value: 31536000
  1832. *************************** 250. row ***************************
  1833. Variable_name: locked_in_memory
  1834. Value: OFF
  1835. *************************** 251. row ***************************
  1836. Variable_name: log_bin
  1837. Value: OFF
  1838. *************************** 252. row ***************************
  1839. Variable_name: log_bin_basename
  1840. Value:
  1841. *************************** 253. row ***************************
  1842. Variable_name: log_bin_index
  1843. Value:
  1844. *************************** 254. row ***************************
  1845. Variable_name: log_bin_trust_function_creators
  1846. Value: OFF
  1847. *************************** 255. row ***************************
  1848. Variable_name: log_bin_use_v1_row_events
  1849. Value: OFF
  1850. *************************** 256. row ***************************
  1851. Variable_name: log_builtin_as_identified_by_password
  1852. Value: OFF
  1853. *************************** 257. row ***************************
  1854. Variable_name: log_error
  1855. Value: /var/log/mysql/error.log
  1856. *************************** 258. row ***************************
  1857. Variable_name: log_error_verbosity
  1858. Value: 3
  1859. *************************** 259. row ***************************
  1860. Variable_name: log_output
  1861. Value: FILE
  1862. *************************** 260. row ***************************
  1863. Variable_name: log_queries_not_using_indexes
  1864. Value: OFF
  1865. *************************** 261. row ***************************
  1866. Variable_name: log_slave_updates
  1867. Value: OFF
  1868. *************************** 262. row ***************************
  1869. Variable_name: log_slow_admin_statements
  1870. Value: OFF
  1871. *************************** 263. row ***************************
  1872. Variable_name: log_slow_slave_statements
  1873. Value: OFF
  1874. *************************** 264. row ***************************
  1875. Variable_name: log_statements_unsafe_for_binlog
  1876. Value: ON
  1877. *************************** 265. row ***************************
  1878. Variable_name: log_syslog
  1879. Value: OFF
  1880. *************************** 266. row ***************************
  1881. Variable_name: log_syslog_facility
  1882. Value: daemon
  1883. *************************** 267. row ***************************
  1884. Variable_name: log_syslog_include_pid
  1885. Value: ON
  1886. *************************** 268. row ***************************
  1887. Variable_name: log_syslog_tag
  1888. Value:
  1889. *************************** 269. row ***************************
  1890. Variable_name: log_throttle_queries_not_using_indexes
  1891. Value: 0
  1892. *************************** 270. row ***************************
  1893. Variable_name: log_timestamps
  1894. Value: UTC
  1895. *************************** 271. row ***************************
  1896. Variable_name: log_warnings
  1897. Value: 2
  1898. *************************** 272. row ***************************
  1899. Variable_name: long_query_time
  1900. Value: 10.000000
  1901. *************************** 273. row ***************************
  1902. Variable_name: low_priority_updates
  1903. Value: OFF
  1904. *************************** 274. row ***************************
  1905. Variable_name: lower_case_file_system
  1906. Value: OFF
  1907. *************************** 275. row ***************************
  1908. Variable_name: lower_case_table_names
  1909. Value: 0
  1910. *************************** 276. row ***************************
  1911. Variable_name: master_info_repository
  1912. Value: FILE
  1913. *************************** 277. row ***************************
  1914. Variable_name: master_verify_checksum
  1915. Value: OFF
  1916. *************************** 278. row ***************************
  1917. Variable_name: max_allowed_packet
  1918. Value: 1073741824
  1919. *************************** 279. row ***************************
  1920. Variable_name: max_binlog_cache_size
  1921. Value: 18446744073709547520
  1922. *************************** 280. row ***************************
  1923. Variable_name: max_binlog_size
  1924. Value: 1073741824
  1925. *************************** 281. row ***************************
  1926. Variable_name: max_binlog_stmt_cache_size
  1927. Value: 18446744073709547520
  1928. *************************** 282. row ***************************
  1929. Variable_name: max_connect_errors
  1930. Value: 100
  1931. *************************** 283. row ***************************
  1932. Variable_name: max_connections
  1933. Value: 150
  1934. *************************** 284. row ***************************
  1935. Variable_name: max_delayed_threads
  1936. Value: 20
  1937. *************************** 285. row ***************************
  1938. Variable_name: max_digest_length
  1939. Value: 1024
  1940. *************************** 286. row ***************************
  1941. Variable_name: max_error_count
  1942. Value: 64
  1943. *************************** 287. row ***************************
  1944. Variable_name: max_execution_time
  1945. Value: 0
  1946. *************************** 288. row ***************************
  1947. Variable_name: max_heap_table_size
  1948. Value: 16777216
  1949. *************************** 289. row ***************************
  1950. Variable_name: max_insert_delayed_threads
  1951. Value: 20
  1952. *************************** 290. row ***************************
  1953. Variable_name: max_join_size
  1954. Value: 18446744073709551615
  1955. *************************** 291. row ***************************
  1956. Variable_name: max_length_for_sort_data
  1957. Value: 1024
  1958. *************************** 292. row ***************************
  1959. Variable_name: max_points_in_geometry
  1960. Value: 65536
  1961. *************************** 293. row ***************************
  1962. Variable_name: max_prepared_stmt_count
  1963. Value: 16382
  1964. *************************** 294. row ***************************
  1965. Variable_name: max_relay_log_size
  1966. Value: 0
  1967. *************************** 295. row ***************************
  1968. Variable_name: max_seeks_for_key
  1969. Value: 18446744073709551615
  1970. *************************** 296. row ***************************
  1971. Variable_name: max_sort_length
  1972. Value: 1024
  1973. *************************** 297. row ***************************
  1974. Variable_name: max_sp_recursion_depth
  1975. Value: 0
  1976. *************************** 298. row ***************************
  1977. Variable_name: max_tmp_tables
  1978. Value: 32
  1979. *************************** 299. row ***************************
  1980. Variable_name: max_user_connections
  1981. Value: 0
  1982. *************************** 300. row ***************************
  1983. Variable_name: max_write_lock_count
  1984. Value: 18446744073709551615
  1985. *************************** 301. row ***************************
  1986. Variable_name: metadata_locks_cache_size
  1987. Value: 1024
  1988. *************************** 302. row ***************************
  1989. Variable_name: metadata_locks_hash_instances
  1990. Value: 8
  1991. *************************** 303. row ***************************
  1992. Variable_name: min_examined_row_limit
  1993. Value: 0
  1994. *************************** 304. row ***************************
  1995. Variable_name: multi_range_count
  1996. Value: 256
  1997. *************************** 305. row ***************************
  1998. Variable_name: myisam_data_pointer_size
  1999. Value: 6
  2000. *************************** 306. row ***************************
  2001. Variable_name: myisam_max_sort_file_size
  2002. Value: 9223372036853727232
  2003. *************************** 307. row ***************************
  2004. Variable_name: myisam_mmap_size
  2005. Value: 18446744073709551615
  2006. *************************** 308. row ***************************
  2007. Variable_name: myisam_recover_options
  2008. Value: OFF
  2009. *************************** 309. row ***************************
  2010. Variable_name: myisam_repair_threads
  2011. Value: 1
  2012. *************************** 310. row ***************************
  2013. Variable_name: myisam_sort_buffer_size
  2014. Value: 8388608
  2015. *************************** 311. row ***************************
  2016. Variable_name: myisam_stats_method
  2017. Value: nulls_unequal
  2018. *************************** 312. row ***************************
  2019. Variable_name: myisam_use_mmap
  2020. Value: OFF
  2021. *************************** 313. row ***************************
  2022. Variable_name: mysql_native_password_proxy_users
  2023. Value: OFF
  2024. *************************** 314. row ***************************
  2025. Variable_name: net_buffer_length
  2026. Value: 1048576
  2027. *************************** 315. row ***************************
  2028. Variable_name: net_read_timeout
  2029. Value: 10000
  2030. *************************** 316. row ***************************
  2031. Variable_name: net_retry_count
  2032. Value: 10
  2033. *************************** 317. row ***************************
  2034. Variable_name: net_write_timeout
  2035. Value: 10000
  2036. *************************** 318. row ***************************
  2037. Variable_name: new
  2038. Value: OFF
  2039. *************************** 319. row ***************************
  2040. Variable_name: ngram_token_size
  2041. Value: 2
  2042. *************************** 320. row ***************************
  2043. Variable_name: offline_mode
  2044. Value: OFF
  2045. *************************** 321. row ***************************
  2046. Variable_name: old
  2047. Value: OFF
  2048. *************************** 322. row ***************************
  2049. Variable_name: old_alter_table
  2050. Value: OFF
  2051. *************************** 323. row ***************************
  2052. Variable_name: old_passwords
  2053. Value: 0
  2054. *************************** 324. row ***************************
  2055. Variable_name: open_files_limit
  2056. Value: 5000
  2057. *************************** 325. row ***************************
  2058. Variable_name: optimizer_prune_level
  2059. Value: 1
  2060. *************************** 326. row ***************************
  2061. Variable_name: optimizer_search_depth
  2062. Value: 62
  2063. *************************** 327. row ***************************
  2064. Variable_name: optimizer_switch
  2065. Value: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on
  2066. *************************** 328. row ***************************
  2067. Variable_name: optimizer_trace
  2068. Value: enabled=off,one_line=off
  2069. *************************** 329. row ***************************
  2070. Variable_name: optimizer_trace_features
  2071. Value: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  2072. *************************** 330. row ***************************
  2073. Variable_name: optimizer_trace_limit
  2074. Value: 1
  2075. *************************** 331. row ***************************
  2076. Variable_name: optimizer_trace_max_mem_size
  2077. Value: 16384
  2078. *************************** 332. row ***************************
  2079. Variable_name: optimizer_trace_offset
  2080. Value: -1
  2081. *************************** 333. row ***************************
  2082. Variable_name: parser_max_mem_size
  2083. Value: 18446744073709551615
  2084. *************************** 334. row ***************************
  2085. Variable_name: performance_schema
  2086. Value: ON
  2087. *************************** 335. row ***************************
  2088. Variable_name: performance_schema_accounts_size
  2089. Value: -1
  2090. *************************** 336. row ***************************
  2091. Variable_name: performance_schema_digests_size
  2092. Value: 10000
  2093. *************************** 337. row ***************************
  2094. Variable_name: performance_schema_events_stages_history_long_size
  2095. Value: 10000
  2096. *************************** 338. row ***************************
  2097. Variable_name: performance_schema_events_stages_history_size
  2098. Value: 10
  2099. *************************** 339. row ***************************
  2100. Variable_name: performance_schema_events_statements_history_long_size
  2101. Value: 10000
  2102. *************************** 340. row ***************************
  2103. Variable_name: performance_schema_events_statements_history_size
  2104. Value: 10
  2105. *************************** 341. row ***************************
  2106. Variable_name: performance_schema_events_transactions_history_long_size
  2107. Value: 10000
  2108. *************************** 342. row ***************************
  2109. Variable_name: performance_schema_events_transactions_history_size
  2110. Value: 10
  2111. *************************** 343. row ***************************
  2112. Variable_name: performance_schema_events_waits_history_long_size
  2113. Value: 10000
  2114. *************************** 344. row ***************************
  2115. Variable_name: performance_schema_events_waits_history_size
  2116. Value: 10
  2117. *************************** 345. row ***************************
  2118. Variable_name: performance_schema_hosts_size
  2119. Value: -1
  2120. *************************** 346. row ***************************
  2121. Variable_name: performance_schema_max_cond_classes
  2122. Value: 80
  2123. *************************** 347. row ***************************
  2124. Variable_name: performance_schema_max_cond_instances
  2125. Value: -1
  2126. *************************** 348. row ***************************
  2127. Variable_name: performance_schema_max_digest_length
  2128. Value: 1024
  2129. *************************** 349. row ***************************
  2130. Variable_name: performance_schema_max_file_classes
  2131. Value: 80
  2132. *************************** 350. row ***************************
  2133. Variable_name: performance_schema_max_file_handles
  2134. Value: 32768
  2135. *************************** 351. row ***************************
  2136. Variable_name: performance_schema_max_file_instances
  2137. Value: -1
  2138. *************************** 352. row ***************************
  2139. Variable_name: performance_schema_max_index_stat
  2140. Value: -1
  2141. *************************** 353. row ***************************
  2142. Variable_name: performance_schema_max_memory_classes
  2143. Value: 320
  2144. *************************** 354. row ***************************
  2145. Variable_name: performance_schema_max_metadata_locks
  2146. Value: -1
  2147. *************************** 355. row ***************************
  2148. Variable_name: performance_schema_max_mutex_classes
  2149. Value: 210
  2150. *************************** 356. row ***************************
  2151. Variable_name: performance_schema_max_mutex_instances
  2152. Value: -1
  2153. *************************** 357. row ***************************
  2154. Variable_name: performance_schema_max_prepared_statements_instances
  2155. Value: -1
  2156. *************************** 358. row ***************************
  2157. Variable_name: performance_schema_max_program_instances
  2158. Value: -1
  2159. *************************** 359. row ***************************
  2160. Variable_name: performance_schema_max_rwlock_classes
  2161. Value: 50
  2162. *************************** 360. row ***************************
  2163. Variable_name: performance_schema_max_rwlock_instances
  2164. Value: -1
  2165. *************************** 361. row ***************************
  2166. Variable_name: performance_schema_max_socket_classes
  2167. Value: 10
  2168. *************************** 362. row ***************************
  2169. Variable_name: performance_schema_max_socket_instances
  2170. Value: -1
  2171. *************************** 363. row ***************************
  2172. Variable_name: performance_schema_max_sql_text_length
  2173. Value: 1024
  2174. *************************** 364. row ***************************
  2175. Variable_name: performance_schema_max_stage_classes
  2176. Value: 150
  2177. *************************** 365. row ***************************
  2178. Variable_name: performance_schema_max_statement_classes
  2179. Value: 193
  2180. *************************** 366. row ***************************
  2181. Variable_name: performance_schema_max_statement_stack
  2182. Value: 10
  2183. *************************** 367. row ***************************
  2184. Variable_name: performance_schema_max_table_handles
  2185. Value: -1
  2186. *************************** 368. row ***************************
  2187. Variable_name: performance_schema_max_table_instances
  2188. Value: -1
  2189. *************************** 369. row ***************************
  2190. Variable_name: performance_schema_max_table_lock_stat
  2191. Value: -1
  2192. *************************** 370. row ***************************
  2193. Variable_name: performance_schema_max_thread_classes
  2194. Value: 50
  2195. *************************** 371. row ***************************
  2196. Variable_name: performance_schema_max_thread_instances
  2197. Value: -1
  2198. *************************** 372. row ***************************
  2199. Variable_name: performance_schema_session_connect_attrs_size
  2200. Value: 512
  2201. *************************** 373. row ***************************
  2202. Variable_name: performance_schema_setup_actors_size
  2203. Value: -1
  2204. *************************** 374. row ***************************
  2205. Variable_name: performance_schema_setup_objects_size
  2206. Value: -1
  2207. *************************** 375. row ***************************
  2208. Variable_name: performance_schema_users_size
  2209. Value: -1
  2210. *************************** 376. row ***************************
  2211. Variable_name: pid_file
  2212. Value: /var/run/mysqld/mysqld.pid
  2213. *************************** 377. row ***************************
  2214. Variable_name: plugin_dir
  2215. Value: /usr/lib/mysql/plugin/
  2216. *************************** 378. row ***************************
  2217. Variable_name: port
  2218. Value: 3306
  2219. *************************** 379. row ***************************
  2220. Variable_name: preload_buffer_size
  2221. Value: 32768
  2222. *************************** 380. row ***************************
  2223. Variable_name: profiling
  2224. Value: OFF
  2225. *************************** 381. row ***************************
  2226. Variable_name: profiling_history_size
  2227. Value: 15
  2228. *************************** 382. row ***************************
  2229. Variable_name: protocol_version
  2230. Value: 10
  2231. *************************** 383. row ***************************
  2232. Variable_name: query_alloc_block_size
  2233. Value: 8192
  2234. *************************** 384. row ***************************
  2235. Variable_name: query_cache_limit
  2236. Value: 1048576
  2237. *************************** 385. row ***************************
  2238. Variable_name: query_cache_min_res_unit
  2239. Value: 4096
  2240. *************************** 386. row ***************************
  2241. Variable_name: query_cache_size
  2242. Value: 0
  2243. *************************** 387. row ***************************
  2244. Variable_name: query_cache_type
  2245. Value: OFF
  2246. *************************** 388. row ***************************
  2247. Variable_name: query_cache_wlock_invalidate
  2248. Value: OFF
  2249. *************************** 389. row ***************************
  2250. Variable_name: query_prealloc_size
  2251. Value: 8192
  2252. *************************** 390. row ***************************
  2253. Variable_name: range_alloc_block_size
  2254. Value: 4096
  2255. *************************** 391. row ***************************
  2256. Variable_name: range_optimizer_max_mem_size
  2257. Value: 8388608
  2258. *************************** 392. row ***************************
  2259. Variable_name: rbr_exec_mode
  2260. Value: STRICT
  2261. *************************** 393. row ***************************
  2262. Variable_name: read_buffer_size
  2263. Value: 1048576
  2264. *************************** 394. row ***************************
  2265. Variable_name: read_only
  2266. Value: OFF
  2267. *************************** 395. row ***************************
  2268. Variable_name: read_rnd_buffer_size
  2269. Value: 1048576
  2270. *************************** 396. row ***************************
  2271. Variable_name: relay_log
  2272. Value:
  2273. *************************** 397. row ***************************
  2274. Variable_name: relay_log_basename
  2275. Value: /var/lib/mysql/wolf1-relay-bin
  2276. *************************** 398. row ***************************
  2277. Variable_name: relay_log_index
  2278. Value: /var/lib/mysql/wolf1-relay-bin.index
  2279. *************************** 399. row ***************************
  2280. Variable_name: relay_log_info_file
  2281. Value: relay-log.info
  2282. *************************** 400. row ***************************
  2283. Variable_name: relay_log_info_repository
  2284. Value: FILE
  2285. *************************** 401. row ***************************
  2286. Variable_name: relay_log_purge
  2287. Value: ON
  2288. *************************** 402. row ***************************
  2289. Variable_name: relay_log_recovery
  2290. Value: OFF
  2291. *************************** 403. row ***************************
  2292. Variable_name: relay_log_space_limit
  2293. Value: 0
  2294. *************************** 404. row ***************************
  2295. Variable_name: report_host
  2296. Value:
  2297. *************************** 405. row ***************************
  2298. Variable_name: report_password
  2299. Value:
  2300. *************************** 406. row ***************************
  2301. Variable_name: report_port
  2302. Value: 3306
  2303. *************************** 407. row ***************************
  2304. Variable_name: report_user
  2305. Value:
  2306. *************************** 408. row ***************************
  2307. Variable_name: require_secure_transport
  2308. Value: OFF
  2309. *************************** 409. row ***************************
  2310. Variable_name: rpl_stop_slave_timeout
  2311. Value: 31536000
  2312. *************************** 410. row ***************************
  2313. Variable_name: secure_auth
  2314. Value: ON
  2315. *************************** 411. row ***************************
  2316. Variable_name: secure_file_priv
  2317. Value: /var/lib/mysql-files/
  2318. *************************** 412. row ***************************
  2319. Variable_name: server_id
  2320. Value: 0
  2321. *************************** 413. row ***************************
  2322. Variable_name: server_id_bits
  2323. Value: 32
  2324. *************************** 414. row ***************************
  2325. Variable_name: server_uuid
  2326. Value: 4e335fb3-45ed-11eb-bb99-3448edeefef6
  2327. *************************** 415. row ***************************
  2328. Variable_name: session_track_gtids
  2329. Value: OFF
  2330. *************************** 416. row ***************************
  2331. Variable_name: session_track_schema
  2332. Value: ON
  2333. *************************** 417. row ***************************
  2334. Variable_name: session_track_state_change
  2335. Value: OFF
  2336. *************************** 418. row ***************************
  2337. Variable_name: session_track_system_variables
  2338. Value: time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  2339. *************************** 419. row ***************************
  2340. Variable_name: session_track_transaction_info
  2341. Value: OFF
  2342. *************************** 420. row ***************************
  2343. Variable_name: sha256_password_auto_generate_rsa_keys
  2344. Value: ON
  2345. *************************** 421. row ***************************
  2346. Variable_name: sha256_password_private_key_path
  2347. Value: private_key.pem
  2348. *************************** 422. row ***************************
  2349. Variable_name: sha256_password_proxy_users
  2350. Value: OFF
  2351. *************************** 423. row ***************************
  2352. Variable_name: sha256_password_public_key_path
  2353. Value: public_key.pem
  2354. *************************** 424. row ***************************
  2355. Variable_name: show_compatibility_56
  2356. Value: OFF
  2357. *************************** 425. row ***************************
  2358. Variable_name: show_create_table_verbosity
  2359. Value: OFF
  2360. *************************** 426. row ***************************
  2361. Variable_name: show_old_temporals
  2362. Value: OFF
  2363. *************************** 427. row ***************************
  2364. Variable_name: skip_external_locking
  2365. Value: ON
  2366. *************************** 428. row ***************************
  2367. Variable_name: skip_name_resolve
  2368. Value: OFF
  2369. *************************** 429. row ***************************
  2370. Variable_name: skip_networking
  2371. Value: OFF
  2372. *************************** 430. row ***************************
  2373. Variable_name: skip_show_database
  2374. Value: OFF
  2375. *************************** 431. row ***************************
  2376. Variable_name: slave_allow_batching
  2377. Value: OFF
  2378. *************************** 432. row ***************************
  2379. Variable_name: slave_checkpoint_group
  2380. Value: 512
  2381. *************************** 433. row ***************************
  2382. Variable_name: slave_checkpoint_period
  2383. Value: 300
  2384. *************************** 434. row ***************************
  2385. Variable_name: slave_compressed_protocol
  2386. Value: OFF
  2387. *************************** 435. row ***************************
  2388. Variable_name: slave_exec_mode
  2389. Value: STRICT
  2390. *************************** 436. row ***************************
  2391. Variable_name: slave_load_tmpdir
  2392. Value: /data/mysql_tmp
  2393. *************************** 437. row ***************************
  2394. Variable_name: slave_max_allowed_packet
  2395. Value: 1073741824
  2396. *************************** 438. row ***************************
  2397. Variable_name: slave_net_timeout
  2398. Value: 60
  2399. *************************** 439. row ***************************
  2400. Variable_name: slave_parallel_type
  2401. Value: DATABASE
  2402. *************************** 440. row ***************************
  2403. Variable_name: slave_parallel_workers
  2404. Value: 0
  2405. *************************** 441. row ***************************
  2406. Variable_name: slave_pending_jobs_size_max
  2407. Value: 16777216
  2408. *************************** 442. row ***************************
  2409. Variable_name: slave_preserve_commit_order
  2410. Value: OFF
  2411. *************************** 443. row ***************************
  2412. Variable_name: slave_rows_search_algorithms
  2413. Value: TABLE_SCAN,INDEX_SCAN
  2414. *************************** 444. row ***************************
  2415. Variable_name: slave_skip_errors
  2416. Value: OFF
  2417. *************************** 445. row ***************************
  2418. Variable_name: slave_sql_verify_checksum
  2419. Value: ON
  2420. *************************** 446. row ***************************
  2421. Variable_name: slave_transaction_retries
  2422. Value: 10
  2423. *************************** 447. row ***************************
  2424. Variable_name: slave_type_conversions
  2425. Value:
  2426. *************************** 448. row ***************************
  2427. Variable_name: slow_launch_time
  2428. Value: 2
  2429. *************************** 449. row ***************************
  2430. Variable_name: slow_query_log
  2431. Value: OFF
  2432. *************************** 450. row ***************************
  2433. Variable_name: slow_query_log_file
  2434. Value: /var/lib/mysql/wolf1-slow.log
  2435. *************************** 451. row ***************************
  2436. Variable_name: socket
  2437. Value: /var/run/mysqld/mysqld.sock
  2438. *************************** 452. row ***************************
  2439. Variable_name: sort_buffer_size
  2440. Value: 10485760
  2441. *************************** 453. row ***************************
  2442. Variable_name: sql_auto_is_null
  2443. Value: OFF
  2444. *************************** 454. row ***************************
  2445. Variable_name: sql_big_selects
  2446. Value: ON
  2447. *************************** 455. row ***************************
  2448. Variable_name: sql_buffer_result
  2449. Value: OFF
  2450. *************************** 456. row ***************************
  2451. Variable_name: sql_log_off
  2452. Value: OFF
  2453. *************************** 457. row ***************************
  2454. Variable_name: sql_mode
  2455. Value: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  2456. *************************** 458. row ***************************
  2457. Variable_name: sql_notes
  2458. Value: ON
  2459. *************************** 459. row ***************************
  2460. Variable_name: sql_quote_show_create
  2461. Value: ON
  2462. *************************** 460. row ***************************
  2463. Variable_name: sql_safe_updates
  2464. Value: OFF
  2465. *************************** 461. row ***************************
  2466. Variable_name: sql_select_limit
  2467. Value: 18446744073709551615
  2468. *************************** 462. row ***************************
  2469. Variable_name: sql_slave_skip_counter
  2470. Value: 0
  2471. *************************** 463. row ***************************
  2472. Variable_name: sql_warnings
  2473. Value: OFF
  2474. *************************** 464. row ***************************
  2475. Variable_name: ssl_ca
  2476. Value: ca.pem
  2477. *************************** 465. row ***************************
  2478. Variable_name: ssl_capath
  2479. Value:
  2480. *************************** 466. row ***************************
  2481. Variable_name: ssl_cert
  2482. Value: server-cert.pem
  2483. *************************** 467. row ***************************
  2484. Variable_name: ssl_cipher
  2485. Value:
  2486. *************************** 468. row ***************************
  2487. Variable_name: ssl_crl
  2488. Value:
  2489. *************************** 469. row ***************************
  2490. Variable_name: ssl_crlpath
  2491. Value:
  2492. *************************** 470. row ***************************
  2493. Variable_name: ssl_key
  2494. Value: server-key.pem
  2495. *************************** 471. row ***************************
  2496. Variable_name: stored_program_cache
  2497. Value: 256
  2498. *************************** 472. row ***************************
  2499. Variable_name: super_read_only
  2500. Value: OFF
  2501. *************************** 473. row ***************************
  2502. Variable_name: sync_binlog
  2503. Value: 1
  2504. *************************** 474. row ***************************
  2505. Variable_name: sync_frm
  2506. Value: ON
  2507. *************************** 475. row ***************************
  2508. Variable_name: sync_master_info
  2509. Value: 10000
  2510. *************************** 476. row ***************************
  2511. Variable_name: sync_relay_log
  2512. Value: 10000
  2513. *************************** 477. row ***************************
  2514. Variable_name: sync_relay_log_info
  2515. Value: 10000
  2516. *************************** 478. row ***************************
  2517. Variable_name: system_time_zone
  2518. Value: CET
  2519. *************************** 479. row ***************************
  2520. Variable_name: table_definition_cache
  2521. Value: 1610
  2522. *************************** 480. row ***************************
  2523. Variable_name: table_open_cache
  2524. Value: 2420
  2525. *************************** 481. row ***************************
  2526. Variable_name: table_open_cache_instances
  2527. Value: 55
  2528. *************************** 482. row ***************************
  2529. Variable_name: thread_cache_size
  2530. Value: 100
  2531. *************************** 483. row ***************************
  2532. Variable_name: thread_handling
  2533. Value: one-thread-per-connection
  2534. *************************** 484. row ***************************
  2535. Variable_name: thread_stack
  2536. Value: 262144
  2537. *************************** 485. row ***************************
  2538. Variable_name: time_format
  2539. Value: %H:%i:%s
  2540. *************************** 486. row ***************************
  2541. Variable_name: time_zone
  2542. Value: SYSTEM
  2543. *************************** 487. row ***************************
  2544. Variable_name: tls_version
  2545. Value: TLSv1,TLSv1.1,TLSv1.2
  2546. *************************** 488. row ***************************
  2547. Variable_name: tmp_table_size
  2548. Value: 16777216
  2549. *************************** 489. row ***************************
  2550. Variable_name: tmpdir
  2551. Value: /data/mysql_tmp
  2552. *************************** 490. row ***************************
  2553. Variable_name: transaction_alloc_block_size
  2554. Value: 8192
  2555. *************************** 491. row ***************************
  2556. Variable_name: transaction_isolation
  2557. Value: REPEATABLE-READ
  2558. *************************** 492. row ***************************
  2559. Variable_name: transaction_prealloc_size
  2560. Value: 4096
  2561. *************************** 493. row ***************************
  2562. Variable_name: transaction_read_only
  2563. Value: OFF
  2564. *************************** 494. row ***************************
  2565. Variable_name: transaction_write_set_extraction
  2566. Value: OFF
  2567. *************************** 495. row ***************************
  2568. Variable_name: tx_isolation
  2569. Value: REPEATABLE-READ
  2570. *************************** 496. row ***************************
  2571. Variable_name: tx_read_only
  2572. Value: OFF
  2573. *************************** 497. row ***************************
  2574. Variable_name: unique_checks
  2575. Value: ON
  2576. *************************** 498. row ***************************
  2577. Variable_name: updatable_views_with_limit
  2578. Value: YES
  2579. *************************** 499. row ***************************
  2580. Variable_name: version
  2581. Value: 5.7.32
  2582. *************************** 500. row ***************************
  2583. Variable_name: version_comment
  2584. Value: MySQL Community Server (GPL)
  2585. *************************** 501. row ***************************
  2586. Variable_name: version_compile_machine
  2587. Value: x86_64
  2588. *************************** 502. row ***************************
  2589. Variable_name: version_compile_os
  2590. Value: Linux
  2591. *************************** 503. row ***************************
  2592. Variable_name: wait_timeout
  2593. Value: 31536000
  2594. 503 rows in set (0.01 sec)
  2595.  
  2596.  
  2597.  
  2598. =======================================================================================================================
  2599.  
  2600.  
  2601. D) SHOW FULL PROCESSLIST;
  2602. (There is not any process or active connection because this server is still in dev mode.)
  2603.  
  2604. +----+-----------------+-----------+------+---------+-------+-----------------------------+-----------------------+
  2605. | Id | User | Host | db | Command | Time | State | Info |
  2606. +----+-----------------+-----------+------+---------+-------+-----------------------------+-----------------------+
  2607. | 1 | event_scheduler | localhost | NULL | Daemon | 17383 | Waiting for next activation | NULL |
  2608. | 71 | root | localhost | NULL | Query | 0 | starting | SHOW FULL PROCESSLIST |
  2609. +----+-----------------+-----------+------+---------+-------+-----------------------------+-----------------------+
  2610.  
  2611.  
  2612.  
  2613. =======================================================================================================================
  2614.  
  2615.  
  2616. STATUS;
  2617.  
  2618.  
  2619. --------------
  2620. mysql Ver 14.14 Distrib 5.7.32, for Linux (x86_64) using EditLine wrapper
  2621.  
  2622. Connection id: 71
  2623. Current database:
  2624. Current user: root@localhost
  2625. SSL: Not in use
  2626. Current pager: stdout
  2627. Using outfile: ''
  2628. Using delimiter: ;
  2629. Server version: 5.7.32 MySQL Community Server (GPL)
  2630. Protocol version: 10
  2631. Connection: Localhost via UNIX socket
  2632. Server characterset: latin1
  2633. Db characterset: latin1
  2634. Client characterset: utf8
  2635. Conn. characterset: utf8
  2636. UNIX socket: /var/run/mysqld/mysqld.sock
  2637. Uptime: 3 days 1 hour 11 min 27 sec
  2638.  
  2639. Threads: 2 Questions: 1344 Slow queries: 0 Opens: 5899 Flush tables: 1 Open tables: 994 Queries per second avg: 0.005
  2640. --------------
  2641.  
  2642.  
  2643.  
  2644. =======================================================================================================================
  2645.  
  2646.  
  2647. F) complete MySQLTuner report
  2648.  
  2649.  
  2650. >> MySQLTuner 1.7.20
  2651.  
  2652. [--] Skipped version check for MySQLTuner script
  2653. Please enter your MySQL administrative login: root
  2654. Please enter your MySQL administrative password: [OK] Currently running supported MySQL version 5.7.32
  2655. [OK] Operating on 64-bit architecture
  2656.  
  2657. -------- Log file Recommendations ------------------------------------------------------------------
  2658. [!!] Log file /var/log/mysql/error.log doesn't exist
  2659.  
  2660. -------- Storage Engine Statistics -----------------------------------------------------------------
  2661. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  2662. [--] Data in InnoDB tables: 996.6G (Tables: 506)
  2663. [OK] Total fragmented tables: 0
  2664.  
  2665. -------- Analysis Performance Metrics --------------------------------------------------------------
  2666. [--] innodb_stats_on_metadata: OFF
  2667. [OK] No stat updates during querying INFORMATION_SCHEMA.
  2668.  
  2669. -------- Security Recommendations ------------------------------------------------------------------
  2670. [OK] There are no anonymous accounts for any database users
  2671. [OK] All database users have passwords assigned
  2672. [!!] There is no basic password file list!
  2673.  
  2674. -------- CVE Security Recommendations --------------------------------------------------------------
  2675. [--] Skipped due to --cvefile option undefined
  2676.  
  2677. -------- Performance Metrics -----------------------------------------------------------------------
  2678. [--] Up for: 3d 1h 12m 54s (198 q [0.001 qps], 79 conn, TX: 353K, RX: 18K)
  2679. [--] Reads / Writes: 66% / 34%
  2680. [--] Binary logging is disabled
  2681. [--] Physical Memory : 125.5G
  2682. [--] Max MySQL memory : 248.0G
  2683. [--] Other process memory: 0B
  2684. [--] Total buffers: 96.1G global + 1.0G per thread (150 max threads)
  2685. [--] P_S Max memory usage: 72B
  2686. [--] Galera GCache Max memory usage: 0B
  2687. [OK] Maximum reached memory usage: 97.1G (77.36% of installed RAM)
  2688. [!!] Maximum possible memory usage: 248.0G (197.65% of installed RAM)
  2689. [!!] Overall possible memory usage with other process exceeded memory
  2690. [OK] Slow queries: 0% (0/198)
  2691. [OK] Highest usage of available connections: 0% (1/150)
  2692. [OK] Aborted connections: 2.53% (2/79)
  2693. [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
  2694. [OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
  2695. [!!] Sorts requiring temporary tables: 769% (939 temp sorts / 122 sorts)
  2696. [OK] No joins without indexes
  2697. [OK] Temporary tables created on disk: 2% (104 on disk / 4K total)
  2698. [OK] Thread cache hit rate: 98% (1 created / 79 connections)
  2699. [!!] Table cache hit rate: 16% (996 open / 5K opened)
  2700. [OK] table_definition_cache(1610) is upper than number of tables(956)
  2701. [OK] Open file limit used: 1% (52/5K)
  2702. [OK] Table locks acquired immediately: 100% (215 immediate / 215 locks)
  2703.  
  2704. -------- Performance schema ------------------------------------------------------------------------
  2705. [--] Memory used by P_S: 72B
  2706. [--] Sys schema is installed.
  2707.  
  2708. -------- ThreadPool Metrics ------------------------------------------------------------------------
  2709. [--] ThreadPool stat is disabled.
  2710.  
  2711. -------- MyISAM Metrics ----------------------------------------------------------------------------
  2712. [!!] Key buffer used: 18.3% (3M used / 16M cache)
  2713. [OK] Key buffer size / total MyISAM indexes: 16.0M/53.0K
  2714. [OK] Read Key buffer hit rate: 95.6% (388 cached / 17 reads)
  2715.  
  2716. -------- InnoDB Metrics ----------------------------------------------------------------------------
  2717. [--] InnoDB is enabled.
  2718. [--] InnoDB Thread Concurrency: 0
  2719. [OK] InnoDB File per table is activated
  2720. [!!] InnoDB buffer pool / data size: 96.0G/996.6G
  2721. [OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 13.0G * 2/96.0G should be equal to 25%
  2722. [OK] InnoDB buffer pool instances: 64
  2723. [--] Number of InnoDB Buffer Pool Chunk : 384 for 64 Buffer Pool Instance(s)
  2724. [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
  2725. [OK] InnoDB Read buffer efficiency: 99.97% (6053632101 hits/ 6055193436 total)
  2726. [OK] InnoDB Write log efficiency: 99.95% (17096889 hits/ 17105509 total)
  2727. [OK] InnoDB log waits: 0.00% (0 waits / 8620 writes)
  2728.  
  2729. -------- AriaDB Metrics ----------------------------------------------------------------------------
  2730. [--] AriaDB is disabled.
  2731.  
  2732. -------- TokuDB Metrics ----------------------------------------------------------------------------
  2733. [--] TokuDB is disabled.
  2734.  
  2735. -------- XtraDB Metrics ----------------------------------------------------------------------------
  2736. [--] XtraDB is disabled.
  2737.  
  2738. -------- Galera Metrics ----------------------------------------------------------------------------
  2739. [--] Galera is disabled.
  2740.  
  2741. -------- Replication Metrics -----------------------------------------------------------------------
  2742. [--] Galera Synchronous replication: NO
  2743. [--] No replication slave(s) for this server.
  2744. [--] Binlog format: ROW
  2745. [--] XA support enabled: ON
  2746. [--] Semi synchronous replication Master: Not Activated
  2747. [--] Semi synchronous replication Slave: Not Activated
  2748. [--] This is a standalone server
  2749.  
  2750. -------- Recommendations ---------------------------------------------------------------------------
  2751. General recommendations:
  2752. Reduce your overall MySQL memory footprint for system stability
  2753. Dedicate this server to your database for highest performance.
  2754. Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
  2755. Increase table_open_cache gradually to avoid file descriptor limits
  2756. Read this before increasing table_open_cache over 64: https://bit.ly/2Fulv7r
  2757. Read this before increasing for MariaDB https://mariadb.com/kb/en/library/optimizing-table_open_cache/
  2758. This is MyISAM only table_cache scalability problem, InnoDB not affected.
  2759. See more details here: https://bugs.mysql.com/bug.php?id=49177
  2760. This bug already fixed in MySQL 5.7.9 and newer MySQL versions.
  2761. Beware that open_files_limit (5000) variable
  2762. should be greater than table_open_cache (2420)
  2763. Variables to adjust:
  2764. *** MySQL's maximum memory usage is dangerously high ***
  2765. *** Add RAM before increasing MySQL buffer variables ***
  2766. sort_buffer_size (> 10M)
  2767. read_rnd_buffer_size (> 1M)
  2768. table_open_cache (> 2420)
  2769. innodb_buffer_pool_size (>= 996.6G) if possible.
  2770.  
  2771.  
  2772.  
  2773. =======================================================================================================================
  2774.  
  2775.  
  2776.  
  2777. G) SHOW ENGINE INNODB STATUS;
  2778.  
  2779.  
  2780. *************************** 1. row ***************************
  2781. Type: InnoDB
  2782. Name:
  2783. Status:
  2784. =====================================
  2785. 2020-12-28 09:55:26 0x7fdfa8058700 INNODB MONITOR OUTPUT
  2786. =====================================
  2787. Per second averages calculated from the last 7 seconds
  2788. -----------------
  2789. BACKGROUND THREAD
  2790. -----------------
  2791. srv_master_thread loops: 8123 srv_active, 0 srv_shutdown, 255471 srv_idle
  2792. srv_master_thread log flush and writes: 263594
  2793. ----------
  2794. SEMAPHORES
  2795. ----------
  2796. OS WAIT ARRAY INFO: reservation count 31952
  2797. OS WAIT ARRAY INFO: signal count 117176
  2798. RW-shared spins 0, rounds 142589, OS waits 10727
  2799. RW-excl spins 0, rounds 700337, OS waits 8069
  2800. RW-sx spins 30983, rounds 248400, OS waits 3022
  2801. Spin rounds per wait: 142589.00 RW-shared, 700337.00 RW-excl, 8.02 RW-sx
  2802. ------------
  2803. TRANSACTIONS
  2804. ------------
  2805. Trx id counter 34272
  2806. Purge done for trx's n:o < 33341 undo n:o < 0 state: running but idle
  2807. History list length 0
  2808. LIST OF TRANSACTIONS FOR EACH SESSION:
  2809. ---TRANSACTION 422073565550432, not started
  2810. 0 lock struct(s), heap size 1136, 0 row lock(s)
  2811. --------
  2812. FILE I/O
  2813. --------
  2814. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  2815. I/O thread 1 state: waiting for completed aio requests (log thread)
  2816. I/O thread 2 state: waiting for completed aio requests (read thread)
  2817. I/O thread 3 state: waiting for completed aio requests (read thread)
  2818. I/O thread 4 state: waiting for completed aio requests (read thread)
  2819. I/O thread 5 state: waiting for completed aio requests (read thread)
  2820. I/O thread 6 state: waiting for completed aio requests (read thread)
  2821. I/O thread 7 state: waiting for completed aio requests (read thread)
  2822. I/O thread 8 state: waiting for completed aio requests (read thread)
  2823. I/O thread 9 state: waiting for completed aio requests (read thread)
  2824. I/O thread 10 state: waiting for completed aio requests (read thread)
  2825. I/O thread 11 state: waiting for completed aio requests (read thread)
  2826. I/O thread 12 state: waiting for completed aio requests (read thread)
  2827. I/O thread 13 state: waiting for completed aio requests (read thread)
  2828. I/O thread 14 state: waiting for completed aio requests (read thread)
  2829. I/O thread 15 state: waiting for completed aio requests (read thread)
  2830. I/O thread 16 state: waiting for completed aio requests (read thread)
  2831. I/O thread 17 state: waiting for completed aio requests (read thread)
  2832. I/O thread 18 state: waiting for completed aio requests (read thread)
  2833. I/O thread 19 state: waiting for completed aio requests (read thread)
  2834. I/O thread 20 state: waiting for completed aio requests (read thread)
  2835. I/O thread 21 state: waiting for completed aio requests (read thread)
  2836. I/O thread 22 state: waiting for completed aio requests (read thread)
  2837. I/O thread 23 state: waiting for completed aio requests (read thread)
  2838. I/O thread 24 state: waiting for completed aio requests (read thread)
  2839. I/O thread 25 state: waiting for completed aio requests (read thread)
  2840. I/O thread 26 state: waiting for completed aio requests (read thread)
  2841. I/O thread 27 state: waiting for completed aio requests (read thread)
  2842. I/O thread 28 state: waiting for completed aio requests (read thread)
  2843. I/O thread 29 state: waiting for completed aio requests (read thread)
  2844. I/O thread 30 state: waiting for completed aio requests (read thread)
  2845. I/O thread 31 state: waiting for completed aio requests (read thread)
  2846. I/O thread 32 state: waiting for completed aio requests (read thread)
  2847. I/O thread 33 state: waiting for completed aio requests (read thread)
  2848. I/O thread 34 state: waiting for completed aio requests (read thread)
  2849. I/O thread 35 state: waiting for completed aio requests (read thread)
  2850. I/O thread 36 state: waiting for completed aio requests (read thread)
  2851. I/O thread 37 state: waiting for completed aio requests (read thread)
  2852. I/O thread 38 state: waiting for completed aio requests (read thread)
  2853. I/O thread 39 state: waiting for completed aio requests (read thread)
  2854. I/O thread 40 state: waiting for completed aio requests (read thread)
  2855. I/O thread 41 state: waiting for completed aio requests (read thread)
  2856. I/O thread 42 state: waiting for completed aio requests (read thread)
  2857. I/O thread 43 state: waiting for completed aio requests (read thread)
  2858. I/O thread 44 state: waiting for completed aio requests (read thread)
  2859. I/O thread 45 state: waiting for completed aio requests (read thread)
  2860. I/O thread 46 state: waiting for completed aio requests (read thread)
  2861. I/O thread 47 state: waiting for completed aio requests (read thread)
  2862. I/O thread 48 state: waiting for completed aio requests (read thread)
  2863. I/O thread 49 state: waiting for completed aio requests (read thread)
  2864. I/O thread 50 state: waiting for completed aio requests (read thread)
  2865. I/O thread 51 state: waiting for completed aio requests (read thread)
  2866. I/O thread 52 state: waiting for completed aio requests (read thread)
  2867. I/O thread 53 state: waiting for completed aio requests (read thread)
  2868. I/O thread 54 state: waiting for completed aio requests (read thread)
  2869. I/O thread 55 state: waiting for completed aio requests (read thread)
  2870. I/O thread 56 state: waiting for completed aio requests (read thread)
  2871. I/O thread 57 state: waiting for completed aio requests (read thread)
  2872. I/O thread 58 state: waiting for completed aio requests (read thread)
  2873. I/O thread 59 state: waiting for completed aio requests (read thread)
  2874. I/O thread 60 state: waiting for completed aio requests (read thread)
  2875. I/O thread 61 state: waiting for completed aio requests (read thread)
  2876. I/O thread 62 state: waiting for completed aio requests (read thread)
  2877. I/O thread 63 state: waiting for completed aio requests (read thread)
  2878. I/O thread 64 state: waiting for completed aio requests (read thread)
  2879. I/O thread 65 state: waiting for completed aio requests (read thread)
  2880. I/O thread 66 state: waiting for completed aio requests (write thread)
  2881. I/O thread 67 state: waiting for completed aio requests (write thread)
  2882. I/O thread 68 state: waiting for completed aio requests (write thread)
  2883. I/O thread 69 state: waiting for completed aio requests (write thread)
  2884. I/O thread 70 state: waiting for completed aio requests (write thread)
  2885. I/O thread 71 state: waiting for completed aio requests (write thread)
  2886. I/O thread 72 state: waiting for completed aio requests (write thread)
  2887. I/O thread 73 state: waiting for completed aio requests (write thread)
  2888. I/O thread 74 state: waiting for completed aio requests (write thread)
  2889. I/O thread 75 state: waiting for completed aio requests (write thread)
  2890. I/O thread 76 state: waiting for completed aio requests (write thread)
  2891. I/O thread 77 state: waiting for completed aio requests (write thread)
  2892. I/O thread 78 state: waiting for completed aio requests (write thread)
  2893. I/O thread 79 state: waiting for completed aio requests (write thread)
  2894. I/O thread 80 state: waiting for completed aio requests (write thread)
  2895. I/O thread 81 state: waiting for completed aio requests (write thread)
  2896. I/O thread 82 state: waiting for completed aio requests (write thread)
  2897. I/O thread 83 state: waiting for completed aio requests (write thread)
  2898. I/O thread 84 state: waiting for completed aio requests (write thread)
  2899. I/O thread 85 state: waiting for completed aio requests (write thread)
  2900. I/O thread 86 state: waiting for completed aio requests (write thread)
  2901. I/O thread 87 state: waiting for completed aio requests (write thread)
  2902. I/O thread 88 state: waiting for completed aio requests (write thread)
  2903. I/O thread 89 state: waiting for completed aio requests (write thread)
  2904. I/O thread 90 state: waiting for completed aio requests (write thread)
  2905. I/O thread 91 state: waiting for completed aio requests (write thread)
  2906. I/O thread 92 state: waiting for completed aio requests (write thread)
  2907. I/O thread 93 state: waiting for completed aio requests (write thread)
  2908. I/O thread 94 state: waiting for completed aio requests (write thread)
  2909. I/O thread 95 state: waiting for completed aio requests (write thread)
  2910. I/O thread 96 state: waiting for completed aio requests (write thread)
  2911. I/O thread 97 state: waiting for completed aio requests (write thread)
  2912. I/O thread 98 state: waiting for completed aio requests (write thread)
  2913. I/O thread 99 state: waiting for completed aio requests (write thread)
  2914. I/O thread 100 state: waiting for completed aio requests (write thread)
  2915. I/O thread 101 state: waiting for completed aio requests (write thread)
  2916. I/O thread 102 state: waiting for completed aio requests (write thread)
  2917. I/O thread 103 state: waiting for completed aio requests (write thread)
  2918. I/O thread 104 state: waiting for completed aio requests (write thread)
  2919. I/O thread 105 state: waiting for completed aio requests (write thread)
  2920. I/O thread 106 state: waiting for completed aio requests (write thread)
  2921. I/O thread 107 state: waiting for completed aio requests (write thread)
  2922. I/O thread 108 state: waiting for completed aio requests (write thread)
  2923. I/O thread 109 state: waiting for completed aio requests (write thread)
  2924. I/O thread 110 state: waiting for completed aio requests (write thread)
  2925. I/O thread 111 state: waiting for completed aio requests (write thread)
  2926. I/O thread 112 state: waiting for completed aio requests (write thread)
  2927. I/O thread 113 state: waiting for completed aio requests (write thread)
  2928. I/O thread 114 state: waiting for completed aio requests (write thread)
  2929. I/O thread 115 state: waiting for completed aio requests (write thread)
  2930. I/O thread 116 state: waiting for completed aio requests (write thread)
  2931. I/O thread 117 state: waiting for completed aio requests (write thread)
  2932. I/O thread 118 state: waiting for completed aio requests (write thread)
  2933. I/O thread 119 state: waiting for completed aio requests (write thread)
  2934. I/O thread 120 state: waiting for completed aio requests (write thread)
  2935. I/O thread 121 state: waiting for completed aio requests (write thread)
  2936. I/O thread 122 state: waiting for completed aio requests (write thread)
  2937. I/O thread 123 state: waiting for completed aio requests (write thread)
  2938. I/O thread 124 state: waiting for completed aio requests (write thread)
  2939. I/O thread 125 state: waiting for completed aio requests (write thread)
  2940. I/O thread 126 state: waiting for completed aio requests (write thread)
  2941. I/O thread 127 state: waiting for completed aio requests (write thread)
  2942. I/O thread 128 state: waiting for completed aio requests (write thread)
  2943. I/O thread 129 state: waiting for completed aio requests (write thread)
  2944. Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
  2945. ibuf aio reads:, log i/o's:, sync i/o's:
  2946. Pending flushes (fsync) log: 0; buffer pool: 0
  2947. 4320913 OS file reads, 538049 OS file writes, 61136 OS fsyncs
  2948. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  2949. -------------------------------------
  2950. INSERT BUFFER AND ADAPTIVE HASH INDEX
  2951. -------------------------------------
  2952. Ibuf: size 1, free list len 264, seg size 266, 42 merges
  2953. merged operations:
  2954. insert 15, delete mark 2, delete 0
  2955. discarded operations:
  2956. insert 0, delete mark 0, delete 0
  2957. Hash table size 25498307, node heap has 100 buffer(s)
  2958. Hash table size 25498307, node heap has 61 buffer(s)
  2959. Hash table size 25498307, node heap has 2842 buffer(s)
  2960. Hash table size 25498307, node heap has 129 buffer(s)
  2961. Hash table size 25498307, node heap has 133 buffer(s)
  2962. Hash table size 25498307, node heap has 11 buffer(s)
  2963. Hash table size 25498307, node heap has 4 buffer(s)
  2964. Hash table size 25498307, node heap has 17616 buffer(s)
  2965. 0.00 hash searches/s, 0.00 non-hash searches/s
  2966. ---
  2967. LOG
  2968. ---
  2969. Log sequence number 1220730253185
  2970. Log flushed up to 1220730253185
  2971. Pages flushed up to 1220730253185
  2972. Last checkpoint at 1220730253176
  2973. 0 pending log flushes, 0 pending chkp writes
  2974. 9160 log i/o's done, 0.00 log i/o's/second
  2975. ----------------------
  2976. BUFFER POOL AND MEMORY
  2977. ----------------------
  2978. Total large memory allocated 105545465856
  2979. Dictionary memory allocated 4090888
  2980. Buffer pool size 6291078
  2981. Free buffers 1730660
  2982. Database pages 4539522
  2983. Old database pages 1674409
  2984. Modified db pages 0
  2985. Pending reads 0
  2986. Pending writes: LRU 0, flush list 0, single page 0
  2987. Pages made young 1919955, not young 858159
  2988. 0.00 youngs/s, 0.00 non-youngs/s
  2989. Pages read 4320449, created 438340, written 497673
  2990. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  2991. No buffer pool page gets since the last printout
  2992. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  2993. LRU len: 4539522, unzip_LRU len: 0
  2994. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  2995. ----------------------
  2996. INDIVIDUAL BUFFER POOL INFO
  2997. ----------------------
  2998. ---BUFFER POOL 0
  2999. Buffer pool size 98304
  3000. Free buffers 25560
  3001. Database pages 72424
  3002. Old database pages 26714
  3003. Modified db pages 0
  3004. Pending reads 0
  3005. Pending writes: LRU 0, flush list 0, single page 0
  3006. Pages made young 46978, not young 179752
  3007. 0.00 youngs/s, 0.00 non-youngs/s
  3008. Pages read 68561, created 7283, written 10093
  3009. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3010. No buffer pool page gets since the last printout
  3011. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3012. LRU len: 72424, unzip_LRU len: 0
  3013. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3014. ---BUFFER POOL 1
  3015. Buffer pool size 98298
  3016. Free buffers 26761
  3017. Database pages 71204
  3018. Old database pages 26264
  3019. Modified db pages 0
  3020. Pending reads 0
  3021. Pending writes: LRU 0, flush list 0, single page 0
  3022. Pages made young 29258, not young 0
  3023. 0.00 youngs/s, 0.00 non-youngs/s
  3024. Pages read 67757, created 6950, written 7672
  3025. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3026. No buffer pool page gets since the last printout
  3027. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3028. LRU len: 71204, unzip_LRU len: 0
  3029. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3030. ---BUFFER POOL 2
  3031. Buffer pool size 98298
  3032. Free buffers 28341
  3033. Database pages 69625
  3034. Old database pages 25681
  3035. Modified db pages 0
  3036. Pending reads 0
  3037. Pending writes: LRU 0, flush list 0, single page 0
  3038. Pages made young 28336, not young 0
  3039. 0.00 youngs/s, 0.00 non-youngs/s
  3040. Pages read 66231, created 6917, written 7634
  3041. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3042. No buffer pool page gets since the last printout
  3043. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3044. LRU len: 69625, unzip_LRU len: 0
  3045. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3046. ---BUFFER POOL 3
  3047. Buffer pool size 98298
  3048. Free buffers 27798
  3049. Database pages 70177
  3050. Old database pages 25885
  3051. Modified db pages 0
  3052. Pending reads 0
  3053. Pending writes: LRU 0, flush list 0, single page 0
  3054. Pages made young 28748, not young 0
  3055. 0.00 youngs/s, 0.00 non-youngs/s
  3056. Pages read 66741, created 6848, written 8154
  3057. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3058. No buffer pool page gets since the last printout
  3059. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3060. LRU len: 70177, unzip_LRU len: 0
  3061. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3062. ---BUFFER POOL 4
  3063. Buffer pool size 98298
  3064. Free buffers 26485
  3065. Database pages 71488
  3066. Old database pages 26369
  3067. Modified db pages 0
  3068. Pending reads 0
  3069. Pending writes: LRU 0, flush list 0, single page 0
  3070. Pages made young 29642, not young 26112
  3071. 0.00 youngs/s, 0.00 non-youngs/s
  3072. Pages read 68031, created 7073, written 7998
  3073. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3074. No buffer pool page gets since the last printout
  3075. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3076. LRU len: 71488, unzip_LRU len: 0
  3077. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3078. ---BUFFER POOL 5
  3079. Buffer pool size 98298
  3080. Free buffers 25609
  3081. Database pages 72356
  3082. Old database pages 26689
  3083. Modified db pages 0
  3084. Pending reads 0
  3085. Pending writes: LRU 0, flush list 0, single page 0
  3086. Pages made young 29803, not young 26112
  3087. 0.00 youngs/s, 0.00 non-youngs/s
  3088. Pages read 68923, created 6748, written 7430
  3089. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3090. No buffer pool page gets since the last printout
  3091. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3092. LRU len: 72356, unzip_LRU len: 0
  3093. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3094. ---BUFFER POOL 6
  3095. Buffer pool size 98298
  3096. Free buffers 28929
  3097. Database pages 69048
  3098. Old database pages 25468
  3099. Modified db pages 0
  3100. Pending reads 0
  3101. Pending writes: LRU 0, flush list 0, single page 0
  3102. Pages made young 28093, not young 26112
  3103. 0.00 youngs/s, 0.00 non-youngs/s
  3104. Pages read 66056, created 6460, written 7227
  3105. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3106. No buffer pool page gets since the last printout
  3107. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3108. LRU len: 69048, unzip_LRU len: 0
  3109. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3110. ---BUFFER POOL 7
  3111. Buffer pool size 98298
  3112. Free buffers 28078
  3113. Database pages 69891
  3114. Old database pages 25779
  3115. Modified db pages 0
  3116. Pending reads 0
  3117. Pending writes: LRU 0, flush list 0, single page 0
  3118. Pages made young 28415, not young 26112
  3119. 0.00 youngs/s, 0.00 non-youngs/s
  3120. Pages read 66624, created 6709, written 7361
  3121. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3122. No buffer pool page gets since the last printout
  3123. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3124. LRU len: 69891, unzip_LRU len: 0
  3125. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3126. ---BUFFER POOL 8
  3127. Buffer pool size 98298
  3128. Free buffers 26721
  3129. Database pages 71246
  3130. Old database pages 26279
  3131. Modified db pages 0
  3132. Pending reads 0
  3133. Pending writes: LRU 0, flush list 0, single page 0
  3134. Pages made young 29370, not young 25024
  3135. 0.00 youngs/s, 0.00 non-youngs/s
  3136. Pages read 68104, created 6370, written 7074
  3137. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3138. No buffer pool page gets since the last printout
  3139. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3140. LRU len: 71246, unzip_LRU len: 0
  3141. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3142. ---BUFFER POOL 9
  3143. Buffer pool size 98298
  3144. Free buffers 26843
  3145. Database pages 71131
  3146. Old database pages 26237
  3147. Modified db pages 0
  3148. Pending reads 0
  3149. Pending writes: LRU 0, flush list 0, single page 0
  3150. Pages made young 29447, not young 26112
  3151. 0.00 youngs/s, 0.00 non-youngs/s
  3152. Pages read 67981, created 6459, written 7352
  3153. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3154. No buffer pool page gets since the last printout
  3155. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3156. LRU len: 71131, unzip_LRU len: 0
  3157. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3158. ---BUFFER POOL 10
  3159. Buffer pool size 98298
  3160. Free buffers 25594
  3161. Database pages 72387
  3162. Old database pages 26700
  3163. Modified db pages 0
  3164. Pending reads 0
  3165. Pending writes: LRU 0, flush list 0, single page 0
  3166. Pages made young 29979, not young 26112
  3167. 0.00 youngs/s, 0.00 non-youngs/s
  3168. Pages read 69166, created 6893, written 7482
  3169. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3170. No buffer pool page gets since the last printout
  3171. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3172. LRU len: 72387, unzip_LRU len: 0
  3173. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3174. ---BUFFER POOL 11
  3175. Buffer pool size 98298
  3176. Free buffers 27396
  3177. Database pages 70575
  3178. Old database pages 26032
  3179. Modified db pages 0
  3180. Pending reads 0
  3181. Pending writes: LRU 0, flush list 0, single page 0
  3182. Pages made young 28885, not young 0
  3183. 0.00 youngs/s, 0.00 non-youngs/s
  3184. Pages read 67445, created 6549, written 7341
  3185. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3186. No buffer pool page gets since the last printout
  3187. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3188. LRU len: 70575, unzip_LRU len: 0
  3189. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3190. ---BUFFER POOL 12
  3191. Buffer pool size 98298
  3192. Free buffers 28259
  3193. Database pages 69715
  3194. Old database pages 25714
  3195. Modified db pages 0
  3196. Pending reads 0
  3197. Pending writes: LRU 0, flush list 0, single page 0
  3198. Pages made young 28581, not young 0
  3199. 0.00 youngs/s, 0.00 non-youngs/s
  3200. Pages read 66481, created 6519, written 7642
  3201. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3202. No buffer pool page gets since the last printout
  3203. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3204. LRU len: 69715, unzip_LRU len: 0
  3205. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3206. ---BUFFER POOL 13
  3207. Buffer pool size 98298
  3208. Free buffers 25581
  3209. Database pages 72387
  3210. Old database pages 26700
  3211. Modified db pages 0
  3212. Pending reads 0
  3213. Pending writes: LRU 0, flush list 0, single page 0
  3214. Pages made young 29906, not young 1
  3215. 0.00 youngs/s, 0.00 non-youngs/s
  3216. Pages read 68919, created 6957, written 8103
  3217. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3218. No buffer pool page gets since the last printout
  3219. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3220. LRU len: 72387, unzip_LRU len: 0
  3221. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3222. ---BUFFER POOL 14
  3223. Buffer pool size 98298
  3224. Free buffers 27729
  3225. Database pages 70245
  3226. Old database pages 25910
  3227. Modified db pages 0
  3228. Pending reads 0
  3229. Pending writes: LRU 0, flush list 0, single page 0
  3230. Pages made young 28613, not young 0
  3231. 0.00 youngs/s, 0.00 non-youngs/s
  3232. Pages read 66692, created 7087, written 8404
  3233. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3234. No buffer pool page gets since the last printout
  3235. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3236. LRU len: 70245, unzip_LRU len: 0
  3237. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3238. ---BUFFER POOL 15
  3239. Buffer pool size 98298
  3240. Free buffers 27400
  3241. Database pages 70561
  3242. Old database pages 26026
  3243. Modified db pages 0
  3244. Pending reads 0
  3245. Pending writes: LRU 0, flush list 0, single page 0
  3246. Pages made young 28608, not young 25024
  3247. 0.00 youngs/s, 0.00 non-youngs/s
  3248. Pages read 67263, created 6420, written 7571
  3249. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3250. No buffer pool page gets since the last printout
  3251. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3252. LRU len: 70561, unzip_LRU len: 0
  3253. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3254. ---BUFFER POOL 16
  3255. Buffer pool size 98298
  3256. Free buffers 25234
  3257. Database pages 72731
  3258. Old database pages 26827
  3259. Modified db pages 0
  3260. Pending reads 0
  3261. Pending writes: LRU 0, flush list 0, single page 0
  3262. Pages made young 30388, not young 0
  3263. 0.00 youngs/s, 0.00 non-youngs/s
  3264. Pages read 69171, created 7212, written 8252
  3265. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3266. No buffer pool page gets since the last printout
  3267. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3268. LRU len: 72731, unzip_LRU len: 0
  3269. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3270. ---BUFFER POOL 17
  3271. Buffer pool size 98298
  3272. Free buffers 27831
  3273. Database pages 70148
  3274. Old database pages 25874
  3275. Modified db pages 0
  3276. Pending reads 0
  3277. Pending writes: LRU 0, flush list 0, single page 0
  3278. Pages made young 28457, not young 0
  3279. 0.00 youngs/s, 0.00 non-youngs/s
  3280. Pages read 66679, created 6727, written 7772
  3281. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3282. No buffer pool page gets since the last printout
  3283. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3284. LRU len: 70148, unzip_LRU len: 0
  3285. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3286. ---BUFFER POOL 18
  3287. Buffer pool size 98298
  3288. Free buffers 27219
  3289. Database pages 70754
  3290. Old database pages 26098
  3291. Modified db pages 0
  3292. Pending reads 0
  3293. Pending writes: LRU 0, flush list 0, single page 0
  3294. Pages made young 28779, not young 0
  3295. 0.00 youngs/s, 0.00 non-youngs/s
  3296. Pages read 67375, created 6692, written 7702
  3297. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3298. No buffer pool page gets since the last printout
  3299. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3300. LRU len: 70754, unzip_LRU len: 0
  3301. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3302. ---BUFFER POOL 19
  3303. Buffer pool size 98298
  3304. Free buffers 26214
  3305. Database pages 71747
  3306. Old database pages 26464
  3307. Modified db pages 0
  3308. Pending reads 0
  3309. Pending writes: LRU 0, flush list 0, single page 0
  3310. Pages made young 29410, not young 0
  3311. 0.00 youngs/s, 0.00 non-youngs/s
  3312. Pages read 68276, created 6800, written 7933
  3313. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3314. No buffer pool page gets since the last printout
  3315. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3316. LRU len: 71747, unzip_LRU len: 0
  3317. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3318. ---BUFFER POOL 20
  3319. Buffer pool size 98298
  3320. Free buffers 27503
  3321. Database pages 70466
  3322. Old database pages 25991
  3323. Modified db pages 0
  3324. Pending reads 0
  3325. Pending writes: LRU 0, flush list 0, single page 0
  3326. Pages made young 29067, not young 0
  3327. 0.00 youngs/s, 0.00 non-youngs/s
  3328. Pages read 66991, created 6819, written 8098
  3329. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3330. No buffer pool page gets since the last printout
  3331. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3332. LRU len: 70466, unzip_LRU len: 0
  3333. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3334. ---BUFFER POOL 21
  3335. Buffer pool size 98298
  3336. Free buffers 24394
  3337. Database pages 73580
  3338. Old database pages 27141
  3339. Modified db pages 0
  3340. Pending reads 0
  3341. Pending writes: LRU 0, flush list 0, single page 0
  3342. Pages made young 30501, not young 0
  3343. 0.00 youngs/s, 0.00 non-youngs/s
  3344. Pages read 69971, created 6999, written 8169
  3345. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3346. No buffer pool page gets since the last printout
  3347. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3348. LRU len: 73580, unzip_LRU len: 0
  3349. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3350. ---BUFFER POOL 22
  3351. Buffer pool size 98298
  3352. Free buffers 26101
  3353. Database pages 71868
  3354. Old database pages 26509
  3355. Modified db pages 0
  3356. Pending reads 0
  3357. Pending writes: LRU 0, flush list 0, single page 0
  3358. Pages made young 29238, not young 0
  3359. 0.00 youngs/s, 0.00 non-youngs/s
  3360. Pages read 68205, created 7112, written 8227
  3361. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3362. No buffer pool page gets since the last printout
  3363. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3364. LRU len: 71868, unzip_LRU len: 0
  3365. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3366. ---BUFFER POOL 23
  3367. Buffer pool size 98298
  3368. Free buffers 28132
  3369. Database pages 69851
  3370. Old database pages 25764
  3371. Modified db pages 0
  3372. Pending reads 0
  3373. Pending writes: LRU 0, flush list 0, single page 0
  3374. Pages made young 28353, not young 0
  3375. 0.00 youngs/s, 0.00 non-youngs/s
  3376. Pages read 66412, created 6839, written 7842
  3377. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3378. No buffer pool page gets since the last printout
  3379. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3380. LRU len: 69851, unzip_LRU len: 0
  3381. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3382. ---BUFFER POOL 24
  3383. Buffer pool size 98298
  3384. Free buffers 27390
  3385. Database pages 70582
  3386. Old database pages 26034
  3387. Modified db pages 0
  3388. Pending reads 0
  3389. Pending writes: LRU 0, flush list 0, single page 0
  3390. Pages made young 29030, not young 0
  3391. 0.00 youngs/s, 0.00 non-youngs/s
  3392. Pages read 67026, created 7015, written 8023
  3393. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3394. No buffer pool page gets since the last printout
  3395. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3396. LRU len: 70582, unzip_LRU len: 0
  3397. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3398. ---BUFFER POOL 25
  3399. Buffer pool size 98298
  3400. Free buffers 27401
  3401. Database pages 70568
  3402. Old database pages 26029
  3403. Modified db pages 0
  3404. Pending reads 0
  3405. Pending writes: LRU 0, flush list 0, single page 0
  3406. Pages made young 28711, not young 0
  3407. 0.00 youngs/s, 0.00 non-youngs/s
  3408. Pages read 66927, created 6983, written 8173
  3409. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3410. No buffer pool page gets since the last printout
  3411. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3412. LRU len: 70568, unzip_LRU len: 0
  3413. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3414. ---BUFFER POOL 26
  3415. Buffer pool size 98298
  3416. Free buffers 25094
  3417. Database pages 72871
  3418. Old database pages 26879
  3419. Modified db pages 0
  3420. Pending reads 0
  3421. Pending writes: LRU 0, flush list 0, single page 0
  3422. Pages made young 30183, not young 0
  3423. 0.00 youngs/s, 0.00 non-youngs/s
  3424. Pages read 69291, created 6863, written 8077
  3425. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3426. No buffer pool page gets since the last printout
  3427. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3428. LRU len: 72871, unzip_LRU len: 0
  3429. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3430. ---BUFFER POOL 27
  3431. Buffer pool size 98298
  3432. Free buffers 27128
  3433. Database pages 70841
  3434. Old database pages 26130
  3435. Modified db pages 0
  3436. Pending reads 0
  3437. Pending writes: LRU 0, flush list 0, single page 0
  3438. Pages made young 28999, not young 0
  3439. 0.00 youngs/s, 0.00 non-youngs/s
  3440. Pages read 67121, created 7128, written 7982
  3441. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3442. No buffer pool page gets since the last printout
  3443. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3444. LRU len: 70841, unzip_LRU len: 0
  3445. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3446. ---BUFFER POOL 28
  3447. Buffer pool size 98298
  3448. Free buffers 27281
  3449. Database pages 70686
  3450. Old database pages 26073
  3451. Modified db pages 0
  3452. Pending reads 0
  3453. Pending writes: LRU 0, flush list 0, single page 0
  3454. Pages made young 29004, not young 0
  3455. 0.00 youngs/s, 0.00 non-youngs/s
  3456. Pages read 66864, created 7342, written 8269
  3457. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3458. No buffer pool page gets since the last printout
  3459. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3460. LRU len: 70686, unzip_LRU len: 0
  3461. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3462. ---BUFFER POOL 29
  3463. Buffer pool size 98298
  3464. Free buffers 26668
  3465. Database pages 71306
  3466. Old database pages 26301
  3467. Modified db pages 0
  3468. Pending reads 0
  3469. Pending writes: LRU 0, flush list 0, single page 0
  3470. Pages made young 29440, not young 0
  3471. 0.00 youngs/s, 0.00 non-youngs/s
  3472. Pages read 67725, created 7054, written 7961
  3473. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3474. No buffer pool page gets since the last printout
  3475. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3476. LRU len: 71306, unzip_LRU len: 0
  3477. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3478. ---BUFFER POOL 30
  3479. Buffer pool size 98298
  3480. Free buffers 26186
  3481. Database pages 71785
  3482. Old database pages 26478
  3483. Modified db pages 0
  3484. Pending reads 0
  3485. Pending writes: LRU 0, flush list 0, single page 0
  3486. Pages made young 29209, not young 0
  3487. 0.00 youngs/s, 0.00 non-youngs/s
  3488. Pages read 68149, created 6903, written 7857
  3489. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3490. No buffer pool page gets since the last printout
  3491. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3492. LRU len: 71785, unzip_LRU len: 0
  3493. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3494. ---BUFFER POOL 31
  3495. Buffer pool size 98298
  3496. Free buffers 27321
  3497. Database pages 70665
  3498. Old database pages 26065
  3499. Modified db pages 0
  3500. Pending reads 0
  3501. Pending writes: LRU 0, flush list 0, single page 0
  3502. Pages made young 28870, not young 0
  3503. 0.00 youngs/s, 0.00 non-youngs/s
  3504. Pages read 66995, created 6746, written 7775
  3505. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3506. No buffer pool page gets since the last printout
  3507. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3508. LRU len: 70665, unzip_LRU len: 0
  3509. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3510. ---BUFFER POOL 32
  3511. Buffer pool size 98298
  3512. Free buffers 25902
  3513. Database pages 72062
  3514. Old database pages 26581
  3515. Modified db pages 0
  3516. Pending reads 0
  3517. Pending writes: LRU 0, flush list 0, single page 0
  3518. Pages made young 29567, not young 0
  3519. 0.00 youngs/s, 0.00 non-youngs/s
  3520. Pages read 68530, created 6793, written 7752
  3521. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3522. No buffer pool page gets since the last printout
  3523. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3524. LRU len: 72062, unzip_LRU len: 0
  3525. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3526. ---BUFFER POOL 33
  3527. Buffer pool size 98298
  3528. Free buffers 27140
  3529. Database pages 70832
  3530. Old database pages 26126
  3531. Modified db pages 0
  3532. Pending reads 0
  3533. Pending writes: LRU 0, flush list 0, single page 0
  3534. Pages made young 28760, not young 0
  3535. 0.00 youngs/s, 0.00 non-youngs/s
  3536. Pages read 67121, created 7112, written 7955
  3537. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3538. No buffer pool page gets since the last printout
  3539. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3540. LRU len: 70832, unzip_LRU len: 0
  3541. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3542. ---BUFFER POOL 34
  3543. Buffer pool size 98298
  3544. Free buffers 27966
  3545. Database pages 70002
  3546. Old database pages 25820
  3547. Modified db pages 0
  3548. Pending reads 0
  3549. Pending writes: LRU 0, flush list 0, single page 0
  3550. Pages made young 28390, not young 0
  3551. 0.00 youngs/s, 0.00 non-youngs/s
  3552. Pages read 66356, created 6976, written 7640
  3553. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3554. No buffer pool page gets since the last printout
  3555. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3556. LRU len: 70002, unzip_LRU len: 0
  3557. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3558. ---BUFFER POOL 35
  3559. Buffer pool size 98298
  3560. Free buffers 26866
  3561. Database pages 71107
  3562. Old database pages 26228
  3563. Modified db pages 0
  3564. Pending reads 0
  3565. Pending writes: LRU 0, flush list 0, single page 0
  3566. Pages made young 29027, not young 0
  3567. 0.00 youngs/s, 0.00 non-youngs/s
  3568. Pages read 67662, created 6736, written 7514
  3569. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3570. No buffer pool page gets since the last printout
  3571. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3572. LRU len: 71107, unzip_LRU len: 0
  3573. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3574. ---BUFFER POOL 36
  3575. Buffer pool size 98298
  3576. Free buffers 36404
  3577. Database pages 61573
  3578. Old database pages 22709
  3579. Modified db pages 0
  3580. Pending reads 0
  3581. Pending writes: LRU 0, flush list 0, single page 0
  3582. Pages made young 33646, not young 218387
  3583. 0.00 youngs/s, 0.00 non-youngs/s
  3584. Pages read 58211, created 6503, written 7184
  3585. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3586. No buffer pool page gets since the last printout
  3587. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3588. LRU len: 61573, unzip_LRU len: 0
  3589. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3590. ---BUFFER POOL 37
  3591. Buffer pool size 98298
  3592. Free buffers 26109
  3593. Database pages 71865
  3594. Old database pages 26508
  3595. Modified db pages 0
  3596. Pending reads 0
  3597. Pending writes: LRU 0, flush list 0, single page 0
  3598. Pages made young 46893, not young 161012
  3599. 0.00 youngs/s, 0.00 non-youngs/s
  3600. Pages read 68544, created 6653, written 7504
  3601. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3602. No buffer pool page gets since the last printout
  3603. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3604. LRU len: 71865, unzip_LRU len: 0
  3605. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3606. ---BUFFER POOL 38
  3607. Buffer pool size 98298
  3608. Free buffers 27721
  3609. Database pages 70242
  3610. Old database pages 25909
  3611. Modified db pages 0
  3612. Pending reads 0
  3613. Pending writes: LRU 0, flush list 0, single page 0
  3614. Pages made young 28086, not young 0
  3615. 0.00 youngs/s, 0.00 non-youngs/s
  3616. Pages read 66685, created 7065, written 7879
  3617. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3618. No buffer pool page gets since the last printout
  3619. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3620. LRU len: 70242, unzip_LRU len: 0
  3621. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3622. ---BUFFER POOL 39
  3623. Buffer pool size 98298
  3624. Free buffers 26661
  3625. Database pages 71307
  3626. Old database pages 26302
  3627. Modified db pages 0
  3628. Pending reads 0
  3629. Pending writes: LRU 0, flush list 0, single page 0
  3630. Pages made young 29267, not young 0
  3631. 0.00 youngs/s, 0.00 non-youngs/s
  3632. Pages read 67752, created 7033, written 7881
  3633. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3634. No buffer pool page gets since the last printout
  3635. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3636. LRU len: 71307, unzip_LRU len: 0
  3637. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3638. ---BUFFER POOL 40
  3639. Buffer pool size 98298
  3640. Free buffers 26818
  3641. Database pages 71146
  3642. Old database pages 26242
  3643. Modified db pages 0
  3644. Pending reads 0
  3645. Pending writes: LRU 0, flush list 0, single page 0
  3646. Pages made young 29153, not young 0
  3647. 0.00 youngs/s, 0.00 non-youngs/s
  3648. Pages read 67623, created 6984, written 7905
  3649. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3650. No buffer pool page gets since the last printout
  3651. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3652. LRU len: 71146, unzip_LRU len: 0
  3653. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3654. ---BUFFER POOL 41
  3655. Buffer pool size 98298
  3656. Free buffers 27125
  3657. Database pages 70849
  3658. Old database pages 26133
  3659. Modified db pages 0
  3660. Pending reads 0
  3661. Pending writes: LRU 0, flush list 0, single page 0
  3662. Pages made young 29027, not young 0
  3663. 0.00 youngs/s, 0.00 non-youngs/s
  3664. Pages read 67320, created 7104, written 8112
  3665. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3666. No buffer pool page gets since the last printout
  3667. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3668. LRU len: 70849, unzip_LRU len: 0
  3669. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3670. ---BUFFER POOL 42
  3671. Buffer pool size 98298
  3672. Free buffers 27009
  3673. Database pages 70961
  3674. Old database pages 26174
  3675. Modified db pages 0
  3676. Pending reads 0
  3677. Pending writes: LRU 0, flush list 0, single page 0
  3678. Pages made young 28949, not young 0
  3679. 0.00 youngs/s, 0.00 non-youngs/s
  3680. Pages read 67501, created 7009, written 8132
  3681. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3682. No buffer pool page gets since the last printout
  3683. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3684. LRU len: 70961, unzip_LRU len: 0
  3685. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3686. ---BUFFER POOL 43
  3687. Buffer pool size 98298
  3688. Free buffers 27262
  3689. Database pages 70712
  3690. Old database pages 26082
  3691. Modified db pages 0
  3692. Pending reads 0
  3693. Pending writes: LRU 0, flush list 0, single page 0
  3694. Pages made young 29102, not young 0
  3695. 0.00 youngs/s, 0.00 non-youngs/s
  3696. Pages read 67374, created 6862, written 7788
  3697. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3698. No buffer pool page gets since the last printout
  3699. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3700. LRU len: 70712, unzip_LRU len: 0
  3701. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3702. ---BUFFER POOL 44
  3703. Buffer pool size 98298
  3704. Free buffers 26726
  3705. Database pages 71239
  3706. Old database pages 26277
  3707. Modified db pages 0
  3708. Pending reads 0
  3709. Pending writes: LRU 0, flush list 0, single page 0
  3710. Pages made young 29326, not young 0
  3711. 0.00 youngs/s, 0.00 non-youngs/s
  3712. Pages read 67773, created 7117, written 7889
  3713. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3714. No buffer pool page gets since the last printout
  3715. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3716. LRU len: 71239, unzip_LRU len: 0
  3717. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3718. ---BUFFER POOL 45
  3719. Buffer pool size 98298
  3720. Free buffers 25084
  3721. Database pages 72900
  3722. Old database pages 26890
  3723. Modified db pages 0
  3724. Pending reads 0
  3725. Pending writes: LRU 0, flush list 0, single page 0
  3726. Pages made young 30353, not young 0
  3727. 0.00 youngs/s, 0.00 non-youngs/s
  3728. Pages read 69706, created 6727, written 7792
  3729. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3730. No buffer pool page gets since the last printout
  3731. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3732. LRU len: 72900, unzip_LRU len: 0
  3733. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3734. ---BUFFER POOL 46
  3735. Buffer pool size 98298
  3736. Free buffers 28089
  3737. Database pages 69885
  3738. Old database pages 25777
  3739. Modified db pages 0
  3740. Pending reads 0
  3741. Pending writes: LRU 0, flush list 0, single page 0
  3742. Pages made young 28196, not young 0
  3743. 0.00 youngs/s, 0.00 non-youngs/s
  3744. Pages read 66612, created 6827, written 7861
  3745. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3746. No buffer pool page gets since the last printout
  3747. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3748. LRU len: 69885, unzip_LRU len: 0
  3749. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3750. ---BUFFER POOL 47
  3751. Buffer pool size 98298
  3752. Free buffers 25422
  3753. Database pages 72544
  3754. Old database pages 26758
  3755. Modified db pages 0
  3756. Pending reads 0
  3757. Pending writes: LRU 0, flush list 0, single page 0
  3758. Pages made young 30378, not young 0
  3759. 0.00 youngs/s, 0.00 non-youngs/s
  3760. Pages read 69281, created 6661, written 7695
  3761. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3762. No buffer pool page gets since the last printout
  3763. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3764. LRU len: 72544, unzip_LRU len: 0
  3765. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3766. ---BUFFER POOL 48
  3767. Buffer pool size 98298
  3768. Free buffers 28030
  3769. Database pages 69940
  3770. Old database pages 25797
  3771. Modified db pages 0
  3772. Pending reads 0
  3773. Pending writes: LRU 0, flush list 0, single page 0
  3774. Pages made young 28324, not young 0
  3775. 0.00 youngs/s, 0.00 non-youngs/s
  3776. Pages read 66806, created 6433, written 7295
  3777. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3778. No buffer pool page gets since the last printout
  3779. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3780. LRU len: 69940, unzip_LRU len: 0
  3781. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3782. ---BUFFER POOL 49
  3783. Buffer pool size 98298
  3784. Free buffers 27287
  3785. Database pages 70681
  3786. Old database pages 26071
  3787. Modified db pages 0
  3788. Pending reads 0
  3789. Pending writes: LRU 0, flush list 0, single page 0
  3790. Pages made young 28819, not young 0
  3791. 0.00 youngs/s, 0.00 non-youngs/s
  3792. Pages read 67335, created 6833, written 7629
  3793. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3794. No buffer pool page gets since the last printout
  3795. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3796. LRU len: 70681, unzip_LRU len: 0
  3797. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3798. ---BUFFER POOL 50
  3799. Buffer pool size 98298
  3800. Free buffers 27233
  3801. Database pages 70745
  3802. Old database pages 26094
  3803. Modified db pages 0
  3804. Pending reads 0
  3805. Pending writes: LRU 0, flush list 0, single page 0
  3806. Pages made young 29288, not young 0
  3807. 0.00 youngs/s, 0.00 non-youngs/s
  3808. Pages read 67479, created 6923, written 7735
  3809. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3810. No buffer pool page gets since the last printout
  3811. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3812. LRU len: 70745, unzip_LRU len: 0
  3813. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3814. ---BUFFER POOL 51
  3815. Buffer pool size 98298
  3816. Free buffers 27616
  3817. Database pages 70363
  3818. Old database pages 25953
  3819. Modified db pages 0
  3820. Pending reads 0
  3821. Pending writes: LRU 0, flush list 0, single page 0
  3822. Pages made young 28583, not young 0
  3823. 0.00 youngs/s, 0.00 non-youngs/s
  3824. Pages read 67033, created 6712, written 7525
  3825. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3826. No buffer pool page gets since the last printout
  3827. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3828. LRU len: 70363, unzip_LRU len: 0
  3829. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3830. ---BUFFER POOL 52
  3831. Buffer pool size 98298
  3832. Free buffers 26789
  3833. Database pages 71177
  3834. Old database pages 26254
  3835. Modified db pages 0
  3836. Pending reads 0
  3837. Pending writes: LRU 0, flush list 0, single page 0
  3838. Pages made young 29241, not young 0
  3839. 0.00 youngs/s, 0.00 non-youngs/s
  3840. Pages read 67808, created 6847, written 7540
  3841. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3842. No buffer pool page gets since the last printout
  3843. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3844. LRU len: 71177, unzip_LRU len: 0
  3845. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3846. ---BUFFER POOL 53
  3847. Buffer pool size 98298
  3848. Free buffers 26123
  3849. Database pages 71846
  3850. Old database pages 26501
  3851. Modified db pages 0
  3852. Pending reads 0
  3853. Pending writes: LRU 0, flush list 0, single page 0
  3854. Pages made young 29761, not young 0
  3855. 0.00 youngs/s, 0.00 non-youngs/s
  3856. Pages read 68539, created 7019, written 8001
  3857. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3858. No buffer pool page gets since the last printout
  3859. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3860. LRU len: 71846, unzip_LRU len: 0
  3861. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3862. ---BUFFER POOL 54
  3863. Buffer pool size 98298
  3864. Free buffers 27798
  3865. Database pages 70182
  3866. Old database pages 25887
  3867. Modified db pages 0
  3868. Pending reads 0
  3869. Pending writes: LRU 0, flush list 0, single page 0
  3870. Pages made young 28639, not young 0
  3871. 0.00 youngs/s, 0.00 non-youngs/s
  3872. Pages read 66896, created 6746, written 7724
  3873. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3874. No buffer pool page gets since the last printout
  3875. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3876. LRU len: 70182, unzip_LRU len: 0
  3877. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3878. ---BUFFER POOL 55
  3879. Buffer pool size 98298
  3880. Free buffers 25667
  3881. Database pages 72302
  3882. Old database pages 26669
  3883. Modified db pages 0
  3884. Pending reads 0
  3885. Pending writes: LRU 0, flush list 0, single page 0
  3886. Pages made young 29906, not young 0
  3887. 0.00 youngs/s, 0.00 non-youngs/s
  3888. Pages read 68987, created 6866, written 7910
  3889. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3890. No buffer pool page gets since the last printout
  3891. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3892. LRU len: 72302, unzip_LRU len: 0
  3893. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3894. ---BUFFER POOL 56
  3895. Buffer pool size 98298
  3896. Free buffers 26036
  3897. Database pages 71938
  3898. Old database pages 26535
  3899. Modified db pages 0
  3900. Pending reads 0
  3901. Pending writes: LRU 0, flush list 0, single page 0
  3902. Pages made young 29416, not young 0
  3903. 0.00 youngs/s, 0.00 non-youngs/s
  3904. Pages read 68603, created 6909, written 7650
  3905. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3906. No buffer pool page gets since the last printout
  3907. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3908. LRU len: 71938, unzip_LRU len: 0
  3909. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3910. ---BUFFER POOL 57
  3911. Buffer pool size 98298
  3912. Free buffers 27280
  3913. Database pages 70690
  3914. Old database pages 26074
  3915. Modified db pages 0
  3916. Pending reads 0
  3917. Pending writes: LRU 0, flush list 0, single page 0
  3918. Pages made young 29029, not young 0
  3919. 0.00 youngs/s, 0.00 non-youngs/s
  3920. Pages read 67361, created 6723, written 7416
  3921. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3922. No buffer pool page gets since the last printout
  3923. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3924. LRU len: 70690, unzip_LRU len: 0
  3925. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3926. ---BUFFER POOL 58
  3927. Buffer pool size 98298
  3928. Free buffers 25403
  3929. Database pages 72579
  3930. Old database pages 26771
  3931. Modified db pages 0
  3932. Pending reads 0
  3933. Pending writes: LRU 0, flush list 0, single page 0
  3934. Pages made young 29914, not young 0
  3935. 0.00 youngs/s, 0.00 non-youngs/s
  3936. Pages read 69184, created 6918, written 7564
  3937. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3938. No buffer pool page gets since the last printout
  3939. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3940. LRU len: 72579, unzip_LRU len: 0
  3941. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3942. ---BUFFER POOL 59
  3943. Buffer pool size 98298
  3944. Free buffers 28548
  3945. Database pages 69426
  3946. Old database pages 25607
  3947. Modified db pages 0
  3948. Pending reads 0
  3949. Pending writes: LRU 0, flush list 0, single page 0
  3950. Pages made young 28124, not young 0
  3951. 0.00 youngs/s, 0.00 non-youngs/s
  3952. Pages read 66009, created 6945, written 7613
  3953. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3954. No buffer pool page gets since the last printout
  3955. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3956. LRU len: 69426, unzip_LRU len: 0
  3957. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3958. ---BUFFER POOL 60
  3959. Buffer pool size 98298
  3960. Free buffers 27037
  3961. Database pages 70936
  3962. Old database pages 26165
  3963. Modified db pages 0
  3964. Pending reads 0
  3965. Pending writes: LRU 0, flush list 0, single page 0
  3966. Pages made young 29066, not young 0
  3967. 0.00 youngs/s, 0.00 non-youngs/s
  3968. Pages read 67685, created 6713, written 7238
  3969. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3970. No buffer pool page gets since the last printout
  3971. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3972. LRU len: 70936, unzip_LRU len: 0
  3973. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3974. ---BUFFER POOL 61
  3975. Buffer pool size 98298
  3976. Free buffers 26027
  3977. Database pages 71954
  3978. Old database pages 26541
  3979. Modified db pages 0
  3980. Pending reads 0
  3981. Pending writes: LRU 0, flush list 0, single page 0
  3982. Pages made young 29809, not young 0
  3983. 0.00 youngs/s, 0.00 non-youngs/s
  3984. Pages read 68707, created 6438, written 6942
  3985. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  3986. No buffer pool page gets since the last printout
  3987. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  3988. LRU len: 71954, unzip_LRU len: 0
  3989. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  3990. ---BUFFER POOL 62
  3991. Buffer pool size 98298
  3992. Free buffers 27985
  3993. Database pages 69983
  3994. Old database pages 25813
  3995. Modified db pages 0
  3996. Pending reads 0
  3997. Pending writes: LRU 0, flush list 0, single page 0
  3998. Pages made young 28499, not young 0
  3999. 0.00 youngs/s, 0.00 non-youngs/s
  4000. Pages read 66540, created 6858, written 7395
  4001. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  4002. No buffer pool page gets since the last printout
  4003. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  4004. LRU len: 69983, unzip_LRU len: 0
  4005. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  4006. ---BUFFER POOL 63
  4007. Buffer pool size 98298
  4008. Free buffers 27316
  4009. Database pages 70645
  4010. Old database pages 26057
  4011. Modified db pages 0
  4012. Pending reads 0
  4013. Pending writes: LRU 0, flush list 0, single page 0
  4014. Pages made young 45116, not young 92287
  4015. 0.00 youngs/s, 0.00 non-youngs/s
  4016. Pages read 67273, created 6819, written 7363
  4017. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  4018. No buffer pool page gets since the last printout
  4019. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  4020. LRU len: 70645, unzip_LRU len: 0
  4021. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  4022. --------------
  4023. ROW OPERATIONS
  4024. --------------
  4025. 0 queries inside InnoDB, 0 queries in queue
  4026. 0 read views open inside InnoDB
  4027. Process ID=40993, Main thread ID=140491033351936, state: sleeping
  4028. Number of rows inserted 42895546, updated 260826, deleted 819021, read 42422942458
  4029. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  4030. ----------------------------
  4031. END OF INNODB MONITOR OUTPUT
  4032. ============================
  4033.  
  4034.  
  4035.  
  4036. =======================================================================================================================
  4037.  
  4038. H) htop OR top for most active app - I recored a video of HTOP activity, don't understand fully what should I do and sent.
  4039.  
  4040. https://streamable.com/akbpi6
  4041.  
  4042.  
  4043. =======================================================================================================================
  4044.  
  4045.  
  4046.  
  4047. I) ulimit -a for a Linux/Unix list of limits
  4048.  
  4049. $ ulimit -a
  4050. core file size (blocks, -c) 0
  4051. data seg size (kbytes, -d) unlimited
  4052. scheduling priority (-e) 0
  4053. file size (blocks, -f) unlimited
  4054. pending signals (-i) 513465
  4055. max locked memory (kbytes, -l) 65536
  4056. max memory size (kbytes, -m) unlimited
  4057. open files (-n) 1024
  4058. pipe size (512 bytes, -p) 8
  4059. POSIX message queues (bytes, -q) 819200
  4060. real-time priority (-r) 0
  4061. stack size (kbytes, -s) 8192
  4062. cpu time (seconds, -t) unlimited
  4063. max user processes (-u) 513465
  4064. virtual memory (kbytes, -v) unlimited
  4065. file locks (-x) unlimited
  4066.  
  4067.  
  4068.  
  4069. =======================================================================================================================
  4070.  
  4071.  
  4072. J) Iostat -xm 5 3 -> for IOPS by device and core/cpu count
  4073.  
  4074.  
  4075. https://i.imgur.com/2pO8h84.png
  4076.  
  4077.  
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!