API tools faq
paste
Guest User

Untitled

a guest
Sep 26th, 2023
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.49 KB | None | 0 0
raw download clone embed print report
  1. SELECT name, count FROM information_schema.innodb_metrics ORDER BY name;
  2.  
  3. +---------------------------------------------+-------------+
  4. | name | count |
  5. +---------------------------------------------+-------------+
  6. | adaptive_hash_pages_added | 0 |
  7. | adaptive_hash_pages_removed | 0 |
  8. | adaptive_hash_rows_added | 0 |
  9. | adaptive_hash_rows_deleted_no_hash_entry | 0 |
  10. | adaptive_hash_rows_removed | 0 |
  11. | adaptive_hash_rows_updated | 0 |
  12. | adaptive_hash_searches | 138179548 |
  13. | adaptive_hash_searches_btree | 7565338 |
  14. | buffer_data_reads | 59771904 |
  15. | buffer_data_written | 185424896 |
  16. | buffer_flush_adaptive | 0 |
  17. | buffer_flush_adaptive_avg_pass | 0 |
  18. | buffer_flush_adaptive_avg_time_est | 0 |
  19. | buffer_flush_adaptive_avg_time_slot | 0 |
  20. | buffer_flush_adaptive_avg_time_thread | 0 |
  21. | buffer_flush_adaptive_pages | 0 |
  22. | buffer_flush_adaptive_total_pages | 0 |
  23. | buffer_flush_avg_page_rate | 0 |
  24. | buffer_flush_avg_pass | 0 |
  25. | buffer_flush_avg_time | 0 |
  26. | buffer_flush_background | 0 |
  27. | buffer_flush_background_pages | 0 |
  28. | buffer_flush_background_total_pages | 0 |
  29. | buffer_flush_batches | 0 |
  30. | buffer_flush_batch_num_scan | 0 |
  31. | buffer_flush_batch_pages | 0 |
  32. | buffer_flush_batch_scanned | 0 |
  33. | buffer_flush_batch_scanned_per_call | 0 |
  34. | buffer_flush_batch_total_pages | 0 |
  35. | buffer_flush_lsn_avg_rate | 0 |
  36. | buffer_flush_neighbor | 0 |
  37. | buffer_flush_neighbor_pages | 0 |
  38. | buffer_flush_neighbor_total_pages | 0 |
  39. | buffer_flush_n_to_flush_by_age | 0 |
  40. | buffer_flush_n_to_flush_by_dirty_page | 0 |
  41. | buffer_flush_n_to_flush_requested | 0 |
  42. | buffer_flush_pct_for_dirty | 0 |
  43. | buffer_flush_pct_for_lsn | 0 |
  44. | buffer_flush_sync | 0 |
  45. | buffer_flush_sync_pages | 0 |
  46. | buffer_flush_sync_total_pages | 0 |
  47. | buffer_flush_sync_waits | 0 |
  48. | buffer_LRU_batches_evict | 0 |
  49. | buffer_LRU_batches_flush | 0 |
  50. | buffer_LRU_batch_evict_pages | 0 |
  51. | buffer_LRU_batch_evict_total_pages | 0 |
  52. | buffer_LRU_batch_flush_avg_pass | 0 |
  53. | buffer_LRU_batch_flush_avg_time_est | 0 |
  54. | buffer_LRU_batch_flush_avg_time_slot | 0 |
  55. | buffer_LRU_batch_flush_avg_time_thread | 0 |
  56. | buffer_LRU_batch_flush_pages | 0 |
  57. | buffer_LRU_batch_flush_total_pages | 0 |
  58. | buffer_LRU_batch_num_scan | 0 |
  59. | buffer_LRU_batch_scanned | 0 |
  60. | buffer_LRU_batch_scanned_per_call | 0 |
  61. | buffer_LRU_get_free_loops | 0 |
  62. | buffer_LRU_get_free_search | 0 |
  63. | buffer_LRU_get_free_waits | 0 |
  64. | buffer_LRU_search_num_scan | 0 |
  65. | buffer_LRU_search_scanned | 0 |
  66. | buffer_LRU_search_scanned_per_call | 0 |
  67. | buffer_LRU_single_flush_failure_count | 0 |
  68. | buffer_LRU_single_flush_num_scan | 0 |
  69. | buffer_LRU_single_flush_scanned | 0 |
  70. | buffer_LRU_single_flush_scanned_per_call | 0 |
  71. | buffer_LRU_unzip_search_num_scan | 0 |
  72. | buffer_LRU_unzip_search_scanned | 0 |
  73. | buffer_LRU_unzip_search_scanned_per_call | 0 |
  74. | buffer_pages_created | 228 |
  75. | buffer_pages_read | 3643 |
  76. | buffer_pages_written | 10761 |
  77. | buffer_page_read_blob | 0 |
  78. | buffer_page_read_fsp_hdr | 0 |
  79. | buffer_page_read_ibuf_bitmap | 0 |
  80. | buffer_page_read_ibuf_free_list | 0 |
  81. | buffer_page_read_index_ibuf_leaf | 0 |
  82. | buffer_page_read_index_ibuf_non_leaf | 0 |
  83. | buffer_page_read_index_inode | 0 |
  84. | buffer_page_read_index_leaf | 0 |
  85. | buffer_page_read_index_non_leaf | 0 |
  86. | buffer_page_read_other | 0 |
  87. | buffer_page_read_rseg_array | 0 |
  88. | buffer_page_read_system_page | 0 |
  89. | buffer_page_read_trx_system | 0 |
  90. | buffer_page_read_undo_log | 0 |
  91. | buffer_page_read_xdes | 0 |
  92. | buffer_page_read_zblob | 0 |
  93. | buffer_page_read_zblob2 | 0 |
  94. | buffer_page_written_blob | 0 |
  95. | buffer_page_written_fsp_hdr | 0 |
  96. | buffer_page_written_ibuf_bitmap | 0 |
  97. | buffer_page_written_ibuf_free_list | 0 |
  98. | buffer_page_written_index_ibuf_leaf | 0 |
  99. | buffer_page_written_index_ibuf_non_leaf | 0 |
  100. | buffer_page_written_index_inode | 0 |
  101. | buffer_page_written_index_leaf | 0 |
  102. | buffer_page_written_index_non_leaf | 0 |
  103. | buffer_page_written_on_log_no_waits | 0 |
  104. | buffer_page_written_on_log_waits | 0 |
  105. | buffer_page_written_on_log_wait_loops | 0 |
  106. | buffer_page_written_other | 0 |
  107. | buffer_page_written_rseg_array | 0 |
  108. | buffer_page_written_system_page | 0 |
  109. | buffer_page_written_trx_system | 0 |
  110. | buffer_page_written_undo_log | 0 |
  111. | buffer_page_written_xdes | 0 |
  112. | buffer_page_written_zblob | 0 |
  113. | buffer_page_written_zblob2 | 0 |
  114. | buffer_pool_bytes_data | 63422464 |
  115. | buffer_pool_bytes_dirty | 0 |
  116. | buffer_pool_pages_data | 3871 |
  117. | buffer_pool_pages_dirty | 0 |
  118. | buffer_pool_pages_free | 782452 |
  119. | buffer_pool_pages_misc | 109 |
  120. | buffer_pool_pages_total | 786432 |
  121. | buffer_pool_reads | 3561 |
  122. | buffer_pool_read_ahead | 0 |
  123. | buffer_pool_read_ahead_evicted | 0 |
  124. | buffer_pool_read_requests | 447983385 |
  125. | buffer_pool_size | 12884901888 |
  126. | buffer_pool_wait_free | 0 |
  127. | buffer_pool_write_requests | 39551 |
  128. | compression_pad_decrements | 0 |
  129. | compression_pad_increments | 0 |
  130. | compress_pages_compressed | 0 |
  131. | compress_pages_decompressed | 0 |
  132. | cpu_n | 0 |
  133. | cpu_stime_abs | 0 |
  134. | cpu_stime_pct | 0 |
  135. | cpu_utime_abs | 0 |
  136. | cpu_utime_pct | 0 |
  137. | dblwr_async_requests | 0 |
  138. | dblwr_flush_requests | 0 |
  139. | dblwr_flush_wait_events | 0 |
  140. | dblwr_sync_requests | 0 |
  141. | ddl_background_drop_tables | 0 |
  142. | ddl_log_file_alter_table | 0 |
  143. | ddl_online_create_index | 0 |
  144. | ddl_pending_alter_table | 0 |
  145. | ddl_sort_file_alter_table | 0 |
  146. | dml_deletes | 0 |
  147. | dml_inserts | 555 |
  148. | dml_reads | 0 |
  149. | dml_system_deletes | 8 |
  150. | dml_system_inserts | 8 |
  151. | dml_system_reads | 14227 |
  152. | dml_system_updates | 331 |
  153. | dml_updates | 1966 |
  154. | file_num_open_files | 38 |
  155. | ibuf_merges | 83 |
  156. | ibuf_merges_delete | 0 |
  157. | ibuf_merges_delete_mark | 0 |
  158. | ibuf_merges_discard_delete | 0 |
  159. | ibuf_merges_discard_delete_mark | 0 |
  160. | ibuf_merges_discard_insert | 0 |
  161. | ibuf_merges_insert | 112 |
  162. | ibuf_size | 1 |
  163. | icp_attempts | 0 |
  164. | icp_match | 0 |
  165. | icp_no_match | 0 |
  166. | icp_out_of_range | 0 |
  167. | index_page_discards | 0 |
  168. | index_page_merge_attempts | 0 |
  169. | index_page_merge_successful | 0 |
  170. | index_page_reorg_attempts | 0 |
  171. | index_page_reorg_successful | 0 |
  172. | index_page_splits | 0 |
  173. | innodb_activity_count | 2544 |
  174. | innodb_background_drop_table_usec | 0 |
  175. | innodb_dblwr_pages_written | 10620 |
  176. | innodb_dblwr_writes | 3345 |
  177. | innodb_dict_lru_count | 0 |
  178. | innodb_dict_lru_usec | 0 |
  179. | innodb_ibuf_merge_usec | 0 |
  180. | innodb_master_active_loops | 0 |
  181. | innodb_master_idle_loops | 0 |
  182. | innodb_master_purge_usec | 0 |
  183. | innodb_master_thread_sleeps | 0 |
  184. | innodb_mem_validate_usec | 0 |
  185. | innodb_page_size | 16384 |
  186. | innodb_rwlock_sx_os_waits | 0 |
  187. | innodb_rwlock_sx_spin_rounds | 0 |
  188. | innodb_rwlock_sx_spin_waits | 0 |
  189. | innodb_rwlock_s_os_waits | 0 |
  190. | innodb_rwlock_s_spin_rounds | 0 |
  191. | innodb_rwlock_s_spin_waits | 0 |
  192. | innodb_rwlock_x_os_waits | 0 |
  193. | innodb_rwlock_x_spin_rounds | 0 |
  194. | innodb_rwlock_x_spin_waits | 0 |
  195. | lock_deadlocks | 0 |
  196. | lock_deadlock_false_positives | 0 |
  197. | lock_deadlock_rounds | 6897 |
  198. | lock_rec_grant_attempts | 0 |
  199. | lock_rec_locks | 0 |
  200. | lock_rec_lock_created | 0 |
  201. | lock_rec_lock_removed | 0 |
  202. | lock_rec_lock_requests | 0 |
  203. | lock_rec_lock_waits | 0 |
  204. | lock_rec_release_attempts | 2473 |
  205. | lock_row_lock_current_waits | 0 |
  206. | lock_row_lock_time | 0 |
  207. | lock_row_lock_time_avg | 0 |
  208. | lock_row_lock_time_max | 0 |
  209. | lock_row_lock_waits | 0 |
  210. | lock_schedule_refreshes | 6897 |
  211. | lock_table_locks | 0 |
  212. | lock_table_lock_created | 0 |
  213. | lock_table_lock_removed | 0 |
  214. | lock_table_lock_waits | 0 |
  215. | lock_threads_waiting | 0 |
  216. | lock_timeouts | 0 |
  217. | log_checkpoints | 0 |
  218. | log_concurrency_margin | 0 |
  219. | log_flusher_no_waits | 0 |
  220. | log_flusher_waits | 0 |
  221. | log_flusher_wait_loops | 0 |
  222. | log_flush_avg_time | 0 |
  223. | log_flush_lsn_avg_rate | 0 |
  224. | log_flush_max_time | 0 |
  225. | log_flush_notifier_no_waits | 0 |
  226. | log_flush_notifier_waits | 0 |
  227. | log_flush_notifier_wait_loops | 0 |
  228. | log_flush_total_time | 0 |
  229. | log_free_space | 0 |
  230. | log_full_block_writes | 0 |
  231. | log_lsn_archived | 0 |
  232. | log_lsn_buf_dirty_pages_added | 0 |
  233. | log_lsn_buf_pool_oldest_approx | 0 |
  234. | log_lsn_buf_pool_oldest_lwm | 0 |
  235. | log_lsn_checkpoint_age | 0 |
  236. | log_lsn_current | 0 |
  237. | log_lsn_last_checkpoint | 0 |
  238. | log_lsn_last_flush | 0 |
  239. | log_max_modified_age_async | 0 |
  240. | log_max_modified_age_sync | 0 |
  241. | log_next_file | 0 |
  242. | log_on_buffer_space_no_waits | 0 |
  243. | log_on_buffer_space_waits | 0 |
  244. | log_on_buffer_space_wait_loops | 0 |
  245. | log_on_file_space_no_waits | 0 |
  246. | log_on_file_space_waits | 0 |
  247. | log_on_file_space_wait_loops | 0 |
  248. | log_on_flush_no_waits | 0 |
  249. | log_on_flush_waits | 0 |
  250. | log_on_flush_wait_loops | 0 |
  251. | log_on_recent_closed_wait_loops | 0 |
  252. | log_on_recent_written_wait_loops | 0 |
  253. | log_on_write_no_waits | 0 |
  254. | log_on_write_waits | 0 |
  255. | log_on_write_wait_loops | 0 |
  256. | log_padded | 0 |
  257. | log_partial_block_writes | 0 |
  258. | log_waits | 0 |
  259. | log_writer_no_waits | 0 |
  260. | log_writer_on_archiver_waits | 0 |
  261. | log_writer_on_file_space_waits | 0 |
  262. | log_writer_waits | 0 |
  263. | log_writer_wait_loops | 0 |
  264. | log_writes | 8316 |
  265. | log_write_notifier_no_waits | 0 |
  266. | log_write_notifier_waits | 0 |
  267. | log_write_notifier_wait_loops | 0 |
  268. | log_write_requests | 30310 |
  269. | log_write_to_file_requests_interval | 0 |
  270. | metadata_table_handles_closed | 0 |
  271. | metadata_table_handles_opened | 0 |
  272. | metadata_table_reference_count | 0 |
  273. | module_cpu | 0 |
  274. | module_dblwr | 0 |
  275. | module_page_track | 0 |
  276. | os_data_fsyncs | 9201 |
  277. | os_data_reads | 3711 |
  278. | os_data_writes | 22636 |
  279. | os_log_bytes_written | 6438912 |
  280. | os_log_fsyncs | 746 |
  281. | os_log_pending_fsyncs | 0 |
  282. | os_log_pending_writes | 0 |
  283. | os_pending_reads | 0 |
  284. | os_pending_writes | 0 |
  285. | page_track_checkpoint_partial_flush_request | 0 |
  286. | page_track_full_block_writes | 0 |
  287. | page_track_partial_block_writes | 0 |
  288. | page_track_resets | 0 |
  289. | purge_del_mark_records | 0 |
  290. | purge_dml_delay_usec | 0 |
  291. | purge_invoked | 0 |
  292. | purge_resume_count | 0 |
  293. | purge_stop_count | 0 |
  294. | purge_truncate_history_count | 0 |
  295. | purge_truncate_history_usec | 0 |
  296. | purge_undo_log_pages | 0 |
  297. | purge_upd_exist_or_extern_records | 0 |
  298. | sampled_pages_read | 0 |
  299. | sampled_pages_skipped | 0 |
  300. | trx_active_transactions | 0 |
  301. | trx_allocations | 0 |
  302. | trx_commits_insert_update | 0 |
  303. | trx_nl_ro_commits | 0 |
  304. | trx_on_log_no_waits | 0 |
  305. | trx_on_log_waits | 0 |
  306. | trx_on_log_wait_loops | 0 |
  307. | trx_rollbacks | 0 |
  308. | trx_rollbacks_savepoint | 0 |
  309. | trx_rollback_active | 0 |
  310. | trx_ro_commits | 0 |
  311. | trx_rseg_current_size | 0 |
  312. | trx_rseg_history_len | 16 |
  313. | trx_rw_commits | 0 |
  314. | trx_undo_slots_cached | 0 |
  315. | trx_undo_slots_used | 0 |
  316. | undo_truncate_count | 0 |
  317. | undo_truncate_done_logging_count | 0 |
  318. | undo_truncate_start_logging_count | 0 |
  319. | undo_truncate_usec | 0 |
  320. +---------------------------------------------+-------------+
  321. 314 rows in set (0.01 sec)
  322.  
  323. MySQL-Tuner output:
  324.  
  325. -------- Storage Engine Statistics -----------------------------------------------------------------
  326. [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA
  327. [--] Data in InnoDB tables: 9.7G (Tables: 1172)
  328. [--] Data in MyISAM tables: 110.8M (Tables: 29)
  329. [--] Data in MEMORY tables: 0B (Tables: 1)
  330. [OK] Total fragmented tables: 0
  331.  
  332. [OK] Currently running supported MySQL version 8.0.34-0ubuntu0.22.04.1
  333.  
  334. -------- Log file Recommendations ------------------------------------------------------------------
  335. [OK] Log file /var/log/mysql/error.log exists
  336. [--] Log file: /var/log/mysql/error.log (1M)
  337. [OK] Log file /var/log/mysql/error.log is not empty
  338. [OK] Log file /var/log/mysql/error.log is smaller than 32 MB
  339. [!!] Log file /var/log/mysql/error.log isn't readable.
  340.  
  341. -------- Analysis Performance Metrics --------------------------------------------------------------
  342. [--] innodb_stats_on_metadata: OFF
  343. [OK] No stat updates during querying INFORMATION_SCHEMA.
  344.  
  345. -------- Views Metrics -----------------------------------------------------------------------------
  346.  
  347. -------- Triggers Metrics --------------------------------------------------------------------------
  348.  
  349. -------- Routines Metrics --------------------------------------------------------------------------
  350.  
  351. -------- Security Recommendations ------------------------------------------------------------------
  352. [--] Skipped due to unsupported feature for MySQL 8.0+
  353.  
  354. -------- CVE Security Recommendations --------------------------------------------------------------
  355. [OK] NO SECURITY CVE FOUND FOR YOUR VERSION
  356.  
  357. -------- Performance Metrics -----------------------------------------------------------------------
  358. [--] Up for: 1h 57m 45s (57K q [8.074 qps], 145 conn, TX: 33M, RX: 6M)
  359. [--] Reads / Writes: 49% / 51%
  360. [--] Binary logging is enabled (GTID MODE: OFF)
  361. [--] Physical Memory : 23.4G
  362. [--] Max MySQL memory : 12.5G
  363. [--] Other process memory: 0B
  364. [--] Total buffers: 12.1G global + 1.9M per thread (100 max threads)
  365. [--] Performance_schema Max memory usage: 227M
  366. [--] Galera GCache Max memory usage: 0B
  367. [OK] Maximum reached memory usage: 12.3G (52.57% of installed RAM)
  368. [OK] Maximum possible memory usage: 12.5G (53.32% of installed RAM)
  369. [OK] Overall possible memory usage with other process is compatible with memory available
  370. [OK] Slow queries: 0% (0/57K)
  371. [OK] Highest usage of available connections: 5% (5/100)
  372. [OK] Aborted connections: 0.69% (1/145)
  373. [--] Query cache has been removed since MySQL 8.0
  374. [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1K sorts)
  375. [OK] No joins without indexes
  376. [OK] Temporary tables created on disk: 0% (0 on disk / 11 total)
  377. [OK] Thread cache hit rate: 96% (5 created / 145 connections)
  378. [OK] Table cache hit rate: 99% (67K hits / 67K requests)
  379. [OK] table_definition_cache (4096) is greater than number of tables (1571)
  380. [OK] Open file limit used: 0% (2/10K)
  381. [OK] Table locks acquired immediately: 100% (4 immediate / 4 locks)
  382. [OK] Binlog cache memory access: 99.96% (2406 Memory / 2407 Total)
  383.  
  384. -------- Performance schema ------------------------------------------------------------------------
  385. [--] Performance_schema is activated.
  386. [--] Memory used by Performance_schema: 227.9M
  387. [--] Sys schema is installed.
  388.  
  389. -------- ThreadPool Metrics ------------------------------------------------------------------------
  390. [--] ThreadPool stat is disabled.
  391.  
  392. -------- MyISAM Metrics ----------------------------------------------------------------------------
  393. [!!] Consider migrating 29 followning tables to InnoDB:
  394. [--] * InnoDB migration request for wordpress.wp_commentmeta Table: ALTER TABLE wordpress.wp_commentmeta ENGINE=InnoDB;
  395. [--] * InnoDB migration request for wordpress.wp_comments Table: ALTER TABLE wordpress.wp_comments ENGINE=InnoDB;
  396. [--] * InnoDB migration request for wordpress.wp_links Table: ALTER TABLE wordpress.wp_links ENGINE=InnoDB;
  397. [--] * InnoDB migration request for wordpress.wp_ngg_album Table: ALTER TABLE wordpress.wp_ngg_album ENGINE=InnoDB;
  398. [--] * InnoDB migration request for wordpress.wp_ngg_gallery Table: ALTER TABLE wordpress.wp_ngg_gallery ENGINE=InnoDB;
  399. [--] * InnoDB migration request for wordpress.wp_ngg_pictures Table: ALTER TABLE wordpress.wp_ngg_pictures ENGINE=InnoDB;
  400. [--] * InnoDB migration request for wordpress.wp_options Table: ALTER TABLE wordpress.wp_options ENGINE=InnoDB;
  401. [--] * InnoDB migration request for wordpress.wp_postmeta Table: ALTER TABLE wordpress.wp_postmeta ENGINE=InnoDB;
  402. [--] * InnoDB migration request for wordpress.wp_posts Table: ALTER TABLE wordpress.wp_posts ENGINE=InnoDB;
  403. [--] * InnoDB migration request for wordpress.wp_socialslider Table: ALTER TABLE wordpress.wp_socialslider ENGINE=InnoDB;
  404. [--] * InnoDB migration request for wordpress.wp_term_relationships Table: ALTER TABLE wordpress.wp_term_relationships ENGINE=InnoDB;
  405. [--] * InnoDB migration request for wordpress.wp_term_taxonomy Table: ALTER TABLE wordpress.wp_term_taxonomy ENGINE=InnoDB;
  406. [--] * InnoDB migration request for wordpress.wp_terms Table: ALTER TABLE wordpress.wp_terms ENGINE=InnoDB;
  407. [--] * InnoDB migration request for wordpress.wp_usermeta Table: ALTER TABLE wordpress.wp_usermeta ENGINE=InnoDB;
  408. [--] * InnoDB migration request for wordpress.wp_users Table: ALTER TABLE wordpress.wp_users ENGINE=InnoDB;
  409. [--] * InnoDB migration request for wordpress.wp_wfBlocks7 Table: ALTER TABLE wordpress.wp_wfBlocks7 ENGINE=InnoDB;
  410. [--] * InnoDB migration request for wordpress.wp_wfFileChanges Table: ALTER TABLE wordpress.wp_wfFileChanges ENGINE=InnoDB;
  411. [--] * InnoDB migration request for wordpress.wp_wfLiveTrafficHuman Table: ALTER TABLE wordpress.wp_wfLiveTrafficHuman ENGINE=InnoDB;
  412. [--] * InnoDB migration request for wordpress.wp_wfPendingIssues Table: ALTER TABLE wordpress.wp_wfPendingIssues ENGINE=InnoDB;
  413. [--] * InnoDB migration request for wordpress.wp_wfSecurityEvents Table: ALTER TABLE wordpress.wp_wfSecurityEvents ENGINE=InnoDB;
  414. [--] * InnoDB migration request for wordpress.wp_wfTrafficRates Table: ALTER TABLE wordpress.wp_wfTrafficRates ENGINE=InnoDB;
  415. [--] * InnoDB migration request for wordpress.wp_wfWafFailures Table: ALTER TABLE wordpress.wp_wfWafFailures ENGINE=InnoDB;
  416. [--] * InnoDB migration request for wordpress.wp_yoast_indexable Table: ALTER TABLE wordpress.wp_yoast_indexable ENGINE=InnoDB;
  417. [--] * InnoDB migration request for wordpress.wp_yoast_indexable_hierarchy Table: ALTER TABLE wordpress.wp_yoast_indexable_hierarchy ENGINE=InnoDB;
  418. [--] * InnoDB migration request for wordpress.wp_yoast_migrations Table: ALTER TABLE wordpress.wp_yoast_migrations ENGINE=InnoDB;
  419. [--] * InnoDB migration request for wordpress.wp_yoast_primary_term Table: ALTER TABLE wordpress.wp_yoast_primary_term ENGINE=InnoDB;
  420. [--] * InnoDB migration request for wordpress.wp_yoast_prominent_words Table: ALTER TABLE wordpress.wp_yoast_prominent_words ENGINE=InnoDB;
  421. [--] * InnoDB migration request for wordpress.wp_yoast_seo_links Table: ALTER TABLE wordpress.wp_yoast_seo_links ENGINE=InnoDB;
  422. [--] * InnoDB migration request for wordpress.wp_yoast_seo_meta Table: ALTER TABLE wordpress.wp_yoast_seo_meta ENGINE=InnoDB;
  423. [--] General MyIsam metrics:
  424. [--] +-- Total MyISAM Tables : 29
  425. [--] +-- Total MyISAM indexes : 67.5M
  426. [--] +-- KB Size :8.0M
  427. [--] +-- KB Used Size :1.5M
  428. [--] +-- KB used :18.2%
  429. [--] +-- Read KB hit rate: 0% (0 cached / 0 reads)
  430. [--] +-- Write KB hit rate: 0% (0 cached / 0 writes)
  431. [--] MyISAM Metrics are disabled since MySQL 8.0.
  432.  
  433. -------- InnoDB Metrics ----------------------------------------------------------------------------
  434. [--] InnoDB is enabled.
  435. [--] InnoDB Thread Concurrency: 0
  436. [OK] InnoDB File per table is activated
  437. [OK] InnoDB Buffer Pool size ( 12.0G ) under limit for 64 bits architecture: (17179869184.0G )
  438. [OK] InnoDB buffer pool / data size: 12.0G / 9.7G
  439. [!!] Ratio InnoDB redo log capacity / InnoDB Buffer pool size (0.520833333333333%): 100.0M / 12.0G should be equal to 25%
  440. [!!] InnoDB buffer pool instances: 8
  441. [--] Number of InnoDB Buffer Pool Chunk: 96 for 8 Buffer Pool Instance(s)
  442. [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
  443. [OK] InnoDB Read buffer efficiency: 100.00% (447985438 hits / 447989002 total)
  444. [!!] InnoDB Write Log efficiency: 72.52% (22503 hits / 31028 total)
  445. [OK] InnoDB log waits: 0.00% (0 waits / 8525 writes)
  446.  
  447. -------- Aria Metrics ------------------------------------------------------------------------------
  448. [--] Aria Storage Engine not available.
  449.  
  450. -------- TokuDB Metrics ----------------------------------------------------------------------------
  451. [--] TokuDB is disabled.
  452.  
  453. -------- XtraDB Metrics ----------------------------------------------------------------------------
  454. [--] XtraDB is disabled.
  455.  
  456. -------- Galera Metrics ----------------------------------------------------------------------------
  457. [--] Galera is disabled.
  458.  
  459. -------- Replication Metrics -----------------------------------------------------------------------
  460. [--] Galera Synchronous replication: NO
  461. [--] No replication slave(s) for this server.
  462. [--] Binlog format: ROW
  463. [--] XA support enabled: ON
  464. [--] Semi synchronous replication Master: Not Activated
  465. [--] Semi synchronous replication Slave: Not Activated
  466. [--] This is a standalone server
  467.  
  468. -------- Recommendations ---------------------------------------------------------------------------
  469. General recommendations:
  470. MySQL was started within the last 24 hours: recommendations may be inaccurate
  471. MyISAM engine is deprecated, consider migrating to InnoDB
  472. Buffer Key MyISAM set to 0, no MyISAM table detected
  473. Be careful, increasing innodb_redo_log_capacity means higher crash recovery mean time
  474. Variables to adjust:
  475. key_buffer_size=0
  476. innodb_redo_log_capacity should be (=3G) if possible, so InnoDB Redo log Capacity equals 25% of buffer pool size.
  477. innodb_buffer_pool_instances(=12)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!