Basic Information
May 03, 2024, 07:30:49 AM
| Operating System: | Debian wheezy/sid |
|---|---|
| Processor: | Intel® Xeon® CPU E5-2630L v2 @ 2.40GHz (2399.998MHz) |
| Load averages: | 0.00, 0.03, 0.05 |
| Current processes: | 80 (79 sleeping, 1 running, 0 zombie) |
| Processes by CPU: | apache2 (14) 7.0%, (other) (53) 0.2% |
| Memory usage: |
91.337% (931168k / 1019484k) Swap: 15.536% (81452k / 524284k) |
MySQL processes
| Total processes: | 5 (4 sleeping, 1 running, 0 locked) |
|---|
MySQL Statistics
MySQL 5.5.x
| Connections per second: | 0.4451 |
|---|---|
| Kilobytes received per second: | 1.6343 |
| Kilobytes sent per second: | 7.8912 |
| Queries per second: | 5.8172 |
| Percentage of slow queries: | 0 |
|
Opened vs. Open tables: (table_cache) |
932.6087 (should be <= 80) |
|
Key buffer read hit rate: (key_buffer_size) |
0 (should be <= 0.01) |
|
Key buffer write hit rate: (key_buffer_size) |
0.4633 (should be <= 0.5) |
|
Thread cache hit rate: (thread_cache_size) |
89061.5733 (should be >= 30 ) |
|
Thread cache usage: (thread_cache_size) |
0.9609 (should be >= 0.7 and <= 0.9) |
|
Temporary table disk usage: (tmp_table_size) |
0.0023 (should be <= 0.5) |
|
Sort merge pass rate: (sort_buffer) |
0 (should be <= 0.001) |
|
Query cache enabled: (query_cache_type) |
1 (should be >= 1 and <= 1) |
|
Query cache miss rate: (query_cache_limit) |
0.5309 (should be <= 0.5) |
|
Query cache prune rate: (query_cache_size) |
0.0223 (should be <= 0.05) |
MySQL status
| Aborted_clients: | 136 |
|---|---|
| Aborted_connects: | 13306 |
| Binlog_cache_disk_use: | 0 |
| Binlog_cache_use: | 0 |
| Binlog_stmt_cache_disk_use: | 0 |
| Binlog_stmt_cache_use: | 0 |
| Bytes_received: | 50223266145 |
| Bytes_sent: | 242505276007 |
| Com_admin_commands: | 348 |
| Com_assign_to_keycache: | 0 |
| Com_alter_db: | 0 |
| Com_alter_db_upgrade: | 0 |
| Com_alter_event: | 0 |
| Com_alter_function: | 0 |
| Com_alter_procedure: | 0 |
| Com_alter_server: | 0 |
| Com_alter_table: | 0 |
| Com_alter_tablespace: | 0 |
| Com_analyze: | 0 |
| Com_begin: | 0 |
| Com_binlog: | 0 |
| Com_call_procedure: | 0 |
| Com_change_db: | 13331526 |
| Com_change_master: | 0 |
| Com_check: | 0 |
| Com_checksum: | 0 |
| Com_commit: | 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: | 149982 |
| Com_create_trigger: | 0 |
| Com_create_udf: | 0 |
| Com_create_user: | 0 |
| Com_create_view: | 0 |
| Com_dealloc_sql: | 0 |
| Com_delete: | 2907241 |
| Com_delete_multi: | 0 |
| Com_do: | 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: | 149982 |
| Com_drop_trigger: | 0 |
| Com_drop_user: | 0 |
| Com_drop_view: | 0 |
| Com_empty_query: | 0 |
| Com_execute_sql: | 0 |
| Com_flush: | 347 |
| Com_grant: | 0 |
| Com_ha_close: | 0 |
| Com_ha_open: | 0 |
| Com_ha_read: | 0 |
| Com_help: | 0 |
| Com_insert: | 4164537 |
| Com_insert_select: | 430 |
| Com_install_plugin: | 0 |
| Com_kill: | 0 |
| Com_load: | 0 |
| Com_lock_tables: | 0 |
| Com_optimize: | 0 |
| Com_preload_keys: | 0 |
| Com_prepare_sql: | 0 |
| Com_purge: | 0 |
| Com_purge_before_date: | 0 |
| Com_release_savepoint: | 0 |
| Com_rename_table: | 0 |
| Com_rename_user: | 0 |
| Com_repair: | 0 |
| Com_replace: | 6515095 |
| Com_replace_select: | 0 |
| Com_reset: | 0 |
| Com_resignal: | 0 |
| Com_revoke: | 0 |
| Com_revoke_all: | 0 |
| Com_rollback: | 0 |
| Com_rollback_to_savepoint: | 0 |
| Com_savepoint: | 0 |
| Com_select: | 52988505 |
| Com_set_option: | 12782083 |
| Com_signal: | 0 |
| Com_show_authors: | 0 |
| Com_show_binlog_events: | 0 |
| Com_show_binlogs: | 0 |
| Com_show_charsets: | 0 |
| Com_show_collations: | 0 |
| Com_show_contributors: | 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: | 0 |
| Com_show_create_trigger: | 0 |
| Com_show_databases: | 0 |
| Com_show_engine_logs: | 0 |
| Com_show_engine_mutex: | 0 |
| Com_show_engine_status: | 0 |
| Com_show_events: | 0 |
| Com_show_errors: | 0 |
| Com_show_fields: | 0 |
| Com_show_function_status: | 0 |
| Com_show_grants: | 0 |
| Com_show_keys: | 0 |
| Com_show_master_status: | 0 |
| Com_show_open_tables: | 0 |
| Com_show_plugins: | 0 |
| Com_show_privileges: | 0 |
| Com_show_procedure_status: | 0 |
| Com_show_processlist: | 755 |
| 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: | 756 |
| Com_show_storage_engines: | 0 |
| Com_show_table_status: | 0 |
| Com_show_tables: | 1656460 |
| Com_show_triggers: | 0 |
| Com_show_variables: | 757 |
| Com_show_warnings: | 0 |
| Com_slave_start: | 0 |
| Com_slave_stop: | 0 |
| Com_stmt_close: | 0 |
| Com_stmt_execute: | 0 |
| Com_stmt_fetch: | 0 |
| Com_stmt_prepare: | 0 |
| Com_stmt_reprepare: | 0 |
| Com_stmt_reset: | 0 |
| Com_stmt_send_long_data: | 0 |
| Com_truncate: | 0 |
| Com_uninstall_plugin: | 0 |
| Com_unlock_tables: | 0 |
| Com_update: | 19760560 |
| 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 |
| Compression: | OFF |
| Connections: | 13359236 |
| Created_tmp_disk_tables: | 4369 |
| Created_tmp_files: | 2869 |
| Created_tmp_tables: | 1883565 |
| Delayed_errors: | 0 |
| Delayed_insert_threads: | 0 |
| Delayed_writes: | 0 |
| Flush_commands: | 1 |
| Handler_commit: | 72281437 |
| Handler_delete: | 4892961 |
| Handler_discover: | 0 |
| Handler_prepare: | 0 |
| Handler_read_first: | 19762346 |
| Handler_read_key: | 1837319787 |
| Handler_read_last: | 326616 |
| Handler_read_next: | 17551030531 |
| Handler_read_prev: | 188981226 |
| Handler_read_rnd: | 216933811 |
| Handler_read_rnd_next: | 2399413595 |
| Handler_rollback: | 1490941 |
| Handler_savepoint: | 0 |
| Handler_savepoint_rollback: | 0 |
| Handler_update: | 45914518 |
| Handler_write: | 93913019 |
| Innodb_buffer_pool_pages_data: | 2031 |
| Innodb_buffer_pool_bytes_data: | 33275904 |
| Innodb_buffer_pool_pages_dirty: | 0 |
| Innodb_buffer_pool_bytes_dirty: | 0 |
| Innodb_buffer_pool_pages_flushed: | 80064591 |
| Innodb_buffer_pool_pages_free: | 0 |
| Innodb_buffer_pool_pages_misc: | 16 |
| Innodb_buffer_pool_pages_total: | 2047 |
| Innodb_buffer_pool_read_ahead_rnd: | 0 |
| Innodb_buffer_pool_read_ahead: | 3595768 |
| Innodb_buffer_pool_read_ahead_evicted: | 470720 |
| Innodb_buffer_pool_read_requests: | 11932987720 |
| Innodb_buffer_pool_reads: | 179169964 |
| Innodb_buffer_pool_wait_free: | 0 |
| Innodb_buffer_pool_write_requests: | 332065076 |
| Innodb_data_fsyncs: | 16350375 |
| Innodb_data_pending_fsyncs: | 0 |
| Innodb_data_pending_reads: | 0 |
| Innodb_data_pending_writes: | 0 |
| Innodb_data_read: | 3000041345024 |
| Innodb_data_reads: | 179571654 |
| Innodb_data_writes: | 105946224 |
| Innodb_data_written: | 2657185130496 |
| Innodb_dblwr_pages_written: | 80064591 |
| Innodb_dblwr_writes: | 3439814 |
| Innodb_have_atomic_builtins: | ON |
| Innodb_log_waits: | 0 |
| Innodb_log_write_requests: | 34825266 |
| Innodb_log_writes: | 32358462 |
| Innodb_os_log_fsyncs: | 9470817 |
| Innodb_os_log_pending_fsyncs: | 0 |
| Innodb_os_log_pending_writes: | 0 |
| Innodb_os_log_written: | 32702227968 |
| Innodb_page_size: | 16384 |
| Innodb_pages_created: | 594703 |
| Innodb_pages_read: | 183107858 |
| Innodb_pages_written: | 80064591 |
| Innodb_row_lock_current_waits: | 0 |
| Innodb_row_lock_time: | 6 |
| Innodb_row_lock_time_avg: | 0 |
| Innodb_row_lock_time_max: | 1 |
| Innodb_row_lock_waits: | 19 |
| Innodb_rows_deleted: | 1567864 |
| Innodb_rows_inserted: | 74140566 |
| Innodb_rows_read: | 19864756638 |
| Innodb_rows_updated: | 22239925 |
| Innodb_truncated_status_writes: | 0 |
| Key_blocks_not_flushed: | 0 |
| Key_blocks_unused: | 10430 |
| Key_blocks_used: | 16362 |
| Key_read_requests: | 383085880 |
| Key_reads: | 8201 |
| Key_write_requests: | 20744962 |
| Key_writes: | 9611937 |
| Last_query_cost: | 0.000000 |
| Max_used_connections: | 150 |
| Not_flushed_delayed_rows: | 0 |
| Open_files: | 178 |
| Open_streams: | 0 |
| Open_table_definitions: | 116 |
| Open_tables: | 161 |
| Opened_files: | 471304 |
| Opened_table_definitions: | 300080 |
| Opened_tables: | 150150 |
| Performance_schema_cond_classes_lost: | 0 |
| Performance_schema_cond_instances_lost: | 0 |
| Performance_schema_file_classes_lost: | 0 |
| Performance_schema_file_handles_lost: | 0 |
| Performance_schema_file_instances_lost: | 0 |
| Performance_schema_locker_lost: | 0 |
| Performance_schema_mutex_classes_lost: | 0 |
| Performance_schema_mutex_instances_lost: | 0 |
| Performance_schema_rwlock_classes_lost: | 0 |
| Performance_schema_rwlock_instances_lost: | 0 |
| Performance_schema_table_handles_lost: | 0 |
| Performance_schema_table_instances_lost: | 0 |
| Performance_schema_thread_classes_lost: | 0 |
| Performance_schema_thread_instances_lost: | 0 |
| Prepared_stmt_count: | 0 |
| Qcache_free_blocks: | 6124 |
| Qcache_free_memory: | 18496304 |
| Qcache_hits: | 46822774 |
| Qcache_inserts: | 52398067 |
| Qcache_lowmem_prunes: | 1180075 |
| Qcache_not_cached: | 590484 |
| Qcache_queries_in_cache: | 7797 |
| Qcache_total_blocks: | 21752 |
| Queries: | 174579362 |
| Questions: | 174579013 |
| Rpl_status: | AUTH_MASTER |
| Select_full_join: | 1523065 |
| Select_full_range_join: | 1716 |
| Select_range: | 12343998 |
| Select_range_check: | 0 |
| Select_scan: | 12582073 |
| Slave_heartbeat_period: | 0.000 |
| Slave_open_temp_tables: | 0 |
| Slave_received_heartbeats: | 0 |
| Slave_retried_transactions: | 0 |
| Slave_running: | OFF |
| Slow_launch_threads: | 0 |
| Slow_queries: | 4464 |
| Sort_merge_passes: | 1432 |
| Sort_range: | 156108 |
| Sort_rows: | 224920609 |
| Sort_scan: | 2521656 |
| 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: | 0 |
| Ssl_ctx_verify_mode: | 0 |
| Ssl_default_timeout: | 0 |
| Ssl_finished_accepts: | 0 |
| Ssl_finished_connects: | 0 |
| Ssl_session_cache_hits: | 0 |
| Ssl_session_cache_misses: | 0 |
| Ssl_session_cache_mode: | NONE |
| Ssl_session_cache_overflows: | 0 |
| Ssl_session_cache_size: | 0 |
| 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: | 196785667 |
| Table_locks_waited: | 18 |
| Tc_log_max_pages_used: | 0 |
| Tc_log_page_size: | 0 |
| Tc_log_page_waits: | 0 |
| Threads_cached: | 123 |
| Threads_connected: | 5 |
| Threads_created: | 150 |
| Threads_running: | 1 |
| Uptime: | 30010928 |
| Uptime_since_flush_status: | 30010928 |
MySQL variables
| auto_increment_increment: | 1 |
|---|---|
| auto_increment_offset: | 1 |
| autocommit: | ON |
| automatic_sp_privileges: | ON |
| back_log: | 50 |
| basedir: | /usr |
| big_tables: | OFF |
| binlog_cache_size: | 32768 |
| binlog_direct_non_transactional_updates: | OFF |
| binlog_format: | STATEMENT |
| binlog_stmt_cache_size: | 32768 |
| bulk_insert_buffer_size: | 8388608 |
| character_set_client: | latin1 |
| character_set_connection: | latin1 |
| character_set_database: | utf8 |
| character_set_filesystem: | binary |
| character_set_results: | latin1 |
| character_set_server: | latin1 |
| character_set_system: | utf8 |
| character_sets_dir: | /usr/share/mysql/charsets/ |
| collation_connection: | latin1_swedish_ci |
| collation_database: | utf8_general_ci |
| collation_server: | latin1_swedish_ci |
| completion_type: | NO_CHAIN |
| concurrent_insert: | AUTO |
| connect_timeout: | 10 |
| datadir: | /var/lib/mysql/ |
| date_format: | %Y-%m-%d |
| datetime_format: | %Y-%m-%d %H:%i:%s |
| default_storage_engine: | InnoDB |
| default_week_format: | 0 |
| delay_key_write: | ON |
| delayed_insert_limit: | 100 |
| delayed_insert_timeout: | 300 |
| delayed_queue_size: | 1000 |
| div_precision_increment: | 4 |
| engine_condition_pushdown: | ON |
| error_count: | 0 |
| event_scheduler: | OFF |
| expire_logs_days: | 10 |
| external_user: | |
| 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_stopword_file: | (built-in) |
| general_log: | OFF |
| general_log_file: | /var/lib/mysql/basketforum.log |
| group_concat_max_len: | 1024 |
| have_compress: | YES |
| have_crypt: | YES |
| have_csv: | YES |
| have_dynamic_loading: | YES |
| have_geometry: | YES |
| have_innodb: | YES |
| have_ndbcluster: | NO |
| have_openssl: | DISABLED |
| have_partitioning: | YES |
| have_profiling: | YES |
| have_query_cache: | YES |
| have_rtree_keys: | YES |
| have_ssl: | DISABLED |
| have_symlink: | YES |
| hostname: | basketforum |
| identity: | 0 |
| ignore_builtin_innodb: | OFF |
| init_connect: | |
| init_file: | |
| init_slave: | |
| innodb_adaptive_flushing: | ON |
| innodb_adaptive_hash_index: | ON |
| innodb_additional_mem_pool_size: | 8388608 |
| innodb_autoextend_increment: | 8 |
| innodb_autoinc_lock_mode: | 1 |
| innodb_buffer_pool_instances: | 1 |
| innodb_buffer_pool_size: | 33554432 |
| innodb_change_buffering: | all |
| innodb_checksums: | ON |
| innodb_commit_concurrency: | 0 |
| innodb_concurrency_tickets: | 500 |
| innodb_data_file_path: | ibdata1:10M:autoextend |
| innodb_data_home_dir: | |
| innodb_doublewrite: | ON |
| innodb_fast_shutdown: | 1 |
| innodb_file_format: | Antelope |
| innodb_file_format_check: | ON |
| innodb_file_format_max: | Antelope |
| innodb_file_per_table: | OFF |
| innodb_flush_log_at_trx_commit: | 2 |
| innodb_flush_method: | |
| innodb_force_load_corrupted: | OFF |
| innodb_force_recovery: | 0 |
| innodb_io_capacity: | 200 |
| innodb_large_prefix: | OFF |
| innodb_lock_wait_timeout: | 50 |
| innodb_locks_unsafe_for_binlog: | OFF |
| innodb_log_buffer_size: | 8388608 |
| innodb_log_file_size: | 5242880 |
| innodb_log_files_in_group: | 2 |
| innodb_log_group_home_dir: | ./ |
| innodb_max_dirty_pages_pct: | 75 |
| innodb_max_purge_lag: | 0 |
| innodb_mirrored_log_groups: | 1 |
| innodb_old_blocks_pct: | 37 |
| innodb_old_blocks_time: | 0 |
| innodb_open_files: | 300 |
| innodb_print_all_deadlocks: | OFF |
| innodb_purge_batch_size: | 20 |
| innodb_purge_threads: | 0 |
| innodb_random_read_ahead: | OFF |
| innodb_read_ahead_threshold: | 56 |
| innodb_read_io_threads: | 4 |
| innodb_replication_delay: | 0 |
| innodb_rollback_on_timeout: | OFF |
| innodb_rollback_segments: | 128 |
| innodb_spin_wait_delay: | 6 |
| innodb_stats_method: | nulls_equal |
| innodb_stats_on_metadata: | ON |
| innodb_stats_sample_pages: | 8 |
| innodb_strict_mode: | OFF |
| innodb_support_xa: | ON |
| innodb_sync_spin_loops: | 30 |
| innodb_table_locks: | ON |
| innodb_thread_concurrency: | 0 |
| innodb_thread_sleep_delay: | 10000 |
| innodb_use_native_aio: | OFF |
| innodb_use_sys_malloc: | ON |
| innodb_version: | 5.5.54 |
| innodb_write_io_threads: | 4 |
| insert_id: | 0 |
| interactive_timeout: | 100 |
| join_buffer_size: | 1048576 |
| keep_files_on_create: | OFF |
| key_buffer_size: | 33554432 |
| key_cache_age_threshold: | 300 |
| key_cache_block_size: | 1024 |
| key_cache_division_limit: | 100 |
| large_files_support: | ON |
| large_page_size: | 0 |
| large_pages: | OFF |
| last_insert_id: | 0 |
| lc_messages: | en_US |
| lc_messages_dir: | /usr/share/mysql/ |
| lc_time_names: | en_US |
| license: | GPL |
| local_infile: | ON |
| lock_wait_timeout: | 31536000 |
| locked_in_memory: | OFF |
| log: | OFF |
| log_bin: | OFF |
| log_bin_trust_function_creators: | OFF |
| log_error: | /var/log/mysql/error.log |
| log_output: | FILE |
| log_queries_not_using_indexes: | OFF |
| log_slave_updates: | OFF |
| log_slow_queries: | ON |
| log_warnings: | 1 |
| long_query_time: | 1.000000 |
| low_priority_updates: | OFF |
| lower_case_file_system: | OFF |
| lower_case_table_names: | 0 |
| max_allowed_packet: | 33554432 |
| max_binlog_cache_size: | 18446744073709547520 |
| max_binlog_size: | 104857600 |
| max_binlog_stmt_cache_size: | 18446744073709547520 |
| max_connect_errors: | 10 |
| max_connections: | 3000 |
| max_delayed_threads: | 20 |
| max_error_count: | 64 |
| max_heap_table_size: | 67108864 |
| max_insert_delayed_threads: | 20 |
| max_join_size: | 18446744073709551615 |
| max_length_for_sort_data: | 1024 |
| max_long_data_size: | 33554432 |
| max_prepared_stmt_count: | 16382 |
| max_relay_log_size: | 0 |
| max_seeks_for_key: | 18446744073709551615 |
| max_sort_length: | 1024 |
| max_sp_recursion_depth: | 0 |
| max_tmp_tables: | 32 |
| max_user_connections: | 600 |
| max_write_lock_count: | 18446744073709551615 |
| metadata_locks_cache_size: | 1024 |
| 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: | BACKUP |
| myisam_repair_threads: | 1 |
| myisam_sort_buffer_size: | 33554432 |
| myisam_stats_method: | nulls_unequal |
| myisam_use_mmap: | OFF |
| net_buffer_length: | 16384 |
| net_read_timeout: | 30 |
| net_retry_count: | 10 |
| net_write_timeout: | 60 |
| new: | OFF |
| old: | OFF |
| old_alter_table: | OFF |
| old_passwords: | OFF |
| open_files_limit: | 15000 |
| 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 |
| performance_schema: | OFF |
| performance_schema_events_waits_history_long_size: | 10000 |
| performance_schema_events_waits_history_size: | 10 |
| performance_schema_max_cond_classes: | 80 |
| performance_schema_max_cond_instances: | 1000 |
| performance_schema_max_file_classes: | 50 |
| performance_schema_max_file_handles: | 32768 |
| performance_schema_max_file_instances: | 10000 |
| performance_schema_max_mutex_classes: | 200 |
| performance_schema_max_mutex_instances: | 1000000 |
| performance_schema_max_rwlock_classes: | 30 |
| performance_schema_max_rwlock_instances: | 1000000 |
| performance_schema_max_table_handles: | 100000 |
| performance_schema_max_table_instances: | 50000 |
| performance_schema_max_thread_classes: | 50 |
| performance_schema_max_thread_instances: | 1000 |
| pid_file: | /var/run/mysqld/mysqld.pid |
| plugin_dir: | /usr/lib/mysql/plugin/ |
| port: | 3306 |
| preload_buffer_size: | 32768 |
| profiling: | OFF |
| profiling_history_size: | 15 |
| protocol_version: | 10 |
| proxy_user: | |
| pseudo_slave_mode: | OFF |
| pseudo_thread_id: | 13359235 |
| query_alloc_block_size: | 8192 |
| query_cache_limit: | 1048576 |
| query_cache_min_res_unit: | 4096 |
| query_cache_size: | 33554432 |
| query_cache_type: | ON |
| query_cache_wlock_invalidate: | OFF |
| query_prealloc_size: | 8192 |
| rand_seed1: | 0 |
| rand_seed2: | 0 |
| range_alloc_block_size: | 4096 |
| read_buffer_size: | 1048576 |
| read_only: | OFF |
| read_rnd_buffer_size: | 786432 |
| relay_log: | |
| relay_log_index: | |
| relay_log_info_file: | relay-log.info |
| relay_log_purge: | ON |
| relay_log_recovery: | OFF |
| relay_log_space_limit: | 0 |
| report_host: | |
| report_password: | |
| report_port: | 3306 |
| report_user: | |
| rpl_recovery_rank: | 0 |
| secure_auth: | OFF |
| secure_file_priv: | /var/lib/mysql-files/ |
| server_id: | 0 |
| skip_external_locking: | ON |
| skip_name_resolve: | OFF |
| skip_networking: | OFF |
| skip_show_database: | OFF |
| slave_compressed_protocol: | OFF |
| slave_exec_mode: | STRICT |
| slave_load_tmpdir: | /var/tmpfs |
| slave_max_allowed_packet: | 1073741824 |
| slave_net_timeout: | 3600 |
| slave_skip_errors: | OFF |
| slave_transaction_retries: | 10 |
| slave_type_conversions: | |
| slow_launch_time: | 2 |
| slow_query_log: | ON |
| slow_query_log_file: | /var/log/mysql/mysql-slow.log |
| socket: | /var/run/mysqld/mysqld.sock |
| sort_buffer_size: | 1048576 |
| sql_auto_is_null: | OFF |
| sql_big_selects: | ON |
| sql_big_tables: | OFF |
| sql_buffer_result: | OFF |
| sql_log_bin: | ON |
| sql_log_off: | OFF |
| sql_low_priority_updates: | OFF |
| sql_max_join_size: | 18446744073709551615 |
| sql_mode: | |
| 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: | |
| ssl_capath: | |
| ssl_cert: | |
| ssl_cipher: | |
| ssl_key: | |
| storage_engine: | InnoDB |
| stored_program_cache: | 256 |
| sync_binlog: | 0 |
| sync_frm: | ON |
| sync_master_info: | 0 |
| sync_relay_log: | 0 |
| sync_relay_log_info: | 0 |
| system_time_zone: | UTC |
| table_definition_cache: | 400 |
| table_open_cache: | 2048 |
| thread_cache_size: | 128 |
| thread_concurrency: | 4 |
| thread_handling: | one-thread-per-connection |
| thread_stack: | 196608 |
| time_format: | %H:%i:%s |
| time_zone: | SYSTEM |
| timed_mutexes: | OFF |
| timestamp: | 1714721449 |
| tmp_table_size: | 67108864 |
| tmpdir: | /var/tmpfs |
| transaction_alloc_block_size: | 8192 |
| transaction_prealloc_size: | 4096 |
| tx_isolation: | REPEATABLE-READ |
| unique_checks: | ON |
| updatable_views_with_limit: | YES |
| version: | 5.5.54-0ubuntu0.12.04.1-log |
| version_comment: | (Ubuntu) |
| version_compile_machine: | x86_64 |
| version_compile_os: | debian-linux-gnu |
| wait_timeout: | 100 |
| warning_count: | 0 |