MYSQL tuner for dba.stack

+---------------------------------------------+-------------+
| name                                        | count       |
+---------------------------------------------+-------------+
| adaptive_hash_pages_added                   |           0 |
| adaptive_hash_pages_removed                 |           0 |
| adaptive_hash_rows_added                    |           0 |
| adaptive_hash_rows_deleted_no_hash_entry    |           0 |
| adaptive_hash_rows_removed                  |           0 |
| adaptive_hash_rows_updated                  |           0 |
| adaptive_hash_searches                      |   146746901 |
| adaptive_hash_searches_btree                |     5533689 |
| buffer_data_reads                           | 60245007360 |
| buffer_data_written                         | 38622450688 |
| buffer_flush_adaptive                       |           0 |
| buffer_flush_adaptive_avg_pass              |           0 |
| buffer_flush_adaptive_avg_time_est          |           0 |
| buffer_flush_adaptive_avg_time_slot         |           0 |
| buffer_flush_adaptive_avg_time_thread       |           0 |
| buffer_flush_adaptive_pages                 |           0 |
| buffer_flush_adaptive_total_pages           |           0 |
| buffer_flush_avg_page_rate                  |           0 |
| buffer_flush_avg_pass                       |           0 |
| buffer_flush_avg_time                       |           0 |
| buffer_flush_background                     |           0 |
| buffer_flush_background_pages               |           0 |
| buffer_flush_background_total_pages         |           0 |
| buffer_flush_batches                        |           0 |
| buffer_flush_batch_num_scan                 |           0 |
| buffer_flush_batch_pages                    |           0 |
| buffer_flush_batch_scanned                  |           0 |
| buffer_flush_batch_scanned_per_call         |           0 |
| buffer_flush_batch_total_pages              |           0 |
| buffer_flush_lsn_avg_rate                   |           0 |
| buffer_flush_neighbor                       |           0 |
| buffer_flush_neighbor_pages                 |           0 |
| buffer_flush_neighbor_total_pages           |           0 |
| buffer_flush_n_to_flush_by_age              |           0 |
| buffer_flush_n_to_flush_by_dirty_page       |           0 |
| buffer_flush_n_to_flush_requested           |           0 |
| buffer_flush_pct_for_dirty                  |           0 |
| buffer_flush_pct_for_lsn                    |           0 |
| buffer_flush_sync                           |           0 |
| buffer_flush_sync_pages                     |           0 |
| buffer_flush_sync_total_pages               |           0 |
| buffer_flush_sync_waits                     |           0 |
| buffer_LRU_batches_evict                    |           0 |
| buffer_LRU_batches_flush                    |           0 |
| buffer_LRU_batch_evict_pages                |           0 |
| buffer_LRU_batch_evict_total_pages          |           0 |
| buffer_LRU_batch_flush_avg_pass             |           0 |
| buffer_LRU_batch_flush_avg_time_est         |           0 |
| buffer_LRU_batch_flush_avg_time_slot        |           0 |
| buffer_LRU_batch_flush_avg_time_thread      |           0 |
| buffer_LRU_batch_flush_pages                |           0 |
| buffer_LRU_batch_flush_total_pages          |           0 |
| buffer_LRU_batch_num_scan                   |           0 |
| buffer_LRU_batch_scanned                    |           0 |
| buffer_LRU_batch_scanned_per_call           |           0 |
| buffer_LRU_get_free_loops                   |           0 |
| buffer_LRU_get_free_search                  |           0 |
| buffer_LRU_get_free_waits                   |           0 |
| buffer_LRU_search_num_scan                  |           0 |
| buffer_LRU_search_scanned                   |           0 |
| buffer_LRU_search_scanned_per_call          |           0 |
| buffer_LRU_single_flush_failure_count       |           0 |
| buffer_LRU_single_flush_num_scan            |           0 |
| buffer_LRU_single_flush_scanned             |           0 |
| buffer_LRU_single_flush_scanned_per_call    |           0 |
| buffer_LRU_unzip_search_num_scan            |           0 |
| buffer_LRU_unzip_search_scanned             |           0 |
| buffer_LRU_unzip_search_scanned_per_call    |           0 |
| buffer_pages_created                        |      810891 |
| buffer_pages_read                           |     3677205 |
| buffer_pages_written                        |      934422 |
| buffer_page_read_blob                       |           0 |
| buffer_page_read_fsp_hdr                    |           0 |
| buffer_page_read_ibuf_bitmap                |           0 |
| buffer_page_read_ibuf_free_list             |           0 |
| buffer_page_read_index_ibuf_leaf            |           0 |
| buffer_page_read_index_ibuf_non_leaf        |           0 |
| buffer_page_read_index_inode                |           0 |
| buffer_page_read_index_leaf                 |           0 |
| buffer_page_read_index_non_leaf             |           0 |
| buffer_page_read_other                      |           0 |
| buffer_page_read_rseg_array                 |           0 |
| buffer_page_read_system_page                |           0 |
| buffer_page_read_trx_system                 |           0 |
| buffer_page_read_undo_log                   |           0 |
| buffer_page_read_xdes                       |           0 |
| buffer_page_read_zblob                      |           0 |
| buffer_page_read_zblob2                     |           0 |
| buffer_page_written_blob                    |           0 |
| buffer_page_written_fsp_hdr                 |           0 |
| buffer_page_written_ibuf_bitmap             |           0 |
| buffer_page_written_ibuf_free_list          |           0 |
| buffer_page_written_index_ibuf_leaf         |           0 |
| buffer_page_written_index_ibuf_non_leaf     |           0 |
| buffer_page_written_index_inode             |           0 |
| buffer_page_written_index_leaf              |           0 |
| buffer_page_written_index_non_leaf          |           0 |
| buffer_page_written_on_log_no_waits         |           0 |
| buffer_page_written_on_log_waits            |           0 |
| buffer_page_written_on_log_wait_loops       |           0 |
| buffer_page_written_other                   |           0 |
| buffer_page_written_rseg_array              |           0 |
| buffer_page_written_system_page             |           0 |
| buffer_page_written_trx_system              |           0 |
| buffer_page_written_undo_log                |           0 |
| buffer_page_written_xdes                    |           0 |
| buffer_page_written_zblob                   |           0 |
| buffer_page_written_zblob2                  |           0 |
| buffer_pool_bytes_data                      |  4144168960 |
| buffer_pool_bytes_dirty                     |           0 |
| buffer_pool_pages_data                      |      252940 |
| buffer_pool_pages_dirty                     |           0 |
| buffer_pool_pages_free                      |        8190 |
| buffer_pool_pages_misc                      |        1014 |
| buffer_pool_pages_total                     |      262144 |
| buffer_pool_reads                           |     1993283 |
| buffer_pool_read_ahead                      |     1683880 |
| buffer_pool_read_ahead_evicted              |        1637 |
| buffer_pool_read_requests                   |   476760952 |
| buffer_pool_size                            |  4294967296 |
| buffer_pool_wait_free                       |           0 |
| buffer_pool_write_requests                  |   202095308 |
| compression_pad_decrements                  |           0 |
| compression_pad_increments                  |           0 |
| compress_pages_compressed                   |           0 |
| compress_pages_decompressed                 |           0 |
| cpu_n                                       |           0 |
| cpu_stime_abs                               |           0 |
| cpu_stime_pct                               |           0 |
| cpu_utime_abs                               |           0 |
| cpu_utime_pct                               |           0 |
| dblwr_async_requests                        |           0 |
| dblwr_flush_requests                        |           0 |
| dblwr_flush_wait_events                     |           0 |
| dblwr_sync_requests                         |           0 |
| ddl_background_drop_tables                  |           0 |
| ddl_log_file_alter_table                    |           0 |
| ddl_online_create_index                     |           0 |
| ddl_pending_alter_table                     |           0 |
| ddl_sort_file_alter_table                   |           0 |
| dml_deletes                                 |         186 |
| dml_inserts                                 |   147076188 |
| dml_reads                                   |           0 |
| dml_system_deletes                          |         147 |
| dml_system_inserts                          |         196 |
| dml_system_reads                            |     1073583 |
| dml_system_updates                          |         531 |
| dml_updates                                 |       38327 |
| file_num_open_files                         |        3803 |
| ibuf_merges                                 |           0 |
| ibuf_merges_delete                          |           0 |
| ibuf_merges_delete_mark                     |           0 |
| ibuf_merges_discard_delete                  |           0 |
| ibuf_merges_discard_delete_mark             |           0 |
| ibuf_merges_discard_insert                  |           0 |
| ibuf_merges_insert                          |           0 |
| ibuf_size                                   |           5 |
| icp_attempts                                |           0 |
| icp_match                                   |           0 |
| icp_no_match                                |           0 |
| icp_out_of_range                            |           0 |
| index_page_discards                         |           0 |
| index_page_merge_attempts                   |           0 |
| index_page_merge_successful                 |           0 |
| index_page_reorg_attempts                   |           0 |
| index_page_reorg_successful                 |           0 |
| index_page_splits                           |           0 |
| innodb_activity_count                       |     5848177 |
| innodb_background_drop_table_usec           |           0 |
| innodb_dblwr_pages_written                  |      934281 |
| innodb_dblwr_writes                         |      238279 |
| innodb_dict_lru_count                       |           0 |
| innodb_dict_lru_usec                        |           0 |
| innodb_ibuf_merge_usec                      |           0 |
| innodb_master_active_loops                  |           0 |
| innodb_master_idle_loops                    |           0 |
| innodb_master_purge_usec                    |           0 |
| innodb_master_thread_sleeps                 |           0 |
| innodb_mem_validate_usec                    |           0 |
| innodb_page_size                            |       16384 |
| innodb_rwlock_sx_os_waits                   |           0 |
| innodb_rwlock_sx_spin_rounds                |           0 |
| innodb_rwlock_sx_spin_waits                 |           0 |
| innodb_rwlock_s_os_waits                    |           0 |
| innodb_rwlock_s_spin_rounds                 |           0 |
| innodb_rwlock_s_spin_waits                  |           0 |
| innodb_rwlock_x_os_waits                    |           0 |
| innodb_rwlock_x_spin_rounds                 |           0 |
| innodb_rwlock_x_spin_waits                  |           0 |
| lock_deadlocks                              |           0 |
| lock_deadlock_false_positives               |           0 |
| lock_deadlock_rounds                        |      147875 |
| lock_rec_grant_attempts                     |           0 |
| lock_rec_locks                              |           0 |
| lock_rec_lock_created                       |           0 |
| lock_rec_lock_removed                       |           0 |
| lock_rec_lock_requests                      |           0 |
| lock_rec_lock_waits                         |           0 |
| lock_rec_release_attempts                   |     1071286 |
| lock_row_lock_current_waits                 |           0 |
| lock_row_lock_time                          |           0 |
| lock_row_lock_time_avg                      |           0 |
| lock_row_lock_time_max                      |           0 |
| lock_row_lock_waits                         |           0 |
| lock_schedule_refreshes                     |      147875 |
| lock_table_locks                            |           0 |
| lock_table_lock_created                     |           0 |
| lock_table_lock_removed                     |           0 |
| lock_table_lock_waits                       |           0 |
| lock_threads_waiting                        |           0 |
| lock_timeouts                               |           0 |
| log_checkpoints                             |           0 |
| log_concurrency_margin                      |           0 |
| log_flusher_no_waits                        |           0 |
| log_flusher_waits                           |           0 |
| log_flusher_wait_loops                      |           0 |
| log_flush_avg_time                          |           0 |
| log_flush_lsn_avg_rate                      |           0 |
| log_flush_max_time                          |           0 |
| log_flush_notifier_no_waits                 |           0 |
| log_flush_notifier_waits                    |           0 |
| log_flush_notifier_wait_loops               |           0 |
| log_flush_total_time                        |           0 |
| log_free_space                              |           0 |
| log_full_block_writes                       |           0 |
| log_lsn_archived                            |           0 |
| log_lsn_buf_dirty_pages_added               |           0 |
| log_lsn_buf_pool_oldest_approx              |           0 |
| log_lsn_buf_pool_oldest_lwm                 |           0 |
| log_lsn_checkpoint_age                      |           0 |
| log_lsn_current                             |           0 |
| log_lsn_last_checkpoint                     |           0 |
| log_lsn_last_flush                          |           0 |
| log_max_modified_age_async                  |           0 |
| log_max_modified_age_sync                   |           0 |
| log_next_file                               |           0 |
| log_on_buffer_space_no_waits                |           0 |
| log_on_buffer_space_waits                   |           0 |
| log_on_buffer_space_wait_loops              |           0 |
| log_on_file_space_no_waits                  |           0 |
| log_on_file_space_waits                     |           0 |
| log_on_file_space_wait_loops                |           0 |
| log_on_flush_no_waits                       |           0 |
| log_on_flush_waits                          |           0 |
| log_on_flush_wait_loops                     |           0 |
| log_on_recent_closed_wait_loops             |           0 |
| log_on_recent_written_wait_loops            |           0 |
| log_on_write_no_waits                       |           0 |
| log_on_write_waits                          |           0 |
| log_on_write_wait_loops                     |           0 |
| log_padded                                  |           0 |
| log_partial_block_writes                    |           0 |
| log_waits                                   |           0 |
| log_writer_no_waits                         |           0 |
| log_writer_on_archiver_waits                |           0 |
| log_writer_on_file_space_waits              |           0 |
| log_writer_waits                            |           0 |
| log_writer_wait_loops                       |           0 |
| log_writes                                  |     4924375 |
| log_write_notifier_no_waits                 |           0 |
| log_write_notifier_waits                    |           0 |
| log_write_notifier_wait_loops               |           0 |
| log_write_requests                          |   194217238 |
| log_write_to_file_requests_interval         |           0 |
| metadata_table_handles_closed               |           0 |
| metadata_table_handles_opened               |           0 |
| metadata_table_reference_count              |           0 |
| module_cpu                                  |           0 |
| module_dblwr                                |           0 |
| module_page_track                           |           0 |
| os_data_fsyncs                              |      338655 |
| os_data_reads                               |     3689227 |
| os_data_writes                              |     6134094 |
| os_log_bytes_written                        | 21169644544 |
| os_log_fsyncs                               |       30842 |
| os_log_pending_fsyncs                       |           0 |
| os_log_pending_writes                       |           0 |
| os_pending_reads                            |           0 |
| os_pending_writes                           |           0 |
| page_track_checkpoint_partial_flush_request |           0 |
| page_track_full_block_writes                |           0 |
| page_track_partial_block_writes             |           0 |
| page_track_resets                           |           0 |
| purge_del_mark_records                      |           0 |
| purge_dml_delay_usec                        |           0 |
| purge_invoked                               |           0 |
| purge_resume_count                          |           0 |
| purge_stop_count                            |           0 |
| purge_truncate_history_count                |           0 |
| purge_truncate_history_usec                 |           0 |
| purge_undo_log_pages                        |           0 |
| purge_upd_exist_or_extern_records           |           0 |
| sampled_pages_read                          |           0 |
| sampled_pages_skipped                       |           0 |
| trx_active_transactions                     |           0 |
| trx_allocations                             |           0 |
| trx_commits_insert_update                   |           0 |
| trx_nl_ro_commits                           |           0 |
| trx_on_log_no_waits                         |           0 |
| trx_on_log_waits                            |           0 |
| trx_on_log_wait_loops                       |           0 |
| trx_rollbacks                               |           0 |
| trx_rollbacks_savepoint                     |           0 |
| trx_rollback_active                         |           0 |
| trx_ro_commits                              |           0 |
| trx_rseg_current_size                       |           0 |
| trx_rseg_history_len                        |           0 |
| trx_rw_commits                              |           0 |
| trx_undo_slots_cached                       |           0 |
| trx_undo_slots_used                         |           0 |
| undo_truncate_count                         |           0 |
| undo_truncate_done_logging_count            |           0 |
| undo_truncate_start_logging_count           |           0 |
| undo_truncate_usec                          |           0 |
+---------------------------------------------+-------------+
314 rows in set (0.00 sec)