API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2025
39
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 92.22 KB | None | 0 0
raw download clone embed print report
  1. SHOW GLOBAL STATUS
  2.  
  3. +-----------------------------------------------+-------------+
  4. | Variable_name | Value |
  5. +-----------------------------------------------+-------------+
  6. | Aborted_clients | 113 |
  7. | Aborted_connects | 63 |
  8. | Binlog_cache_disk_use | 0 |
  9. | Binlog_cache_use | 0 |
  10. | Binlog_stmt_cache_disk_use | 0 |
  11. | Binlog_stmt_cache_use | 0 |
  12. | Bytes_received | 673544622 |
  13. | Bytes_sent | 1453336888 |
  14. | Com_admin_commands | 119 |
  15. | Com_assign_to_keycache | 0 |
  16. | Com_alter_db | 0 |
  17. | Com_alter_db_upgrade | 0 |
  18. | Com_alter_event | 0 |
  19. | Com_alter_function | 0 |
  20. | Com_alter_procedure | 0 |
  21. | Com_alter_server | 0 |
  22. | Com_alter_table | 21 |
  23. | Com_alter_tablespace | 0 |
  24. | Com_alter_user | 0 |
  25. | Com_analyze | 0 |
  26. | Com_begin | 4666 |
  27. | Com_binlog | 0 |
  28. | Com_call_procedure | 11233 |
  29. | Com_change_db | 5331 |
  30. | Com_change_master | 0 |
  31. | Com_check | 0 |
  32. | Com_checksum | 0 |
  33. | Com_commit | 4657 |
  34. | Com_create_db | 0 |
  35. | Com_create_event | 0 |
  36. | Com_create_function | 0 |
  37. | Com_create_index | 0 |
  38. | Com_create_procedure | 0 |
  39. | Com_create_server | 0 |
  40. | Com_create_table | 41181 |
  41. | Com_create_trigger | 0 |
  42. | Com_create_udf | 0 |
  43. | Com_create_user | 0 |
  44. | Com_create_view | 0 |
  45. | Com_dealloc_sql | 245 |
  46. | Com_delete | 8300 |
  47. | Com_delete_multi | 165 |
  48. | Com_do | 0 |
  49. | Com_drop_db | 0 |
  50. | Com_drop_event | 0 |
  51. | Com_drop_function | 0 |
  52. | Com_drop_index | 0 |
  53. | Com_drop_procedure | 0 |
  54. | Com_drop_server | 0 |
  55. | Com_drop_table | 43215 |
  56. | Com_drop_trigger | 0 |
  57. | Com_drop_user | 0 |
  58. | Com_drop_view | 0 |
  59. | Com_empty_query | 0 |
  60. | Com_execute_sql | 295 |
  61. | Com_flush | 1 |
  62. | Com_get_diagnostics | 0 |
  63. | Com_grant | 0 |
  64. | Com_ha_close | 0 |
  65. | Com_ha_open | 0 |
  66. | Com_ha_read | 0 |
  67. | Com_help | 0 |
  68. | Com_insert | 31957 |
  69. | Com_insert_select | 32956 |
  70. | Com_install_plugin | 0 |
  71. | Com_kill | 0 |
  72. | Com_load | 0 |
  73. | Com_lock_tables | 0 |
  74. | Com_optimize | 50 |
  75. | Com_preload_keys | 0 |
  76. | Com_prepare_sql | 295 |
  77. | Com_purge | 0 |
  78. | Com_purge_before_date | 0 |
  79. | Com_release_savepoint | 0 |
  80. | Com_rename_table | 0 |
  81. | Com_rename_user | 0 |
  82. | Com_repair | 0 |
  83. | Com_replace | 0 |
  84. | Com_replace_select | 8 |
  85. | Com_reset | 0 |
  86. | Com_resignal | 0 |
  87. | Com_revoke | 0 |
  88. | Com_revoke_all | 0 |
  89. | Com_rollback | 2 |
  90. | Com_rollback_to_savepoint | 0 |
  91. | Com_savepoint | 0 |
  92. | Com_select | 204924 |
  93. | Com_set_option | 50214 |
  94. | Com_signal | 0 |
  95. | Com_show_binlog_events | 0 |
  96. | Com_show_binlogs | 0 |
  97. | Com_show_charsets | 0 |
  98. | Com_show_collations | 0 |
  99. | Com_show_create_db | 0 |
  100. | Com_show_create_event | 0 |
  101. | Com_show_create_func | 0 |
  102. | Com_show_create_proc | 0 |
  103. | Com_show_create_table | 1 |
  104. | Com_show_create_trigger | 0 |
  105. | Com_show_databases | 3 |
  106. | Com_show_engine_logs | 0 |
  107. | Com_show_engine_mutex | 0 |
  108. | Com_show_engine_status | 1 |
  109. | Com_show_events | 0 |
  110. | Com_show_errors | 0 |
  111. | Com_show_fields | 70 |
  112. | Com_show_function_code | 0 |
  113. | Com_show_function_status | 0 |
  114. | Com_show_grants | 0 |
  115. | Com_show_keys | 0 |
  116. | Com_show_master_status | 0 |
  117. | Com_show_open_tables | 0 |
  118. | Com_show_plugins | 0 |
  119. | Com_show_privileges | 0 |
  120. | Com_show_procedure_code | 0 |
  121. | Com_show_procedure_status | 0 |
  122. | Com_show_processlist | 1 |
  123. | Com_show_profile | 0 |
  124. | Com_show_profiles | 0 |
  125. | Com_show_relaylog_events | 0 |
  126. | Com_show_slave_hosts | 0 |
  127. | Com_show_slave_status | 0 |
  128. | Com_show_status | 7072 |
  129. | Com_show_storage_engines | 0 |
  130. | Com_show_table_status | 0 |
  131. | Com_show_tables | 2 |
  132. | Com_show_triggers | 0 |
  133. | Com_show_variables | 9 |
  134. | Com_show_warnings | 0 |
  135. | Com_slave_start | 0 |
  136. | Com_slave_stop | 0 |
  137. | Com_stmt_close | 271 |
  138. | Com_stmt_execute | 295 |
  139. | Com_stmt_fetch | 0 |
  140. | Com_stmt_prepare | 295 |
  141. | Com_stmt_reprepare | 0 |
  142. | Com_stmt_reset | 0 |
  143. | Com_stmt_send_long_data | 0 |
  144. | Com_truncate | 2 |
  145. | Com_uninstall_plugin | 0 |
  146. | Com_unlock_tables | 0 |
  147. | Com_update | 1035916 |
  148. | Com_update_multi | 6540 |
  149. | Com_xa_commit | 0 |
  150. | Com_xa_end | 0 |
  151. | Com_xa_prepare | 0 |
  152. | Com_xa_recover | 0 |
  153. | Com_xa_rollback | 0 |
  154. | Com_xa_start | 0 |
  155. | Compression | OFF |
  156. | Connection_errors_accept | 0 |
  157. | Connection_errors_internal | 0 |
  158. | Connection_errors_max_connections | 0 |
  159. | Connection_errors_peer_address | 0 |
  160. | Connection_errors_select | 0 |
  161. | Connection_errors_tcpwrap | 0 |
  162. | Connections | 32933 |
  163. | Created_tmp_disk_tables | 7529 |
  164. | Created_tmp_files | 116 |
  165. | Created_tmp_tables | 60603 |
  166. | Delayed_errors | 0 |
  167. | Delayed_insert_threads | 0 |
  168. | Delayed_writes | 0 |
  169. | Flush_commands | 2 |
  170. | Handler_commit | 1231260 |
  171. | Handler_delete | 25604 |
  172. | Handler_discover | 0 |
  173. | Handler_external_lock | 14386602 |
  174. | Handler_mrr_init | 0 |
  175. | Handler_prepare | 0 |
  176. | Handler_read_first | 67841 |
  177. | Handler_read_key | 47053548 |
  178. | Handler_read_last | 251 |
  179. | Handler_read_next | 173424298 |
  180. | Handler_read_prev | 24022 |
  181. | Handler_read_rnd | 4443243 |
  182. | Handler_read_rnd_next | 183345206 |
  183. | Handler_rollback | 5 |
  184. | Handler_savepoint | 0 |
  185. | Handler_savepoint_rollback | 0 |
  186. | Handler_update | 2456590 |
  187. | Handler_write | 47072341 |
  188. | Innodb_buffer_pool_dump_status | not started |
  189. | Innodb_buffer_pool_load_status | not started |
  190. | Innodb_buffer_pool_pages_data | 111909 |
  191. | Innodb_buffer_pool_bytes_data | 1833517056 |
  192. | Innodb_buffer_pool_pages_dirty | 642 |
  193. | Innodb_buffer_pool_bytes_dirty | 10518528 |
  194. | Innodb_buffer_pool_pages_flushed | 222186 |
  195. | Innodb_buffer_pool_pages_free | 8198 |
  196. | Innodb_buffer_pool_pages_misc | 10957 |
  197. | Innodb_buffer_pool_pages_total | 131064 |
  198. | Innodb_buffer_pool_read_ahead_rnd | 0 |
  199. | Innodb_buffer_pool_read_ahead | 73973 |
  200. | Innodb_buffer_pool_read_ahead_evicted | 0 |
  201. | Innodb_buffer_pool_read_requests | 599879788 |
  202. | Innodb_buffer_pool_reads | 161430 |
  203. | Innodb_buffer_pool_wait_free | 0 |
  204. | Innodb_buffer_pool_write_requests | 6862707 |
  205. | Innodb_data_fsyncs | 51903 |
  206. | Innodb_data_pending_fsyncs | 0 |
  207. | Innodb_data_pending_reads | 0 |
  208. | Innodb_data_pending_writes | 0 |
  209. | Innodb_data_read | 3933949952 |
  210. | Innodb_data_reads | 244725 |
  211. | Innodb_data_writes | 1305521 |
  212. | Innodb_data_written | 8379636224 |
  213. | Innodb_dblwr_pages_written | 222186 |
  214. | Innodb_dblwr_writes | 10931 |
  215. | Innodb_have_atomic_builtins | ON |
  216. | Innodb_log_waits | 0 |
  217. | Innodb_log_write_requests | 1208170 |
  218. | Innodb_log_writes | 1069478 |
  219. | Innodb_os_log_fsyncs | 7050 |
  220. | Innodb_os_log_pending_fsyncs | 0 |
  221. | Innodb_os_log_pending_writes | 0 |
  222. | Innodb_os_log_written | 1098661376 |
  223. | Innodb_page_size | 16384 |
  224. | Innodb_pages_created | 8680 |
  225. | Innodb_pages_read | 240104 |
  226. | Innodb_pages_written | 222186 |
  227. | Innodb_row_lock_current_waits | 0 |
  228. | Innodb_row_lock_time | 0 |
  229. | Innodb_row_lock_time_avg | 0 |
  230. | Innodb_row_lock_time_max | 0 |
  231. | Innodb_row_lock_waits | 0 |
  232. | Innodb_rows_deleted | 23733 |
  233. | Innodb_rows_inserted | 82862 |
  234. | Innodb_rows_read | 346137698 |
  235. | Innodb_rows_updated | 1090766 |
  236. | Innodb_num_open_files | 1024 |
  237. | Innodb_truncated_status_writes | 0 |
  238. | Innodb_available_undo_logs | 128 |
  239. | Key_blocks_not_flushed | 0 |
  240. | Key_blocks_unused | 26616 |
  241. | Key_blocks_used | 787 |
  242. | Key_read_requests | 1897161 |
  243. | Key_reads | 34306 |
  244. | Key_write_requests | 629383 |
  245. | Key_writes | 874 |
  246. | Last_query_cost | 0.000000 |
  247. | Last_query_partial_plans | 0 |
  248. | Max_used_connections | 26 |
  249. | Not_flushed_delayed_rows | 0 |
  250. | Open_files | 14 |
  251. | Open_streams | 0 |
  252. | Open_table_definitions | 928 |
  253. | Open_tables | 1024 |
  254. | Opened_files | 568968 |
  255. | Opened_table_definitions | 132490 |
  256. | Opened_tables | 511715 |
  257. | Performance_schema_accounts_lost | 0 |
  258. | Performance_schema_cond_classes_lost | 0 |
  259. | Performance_schema_cond_instances_lost | 0 |
  260. | Performance_schema_digest_lost | 0 |
  261. | Performance_schema_file_classes_lost | 0 |
  262. | Performance_schema_file_handles_lost | 0 |
  263. | Performance_schema_file_instances_lost | 0 |
  264. | Performance_schema_hosts_lost | 0 |
  265. | Performance_schema_locker_lost | 0 |
  266. | Performance_schema_mutex_classes_lost | 0 |
  267. | Performance_schema_mutex_instances_lost | 0 |
  268. | Performance_schema_rwlock_classes_lost | 0 |
  269. | Performance_schema_rwlock_instances_lost | 0 |
  270. | Performance_schema_session_connect_attrs_lost | 0 |
  271. | Performance_schema_socket_classes_lost | 0 |
  272. | Performance_schema_socket_instances_lost | 0 |
  273. | Performance_schema_stage_classes_lost | 0 |
  274. | Performance_schema_statement_classes_lost | 0 |
  275. | Performance_schema_table_handles_lost | 8729 |
  276. | Performance_schema_table_instances_lost | 0 |
  277. | Performance_schema_thread_classes_lost | 0 |
  278. | Performance_schema_thread_instances_lost | 0 |
  279. | Performance_schema_users_lost | 0 |
  280. | Prepared_stmt_count | 0 |
  281. | Qcache_free_blocks | 35 |
  282. | Qcache_free_memory | 194348312 |
  283. | Qcache_hits | 342999 |
  284. | Qcache_inserts | 88965 |
  285. | Qcache_lowmem_prunes | 0 |
  286. | Qcache_not_cached | 47680 |
  287. | Qcache_queries_in_cache | 5572 |
  288. | Qcache_total_blocks | 12002 |
  289. | Queries | 7521828 |
  290. | Questions | 1624254 |
  291. | Rsa_public_key | |
  292. | Select_full_join | 23371 |
  293. | Select_full_range_join | 823 |
  294. | Select_range | 23704 |
  295. | Select_range_check | 104 |
  296. | Select_scan | 49675 |
  297. | Slave_heartbeat_period | |
  298. | Slave_last_heartbeat | |
  299. | Slave_open_temp_tables | 0 |
  300. | Slave_received_heartbeats | |
  301. | Slave_retried_transactions | |
  302. | Slave_running | OFF |
  303. | Slow_launch_threads | 0 |
  304. | Slow_queries | 2 |
  305. | Sort_merge_passes | 35 |
  306. | Sort_range | 46866 |
  307. | Sort_rows | 4788206 |
  308. | Sort_scan | 41244 |
  309. | Ssl_accept_renegotiates | 0 |
  310. | Ssl_accepts | 0 |
  311. | Ssl_callback_cache_hits | 0 |
  312. | Ssl_cipher | |
  313. | Ssl_cipher_list | |
  314. | Ssl_client_connects | 0 |
  315. | Ssl_connect_renegotiates | 0 |
  316. | Ssl_ctx_verify_depth | 0 |
  317. | Ssl_ctx_verify_mode | 0 |
  318. | Ssl_default_timeout | 0 |
  319. | Ssl_finished_accepts | 0 |
  320. | Ssl_finished_connects | 0 |
  321. | Ssl_server_not_after | |
  322. | Ssl_server_not_before | |
  323. | Ssl_session_cache_hits | 0 |
  324. | Ssl_session_cache_misses | 0 |
  325. | Ssl_session_cache_mode | NONE |
  326. | Ssl_session_cache_overflows | 0 |
  327. | Ssl_session_cache_size | 0 |
  328. | Ssl_session_cache_timeouts | 0 |
  329. | Ssl_sessions_reused | 0 |
  330. | Ssl_used_session_cache_entries | 0 |
  331. | Ssl_verify_depth | 0 |
  332. | Ssl_verify_mode | 0 |
  333. | Ssl_version | |
  334. | Table_locks_immediate | 7188619 |
  335. | Table_locks_waited | 0 |
  336. | Table_open_cache_hits | 6712695 |
  337. | Table_open_cache_misses | 470571 |
  338. | Table_open_cache_overflows | 468384 |
  339. | Tc_log_max_pages_used | 0 |
  340. | Tc_log_page_size | 0 |
  341. | Tc_log_page_waits | 0 |
  342. | Threads_cached | 24 |
  343. | Threads_connected | 2 |
  344. | Threads_created | 26 |
  345. | Threads_running | 1 |
  346. | Uptime | 7324 |
  347. | Uptime_since_flush_status | 7324 |
  348. +-----------------------------------------------+-------------+
  349.  
  350. SHOW VARIABLES :
  351.  
  352. +--------------------------------------------------------+----------------------------------------------------------------------------+
  353. | Variable_name | Value |
  354. +--------------------------------------------------------+----------------------------------------------------------------------------+
  355. | auto_increment_increment | 1 |
  356. | auto_increment_offset | 1 |
  357. | autocommit | ON |
  358. | automatic_sp_privileges | ON |
  359. | avoid_temporal_upgrade | OFF |
  360. | back_log | 80 |
  361. | basedir | /usr/ |
  362. | big_tables | OFF |
  363. | bind_address | 127.0.0.1 |
  364. | binlog_cache_size | 32768 |
  365. | binlog_checksum | CRC32 |
  366. | binlog_direct_non_transactional_updates | OFF |
  367. | binlog_error_action | IGNORE_ERROR |
  368. | binlog_format | STATEMENT |
  369. | binlog_gtid_simple_recovery | OFF |
  370. | binlog_max_flush_queue_time | 0 |
  371. | binlog_order_commits | ON |
  372. | binlog_row_image | FULL |
  373. | binlog_rows_query_log_events | OFF |
  374. | binlog_stmt_cache_size | 32768 |
  375. | binlogging_impossible_mode | IGNORE_ERROR |
  376. | block_encryption_mode | aes-128-ecb |
  377. | bulk_insert_buffer_size | 67108864 |
  378. | character_set_client | utf8 |
  379. | character_set_connection | utf8 |
  380. | character_set_database | latin1 |
  381. | character_set_filesystem | binary |
  382. | character_set_results | utf8 |
  383. | character_set_server | latin1 |
  384. | character_set_system | utf8 |
  385. | character_sets_dir | /usr/share/mysql/charsets/ |
  386. | collation_connection | utf8_general_ci |
  387. | collation_database | latin1_swedish_ci |
  388. | collation_server | latin1_swedish_ci |
  389. | completion_type | NO_CHAIN |
  390. | concurrent_insert | AUTO |
  391. | connect_timeout | 10 |
  392. | core_file | OFF |
  393. | datadir | /var/lib/mysql/ |
  394. | date_format | %Y-%m-%d |
  395. | datetime_format | %Y-%m-%d %H:%i:%s |
  396. | default_storage_engine | InnoDB |
  397. | default_tmp_storage_engine | InnoDB |
  398. | default_week_format | 0 |
  399. | delay_key_write | ON |
  400. | delayed_insert_limit | 100 |
  401. | delayed_insert_timeout | 300 |
  402. | delayed_queue_size | 1000 |
  403. | disconnect_on_expired_password | ON |
  404. | div_precision_increment | 4 |
  405. | end_markers_in_json | OFF |
  406. | enforce_gtid_consistency | OFF |
  407. | eq_range_index_dive_limit | 10 |
  408. | error_count | 0 |
  409. | event_scheduler | OFF |
  410. | expire_logs_days | 0 |
  411. | explicit_defaults_for_timestamp | OFF |
  412. | external_user | |
  413. | flush | OFF |
  414. | flush_time | 0 |
  415. | foreign_key_checks | ON |
  416. | ft_boolean_syntax | + -><()~*:""&| |
  417. | ft_max_word_len | 84 |
  418. | ft_min_word_len | 4 |
  419. | ft_query_expansion_limit | 20 |
  420. | ft_stopword_file | (built-in) |
  421. | general_log | OFF |
  422. | general_log_file | /var/lib/mysql/srv03.log |
  423. | group_concat_max_len | 1024 |
  424. | gtid_executed | |
  425. | gtid_mode | OFF |
  426. | gtid_next | AUTOMATIC |
  427. | gtid_owned | |
  428. | gtid_purged | |
  429. | have_compress | YES |
  430. | have_crypt | YES |
  431. | have_dynamic_loading | YES |
  432. | have_geometry | YES |
  433. | have_openssl | DISABLED |
  434. | have_profiling | YES |
  435. | have_query_cache | YES |
  436. | have_rtree_keys | YES |
  437. | have_ssl | DISABLED |
  438. | have_symlink | DISABLED |
  439. | host_cache_size | 279 |
  440. | identity | 0 |
  441. | ignore_builtin_innodb | OFF |
  442. | ignore_db_dirs | |
  443. | init_connect | |
  444. | init_file | |
  445. | init_slave | |
  446. | innodb_adaptive_flushing | ON |
  447. | innodb_adaptive_flushing_lwm | 10 |
  448. | innodb_adaptive_hash_index | ON |
  449. | innodb_adaptive_max_sleep_delay | 150000 |
  450. | innodb_additional_mem_pool_size | 16777216 |
  451. | innodb_api_bk_commit_interval | 5 |
  452. | innodb_api_disable_rowlock | OFF |
  453. | innodb_api_enable_binlog | OFF |
  454. | innodb_api_enable_mdl | OFF |
  455. | innodb_api_trx_level | 0 |
  456. | innodb_autoextend_increment | 64 |
  457. | innodb_autoinc_lock_mode | 1 |
  458. | innodb_buffer_pool_dump_at_shutdown | OFF |
  459. | innodb_buffer_pool_dump_now | OFF |
  460. | innodb_buffer_pool_filename | ib_buffer_pool |
  461. | innodb_buffer_pool_instances | 8 |
  462. | innodb_buffer_pool_load_abort | OFF |
  463. | innodb_buffer_pool_load_at_startup | OFF |
  464. | innodb_buffer_pool_load_now | OFF |
  465. | innodb_buffer_pool_size | 2147483648 |
  466. | innodb_change_buffer_max_size | 25 |
  467. | innodb_change_buffering | all |
  468. | innodb_checksum_algorithm | innodb |
  469. | innodb_checksums | ON |
  470. | innodb_cmp_per_index_enabled | OFF |
  471. | innodb_commit_concurrency | 0 |
  472. | innodb_compression_failure_threshold_pct | 5 |
  473. | innodb_compression_level | 6 |
  474. | innodb_compression_pad_pct_max | 50 |
  475. | innodb_concurrency_tickets | 5000 |
  476. | innodb_data_file_path | ibdata1:12M:autoextend |
  477. | innodb_data_home_dir | |
  478. | innodb_disable_sort_file_cache | OFF |
  479. | innodb_doublewrite | ON |
  480. | innodb_fast_shutdown | 1 |
  481. | innodb_file_format | Antelope |
  482. | innodb_file_format_check | ON |
  483. | innodb_file_format_max | Antelope |
  484. | innodb_file_per_table | ON |
  485. | innodb_flush_log_at_timeout | 1 |
  486. | innodb_flush_log_at_trx_commit | 2 |
  487. | innodb_flush_method | |
  488. | innodb_flush_neighbors | 1 |
  489. | innodb_flushing_avg_loops | 30 |
  490. | innodb_force_load_corrupted | OFF |
  491. | innodb_force_recovery | 0 |
  492. | innodb_ft_aux_table | |
  493. | innodb_ft_cache_size | 8000000 |
  494. | innodb_ft_enable_diag_print | OFF |
  495. | innodb_ft_enable_stopword | ON |
  496. | innodb_ft_max_token_size | 84 |
  497. | innodb_ft_min_token_size | 3 |
  498. | innodb_ft_num_word_optimize | 2000 |
  499. | innodb_ft_result_cache_limit | 2000000000 |
  500. | innodb_ft_server_stopword_table | |
  501. | innodb_ft_sort_pll_degree | 2 |
  502. | innodb_ft_total_cache_size | 640000000 |
  503. | innodb_ft_user_stopword_table | |
  504. | innodb_io_capacity | 200 |
  505. | innodb_io_capacity_max | 2000 |
  506. | innodb_large_prefix | OFF |
  507. | innodb_lock_wait_timeout | 50 |
  508. | innodb_locks_unsafe_for_binlog | OFF |
  509. | innodb_log_buffer_size | 16777216 |
  510. | innodb_log_compressed_pages | ON |
  511. | innodb_log_file_size | 524288000 |
  512. | innodb_log_files_in_group | 2 |
  513. | innodb_log_group_home_dir | ./ |
  514. | innodb_lru_scan_depth | 1024 |
  515. | innodb_max_dirty_pages_pct | 75 |
  516. | innodb_max_dirty_pages_pct_lwm | 0 |
  517. | innodb_max_purge_lag | 0 |
  518. | innodb_max_purge_lag_delay | 0 |
  519. | innodb_mirrored_log_groups | 1 |
  520. | innodb_monitor_disable | |
  521. | innodb_monitor_enable | |
  522. | innodb_monitor_reset | |
  523. | innodb_monitor_reset_all | |
  524. | innodb_numa_interleave | OFF |
  525. | innodb_old_blocks_pct | 37 |
  526. | innodb_old_blocks_time | 1000 |
  527. | innodb_online_alter_log_max_size | 134217728 |
  528. | innodb_open_files | 1024 |
  529. | innodb_optimize_fulltext_only | OFF |
  530. | innodb_page_size | 16384 |
  531. | innodb_print_all_deadlocks | OFF |
  532. | innodb_purge_batch_size | 300 |
  533. | innodb_purge_threads | 1 |
  534. | innodb_random_read_ahead | OFF |
  535. | innodb_read_ahead_threshold | 56 |
  536. | innodb_read_io_threads | 4 |
  537. | innodb_read_only | OFF |
  538. | innodb_replication_delay | 0 |
  539. | innodb_rollback_on_timeout | OFF |
  540. | innodb_rollback_segments | 128 |
  541. | innodb_sort_buffer_size | 1048576 |
  542. | innodb_spin_wait_delay | 6 |
  543. | innodb_stats_auto_recalc | ON |
  544. | innodb_stats_include_delete_marked | OFF |
  545. | innodb_stats_method | nulls_equal |
  546. | innodb_stats_on_metadata | OFF |
  547. | innodb_stats_persistent | ON |
  548. | innodb_stats_persistent_sample_pages | 20 |
  549. | innodb_stats_sample_pages | 8 |
  550. | innodb_stats_transient_sample_pages | 8 |
  551. | innodb_status_output | OFF |
  552. | innodb_status_output_locks | OFF |
  553. | innodb_strict_mode | OFF |
  554. | innodb_support_xa | ON |
  555. | innodb_sync_array_size | 1 |
  556. | innodb_sync_spin_loops | 30 |
  557. | innodb_table_locks | ON |
  558. | innodb_thread_concurrency | 2 |
  559. | innodb_thread_sleep_delay | 0 |
  560. | innodb_tmpdir | |
  561. | innodb_undo_directory | . |
  562. | innodb_undo_logs | 128 |
  563. | innodb_undo_tablespaces | 0 |
  564. | innodb_use_native_aio | ON |
  565. | innodb_use_sys_malloc | ON |
  566. | innodb_version | 5.6.51 |
  567. | innodb_write_io_threads | 4 |
  568. | insert_id | 0 |
  569. | interactive_timeout | 28800 |
  570. | join_buffer_size | 8388608 |
  571. | keep_files_on_create | OFF |
  572. | key_buffer_size | 33554432 |
  573. | key_cache_age_threshold | 300 |
  574. | key_cache_block_size | 1024 |
  575. | key_cache_division_limit | 100 |
  576. | large_files_support | ON |
  577. | large_page_size | 0 |
  578. | large_pages | OFF |
  579. | last_insert_id | 0 |
  580. | lc_messages | en_US |
  581. | lc_messages_dir | /usr/share/mysql/ |
  582. | lc_time_names | en_US |
  583. | license | GPL |
  584. | local_infile | ON |
  585. | lock_wait_timeout | 31536000 |
  586. | locked_in_memory | OFF |
  587. | log_bin | OFF |
  588. | log_bin_basename | |
  589. | log_bin_index | |
  590. | log_bin_trust_function_creators | OFF |
  591. | log_bin_use_v1_row_events | OFF |
  592. | log_error | /var/log/mysqld.log |
  593. | log_output | FILE |
  594. | log_queries_not_using_indexes | OFF |
  595. | log_slave_updates | OFF |
  596. | log_slow_admin_statements | OFF |
  597. | log_slow_slave_statements | OFF |
  598. | log_throttle_queries_not_using_indexes | 0 |
  599. | log_warnings | 1 |
  600. | long_query_time | 10.000000 |
  601. | low_priority_updates | OFF |
  602. | lower_case_file_system | OFF |
  603. | lower_case_table_names | 0 |
  604. | master_info_repository | FILE |
  605. | master_verify_checksum | OFF |
  606. | max_allowed_packet | 134217728 |
  607. | max_binlog_cache_size | 18446744073709547520 |
  608. | max_binlog_size | 1073741824 |
  609. | max_binlog_stmt_cache_size | 18446744073709547520 |
  610. | max_connect_errors | 10 |
  611. | max_connections | 151 |
  612. | max_delayed_threads | 20 |
  613. | max_digest_length | 1024 |
  614. | max_error_count | 64 |
  615. | max_heap_table_size | 67108864 |
  616. | max_insert_delayed_threads | 20 |
  617. | max_join_size | 18446744073709551615 |
  618. | max_length_for_sort_data | 1024 |
  619. | max_prepared_stmt_count | 16382 |
  620. | max_relay_log_size | 0 |
  621. | max_seeks_for_key | 18446744073709551615 |
  622. | max_sort_length | 1024 |
  623. | max_sp_recursion_depth | 0 |
  624. | max_tmp_tables | 32 |
  625. | max_user_connections | 0 |
  626. | max_write_lock_count | 18446744073709551615 |
  627. | metadata_locks_cache_size | 1024 |
  628. | metadata_locks_hash_instances | 8 |
  629. | min_examined_row_limit | 0 |
  630. | multi_range_count | 256 |
  631. | myisam_data_pointer_size | 6 |
  632. | myisam_max_sort_file_size | 10737418240 |
  633. | myisam_mmap_size | 18446744073709551615 |
  634. | myisam_recover_options | OFF |
  635. | myisam_repair_threads | 1 |
  636. | myisam_sort_buffer_size | 134217728 |
  637. | myisam_stats_method | nulls_unequal |
  638. | myisam_use_mmap | OFF |
  639. | net_buffer_length | 16384 |
  640. | net_read_timeout | 30 |
  641. | net_retry_count | 10 |
  642. | net_write_timeout | 60 |
  643. | new | OFF |
  644. | old | OFF |
  645. | old_alter_table | OFF |
  646. | old_passwords | 0 |
  647. | open_files_limit | 65500 |
  648. | optimizer_prune_level | 1 |
  649. | optimizer_search_depth | 62 |
  650. | optimizer_trace | enabled=off,one_line=off |
  651. | optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
  652. | optimizer_trace_limit | 1 |
  653. | optimizer_trace_max_mem_size | 16384 |
  654. | optimizer_trace_offset | -1 |
  655. | performance_schema | ON |
  656. | performance_schema_accounts_size | 100 |
  657. | performance_schema_digests_size | 10000 |
  658. | performance_schema_events_stages_history_long_size | 10000 |
  659. | performance_schema_events_stages_history_size | 10 |
  660. | performance_schema_events_statements_history_long_size | 10000 |
  661. | performance_schema_events_statements_history_size | 10 |
  662. | performance_schema_events_waits_history_long_size | 10000 |
  663. | performance_schema_events_waits_history_size | 10 |
  664. | performance_schema_hosts_size | 100 |
  665. | performance_schema_max_cond_classes | 80 |
  666. | performance_schema_max_cond_instances | 2528 |
  667. | performance_schema_max_digest_length | 1024 |
  668. | performance_schema_max_file_classes | 50 |
  669. | performance_schema_max_file_handles | 32768 |
  670. | performance_schema_max_file_instances | 100770 |
  671. | performance_schema_max_mutex_classes | 200 |
  672. | performance_schema_max_mutex_instances | 11026 |
  673. | performance_schema_max_rwlock_classes | 40 |
  674. | performance_schema_max_rwlock_instances | 6174 |
  675. | performance_schema_max_socket_classes | 10 |
  676. | performance_schema_max_socket_instances | 322 |
  677. | performance_schema_max_stage_classes | 150 |
  678. | performance_schema_max_statement_classes | 168 |
  679. | performance_schema_max_table_handles | 2048 |
  680. | performance_schema_max_table_instances | 12500 |
  681. | performance_schema_max_thread_classes | 50 |
  682. | performance_schema_max_thread_instances | 402 |
  683. | performance_schema_session_connect_attrs_size | 512 |
  684. | performance_schema_setup_actors_size | 100 |
  685. | performance_schema_setup_objects_size | 100 |
  686. | performance_schema_users_size | 100 |
  687. | pid_file | /var/run/mysqld/mysqld.pid |
  688. | plugin_dir | /usr/lib64/mysql/plugin/ |
  689. | port | 3306 |
  690. | preload_buffer_size | 32768 |
  691. | profiling | OFF |
  692. | profiling_history_size | 15 |
  693. | protocol_version | 10 |
  694. | proxy_user | |
  695. | pseudo_slave_mode | OFF |
  696. | pseudo_thread_id | 32880 |
  697. | query_alloc_block_size | 8192 |
  698. | query_cache_limit | 52428800 |
  699. | query_cache_min_res_unit | 4096 |
  700. | query_cache_size | 209715200 |
  701. | query_cache_type | ON |
  702. | query_cache_wlock_invalidate | OFF |
  703. | query_prealloc_size | 8192 |
  704. | rand_seed1 | 0 |
  705. | rand_seed2 | 0 |
  706. | range_alloc_block_size | 4096 |
  707. | read_buffer_size | 2097152 |
  708. | read_only | OFF |
  709. | read_rnd_buffer_size | 16777216 |
  710. | relay_log | |
  711. | relay_log_basename | |
  712. | relay_log_index | |
  713. | relay_log_info_file | relay-log.info |
  714. | relay_log_info_repository | FILE |
  715. | relay_log_purge | ON |
  716. | relay_log_recovery | OFF |
  717. | relay_log_space_limit | 0 |
  718. | report_host | |
  719. | report_password | |
  720. | report_port | 3306 |
  721. | report_user | |
  722. | rpl_stop_slave_timeout | 31536000 |
  723. | secure_auth | ON |
  724. | secure_file_priv | |
  725. | server_id | 0 |
  726. | server_id_bits | 32 |
  727. | server_uuid | 39b3d150-f6c3-11eb-b69e-0025904cd510 |
  728. | sha256_password_private_key_path | private_key.pem |
  729. | sha256_password_public_key_path | public_key.pem |
  730. | show_old_temporals | OFF |
  731. | simplified_binlog_gtid_recovery | OFF |
  732. | skip_external_locking | ON |
  733. | skip_name_resolve | OFF |
  734. | skip_networking | OFF |
  735. | skip_show_database | OFF |
  736. | slave_allow_batching | OFF |
  737. | slave_checkpoint_group | 512 |
  738. | slave_checkpoint_period | 300 |
  739. | slave_compressed_protocol | OFF |
  740. | slave_exec_mode | STRICT |
  741. | slave_load_tmpdir | /tmp |
  742. | slave_max_allowed_packet | 1073741824 |
  743. | slave_net_timeout | 3600 |
  744. | slave_parallel_workers | 0 |
  745. | slave_pending_jobs_size_max | 16777216 |
  746. | slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN |
  747. | slave_skip_errors | OFF |
  748. | slave_sql_verify_checksum | ON |
  749. | slave_transaction_retries | 10 |
  750. | slave_type_conversions | |
  751. | slow_launch_time | 2 |
  752. | slow_query_log | OFF |
  753. | slow_query_log_file | /var/lib/mysql/srv03-slow.log |
  754. | socket | /var/lib/mysql/mysql.sock |
  755. | sort_buffer_size | 8388608 |
  756. | sql_auto_is_null | OFF |
  757. | sql_big_selects | ON |
  758. | sql_buffer_result | OFF |
  759. | sql_log_bin | ON |
  760. | sql_log_off | OFF |
  761. | sql_mode | NO_ENGINE_SUBSTITUTION |
  762. | sql_notes | ON |
  763. | sql_quote_show_create | ON |
  764. | sql_safe_updates | OFF |
  765. | sql_select_limit | 18446744073709551615 |
  766. | sql_slave_skip_counter | 0 |
  767. | sql_warnings | OFF |
  768. | ssl_ca | |
  769. | ssl_capath | |
  770. | ssl_cert | |
  771. | ssl_cipher | |
  772. | ssl_crl | |
  773. | ssl_crlpath | |
  774. | ssl_key | |
  775. | storage_engine | InnoDB |
  776. | stored_program_cache | 256 |
  777. | sync_binlog | 0 |
  778. | sync_frm | ON |
  779. | sync_master_info | 10000 |
  780. | sync_relay_log | 10000 |
  781. | sync_relay_log_info | 10000 |
  782. | system_time_zone | CET |
  783. | table_definition_cache | 912 |
  784. | table_open_cache | 1024 |
  785. | table_open_cache_instances | 1 |
  786. | thread_cache_size | 32 |
  787. | thread_concurrency | 8 |
  788. | thread_handling | one-thread-per-connection |
  789. | thread_stack | 262144 |
  790. | time_format | %H:%i:%s |
  791. | time_zone | SYSTEM |
  792. | timed_mutexes | OFF |
  793. | timestamp | 1737633507.922229 |
  794. | tmp_table_size | 67108864 |
  795. | tmpdir | /tmp |
  796. | transaction_alloc_block_size | 8192 |
  797. | transaction_allow_batching | OFF |
  798. | transaction_prealloc_size | 4096 |
  799. | tx_isolation | REPEATABLE-READ |
  800. | tx_read_only | OFF |
  801. | unique_checks | ON |
  802. | updatable_views_with_limit | YES |
  803. | version | 5.6.51 |
  804. | version_comment | MySQL Community Server (GPL) |
  805. | version_compile_machine | x86_64 |
  806. | version_compile_os | Linux |
  807. | wait_timeout | 28800 |
  808. | warning_count | 0 |
  809. +--------------------------------------------------------+----------------------------------------------------------------------------+
  810.  
  811.  
  812. SHOW ENGINE INNODB STATUS :
  813.  
  814. =====================================
  815. 2025-01-23 12:51:00 7fb8a08dc700 INNODB MONITOR OUTPUT
  816. =====================================
  817. Per second averages calculated from the last 28 seconds
  818. -----------------
  819. BACKGROUND THREAD
  820. -----------------
  821. srv_master_thread loops: 5864 srv_active, 0 srv_shutdown, 1488 srv_idle
  822. srv_master_thread log flush and writes: 7352
  823. ----------
  824. SEMAPHORES
  825. ----------
  826. OS WAIT ARRAY INFO: reservation count 14293
  827. OS WAIT ARRAY INFO: signal count 32184
  828. Mutex spin waits 119146, rounds 436256, OS waits 8873
  829. RW-shared spins 10199, rounds 142901, OS waits 3580
  830. RW-excl spins 3196, rounds 85957, OS waits 1340
  831. Spin rounds per wait: 3.66 mutex, 14.01 RW-shared, 26.90 RW-excl
  832. ------------
  833. TRANSACTIONS
  834. ------------
  835. Trx id counter 22285876561
  836. Purge done for trx's n:o < 22285876561 undo n:o < 0 state: running but idle
  837. History list length 3227
  838. LIST OF TRANSACTIONS FOR EACH SESSION:
  839. ---TRANSACTION 0, not started
  840. MySQL thread id 32880, OS thread handle 0x7fb8a08dc700, query id 7646066 localhost root init
  841. show engine innodb status
  842. ---TRANSACTION 22285876559, not started
  843. MySQL thread id 33048, OS thread handle 0x7fb8a3f53700, query id 7646041 localhost 127.0.0.1 redacted_db_name
  844. --------
  845. FILE I/O
  846. --------
  847. I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
  848. I/O thread 1 state: waiting for completed aio requests (log thread)
  849. I/O thread 2 state: waiting for completed aio requests (read thread)
  850. I/O thread 3 state: waiting for completed aio requests (read thread)
  851. I/O thread 4 state: waiting for completed aio requests (read thread)
  852. I/O thread 5 state: waiting for completed aio requests (read thread)
  853. I/O thread 6 state: waiting for completed aio requests (write thread)
  854. I/O thread 7 state: waiting for completed aio requests (write thread)
  855. I/O thread 8 state: waiting for completed aio requests (write thread)
  856. I/O thread 9 state: waiting for completed aio requests (write thread)
  857. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  858. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  859. Pending flushes (fsync) log: 0; buffer pool: 0
  860. 244725 OS file reads, 1318582 OS file writes, 52009 OS fsyncs
  861. 0.00 reads/s, 0 avg bytes/read, 25.71 writes/s, 0.96 fsyncs/s
  862. -------------------------------------
  863. INSERT BUFFER AND ADAPTIVE HASH INDEX
  864. -------------------------------------
  865. Ibuf: size 1, free list len 3540, seg size 3542, 5394 merges
  866. merged operations:
  867. insert 12254, delete mark 1529, delete 199
  868. discarded operations:
  869. insert 0, delete mark 0, delete 0
  870. Hash table size 4730647, node heap has 10957 buffer(s)
  871. 507.16 hash searches/s, 218.85 non-hash searches/s
  872. ---
  873. LOG
  874. ---
  875. Log sequence number 5629968036779
  876. Log flushed up to 5629968032952
  877. Pages flushed up to 5629962950758
  878. Last checkpoint at 5629962950758
  879. 0 pending log writes, 0 pending chkp writes
  880. 1083294 log i/o's done, 25.71 log i/o's/second
  881. ----------------------
  882. BUFFER POOL AND MEMORY
  883. ----------------------
  884. Total memory allocated 2197815296; in additional pool allocated 0
  885. Dictionary memory allocated 415664739
  886. Buffer pool size 131064
  887. Free buffers 8198
  888. Database pages 111909
  889. Old database pages 41147
  890. Modified db pages 3086
  891. Pending reads 0
  892. Pending writes: LRU 0, flush list 0, single page 0
  893. Pages made young 266415, not young 18997025
  894. 0.89 youngs/s, 0.00 non-youngs/s
  895. Pages read 240104, created 8680, written 222186
  896. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  897. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  898. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  899. LRU len: 111909, unzip_LRU len: 0
  900. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  901. ----------------------
  902. INDIVIDUAL BUFFER POOL INFO
  903. ----------------------
  904. ---BUFFER POOL 0
  905. Buffer pool size 16383
  906. Free buffers 1024
  907. Database pages 13983
  908. Old database pages 5141
  909. Modified db pages 654
  910. Pending reads 0
  911. Pending writes: LRU 0, flush list 0, single page 0
  912. Pages made young 32763, not young 2338248
  913. 0.00 youngs/s, 0.00 non-youngs/s
  914. Pages read 30349, created 1450, written 52677
  915. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  916. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  917. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  918. LRU len: 13983, unzip_LRU len: 0
  919. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  920. ---BUFFER POOL 1
  921. Buffer pool size 16383
  922. Free buffers 1029
  923. Database pages 13972
  924. Old database pages 5138
  925. Modified db pages 415
  926. Pending reads 0
  927. Pending writes: LRU 0, flush list 0, single page 0
  928. Pages made young 37157, not young 2543897
  929. 0.00 youngs/s, 0.00 non-youngs/s
  930. Pages read 32724, created 978, written 19148
  931. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  932. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  933. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  934. LRU len: 13972, unzip_LRU len: 0
  935. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  936. ---BUFFER POOL 2
  937. Buffer pool size 16383
  938. Free buffers 1024
  939. Database pages 13988
  940. Old database pages 5143
  941. Modified db pages 291
  942. Pending reads 0
  943. Pending writes: LRU 0, flush list 0, single page 0
  944. Pages made young 25463, not young 1595592
  945. 0.89 youngs/s, 0.00 non-youngs/s
  946. Pages read 30121, created 1002, written 16484
  947. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  948. Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 0 / 1000
  949. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  950. LRU len: 13988, unzip_LRU len: 0
  951. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  952. ---BUFFER POOL 3
  953. Buffer pool size 16383
  954. Free buffers 1024
  955. Database pages 13984
  956. Old database pages 5142
  957. Modified db pages 351
  958. Pending reads 0
  959. Pending writes: LRU 0, flush list 0, single page 0
  960. Pages made young 26121, not young 1867401
  961. 0.00 youngs/s, 0.00 non-youngs/s
  962. Pages read 30437, created 1156, written 34792
  963. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  964. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  965. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  966. LRU len: 13984, unzip_LRU len: 0
  967. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  968. ---BUFFER POOL 4
  969. Buffer pool size 16383
  970. Free buffers 1024
  971. Database pages 13994
  972. Old database pages 5145
  973. Modified db pages 420
  974. Pending reads 0
  975. Pending writes: LRU 0, flush list 0, single page 0
  976. Pages made young 37411, not young 1994613
  977. 0.00 youngs/s, 0.00 non-youngs/s
  978. Pages read 27885, created 1000, written 31131
  979. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  980. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  981. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  982. LRU len: 13994, unzip_LRU len: 0
  983. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  984. ---BUFFER POOL 5
  985. Buffer pool size 16383
  986. Free buffers 1024
  987. Database pages 13989
  988. Old database pages 5143
  989. Modified db pages 337
  990. Pending reads 0
  991. Pending writes: LRU 0, flush list 0, single page 0
  992. Pages made young 35494, not young 1976610
  993. 0.00 youngs/s, 0.00 non-youngs/s
  994. Pages read 28581, created 1075, written 22831
  995. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  996. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  997. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  998. LRU len: 13989, unzip_LRU len: 0
  999. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1000. ---BUFFER POOL 6
  1001. Buffer pool size 16383
  1002. Free buffers 1024
  1003. Database pages 14003
  1004. Old database pages 5149
  1005. Modified db pages 299
  1006. Pending reads 0
  1007. Pending writes: LRU 0, flush list 0, single page 0
  1008. Pages made young 35320, not young 3037136
  1009. 0.00 youngs/s, 0.00 non-youngs/s
  1010. Pages read 28581, created 1057, written 25865
  1011. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1012. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1013. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1014. LRU len: 14003, unzip_LRU len: 0
  1015. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1016. ---BUFFER POOL 7
  1017. Buffer pool size 16383
  1018. Free buffers 1025
  1019. Database pages 13996
  1020. Old database pages 5146
  1021. Modified db pages 319
  1022. Pending reads 0
  1023. Pending writes: LRU 0, flush list 0, single page 0
  1024. Pages made young 36686, not young 3643528
  1025. 0.00 youngs/s, 0.00 non-youngs/s
  1026. Pages read 31426, created 962, written 19258
  1027. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  1028. Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
  1029. Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
  1030. LRU len: 13996, unzip_LRU len: 0
  1031. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  1032. --------------
  1033. ROW OPERATIONS
  1034. --------------
  1035. 0 queries inside InnoDB, 0 queries in queue
  1036. 0 read views open inside InnoDB
  1037. Main thread process no. 2685192, id 140431039944448, state: sleeping
  1038. Number of rows inserted 82862, updated 1103721, deleted 23733, read 348534965
  1039. 0.00 inserts/s, 24.75 updates/s, 0.00 deletes/s, 1357.99 reads/s
  1040. ----------------------------
  1041. END OF INNODB MONITOR OUTPUT
  1042. ============================
  1043.  
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!