Re: Open Table Cache (1024 limit vs. 100 mil. opened tables)

[Kim Waldorff Østergaard]

Hi Peter,

Thanks for your reply.

First the general questions to asked:

The DB is a ClearDB / AZure hosted on, and I cannot figure out how to see RAM allocated. But I can see that it uses 33% of Memory as of now in the ClearDB dashboard.

And I can see the buffer and versions are printed below.


(i)

# engine, data, indexes, total
'MyISAM', '0.06 GB', '0.02 GB', '0.08 GB'
'InnoDB', '0.02 GB', '0.01 GB', '0.04 GB'
'MEMORY', '0.00 GB', '0.00 GB', '0.00 GB'
'TOTALS', '0.09 GB', '0.03 GB', '0.12 GB'


(ii)

show variables;
# Variable_name, Value
'auto_increment_increment', '10'
'auto_increment_offset', '4'
'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', 'MIXED'
'binlog_stmt_cache_size', '32768'
'bulk_insert_buffer_size', '8388608'
'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'utf8'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'latin1'
'character_set_system', 'utf8'
'character_sets_dir', '/usr/share/mysql/charsets/'
'collation_connection', 'utf8_general_ci'
'collation_database', 'utf8_general_ci'
'collation_server', 'latin1_swedish_ci'
'completion_type', 'NO_CHAIN'
'concurrent_insert', 'AUTO'
'connect_timeout', '10'
'datadir', '/data/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', '0'
'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', '/data/mysql/eummazurewest13a.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', 'YES'
'have_partitioning', 'YES'
'have_profiling', 'YES'
'have_query_cache', 'YES'
'have_rtree_keys', 'YES'
'have_ssl', 'YES'
'have_symlink', 'DISABLED'
'hostname', 'eummazurewest13a'
'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', '83886080'
'innodb_autoextend_increment', '8'
'innodb_autoinc_lock_mode', '1'
'innodb_buffer_pool_instances', '1'
'innodb_buffer_pool_size', '1073741824'
'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', '1'
'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', '16777216'
'innodb_log_file_size', '67108864'
'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', 'ON'
'innodb_use_sys_malloc', 'ON'
'innodb_version', '5.5.56'
'innodb_write_io_threads', '4'
'insert_id', '0'
'interactive_timeout', '28800'
'join_buffer_size', '131072'
'keep_files_on_create', 'OFF'
'key_buffer_size', '402653184'
'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', 'OFF'
'lock_wait_timeout', '31536000'
'locked_in_memory', 'OFF'
'log', 'OFF'
'log_bin', 'ON'
'log_bin_trust_function_creators', 'OFF'
'log_error', '/var/log/mysqld.log'
'log_output', 'TABLE'
'log_queries_not_using_indexes', 'OFF'
'log_slave_updates', 'ON'
'log_slow_queries', 'ON'
'log_warnings', '1'
'long_query_time', '10.000000'
'low_priority_updates', 'OFF'
'lower_case_file_system', 'OFF'
'lower_case_table_names', '1'
'max_allowed_packet', '33554432'
'max_binlog_cache_size', '18446744073709547520'
'max_binlog_size', '1073741824'
'max_binlog_stmt_cache_size', '18446744073709547520'
'max_connect_errors', '1000000'
'max_connections', '1000'
'max_delayed_threads', '20'
'max_error_count', '64'
'max_heap_table_size', '16777216'
'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', '15'
'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', 'OFF'
'myisam_repair_threads', '1'
'myisam_sort_buffer_size', '16777216'
'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', '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'
'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', '/data/mysql/eummazurewest13a.pid'
'plugin_dir', '/usr/lib64/mysql/plugin/'
'port', '3310'
'preload_buffer_size', '32768'
'profiling', 'OFF'
'profiling_history_size', '15'
'protocol_version', '10'
'proxy_user', ''
'pseudo_slave_mode', 'OFF'
'pseudo_thread_id', '54650070'
'query_alloc_block_size', '8192'
'query_cache_limit', '1048576'
'query_cache_min_res_unit', '4096'
'query_cache_size', '268435456'
'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', '16777216'
'read_only', 'OFF'
'read_rnd_buffer_size', '16777216'
'relay_log', '/data/mysql/relay.log'
'relay_log_index', '/data/mysql/relay-log.index'
'relay_log_info_file', '/data/mysql/relay-log.info'
'relay_log_purge', 'ON'
'relay_log_recovery', 'OFF'
'relay_log_space_limit', '0'
'report_host', ''
'report_password', ''
'report_port', '3310'
'report_user', ''
'rpl_recovery_rank', '0'
'secure_auth', 'OFF'
'secure_file_priv', '/var/lib/mysql-files/'
'server_id', '4'
'skip_external_locking', 'ON'
'skip_name_resolve', 'OFF'
'skip_networking', 'OFF'
'skip_show_database', 'OFF'
'slave_compressed_protocol', 'ON'
'slave_exec_mode', 'STRICT'
'slave_load_tmpdir', '/data/mysql_tmp'
'slave_max_allowed_packet', '1073741824'
'slave_net_timeout', '3600'
'slave_skip_errors', '126,1032,1050,1051,1060,1062,1141,1146,1192,1366,1677'
'slave_transaction_retries', '10'
'slave_type_conversions', ''
'slow_launch_time', '2'
'slow_query_log', 'ON'
'slow_query_log_file', '/data/mysql/eummazurewest13a-slow.log'
'socket', '/var/lib/mysql/mysql.sock'
'sort_buffer_size', '16777216'
'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', 'ON'
'sql_select_limit', '18446744073709551615'
'sql_slave_skip_counter', '0'
'sql_warnings', 'OFF'
'ssl_ca', '/etc/mysql/ssl/ca-cert.pem'
'ssl_capath', ''
'ssl_cert', '/etc/mysql/ssl/server-cert.pem'
'ssl_cipher', ''
'ssl_key', '/etc/mysql/ssl/server-key.pem'
'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', '1024'
'thread_cache_size', '4'
'thread_concurrency', '10'
'thread_handling', 'one-thread-per-connection'
'thread_stack', '262144'
'time_format', '%H:%i:%s'
'time_zone', 'SYSTEM'
'timed_mutexes', 'OFF'
'timestamp', '1552903533'
'tmp_table_size', '16777216'
'tmpdir', '/data/mysql_tmp'
'transaction_alloc_block_size', '8192'
'transaction_prealloc_size', '4096'
'tx_isolation', 'REPEATABLE-READ'
'unique_checks', 'ON'
'updatable_views_with_limit', 'YES'
'version', '5.5.56-log'
'version_comment', 'MySQL Community Server (GPL)'
'version_compile_machine', 'x86_64'
'version_compile_os', 'Linux'
'wait_timeout', '28800'
'warning_count', '0'


show global status;
# Variable_name, Value
'Aborted_clients', '430354'
'Aborted_connects', '18476721'
'Binlog_cache_disk_use', '519983'
'Binlog_cache_use', '77375334'
'Binlog_stmt_cache_disk_use', '33979'
'Binlog_stmt_cache_use', '10600157'
'Bytes_received', '420573230296'
'Bytes_sent', '13054299986966'
'Com_admin_commands', '21704079'
'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', '1142672'
'Com_alter_tablespace', '0'
'Com_analyze', '0'
'Com_begin', '24829'
'Com_binlog', '0'
'Com_call_procedure', '0'
'Com_change_db', '46573403'
'Com_change_master', '0'
'Com_check', '15'
'Com_checksum', '0'
'Com_commit', '48987'
'Com_create_db', '4'
'Com_create_event', '0'
'Com_create_function', '0'
'Com_create_index', '2'
'Com_create_procedure', '0'
'Com_create_server', '0'
'Com_create_table', '121790'
'Com_create_trigger', '0'
'Com_create_udf', '0'
'Com_create_user', '0'
'Com_create_view', '0'
'Com_dealloc_sql', '2'
'Com_delete', '5128229'
'Com_delete_multi', '11694'
'Com_do', '6'
'Com_drop_db', '42'
'Com_drop_event', '0'
'Com_drop_function', '0'
'Com_drop_index', '0'
'Com_drop_procedure', '0'
'Com_drop_server', '0'
'Com_drop_table', '1292'
'Com_drop_trigger', '0'
'Com_drop_user', '0'
'Com_drop_view', '0'
'Com_empty_query', '249'
'Com_execute_sql', '1874'
'Com_flush', '0'
'Com_grant', '98'
'Com_ha_close', '0'
'Com_ha_open', '0'
'Com_ha_read', '0'
'Com_help', '36'
'Com_insert', '50437686'
'Com_insert_select', '278'
'Com_install_plugin', '0'
'Com_kill', '50'
'Com_load', '0'
'Com_lock_tables', '6281'
'Com_optimize', '15829'
'Com_preload_keys', '0'
'Com_prepare_sql', '3'
'Com_purge', '0'
'Com_purge_before_date', '95'
'Com_release_savepoint', '3522'
'Com_rename_table', '393'
'Com_rename_user', '0'
'Com_repair', '0'
'Com_replace', '1670425'
'Com_replace_select', '204'
'Com_reset', '0'
'Com_resignal', '0'
'Com_revoke', '19'
'Com_revoke_all', '0'
'Com_rollback', '182010'
'Com_rollback_to_savepoint', '149479'
'Com_savepoint', '3524'
'Com_select', '373075977'
'Com_set_option', '83952343'
'Com_signal', '0'
'Com_show_authors', '0'
'Com_show_binlog_events', '0'
'Com_show_binlogs', '37'
'Com_show_charsets', '201'
'Com_show_collations', '1541931'
'Com_show_contributors', '0'
'Com_show_create_db', '102'
'Com_show_create_event', '0'
'Com_show_create_func', '0'
'Com_show_create_proc', '1'
'Com_show_create_table', '233058'
'Com_show_create_trigger', '0'
'Com_show_databases', '680'
'Com_show_engine_logs', '0'
'Com_show_engine_mutex', '0'
'Com_show_engine_status', '0'
'Com_show_events', '180'
'Com_show_errors', '0'
'Com_show_fields', '26456667'
'Com_show_function_status', '404'
'Com_show_grants', '40'
'Com_show_keys', '1057505'
'Com_show_master_status', '63'
'Com_show_open_tables', '10'
'Com_show_plugins', '102'
'Com_show_privileges', '0'
'Com_show_procedure_status', '423'
'Com_show_processlist', '208'
'Com_show_profile', '0'
'Com_show_profiles', '0'
'Com_show_relaylog_events', '0'
'Com_show_slave_hosts', '0'
'Com_show_slave_status', '1470634'
'Com_show_status', '1115907'
'Com_show_storage_engines', '291'
'Com_show_table_status', '285160'
'Com_show_tables', '19426787'
'Com_show_triggers', '163442'
'Com_show_variables', '2100262'
'Com_show_warnings', '1149115'
'Com_slave_start', '1'
'Com_slave_stop', '0'
'Com_stmt_close', '1106723'
'Com_stmt_execute', '1108597'
'Com_stmt_fetch', '0'
'Com_stmt_prepare', '1106732'
'Com_stmt_reprepare', '0'
'Com_stmt_reset', '0'
'Com_stmt_send_long_data', '482846'
'Com_truncate', '19325'
'Com_uninstall_plugin', '0'
'Com_unlock_tables', '9723'
'Com_update', '32950377'
'Com_update_multi', '37'
'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', 'ON'
'Connections', '54651912'
'Created_tmp_disk_tables', '52901486'
'Created_tmp_files', '476740'
'Created_tmp_tables', '90358582'
'Delayed_errors', '0'
'Delayed_insert_threads', '0'
'Delayed_writes', '0'
'Flush_commands', '1'
'Handler_commit', '446131193'
'Handler_delete', '11317505'
'Handler_discover', '0'
'Handler_prepare', '151937130'
'Handler_read_first', '44579818'
'Handler_read_key', '4922720807'
'Handler_read_last', '3171313'
'Handler_read_next', '52837444987'
'Handler_read_prev', '421634188'
'Handler_read_rnd', '2854533392'
'Handler_read_rnd_next', '111246498271'
'Handler_rollback', '570333'
'Handler_savepoint', '3524'
'Handler_savepoint_rollback', '149479'
'Handler_update', '703762556'
'Handler_write', '2689355906'
'Innodb_buffer_pool_pages_data', '65245'
'Innodb_buffer_pool_bytes_data', '1068974080'
'Innodb_buffer_pool_pages_dirty', '1623'
'Innodb_buffer_pool_bytes_dirty', '26591232'
'Innodb_buffer_pool_pages_flushed', '27001085'
'Innodb_buffer_pool_pages_free', '0'
'Innodb_buffer_pool_pages_misc', '290'
'Innodb_buffer_pool_pages_total', '65535'
'Innodb_buffer_pool_read_ahead_rnd', '0'
'Innodb_buffer_pool_read_ahead', '82776269'
'Innodb_buffer_pool_read_ahead_evicted', '5625819'
'Innodb_buffer_pool_read_requests', '182383488490'
'Innodb_buffer_pool_reads', '496292658'
'Innodb_buffer_pool_wait_free', '0'
'Innodb_buffer_pool_write_requests', '800497879'
'Innodb_data_fsyncs', '129471652'
'Innodb_data_pending_fsyncs', '0'
'Innodb_data_pending_reads', '1'
'Innodb_data_pending_writes', '0'
'Innodb_data_read', '9504164646912'
'Innodb_data_reads', '580088091'
'Innodb_data_writes', '155593781'
'Innodb_data_written', '1074584688128'
'Innodb_dblwr_pages_written', '27001085'
'Innodb_dblwr_writes', '1017531'
'Innodb_have_atomic_builtins', 'ON'
'Innodb_log_waits', '0'
'Innodb_log_write_requests', '263925147'
'Innodb_log_writes', '126675298'
'Innodb_os_log_fsyncs', '127651518'
'Innodb_os_log_pending_fsyncs', '0'
'Innodb_os_log_pending_writes', '0'
'Innodb_os_log_written', '189404240896'
'Innodb_page_size', '16384'
'Innodb_pages_created', '2895307'
'Innodb_pages_read', '580088044'
'Innodb_pages_written', '27001085'
'Innodb_row_lock_current_waits', '0'
'Innodb_row_lock_time', '61456757'
'Innodb_row_lock_time_avg', '62'
'Innodb_row_lock_time_max', '42781'
'Innodb_row_lock_waits', '977576'
'Innodb_rows_deleted', '9984117'
'Innodb_rows_inserted', '19760846'
'Innodb_rows_read', '141189121709'
'Innodb_rows_updated', '48245496'
'Innodb_truncated_status_writes', '0'
'Key_blocks_not_flushed', '0'
'Key_blocks_unused', '319275'
'Key_blocks_used', '11434'
'Key_read_requests', '1238592193'
'Key_reads', '26906630'
'Key_write_requests', '49006515'
'Key_writes', '8860400'
'Last_query_cost', '0.000000'
'Max_used_connections', '146'
'Not_flushed_delayed_rows', '0'
'Open_files', '425'
'Open_streams', '0'
'Open_table_definitions', '987'
'Open_tables', '1025'
'Opened_files', '442581132'
'Opened_table_definitions', '134106676'
'Opened_tables', '137411921'
'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', '20543'
'Qcache_free_memory', '96487416'
'Qcache_hits', '914448899'
'Qcache_inserts', '169885481'
'Qcache_lowmem_prunes', '30246428'
'Qcache_not_cached', '198340925'
'Qcache_queries_in_cache', '33263'
'Qcache_total_blocks', '96387'
'Queries', '1625155386'
'Questions', '1612870947'
'Rpl_status', 'AUTH_MASTER'
'Select_full_join', '2115621'
'Select_full_range_join', '9466'
'Select_range', '22871945'
'Select_range_check', '11'
'Select_scan', '112709484'
'Slave_heartbeat_period', '1800.000'
'Slave_open_temp_tables', '0'
'Slave_received_heartbeats', '0'
'Slave_retried_transactions', '0'
'Slave_running', 'ON'
'Slow_launch_threads', '0'
'Slow_queries', '144924'
'Sort_merge_passes', '26'
'Sort_range', '35740335'
'Sort_rows', '3213421578'
'Sort_scan', '16708910'
'Ssl_accept_renegotiates', '0'
'Ssl_accepts', '0'
'Ssl_callback_cache_hits', '0'
'Ssl_cipher', 'DHE-RSA-AES256-SHA'
'Ssl_cipher_list', 'DHE-RSA-AES256-SHA:AES256-SHA:DHE-RSA-AES128-SHA:AES128-SHA:AES256-RMD:AES128-RMD:DES-CBC3-RMD:DHE-RSA-AES256-RMD:DHE-RSA-AES128-RMD:DHE-RSA-DES-CBC3-RMD:RC4-SHA:RC4-MD5:DES-CBC3-SHA:DES-CBC-SHA:EDH-RSA-DES-CBC3-SHA:EDH-RSA-DES-CBC-SHA'
'Ssl_client_connects', '0'
'Ssl_connect_renegotiates', '0'
'Ssl_ctx_verify_depth', '0'
'Ssl_ctx_verify_mode', '0'
'Ssl_default_timeout', '500'
'Ssl_finished_accepts', '0'
'Ssl_finished_connects', '0'
'Ssl_session_cache_hits', '0'
'Ssl_session_cache_misses', '0'
'Ssl_session_cache_mode', 'Unknown'
'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', 'TLSv1'
'Table_locks_immediate', '434923764'
'Table_locks_waited', '23536'
'Tc_log_max_pages_used', '0'
'Tc_log_page_size', '0'
'Tc_log_page_waits', '43'
'Threads_cached', '0'
'Threads_connected', '54'
'Threads_created', '4701661'
'Threads_running', '3'
'Uptime', '8173604'
'Uptime_since_flush_status', '8173604'