I have a server running Percona Server 5.5.29 that keeps running out of memory. It is a dedicated database server to a black box appliance that we have to run for business purposes. It is a log archiving system so it was built for size and not speed.
The server is a Dell R320 with 8 GB of memory and 600 GB of disk. There is an 8 GB swap file. The server OS is CentOS 6.3 with the latest updates.
The tables are all using MyISAM as that is what the appliance is coded to create the new tables with, I cannot switch anything to InnoDB.
MySQL starts up using less than 500MB of memory, but slowly grows to use more and more memory and starts to use swap after a few days. I notice it when my monitoring alerts that I am using more than 50% of my swap space. I can restart MySQL and it will restore the memory allocation but it causes an impact to the application.
I have tried the following fixes to no avail:
- Setting ‘vm.zone_reclaim_mode = 1’ in /etc/sysctl.conf as a workaround to a known mmap memory bug.
- I have also tried setting ‘myisam_mmap_size = 4294967296’ in /etc/my.cnf on a parallel system (we have one in each data center), and it doesn’t look great so far but hasn’t run long enough to confirm.
I would appreciate some guidance into where I should look for the issue, or if there is something really odd about my configuration.
*** Top and ‘ps aux’ outputs:
top - 14:56:16 up 7 days, 16:03, 1 user, load average: 0.95, 0.47, 0.30
Tasks: 329 total, 1 running, 328 sleeping, 0 stopped, 0 zombie
Cpu(s): 10.5%us, 0.6%sy, 0.0%ni, 88.1%id, 0.8%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 7977428k total, 7766648k used, 210780k free, 1904k buffers
Swap: 8110072k total, 5491684k used, 2618388k free, 347344k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
7214 mysql 20 0 14.2g 6.6g 4176 S 89.1 87.0 510:42.14 mysqld
ps aux | grep mysql
root 6685 0.0 0.0 108328 296 ? S Feb07 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql/ --pid-file=/var/lib/mysql//co-db-04.XXXXXXXX.com.pid
mysql 7214 4.6 87.0 14932824 6946328 ? Sl Feb07 512:33 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql/ --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/var/lib/mysql//co-db-04.XXXXXXXX.com.pid --socket=/var/lib/mysql/mysql.sock
date
Fri Feb 15 15:12:45 EST 2013
*** /etc/my.cnf
[mysql]
CLIENT
port = 3306
socket = /var/lib/mysql/mysql.sock
no-auto-rehash
[mysqld]
GENERAL
user = mysql
default_storage_engine = MyISAM
socket = /var/lib/mysql/mysql.sock
pid_file = /var/lib/mysql/mysql.pid
skip-name-resolve
old_passwords
skip-slave-start
MyISAM
key_buffer_size = 1G
myisam_recover = FORCE,BACKUP
SAFETY
max_allowed_packet = 512M
max_connect_errors = 1000000
DATA STORAGE
datadir = /var/lib/mysql/
CACHES AND LIMITS
tmp_table_size = 32M
max_heap_table_size = 32M
query_cache_type = 1
query_cache_size = 128M
max_connections = 2500
thread_cache_size = 100
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 5120
sort_buffer_size = 2M
read_buffer_size = 1M
join_buffer_size = 2M
read_rnd_buffer_size = 4M
thread_concurrency = 8
INNODB
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 5M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 8M
LOGGING
log_error = /var/lib/mysql/mysql-error.log
log_queries_not_using_indexes = 0
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/mysql-slow.log
[mysqldump]
quick
max_allowed_packet = 512M
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
*** Status and Variables:
mysql> show status;
±-----------------------------------------±-------------+
| Variable_name | Value |
±-----------------------------------------±-------------+
| Aborted_clients | 35 |
| Aborted_connects | 185 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 150 |
| Bytes_sent | 265 |
| 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_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 | 0 |
| 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 | 0 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 0 |
| 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 | 0 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 0 |
| Com_insert_select | 0 |
| 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 | 0 |
| 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 | 1 |
| Com_set_option | 0 |
| Com_signal | 0 |
| Com_show_authors | 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_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_index_statistics | 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 | 0 |
| 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_slave_status_nolock | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_table_statistics | 0 |
| Com_show_table_status | 0 |
| Com_show_tables | 0 |
| Com_show_temporary_tables | 0 |
| Com_show_thread_statistics | 0 |
| Com_show_triggers | 0 |
| Com_show_user_statistics | 0 |
| Com_show_variables | 0 |
| 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 | 0 |
| 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 | 3670 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 154 |
| Created_tmp_tables | 0 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flashcache_enabled | OFF |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 0 |
| Handler_read_last | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 0 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 0 |
| Handler_write | 0 |
| Innodb_adaptive_hash_cells | 69221 |
| Innodb_adaptive_hash_heap_buffers | 25 |
| Innodb_adaptive_hash_hash_searches | 1625760 |
| Innodb_adaptive_hash_non_hash_searches | 161092 |
| Innodb_background_log_sync | 646256 |
| Innodb_buffer_pool_pages_data | 2020 |
| Innodb_buffer_pool_pages_dirty | 141 |
| Innodb_buffer_pool_pages_flushed | 3856941 |
| Innodb_buffer_pool_pages_LRU_flushed | 0 |
| Innodb_buffer_pool_pages_free | 1 |
| Innodb_buffer_pool_pages_made_not_young | 0 |
| Innodb_buffer_pool_pages_made_young | 2744 |
| Innodb_buffer_pool_pages_misc | 26 |
| Innodb_buffer_pool_pages_old | 725 |
| Innodb_buffer_pool_pages_total | 2047 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 2984 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 54023198 |
| Innodb_buffer_pool_reads | 1602 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 8759333 |
| Innodb_checkpoint_age | 16059 |
| Innodb_checkpoint_max_age | 7782360 |
| Innodb_checkpoint_target_age | 7539162 |
| Innodb_data_fsyncs | 1784637 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 78073856 |
| Innodb_data_reads | 4645 |
| Innodb_data_writes | 5598972 |
| Innodb_data_written | 127696778752 |
| Innodb_dblwr_pages_written | 3856941 |
| Innodb_dblwr_writes | 39519 |
| Innodb_deadlocks | 0 |
| Innodb_dict_tables | 11 |
| Innodb_have_atomic_builtins | ON |
| Innodb_history_list_length | 2730 |
| Innodb_ibuf_discarded_delete_marks | 0 |
| Innodb_ibuf_discarded_deletes | 0 |
| Innodb_ibuf_discarded_inserts | 0 |
| Innodb_ibuf_free_list | 0 |
| Innodb_ibuf_merged_delete_marks | 135 |
| Innodb_ibuf_merged_deletes | 96 |
| Innodb_ibuf_merged_inserts | 70 |
| Innodb_ibuf_merges | 83 |
| Innodb_ibuf_segment_size | 2 |
| Innodb_ibuf_size | 1 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 909817 |
| Innodb_log_writes | 1637697 |
| Innodb_lsn_current | 3146230135 |
| Innodb_lsn_flushed | 3146230135 |
| Innodb_lsn_last_checkpoint | 3146214076 |
| Innodb_master_thread_1_second_loops | 354105 |
| Innodb_master_thread_10_second_loops | 32293 |
| Innodb_master_thread_background_loops | 31558 |
| Innodb_master_thread_main_flush_loops | 31558 |
| Innodb_master_thread_sleeps | 354104 |
| Innodb_max_trx_id | 22441372 |
| Innodb_mem_adaptive_hash | 983968 |
| Innodb_mem_dictionary | 199049 |
| Innodb_mem_total | 34471936 |
| Innodb_mutex_os_waits | 950 |
| Innodb_mutex_spin_rounds | 53117 |
| Innodb_mutex_spin_waits | 9358 |
| Innodb_oldest_view_low_limit_trx_id | 22441372 |
| Innodb_os_log_fsyncs | 1670546 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 1295809024 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 477 |
| Innodb_pages_read | 4631 |
| Innodb_pages_written | 3856941 |
| Innodb_purge_trx_id | 22441372 |
| Innodb_purge_undo_no | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_current_row_locks | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 294 |
| Innodb_rows_inserted | 15837 |
| Innodb_rows_read | 2229623 |
| Innodb_rows_updated | 1618704 |
| Innodb_s_lock_os_waits | 32782 |
| Innodb_s_lock_spin_rounds | 984088 |
| Innodb_s_lock_spin_waits | 32849 |
| Innodb_truncated_status_writes | 0 |
| Innodb_x_lock_os_waits | 829 |
| Innodb_x_lock_spin_rounds | 25425 |
| Innodb_x_lock_spin_waits | 223 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 802064 |
| Key_blocks_used | 81088 |
| Key_read_requests | 1072909174 |
| Key_reads | 19753 |
| Key_write_requests | 102444162 |
| Key_writes | 9023517 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 10 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 10123 |
| Open_streams | 0 |
| Open_table_definitions | 5047 |
| Open_tables | 5120 |
| Opened_files | 1913619 |
| Opened_table_definitions | 0 |
| Opened_tables | 0 |
| 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 | 1 |
| Qcache_free_memory | 109888904 |
| Qcache_hits | 21428 |
| Qcache_inserts | 39935 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 78688 |
| Qcache_queries_in_cache | 15353 |
| Qcache_total_blocks | 46042 |
| Queries | 453515314 |
| Questions | 2 |
| Rpl_status | AUTH_MASTER |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 0 |
| 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 | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| 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 | 543067117 |
| Table_locks_waited | 0 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 5 |
| Threads_connected | 5 |
| Threads_created | 10 |
| Threads_running | 1 |
| Uptime | 662673 |
| Uptime_since_flush_status | 662673 |
| binlog_commits | 0 |
| binlog_group_commits | 0 |
±-----------------------------------------±-------------+
370 rows in set (0.00 sec)
mysql> show variables;
±--------------------------------------------------±------ ------------------------------------------------------------ -----------------------------------------------------+
| Variable_name | Value |
±--------------------------------------------------±------ ------------------------------------------------------------ -----------------------------------------------------+
| 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 | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| 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 | latin1_swedish_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 | MyISAM |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| enforce_storage_engine | |
| engine_condition_pushdown | ON |
| error_count | 0 |
| event_scheduler | OFF |
| expand_fast_index_creation | OFF |
| expire_logs_days | 0 |
| external_user | |
| fast_index_creation | ON |
| 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/co-db-04.log |
| group_concat_max_len | 1024 |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_flashcache | YES |
| have_geometry | YES |
| have_innodb | YES |
| have_ndbcluster | NO |
| have_openssl | DISABLED |
| have_partitioning | YES |
| have_profiling | YES |
| have_query_cache | YES |
| have_response_time_distribution | YES |
| have_rtree_keys | YES |
| have_ssl | DISABLED |
| have_symlink | YES |
| hostname | co-db-04.XXXXXXXX.com |
| identity | 0 |
| ignore_builtin_innodb | OFF |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_adaptive_flushing | ON |
| innodb_adaptive_flushing_method | estimate |
| innodb_adaptive_hash_index | ON |
| innodb_adaptive_hash_index_partitions | 1 |
| innodb_additional_mem_pool_size | 8388608 |
| innodb_autoextend_increment | 8 |
| innodb_autoinc_lock_mode | 1 |
| innodb_blocking_buffer_pool_restore | OFF |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_populate | OFF |
| innodb_buffer_pool_restore_at_startup | 0 |
| innodb_buffer_pool_shm_checksum | ON |
| innodb_buffer_pool_shm_key | 0 |
| innodb_buffer_pool_size | 33554432 |
| innodb_change_buffering | all |
| innodb_changed_pages_limit | 1000000 |
| innodb_checkpoint_age_target | 0 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_corrupt_table_action | assert |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_dict_size_limit | 0 |
| innodb_doublewrite | ON |
| innodb_doublewrite_file | |
| innodb_fake_changes | OFF |
| innodb_fast_checksum | OFF |
| innodb_fast_shutdown | 1 |
| innodb_file_format | Antelope |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
| innodb_file_per_table | ON |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | O_DIRECT |
| innodb_flush_neighbor_pages | area |
| innodb_force_load_corrupted | OFF |
| innodb_force_recovery | 0 |
| innodb_ibuf_accel_rate | 100 |
| innodb_ibuf_active_contract | 1 |
| innodb_ibuf_max_size | 16760832 |
| innodb_import_table_from_xtrabackup | 0 |
| innodb_io_capacity | 200 |
| innodb_kill_idle_transaction | 0 |
| innodb_large_prefix | OFF |
| innodb_lazy_drop_table | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locking_fake_changes | ON |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_block_size | 512 |
| innodb_log_buffer_size | 8388608 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_bitmap_file_size | 104857600 |
| innodb_max_dirty_pages_pct | 75 |
| innodb_max_purge_lag | 0 |
| innodb_merge_sort_block_size | 1048576 |
| innodb_mirrored_log_groups | 1 |
| innodb_old_blocks_pct | 37 |
| innodb_old_blocks_time | 0 |
| innodb_open_files | 300 |
| innodb_page_size | 16384 |
| innodb_purge_batch_size | 20 |
| innodb_purge_threads | 1 |
| innodb_random_read_ahead | OFF |
| innodb_read_ahead | linear |
| innodb_read_ahead_threshold | 56 |
| innodb_read_io_threads | 4 |
| innodb_recovery_stats | OFF |
| innodb_recovery_update_relay_log | OFF |
| innodb_replication_delay | 0 |
| innodb_rollback_on_timeout | OFF |
| innodb_rollback_segments | 128 |
| innodb_show_locks_held | 10 |
| innodb_show_verbose_locks | 0 |
| innodb_spin_wait_delay | 6 |
| innodb_stats_auto_update | 1 |
| innodb_stats_method | nulls_equal |
| innodb_stats_on_metadata | ON |
| innodb_stats_sample_pages | 8 |
| innodb_stats_update_need_lock | 1 |
| innodb_strict_mode | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 30 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 0 |
| innodb_thread_concurrency_timer_based | OFF |
| innodb_thread_sleep_delay | 10000 |
| innodb_track_changed_pages | OFF |
| innodb_use_global_flush_log_at_trx_commit | ON |
| innodb_use_native_aio | ON |
| innodb_use_sys_malloc | ON |
| innodb_use_sys_stats_table | OFF |
| innodb_version | 1.1.8-rel29.4 |
| innodb_write_io_threads | 4 |
| insert_id | 0 |
| interactive_timeout | 28800 |
| join_buffer_size | 2097152 |
| keep_files_on_create | OFF |
| key_buffer_size | 1073741824 |
| 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