Basic Information
July 18, 2025, 12:17:33 PM
| Operating System: | CentOS release 6.9 (Final) |
|---|---|
| Processor: | Intel® Core(TM) i7 CPU 920 @ 2.67GHz (1600.000MHz) |
| Load averages: | 0.61, 0.72, 0.87 |
| Current processes: | 255 (254 sleeping, 1 running, 0 zombie) |
| Processes by CPU: | php-fpm (36) 49.1%, mysqld (1) 21.1%, nginx (7) 7.4%, ps (1) 1.0%, (other) (72) 0.0% |
| Memory usage: |
97.96% (24226604k / 24731160k) Swap: 23.889% (500728k / 2096060k) |
MySQL Statistics
MySQL 5.7.x
| Connections per second: | 3.8062 |
|---|---|
| Kilobytes received per second: | 20.9817 |
| Kilobytes sent per second: | 1590.4638 |
| Queries per second: | 78.8031 |
| Percentage of slow queries: | 0 |
|
Opened vs. Open tables: (table_cache) |
89.255 (should be <= 80) |
|
Key buffer read hit rate: (key_buffer_size) |
0.0184 (should be <= 0.01) |
|
Key buffer write hit rate: (key_buffer_size) |
0.998 (should be <= 0.5) |
|
Thread cache hit rate: (thread_cache_size) |
3437.3326 (should be >= 30 ) |
|
Thread cache usage: (thread_cache_size) |
0.9688 (should be >= 0.7 and <= 0.9) |
|
Temporary table disk usage: (tmp_table_size) |
0.244 (should be <= 0.5) |
|
Sort merge pass rate: (sort_buffer) |
0.0001 (should be <= 0.001) |
|
Query cache enabled: (query_cache_type) |
1 (should be >= 1 and <= 1) |
|
Query cache miss rate: (query_cache_limit) |
0.6307 (should be <= 0.5) |
|
Query cache prune rate: (query_cache_size) |
0.1188 (should be <= 0.05) |
MySQL status
| Aborted_clients: | 541 |
|---|---|
| Aborted_connects: | 678 |
| Binlog_snapshot_file: | |
| Binlog_snapshot_position: | 0 |
| Binlog_cache_disk_use: | 0 |
| Binlog_cache_use: | 0 |
| Binlog_stmt_cache_disk_use: | 0 |
| Binlog_stmt_cache_use: | 0 |
| Bytes_received: | 2780872282231 |
| Bytes_sent: | 210796919703213 |
| Com_admin_commands: | 0 |
| Com_assign_to_keycache: | 0 |
| Com_alter_db: | 0 |
| Com_alter_db_upgrade: | 0 |
| Com_alter_event: | 0 |
| Com_alter_function: | 0 |
| Com_alter_instance: | 0 |
| Com_alter_procedure: | 0 |
| Com_alter_server: | 0 |
| Com_alter_table: | 1 |
| Com_alter_tablespace: | 0 |
| Com_alter_user: | 0 |
| Com_analyze: | 0 |
| Com_begin: | 215 |
| Com_binlog: | 0 |
| Com_call_procedure: | 0 |
| Com_change_db: | 492276090 |
| Com_change_master: | 0 |
| Com_change_repl_filter: | 0 |
| Com_check: | 1 |
| Com_checksum: | 0 |
| Com_commit: | 0 |
| Com_create_compression_dictionary: | 0 |
| Com_create_db: | 0 |
| Com_create_event: | 0 |
| Com_create_function: | 0 |
| Com_create_index: | 0 |
| Com_create_procedure: | 0 |
| Com_create_server: | 0 |
| Com_create_table: | 103131 |
| Com_create_trigger: | 0 |
| Com_create_udf: | 0 |
| Com_create_user: | 0 |
| Com_create_view: | 0 |
| Com_dealloc_sql: | 0 |
| Com_delete: | 75239301 |
| Com_delete_multi: | 0 |
| Com_do: | 0 |
| Com_drop_compression_dictionary: | 0 |
| Com_drop_db: | 0 |
| Com_drop_event: | 0 |
| Com_drop_function: | 0 |
| Com_drop_index: | 0 |
| Com_drop_procedure: | 0 |
| Com_drop_server: | 0 |
| Com_drop_table: | 157834 |
| Com_drop_trigger: | 0 |
| Com_drop_user: | 0 |
| Com_drop_view: | 0 |
| Com_empty_query: | 0 |
| Com_execute_sql: | 0 |
| Com_explain_other: | 0 |
| Com_flush: | 1230 |
| Com_get_diagnostics: | 0 |
| Com_grant: | 0 |
| Com_ha_close: | 0 |
| Com_ha_open: | 0 |
| Com_ha_read: | 0 |
| Com_help: | 0 |
| Com_insert: | 380531866 |
| Com_insert_select: | 0 |
| Com_install_plugin: | 0 |
| Com_kill: | 1 |
| Com_load: | 0 |
| Com_lock_tables: | 0 |
| Com_lock_tables_for_backup: | 1230 |
| Com_lock_binlog_for_backup: | 1230 |
| Com_optimize: | 1935 |
| Com_preload_keys: | 0 |
| Com_prepare_sql: | 0 |
| Com_purge: | 0 |
| Com_purge_before_date: | 0 |
| Com_release_savepoint: | 214 |
| Com_rename_table: | 0 |
| Com_rename_user: | 0 |
| Com_repair: | 0 |
| Com_replace: | 248335516 |
| Com_replace_select: | 1498 |
| Com_reset: | 0 |
| Com_resignal: | 0 |
| Com_revoke: | 0 |
| Com_revoke_all: | 0 |
| Com_rollback: | 0 |
| Com_rollback_to_savepoint: | 14400 |
| Com_savepoint: | 215 |
| Com_select: | 4454144033 |
| Com_set_option: | 492572196 |
| Com_signal: | 0 |
| Com_show_binlog_events: | 0 |
| Com_show_binlogs: | 0 |
| Com_show_charsets: | 0 |
| Com_show_client_statistics: | 0 |
| Com_show_collations: | 0 |
| Com_show_create_db: | 0 |
| Com_show_create_event: | 0 |
| Com_show_create_func: | 0 |
| Com_show_create_proc: | 0 |
| Com_show_create_table: | 14401 |
| Com_show_create_trigger: | 0 |
| Com_show_databases: | 0 |
| Com_show_engine_logs: | 0 |
| Com_show_engine_mutex: | 0 |
| Com_show_engine_status: | 1281 |
| Com_show_events: | 0 |
| Com_show_errors: | 0 |
| Com_show_fields: | 28803 |
| Com_show_function_code: | 0 |
| Com_show_function_status: | 0 |
| Com_show_grants: | 0 |
| Com_show_index_statistics: | 0 |
| Com_show_keys: | 0 |
| Com_show_master_status: | 1230 |
| Com_show_open_tables: | 0 |
| Com_show_plugins: | 0 |
| Com_show_privileges: | 0 |
| Com_show_procedure_code: | 0 |
| Com_show_procedure_status: | 0 |
| Com_show_processlist: | 495 |
| Com_show_profile: | 0 |
| Com_show_profiles: | 0 |
| Com_show_relaylog_events: | 0 |
| Com_show_slave_hosts: | 0 |
| Com_show_slave_status: | 0 |
| Com_show_status: | 479 |
| Com_show_storage_engines: | 0 |
| Com_show_table_statistics: | 0 |
| Com_show_table_status: | 14402 |
| Com_show_tables: | 217 |
| Com_show_thread_statistics: | 0 |
| Com_show_triggers: | 14400 |
| Com_show_user_statistics: | 0 |
| Com_show_variables: | 4293 |
| Com_show_warnings: | 0 |
| Com_show_create_user: | 0 |
| Com_shutdown: | 0 |
| Com_slave_start: | 0 |
| Com_slave_stop: | 0 |
| Com_group_replication_start: | 0 |
| Com_group_replication_stop: | 0 |
| Com_stmt_execute: | 0 |
| Com_stmt_close: | 0 |
| Com_stmt_fetch: | 0 |
| Com_stmt_prepare: | 0 |
| Com_stmt_reset: | 0 |
| Com_stmt_send_long_data: | 0 |
| Com_truncate: | 0 |
| Com_uninstall_plugin: | 0 |
| Com_unlock_binlog: | 1230 |
| Com_unlock_tables: | 1445 |
| Com_update: | 955319939 |
| Com_update_multi: | 0 |
| Com_xa_commit: | 0 |
| Com_xa_end: | 0 |
| Com_xa_prepare: | 0 |
| Com_xa_recover: | 0 |
| Com_xa_rollback: | 0 |
| Com_xa_start: | 0 |
| Com_stmt_reprepare: | 0 |
| Connection_errors_accept: | 0 |
| Connection_errors_internal: | 0 |
| Connection_errors_max_connections: | 0 |
| Connection_errors_peer_address: | 0 |
| Connection_errors_select: | 0 |
| Connection_errors_tcpwrap: | 0 |
| Connections: | 492645377 |
| Created_tmp_disk_tables: | 4501882 |
| Created_tmp_files: | 6791827 |
| Created_tmp_tables: | 18453667 |
| Delayed_errors: | 0 |
| Delayed_insert_threads: | 0 |
| Delayed_writes: | 0 |
| Flush_commands: | 1 |
| Handler_commit: | 6101248414 |
| Handler_delete: | 361937710 |
| Handler_discover: | 0 |
| Handler_external_lock: | 22827567065 |
| Handler_mrr_init: | 0 |
| Handler_prepare: | 0 |
| Handler_read_first: | 768854896 |
| Handler_read_key: | 2598930120397 |
| Handler_read_last: | 672538 |
| Handler_read_next: | 1451485486997 |
| Handler_read_prev: | 152916340801 |
| Handler_read_rnd: | 6518230914 |
| Handler_read_rnd_next: | 3645162425370 |
| Handler_rollback: | 37082 |
| Handler_savepoint: | 215 |
| Handler_savepoint_rollback: | 14400 |
| Handler_update: | 3078304408 |
| Handler_write: | 17066915625 |
| Innodb_background_log_sync: | 129141558 |
| Innodb_buffer_pool_dump_status: | Dumping of buffer pool not started |
| Innodb_buffer_pool_load_status: | Buffer pool(s) load completed at 210611 13:03:18 |
| Innodb_buffer_pool_resize_status: | |
| Innodb_buffer_pool_pages_data: | 497769 |
| Innodb_buffer_pool_bytes_data: | 8155447296 |
| Innodb_buffer_pool_pages_dirty: | 9210 |
| Innodb_buffer_pool_bytes_dirty: | 150896640 |
| Innodb_buffer_pool_pages_flushed: | 120266031917 |
| Innodb_buffer_pool_pages_free: | 8128 |
| Innodb_buffer_pool_pages_LRU_flushed: | 0 |
| Innodb_buffer_pool_pages_made_not_young: | 756942562185 |
| Innodb_buffer_pool_pages_made_young: | 104842300088 |
| Innodb_buffer_pool_pages_misc: | 18327 |
| Innodb_buffer_pool_pages_old: | 183588 |
| Innodb_buffer_pool_pages_total: | 524224 |
| Innodb_buffer_pool_read_ahead_rnd: | 0 |
| Innodb_buffer_pool_read_ahead: | 117063614 |
| Innodb_buffer_pool_read_ahead_evicted: | 0 |
| Innodb_buffer_pool_read_requests: | 8984384488501 |
| Innodb_buffer_pool_reads: | 118538950939 |
| Innodb_buffer_pool_wait_free: | 99105474 |
| Innodb_buffer_pool_write_requests: | 24183783863 |
| Innodb_checkpoint_age: | 631226426 |
| Innodb_checkpoint_max_age: | 5196817982 |
| Innodb_data_fsyncs: | 604514791 |
| Innodb_data_pending_fsyncs: | 0 |
| Innodb_data_pending_reads: | 0 |
| Innodb_data_pending_writes: | 0 |
| Innodb_data_read: | 1944088069542912 |
| Innodb_data_reads: | 118674638440 |
| Innodb_data_writes: | 2058589261 |
| Innodb_data_written: | 31443086295552 |
| Innodb_dblwr_pages_written: | 1155037184 |
| Innodb_dblwr_writes: | 336414870 |
| Innodb_ibuf_free_list: | 9837 |
| Innodb_ibuf_segment_size: | 9839 |
| Innodb_log_waits: | 0 |
| Innodb_log_write_requests: | 3407037702 |
| Innodb_log_writes: | 128152280 |
| Innodb_lsn_current: | 1831216200039 |
| Innodb_lsn_flushed: | 1831216200039 |
| Innodb_lsn_last_checkpoint: | 1830584973613 |
| Innodb_master_thread_active_loops: | 123995606 |
| Innodb_master_thread_idle_loops: | 5145952 |
| Innodb_max_trx_id: | 3738778277 |
| Innodb_mem_adaptive_hash: | 451678656 |
| Innodb_mem_dictionary: | 38541083 |
| Innodb_oldest_view_low_limit_trx_id: | 0 |
| Innodb_os_log_fsyncs: | 131923525 |
| Innodb_os_log_pending_fsyncs: | 0 |
| Innodb_os_log_pending_writes: | 0 |
| Innodb_os_log_written: | 1648534070272 |
| Innodb_page_size: | 16384 |
| Innodb_pages_created: | 917328929 |
| Innodb_pages_read: | 118665021717 |
| Innodb_pages0_read: | 73 |
| Innodb_pages_written: | 1571263443 |
| Innodb_purge_trx_id: | 3738778277 |
| Innodb_purge_undo_no: | 0 |
| Innodb_row_lock_current_waits: | 34 |
| Innodb_row_lock_time: | 3109327582 |
| Innodb_row_lock_time_avg: | 4507 |
| Innodb_row_lock_time_max: | 240937 |
| Innodb_row_lock_waits: | 689883 |
| Innodb_rows_deleted: | 359434814 |
| Innodb_rows_inserted: | 59178296521 |
| Innodb_rows_read: | 7541916438182 |
| Innodb_rows_updated: | 864828943 |
| Innodb_num_open_files: | 76 |
| Innodb_truncated_status_writes: | 0 |
| Innodb_available_undo_logs: | 128 |
| Innodb_secondary_index_triggered_cluster_reads: | 556934596384 |
| Innodb_secondary_index_triggered_cluster_reads_avoided: | 1838071 |
| Innodb_buffered_aio_submitted: | 117063614 |
| Innodb_scan_pages_contiguous: | 0 |
| Innodb_scan_pages_disjointed: | 0 |
| Innodb_scan_pages_total_seek_distance: | 0 |
| Innodb_scan_data_size: | 0 |
| Innodb_scan_deleted_recs_size: | 0 |
| Innodb_scrub_background_page_reorganizations: | 0 |
| Innodb_scrub_background_page_splits: | 0 |
| Innodb_scrub_background_page_split_failures_underflow: | 0 |
| Innodb_scrub_background_page_split_failures_out_of_filespace: | 0 |
| Innodb_scrub_background_page_split_failures_missing_index: | 0 |
| Innodb_scrub_background_page_split_failures_unknown: | 0 |
| Innodb_scrub_log: | 0 |
| Innodb_encryption_rotation_pages_read_from_cache: | 0 |
| Innodb_encryption_rotation_pages_read_from_disk: | 0 |
| Innodb_encryption_rotation_pages_modified: | 0 |
| Innodb_encryption_rotation_pages_flushed: | 0 |
| Innodb_encryption_rotation_estimated_iops: | 0 |
| Innodb_encryption_key_rotation_list_length: | 0 |
| Innodb_encryption_n_merge_blocks_encrypted: | 0 |
| Innodb_encryption_n_merge_blocks_decrypted: | 0 |
| Innodb_encryption_n_rowlog_blocks_encrypted: | 0 |
| Innodb_encryption_n_rowlog_blocks_decrypted: | 0 |
| Innodb_num_pages_encrypted: | 0 |
| Innodb_num_pages_decrypted: | 0 |
| Innodb_encryption_redo_key_version: | 0 |
| Key_blocks_not_flushed: | 0 |
| Key_blocks_unused: | 36797 |
| Key_blocks_used: | 3161 |
| Key_read_requests: | 139591 |
| Key_reads: | 2563 |
| Key_write_requests: | 15820 |
| Key_writes: | 15789 |
| Locked_connects: | 0 |
| Max_execution_time_exceeded: | 0 |
| Max_execution_time_set: | 0 |
| Max_execution_time_set_failed: | 0 |
| Max_used_connections: | 152 |
| Max_used_connections_time: | 2023-12-21 20:40:49 |
| Not_flushed_delayed_rows: | 0 |
| Ongoing_anonymous_transaction_count: | 0 |
| Open_files: | 71 |
| Open_streams: | 0 |
| Open_table_definitions: | 274 |
| Open_tables: | 1894 |
| Opened_files: | 7115440 |
| Opened_table_definitions: | 212338 |
| Opened_tables: | 169049 |
| Performance_schema_accounts_lost: | 0 |
| Performance_schema_cond_classes_lost: | 0 |
| Performance_schema_cond_instances_lost: | 0 |
| Performance_schema_digest_lost: | 0 |
| Performance_schema_file_classes_lost: | 0 |
| Performance_schema_file_handles_lost: | 0 |
| Performance_schema_file_instances_lost: | 1929 |
| Performance_schema_hosts_lost: | 0 |
| Performance_schema_index_stat_lost: | 0 |
| Performance_schema_locker_lost: | 0 |
| Performance_schema_memory_classes_lost: | 0 |
| Performance_schema_metadata_lock_lost: | 0 |
| Performance_schema_mutex_classes_lost: | 0 |
| Performance_schema_mutex_instances_lost: | 0 |
| Performance_schema_nested_statement_lost: | 0 |
| Performance_schema_prepared_statements_lost: | 0 |
| Performance_schema_program_lost: | 0 |
| Performance_schema_rwlock_classes_lost: | 0 |
| Performance_schema_rwlock_instances_lost: | 0 |
| Performance_schema_session_connect_attrs_lost: | 0 |
| Performance_schema_socket_classes_lost: | 0 |
| Performance_schema_socket_instances_lost: | 0 |
| Performance_schema_stage_classes_lost: | 0 |
| Performance_schema_statement_classes_lost: | 0 |
| Performance_schema_table_handles_lost: | 0 |
| Performance_schema_table_instances_lost: | 0 |
| Performance_schema_table_lock_stat_lost: | 0 |
| Performance_schema_thread_classes_lost: | 0 |
| Performance_schema_thread_instances_lost: | 0 |
| Performance_schema_users_lost: | 0 |
| Prepared_stmt_count: | 0 |
| Qcache_free_blocks: | 7217 |
| Qcache_free_memory: | 20870104 |
| Qcache_hits: | 2608181973 |
| Qcache_inserts: | 4442972172 |
| Qcache_lowmem_prunes: | 529146442 |
| Qcache_not_cached: | 11035662 |
| Qcache_queries_in_cache: | 15940 |
| Qcache_total_blocks: | 41288 |
| Queries: | 10199611814 |
| Questions: | 10199611813 |
| Rsa_public_key: | -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxyjYtlqNWO1s8iY1afkh E/cHgJwTJFCkfN0+S1cXFJSvkJ5cZFTWVu2agzdMjO2G1Ek1wKt+gvu8elxOzqDt 8dlnCUvU4uBSp+2ALyQDDM4WOEvTIBeyfL0KCU3K6U9lQV6Qt2jqbz/T0YhADv1m AkaE3TiRDjRTM18Dn7150nYhpj3/68ys//oQxf3SFY/merqdZh4t4IqoDEfE88f0 BxnkTNpr6wH4vHvSE9NVakMfEXXjUAR+gnvwGkpqdN8EV4dIbcWdY8zlzZJhY+Z4 Jhhvtqqam0kPztTKibNsuIX8Fafyzrt12nqU+5/puD2Usg56S38AVwOD3DdOBR5c nwIDAQAB -----END PUBLIC KEY----- |
| Select_full_join: | 80352190 |
| Select_full_range_join: | 0 |
| Select_range: | 1008059200 |
| Select_range_check: | 0 |
| Select_scan: | 620455997 |
| Slave_open_temp_tables: | 0 |
| Slow_launch_threads: | 0 |
| Slow_queries: | 0 |
| Sort_merge_passes: | 5337129 |
| Sort_range: | 327776490 |
| Sort_rows: | 39535567488 |
| Sort_scan: | 40227423 |
| Ssl_accept_renegotiates: | 0 |
| Ssl_accepts: | 0 |
| Ssl_callback_cache_hits: | 0 |
| Ssl_cipher: | |
| Ssl_cipher_list: | |
| Ssl_client_connects: | 0 |
| Ssl_connect_renegotiates: | 0 |
| Ssl_ctx_verify_depth: | 18446744073709551615 |
| Ssl_ctx_verify_mode: | 5 |
| Ssl_default_timeout: | 0 |
| Ssl_finished_accepts: | 0 |
| Ssl_finished_connects: | 0 |
| Ssl_server_not_after: | Jan 19 07:19:47 2030 GMT |
| Ssl_server_not_before: | Jan 22 07:19:47 2020 GMT |
| Ssl_session_cache_hits: | 0 |
| Ssl_session_cache_misses: | 0 |
| Ssl_session_cache_mode: | SERVER |
| Ssl_session_cache_overflows: | 0 |
| Ssl_session_cache_size: | 128 |
| Ssl_session_cache_timeouts: | 0 |
| Ssl_sessions_reused: | 0 |
| Ssl_used_session_cache_entries: | 0 |
| Ssl_verify_depth: | 0 |
| Ssl_verify_mode: | 0 |
| Ssl_version: | |
| Table_locks_immediate: | 12351449 |
| Table_locks_waited: | 5808 |
| Table_open_cache_hits: | 11413241279 |
| Table_open_cache_misses: | 65917 |
| Table_open_cache_overflows: | 1831 |
| Tc_log_max_pages_used: | 0 |
| Tc_log_page_size: | 0 |
| Tc_log_page_waits: | 0 |
| Threadpool_idle_threads: | 0 |
| Threadpool_threads: | 0 |
| Threads_cached: | 31 |
| Threads_connected: | 1 |
| Threads_created: | 143322 |
| Threads_running: | 1 |
| Uptime: | 129431657 |
| Uptime_since_flush_status: | 129431657 |
MySQL variables
| auto_generate_certs: | ON |
|---|---|
| auto_increment_increment: | 1 |
| auto_increment_offset: | 1 |
| autocommit: | ON |
| automatic_sp_privileges: | ON |
| avoid_temporal_upgrade: | OFF |
| back_log: | 90 |
| basedir: | /usr/ |
| big_tables: | OFF |
| bind_address: | 127.0.0.1 |
| binlog_cache_size: | 32768 |
| binlog_checksum: | CRC32 |
| binlog_direct_non_transactional_updates: | OFF |
| binlog_error_action: | ABORT_SERVER |
| binlog_format: | ROW |
| binlog_group_commit_sync_delay: | 0 |
| binlog_group_commit_sync_no_delay_count: | 0 |
| binlog_gtid_simple_recovery: | ON |
| binlog_max_flush_queue_time: | 0 |
| binlog_order_commits: | ON |
| binlog_row_image: | FULL |
| binlog_rows_query_log_events: | OFF |
| binlog_skip_flush_commands: | OFF |
| binlog_space_limit: | 0 |
| binlog_stmt_cache_size: | 32768 |
| binlog_transaction_dependency_history_size: | 25000 |
| binlog_transaction_dependency_tracking: | COMMIT_ORDER |
| block_encryption_mode: | aes-128-ecb |
| bulk_insert_buffer_size: | 8388608 |
| character_set_client: | latin1 |
| character_set_connection: | latin1 |
| character_set_database: | latin1 |
| character_set_filesystem: | binary |
| character_set_results: | latin1 |
| character_set_server: | latin1 |
| character_set_system: | utf8 |
| character_sets_dir: | /usr/share/percona-server/charsets/ |
| check_proxy_users: | OFF |
| collation_connection: | latin1_swedish_ci |
| collation_database: | latin1_swedish_ci |
| collation_server: | latin1_swedish_ci |
| completion_type: | NO_CHAIN |
| concurrent_insert: | ALWAYS |
| connect_timeout: | 10 |
| core_file: | OFF |
| csv_mode: | |
| datadir: | /opt/var/lib/mysql/ |
| date_format: | %Y-%m-%d |
| datetime_format: | %Y-%m-%d %H:%i:%s |
| default_authentication_plugin: | mysql_native_password |
| default_password_lifetime: | 0 |
| default_storage_engine: | MyISAM |
| default_tmp_storage_engine: | InnoDB |
| default_week_format: | 0 |
| delay_key_write: | ON |
| delayed_insert_limit: | 100 |
| delayed_insert_timeout: | 300 |
| delayed_queue_size: | 1000 |
| disabled_storage_engines: | |
| disconnect_on_expired_password: | ON |
| div_precision_increment: | 4 |
| encrypt_binlog: | OFF |
| encrypt_tmp_files: | OFF |
| end_markers_in_json: | OFF |
| enforce_gtid_consistency: | OFF |
| enforce_storage_engine: | |
| eq_range_index_dive_limit: | 200 |
| error_count: | 0 |
| event_scheduler: | OFF |
| expand_fast_index_creation: | OFF |
| expire_logs_days: | 0 |
| explicit_defaults_for_timestamp: | OFF |
| external_user: | |
| extra_max_connections: | 1 |
| extra_port: | 0 |
| flush: | OFF |
| flush_time: | 0 |
| foreign_key_checks: | ON |
| ft_boolean_syntax: | + -><()~*:""&| |
| ft_max_word_len: | 84 |
| ft_min_word_len: | 4 |
| ft_query_expansion_limit: | 20 |
| ft_query_extra_word_chars: | OFF |
| ft_stopword_file: | (built-in) |
| general_log: | OFF |
| general_log_file: | /opt/var/lib/mysql/forum.log |
| group_concat_max_len: | 1024 |
| gtid_executed_compression_period: | 1000 |
| gtid_mode: | OFF |
| gtid_next: | AUTOMATIC |
| gtid_owned: | |
| gtid_purged: | |
| have_backup_locks: | YES |
| have_backup_safe_binlog_info: | YES |
| have_compress: | YES |
| have_crypt: | YES |
| have_dynamic_loading: | YES |
| have_geometry: | YES |
| have_openssl: | YES |
| have_profiling: | YES |
| have_query_cache: | YES |
| have_rtree_keys: | YES |
| have_snapshot_cloning: | YES |
| have_ssl: | YES |
| have_statement_timeout: | YES |
| have_symlink: | YES |
| host_cache_size: | 328 |
| hostname: | forum.grodno.net |
| identity: | 0 |
| ignore_builtin_innodb: | OFF |
| ignore_db_dirs: | |
| init_connect: | |
| init_file: | |
| init_slave: | |
| innodb_adaptive_flushing: | ON |
| innodb_adaptive_flushing_lwm: | 10 |
| innodb_adaptive_hash_index: | ON |
| innodb_adaptive_hash_index_parts: | 8 |
| innodb_adaptive_max_sleep_delay: | 150000 |
| innodb_api_bk_commit_interval: | 5 |
| innodb_api_disable_rowlock: | OFF |
| innodb_api_enable_binlog: | OFF |
| innodb_api_enable_mdl: | OFF |
| innodb_api_trx_level: | 0 |
| innodb_autoextend_increment: | 64 |
| innodb_autoinc_lock_mode: | 1 |
| innodb_background_scrub_data_check_interval: | 3600 |
| innodb_background_scrub_data_compressed: | OFF |
| innodb_background_scrub_data_interval: | 604800 |
| innodb_background_scrub_data_uncompressed: | OFF |
| innodb_buffer_pool_chunk_size: | 134217728 |
| innodb_buffer_pool_dump_at_shutdown: | ON |
| innodb_buffer_pool_dump_now: | OFF |
| innodb_buffer_pool_dump_pct: | 25 |
| innodb_buffer_pool_filename: | ib_buffer_pool |
| innodb_buffer_pool_instances: | 8 |
| innodb_buffer_pool_load_abort: | OFF |
| innodb_buffer_pool_load_at_startup: | ON |
| innodb_buffer_pool_load_now: | OFF |
| innodb_buffer_pool_size: | 8589934592 |
| innodb_change_buffer_max_size: | 25 |
| innodb_change_buffering: | all |
| innodb_checksum_algorithm: | crc32 |
| innodb_checksums: | ON |
| innodb_cleaner_lsn_age_factor: | high_checkpoint |
| innodb_cmp_per_index_enabled: | OFF |
| innodb_commit_concurrency: | 0 |
| innodb_compressed_columns_threshold: | 96 |
| innodb_compressed_columns_zip_level: | 6 |
| innodb_compression_failure_threshold_pct: | 5 |
| innodb_compression_level: | 6 |
| innodb_compression_pad_pct_max: | 50 |
| innodb_concurrency_tickets: | 5000 |
| innodb_corrupt_table_action: | assert |
| innodb_data_file_path: | ibdata1:12M:autoextend |
| innodb_data_home_dir: | /opt/var/lib/mysql/ |
| innodb_deadlock_detect: | ON |
| innodb_default_encryption_key_id: | 0 |
| innodb_default_row_format: | dynamic |
| innodb_disable_sort_file_cache: | OFF |
| innodb_doublewrite: | ON |
| innodb_empty_free_list_algorithm: | backoff |
| innodb_encrypt_online_alter_logs: | OFF |
| innodb_encrypt_tables: | OFF |
| innodb_encryption_rotate_key_age: | 1 |
| innodb_encryption_rotation_iops: | 100 |
| innodb_encryption_threads: | 0 |
| innodb_fast_shutdown: | 1 |
| innodb_file_format: | Barracuda |
| innodb_file_format_check: | ON |
| innodb_file_format_max: | Barracuda |
| innodb_file_per_table: | ON |
| innodb_fill_factor: | 100 |
| innodb_flush_log_at_timeout: | 1 |
| innodb_flush_log_at_trx_commit: | 0 |
| innodb_flush_method: | |
| innodb_flush_neighbors: | 1 |
| innodb_flush_sync: | ON |
| innodb_flushing_avg_loops: | 30 |
| innodb_force_index_records_in_range: | 0 |
| innodb_force_load_corrupted: | OFF |
| innodb_force_recovery: | 0 |
| innodb_ft_aux_table: | |
| innodb_ft_cache_size: | 8000000 |
| innodb_ft_enable_diag_print: | OFF |
| innodb_ft_enable_stopword: | ON |
| innodb_ft_ignore_stopwords: | OFF |
| innodb_ft_max_token_size: | 84 |
| innodb_ft_min_token_size: | 3 |
| innodb_ft_num_word_optimize: | 2000 |
| innodb_ft_result_cache_limit: | 2000000000 |
| innodb_ft_server_stopword_table: | |
| innodb_ft_sort_pll_degree: | 2 |
| innodb_ft_total_cache_size: | 640000000 |
| innodb_ft_user_stopword_table: | |
| innodb_immediate_scrub_data_uncompressed: | OFF |
| innodb_io_capacity: | 200 |
| innodb_io_capacity_max: | 2000 |
| innodb_kill_idle_transaction: | 0 |
| innodb_large_prefix: | ON |
| innodb_lock_wait_timeout: | 50 |
| innodb_locks_unsafe_for_binlog: | OFF |
| innodb_log_buffer_size: | 8388608 |
| innodb_log_checksums: | ON |
| innodb_log_compressed_pages: | ON |
| innodb_log_file_size: | 3208642560 |
| innodb_log_files_in_group: | 2 |
| innodb_log_group_home_dir: | /opt/var/lib/mysql/ |
| innodb_log_write_ahead_size: | 8192 |
| innodb_lru_scan_depth: | 1024 |
| innodb_max_bitmap_file_size: | 104857600 |
| innodb_max_changed_pages: | 1000000 |
| innodb_max_dirty_pages_pct: | 75.000000 |
| innodb_max_dirty_pages_pct_lwm: | 0.000000 |
| innodb_max_purge_lag: | 0 |
| innodb_max_purge_lag_delay: | 0 |
| innodb_max_undo_log_size: | 1073741824 |
| innodb_monitor_disable: | |
| innodb_monitor_enable: | |
| innodb_monitor_reset: | |
| innodb_monitor_reset_all: | |
| innodb_numa_interleave: | OFF |
| innodb_old_blocks_pct: | 37 |
| innodb_old_blocks_time: | 1000 |
| innodb_online_alter_log_max_size: | 134217728 |
| innodb_open_files: | 2000 |
| innodb_optimize_fulltext_only: | OFF |
| innodb_page_cleaners: | 4 |
| innodb_page_size: | 16384 |
| innodb_parallel_dblwr_encrypt: | OFF |
| innodb_parallel_doublewrite_path: | xb_doublewrite |
| innodb_print_all_deadlocks: | OFF |
| innodb_print_lock_wait_timeout_info: | OFF |
| innodb_purge_batch_size: | 300 |
| innodb_purge_rseg_truncate_frequency: | 128 |
| innodb_purge_threads: | 4 |
| innodb_random_read_ahead: | OFF |
| innodb_read_ahead_threshold: | 56 |
| innodb_read_io_threads: | 4 |
| innodb_read_only: | OFF |
| innodb_records_in_range: | 0 |
| innodb_redo_log_encrypt: | OFF |
| innodb_replication_delay: | 0 |
| innodb_rollback_on_timeout: | OFF |
| innodb_rollback_segments: | 128 |
| innodb_scrub_log: | OFF |
| innodb_scrub_log_speed: | 256 |
| innodb_show_locks_held: | 10 |
| innodb_show_verbose_locks: | 0 |
| innodb_sort_buffer_size: | 1048576 |
| innodb_spin_wait_delay: | 6 |
| innodb_stats_auto_recalc: | ON |
| innodb_stats_include_delete_marked: | OFF |
| innodb_stats_method: | nulls_equal |
| innodb_stats_on_metadata: | OFF |
| innodb_stats_persistent: | ON |
| innodb_stats_persistent_sample_pages: | 20 |
| innodb_stats_sample_pages: | 8 |
| innodb_stats_transient_sample_pages: | 8 |
| innodb_status_output: | ON |
| innodb_status_output_locks: | OFF |
| innodb_strict_mode: | ON |
| innodb_support_xa: | ON |
| innodb_sync_array_size: | 1 |
| innodb_sync_spin_loops: | 30 |
| innodb_sys_tablespace_encrypt: | OFF |
| innodb_table_locks: | ON |
| innodb_temp_data_file_path: | ibtmp1:12M:autoextend |
| innodb_temp_tablespace_encrypt: | OFF |
| innodb_thread_concurrency: | 8 |
| innodb_thread_sleep_delay: | 0 |
| innodb_tmpdir: | |
| innodb_track_changed_pages: | OFF |
| innodb_undo_directory: | ./ |
| innodb_undo_log_encrypt: | OFF |
| innodb_undo_log_truncate: | OFF |
| innodb_undo_logs: | 128 |
| innodb_undo_tablespaces: | 0 |
| innodb_use_global_flush_log_at_trx_commit: | ON |
| innodb_use_native_aio: | ON |
| innodb_version: | 5.7.28-31 |
| innodb_write_io_threads: | 4 |
| insert_id: | 0 |
| interactive_timeout: | 28800 |
| internal_tmp_disk_storage_engine: | InnoDB |
| join_buffer_size: | 2097152 |
| keep_files_on_create: | OFF |
| key_buffer_size: | 50331648 |
| key_cache_age_threshold: | 300 |
| key_cache_block_size: | 1024 |
| key_cache_division_limit: | 70 |
| keyring_operations: | ON |
| kill_idle_transaction: | 0 |
| large_files_support: | ON |
| large_page_size: | 0 |
| large_pages: | OFF |
| last_insert_id: | 0 |
| lc_messages: | en_US |
| lc_messages_dir: | /usr/share/percona-server/ |
| lc_time_names: | en_US |
| license: | GPL |
| local_infile: | ON |
| lock_wait_timeout: | 31536000 |
| locked_in_memory: | OFF |
| log_bin: | OFF |
| log_bin_basename: | |
| log_bin_index: | |
| log_bin_trust_function_creators: | OFF |
| log_bin_use_v1_row_events: | OFF |
| log_builtin_as_identified_by_password: | OFF |
| log_error: | /var/log/mysqld.log |
| log_error_verbosity: | 3 |
| log_output: | FILE |
| log_queries_not_using_indexes: | OFF |
| log_slave_updates: | OFF |
| log_slow_admin_statements: | OFF |
| log_slow_filter: | |
| log_slow_rate_limit: | 1 |
| log_slow_rate_type: | session |
| log_slow_slave_statements: | OFF |
| log_slow_sp_statements: | ON |
| log_slow_verbosity: | |
| log_statements_unsafe_for_binlog: | ON |
| log_syslog: | OFF |
| log_syslog_facility: | daemon |
| log_syslog_include_pid: | ON |
| log_syslog_tag: | |
| log_throttle_queries_not_using_indexes: | 0 |
| log_timestamps: | UTC |
| log_warnings: | 2 |
| long_query_time: | 10.000000 |
| low_priority_updates: | OFF |
| lower_case_file_system: | OFF |
| lower_case_table_names: | 0 |
| master_info_repository: | FILE |
| master_verify_checksum: | OFF |
| max_allowed_packet: | 16777216 |
| max_binlog_cache_size: | 18446744073709547520 |
| max_binlog_files: | 0 |
| max_binlog_size: | 1073741824 |
| max_binlog_stmt_cache_size: | 18446744073709547520 |
| max_connect_errors: | 100 |
| max_connections: | 200 |
| max_delayed_threads: | 20 |
| max_digest_length: | 1024 |
| max_error_count: | 64 |
| max_execution_time: | 0 |
| max_heap_table_size: | 33554432 |
| max_insert_delayed_threads: | 20 |
| max_join_size: | 18446744073709551615 |
| max_length_for_sort_data: | 1024 |
| max_points_in_geometry: | 65536 |
| max_prepared_stmt_count: | 16382 |
| max_relay_log_size: | 0 |
| max_seeks_for_key: | 18446744073709551615 |
| max_slowlog_files: | 0 |
| max_slowlog_size: | 0 |
| max_sort_length: | 1024 |
| max_sp_recursion_depth: | 0 |
| max_tmp_tables: | 32 |
| max_user_connections: | 0 |
| max_write_lock_count: | 18446744073709551615 |
| metadata_locks_cache_size: | 1024 |
| metadata_locks_hash_instances: | 8 |
| min_examined_row_limit: | 0 |
| multi_range_count: | 256 |
| myisam_data_pointer_size: | 6 |
| myisam_max_sort_file_size: | 9223372036853727232 |
| myisam_mmap_size: | 18446744073709551615 |
| myisam_recover_options: | OFF |
| myisam_repair_threads: | 1 |
| myisam_sort_buffer_size: | 67108864 |
| myisam_stats_method: | nulls_unequal |
| myisam_use_mmap: | OFF |
| mysql_native_password_proxy_users: | OFF |
| net_buffer_length: | 16384 |
| net_read_timeout: | 30 |
| net_retry_count: | 10 |
| net_write_timeout: | 60 |
| new: | OFF |
| ngram_token_size: | 2 |
| offline_mode: | OFF |
| old: | OFF |
| old_alter_table: | OFF |
| old_passwords: | 2 |
| open_files_limit: | 5000 |
| optimizer_prune_level: | 1 |
| optimizer_search_depth: | 62 |
| optimizer_switch: | 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 |
| optimizer_trace: | enabled=off,one_line=off |
| optimizer_trace_features: | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
| optimizer_trace_limit: | 1 |
| optimizer_trace_max_mem_size: | 16384 |
| optimizer_trace_offset: | -1 |
| parser_max_mem_size: | 18446744073709551615 |
| performance_schema: | ON |
| performance_schema_accounts_size: | -1 |
| performance_schema_digests_size: | 10000 |
| performance_schema_events_stages_history_long_size: | 10000 |
| performance_schema_events_stages_history_size: | 10 |
| performance_schema_events_statements_history_long_size: | 10000 |
| performance_schema_events_statements_history_size: | 10 |
| performance_schema_events_transactions_history_long_size: | 10000 |
| performance_schema_events_transactions_history_size: | 10 |
| performance_schema_events_waits_history_long_size: | 10000 |
| performance_schema_events_waits_history_size: | 10 |
| performance_schema_hosts_size: | -1 |
| performance_schema_max_cond_classes: | 80 |
| performance_schema_max_cond_instances: | -1 |
| performance_schema_max_digest_length: | 1024 |
| performance_schema_max_file_classes: | 80 |
| performance_schema_max_file_handles: | 32768 |
| performance_schema_max_file_instances: | -1 |
| performance_schema_max_index_stat: | -1 |
| performance_schema_max_memory_classes: | 400 |
| performance_schema_max_metadata_locks: | -1 |
| performance_schema_max_mutex_classes: | 250 |
| performance_schema_max_mutex_instances: | -1 |
| performance_schema_max_prepared_statements_instances: | -1 |
| performance_schema_max_program_instances: | -1 |
| performance_schema_max_rwlock_classes: | 50 |
| performance_schema_max_rwlock_instances: | -1 |
| performance_schema_max_socket_classes: | 10 |
| performance_schema_max_socket_instances: | -1 |
| performance_schema_max_sql_text_length: | 1024 |
| performance_schema_max_stage_classes: | 150 |
| performance_schema_max_statement_classes: | 203 |
| performance_schema_max_statement_stack: | 10 |
| performance_schema_max_table_handles: | -1 |
| performance_schema_max_table_instances: | -1 |
| performance_schema_max_table_lock_stat: | -1 |
| performance_schema_max_thread_classes: | 50 |
| performance_schema_max_thread_instances: | -1 |
| performance_schema_session_connect_attrs_size: | 512 |
| performance_schema_setup_actors_size: | -1 |
| performance_schema_setup_objects_size: | -1 |
| performance_schema_users_size: | -1 |
| pid_file: | /var/run/mysqld/mysqld.pid |
| plugin_dir: | /usr/lib64/mysql/plugin/ |
| port: | 3306 |
| preload_buffer_size: | 32768 |
| profiling: | OFF |
| profiling_history_size: | 15 |
| protocol_version: | 10 |
| proxy_protocol_networks: | |
| proxy_user: | |
| pseudo_server_id: | 0 |
| pseudo_slave_mode: | OFF |
| pseudo_thread_id: | 492645376 |
| query_alloc_block_size: | 8192 |
| query_cache_limit: | 16777216 |
| query_cache_min_res_unit: | 4096 |
| query_cache_size: | 67108864 |
| query_cache_strip_comments: | OFF |
| query_cache_type: | ON |
| query_cache_wlock_invalidate: | OFF |
| query_prealloc_size: | 8192 |
| rand_seed1: | 0 |
| rand_seed2: | 0 |
| range_alloc_block_size: | 4096 |
| range_optimizer_max_mem_size: | 8388608 |
| rbr_exec_mode: | STRICT |
| read_buffer_size: | 262144 |
| read_only: | OFF |
| read_rnd_buffer_size: | 4194304 |
| relay_log: | |
| relay_log_basename: | /opt/var/lib/mysql/forum-relay-bin |
| relay_log_index: | /opt/var/lib/mysql/forum-relay-bin.index |
| relay_log_info_file: | relay-log.info |
| relay_log_info_repository: | FILE |
| relay_log_purge: | ON |
| relay_log_recovery: | OFF |
| relay_log_space_limit: | 0 |
| report_host: | |
| report_password: | |
| report_port: | 3306 |
| report_user: | |
| require_secure_transport: | OFF |
| rpl_stop_slave_timeout: | 31536000 |
| secure_auth: | ON |
| secure_file_priv: | /var/lib/mysql-files/ |
| server_id: | 0 |
| server_id_bits: | 32 |
| server_uuid: | 923c0d45-3ce7-11ea-9184-406186f7001d |
| session_track_gtids: | OFF |
| session_track_schema: | ON |
| session_track_state_change: | OFF |
| session_track_system_variables: | time_zone,autocommit,character_set_client,character_set_results,character_set_connection |
| session_track_transaction_info: | OFF |
| sha256_password_auto_generate_rsa_keys: | ON |
| sha256_password_private_key_path: | private_key.pem |
| sha256_password_proxy_users: | OFF |
| sha256_password_public_key_path: | public_key.pem |
| show_compatibility_56: | OFF |
| show_create_table_verbosity: | OFF |
| show_old_temporals: | OFF |
| skip_external_locking: | ON |
| skip_name_resolve: | OFF |
| skip_networking: | OFF |
| skip_show_database: | OFF |
| slave_allow_batching: | OFF |
| slave_checkpoint_group: | 512 |
| slave_checkpoint_period: | 300 |
| slave_compressed_protocol: | OFF |
| slave_exec_mode: | STRICT |
| slave_load_tmpdir: | /opt/var/tmp |
| slave_max_allowed_packet: | 1073741824 |
| slave_net_timeout: | 60 |
| slave_parallel_type: | DATABASE |
| slave_parallel_workers: | 0 |
| slave_pending_jobs_size_max: | 16777216 |
| slave_preserve_commit_order: | OFF |
| slave_rows_search_algorithms: | TABLE_SCAN,INDEX_SCAN |
| slave_skip_errors: | OFF |
| slave_sql_verify_checksum: | ON |
| slave_transaction_retries: | 10 |
| slave_type_conversions: | |
| slow_launch_time: | 2 |
| slow_query_log: | OFF |
| slow_query_log_always_write_time: | 10.000000 |
| slow_query_log_file: | /var/log/mysql/mysql-slow.log |
| slow_query_log_use_global_control: | |
| socket: | /var/lib/mysql/mysql.sock |
| sort_buffer_size: | 393216 |
| sql_auto_is_null: | OFF |
| sql_big_selects: | ON |
| sql_buffer_result: | OFF |
| sql_log_bin: | ON |
| sql_log_off: | OFF |
| sql_mode: | NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
| sql_notes: | ON |
| sql_quote_show_create: | ON |
| sql_safe_updates: | OFF |
| sql_select_limit: | 18446744073709551615 |
| sql_slave_skip_counter: | 0 |
| sql_warnings: | OFF |
| ssl_ca: | ca.pem |
| ssl_capath: | |
| ssl_cert: | server-cert.pem |
| ssl_cipher: | |
| ssl_crl: | |
| ssl_crlpath: | |
| ssl_key: | server-key.pem |
| stored_program_cache: | 256 |
| super_read_only: | OFF |
| sync_binlog: | 1 |
| sync_frm: | ON |
| sync_master_info: | 10000 |
| sync_relay_log: | 10000 |
| sync_relay_log_info: | 10000 |
| system_time_zone: | CEST |
| table_definition_cache: | 1400 |
| table_open_cache: | 2000 |
| table_open_cache_instances: | 16 |
| thread_cache_size: | 32 |
| thread_handling: | one-thread-per-connection |
| thread_pool_high_prio_mode: | transactions |
| thread_pool_high_prio_tickets: | 4294967295 |
| thread_pool_idle_timeout: | 60 |
| thread_pool_max_threads: | 100000 |
| thread_pool_oversubscribe: | 3 |
| thread_pool_size: | 8 |
| thread_pool_stall_limit: | 500 |
| thread_stack: | 262144 |
| thread_statistics: | OFF |
| time_format: | %H:%i:%s |
| time_zone: | SYSTEM |
| timestamp: | 1752841053.332068 |
| tls_version: | TLSv1,TLSv1.1,TLSv1.2 |
| tmp_table_size: | 33554432 |
| tmpdir: | /opt/var/tmp |
| transaction_alloc_block_size: | 8192 |
| transaction_allow_batching: | OFF |
| transaction_isolation: | REPEATABLE-READ |
| transaction_prealloc_size: | 4096 |
| transaction_read_only: | OFF |
| transaction_write_set_extraction: | OFF |
| tx_isolation: | REPEATABLE-READ |
| tx_read_only: | OFF |
| unique_checks: | ON |
| updatable_views_with_limit: | YES |
| userstat: | OFF |
| version: | 5.7.28-31 |
| version_comment: | Percona Server (GPL), Release 31, Revision d14ef86 |
| version_compile_machine: | x86_64 |
| version_compile_os: | Linux |
| version_suffix: | |
| wait_timeout: | 120 |
| warning_count: | 0 |