MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.102
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mariadb-bin.000502
Read_Master_Log_Pos: 37087899
Relay_Log_File: relay-bin.001065
Relay_Log_Pos: 25317
Relay_Master_Log_File: mariadb-bin.000501
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 13
Last_Error: Error 'Can't get stat of './mysql/general_log.CSV' (Errcode: 2)' on query. Default database: 'mysql'. Query: 'ALTER TABLE general_log
MODIFY event_time TIMESTAMP NOT NULL,
MODIFY user_host MEDIUMTEXT NOT NULL,
MODIFY thread_id INTEGER NOT NULL,
MODIFY server_id INTEGER UNSIGNED NOT NULL,
MODIFY command_type VARCHAR(64) NOT NULL,
MODIFY argument MEDIUMTEXT NOT NULL'
Skip_Counter: 0
Exec_Master_Log_Pos: 239857
Relay_Log_Space: 40125
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 13
Last_SQL_Error: Error 'Can't get stat of './mysql/general_log.CSV' (Errcode: 2)' on query. Default database: 'mysql'. Query: 'ALTER TABLE general_log
MODIFY event_time TIMESTAMP NOT NULL,
MODIFY user_host MEDIUMTEXT NOT NULL,
MODIFY thread_id INTEGER NOT NULL,
MODIFY server_id INTEGER UNSIGNED NOT NULL,
MODIFY command_type VARCHAR(64) NOT NULL,
MODIFY argument MEDIUMTEXT NOT NULL'
1 row in set (0.00 sec)
So I investigated and fixed:
[27-06-11 16:01:45] [root@server03.yomamma.com] [/mysql/mysql] # ls -lha total 988K drwxr-xr-x 2 mysql mysql 4.0K 2011-06-27 10:55 . drwxr-xr-x 31 mysql mysql 4.0K 2011-06-27 16:01 .. -rw-rw---- 1 mysql mysql 8.7K 2011-06-27 10:55 columns_priv.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 columns_priv.MYD -rw-rw---- 1 mysql mysql 4.0K 2011-06-27 10:55 columns_priv.MYI -rw-rw---- 1 mysql mysql 9.4K 2011-06-27 10:55 db.frm -rw-rw---- 1 mysql mysql 19K 2011-06-27 10:55 db.MYD -rw-rw---- 1 mysql mysql 5.0K 2011-06-27 10:55 db.MYI -rw-rw---- 1 mysql mysql 10K 2011-06-27 10:55 event.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 event.MYD -rw-rw---- 1 mysql mysql 2.0K 2011-06-27 10:55 event.MYI -rw-rw---- 1 mysql mysql 8.5K 2011-06-27 10:55 func.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 func.MYD -rw-rw---- 1 mysql mysql 1.0K 2011-06-27 10:55 func.MYI -rw-r----- 1 mysql mysql 8.6K 2010-06-16 19:06 general_log.frm -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 help_category.frm -rw------- 1 mysql mysql 21K 2011-06-27 10:54 help_category.MYD -rw------- 1 mysql mysql 3.0K 2011-06-27 10:54 help_category.MYI -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 help_keyword.frm -rw------- 1 mysql mysql 87K 2011-06-27 10:54 help_keyword.MYD -rw------- 1 mysql mysql 16K 2011-06-27 10:54 help_keyword.MYI -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 help_relation.frm -rw------- 1 mysql mysql 8.8K 2011-06-27 10:54 help_relation.MYD -rw------- 1 mysql mysql 18K 2011-06-27 10:54 help_relation.MYI -rw------- 1 mysql mysql 8.6K 2010-06-16 19:06 help_topic.frm -rw------- 1 mysql mysql 412K 2011-06-27 10:54 help_topic.MYD -rw------- 1 mysql mysql 20K 2011-06-27 10:54 help_topic.MYI -rw-rw---- 1 mysql mysql 9.3K 2011-06-27 10:55 host.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 host.MYD -rw-rw---- 1 mysql mysql 2.0K 2011-06-27 10:55 host.MYI -rw------- 1 mysql mysql 8.6K 2010-06-16 19:06 ndb_binlog_index.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 ndb_binlog_index.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 ndb_binlog_index.MYI -rw------- 1 mysql mysql 8.4K 2010-06-16 19:06 plugin.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 plugin.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 plugin.MYI -rw-rw---- 1 mysql mysql 9.8K 2011-06-27 10:55 proc.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 proc.MYD -rw-rw---- 1 mysql mysql 2.0K 2011-06-27 10:55 proc.MYI -rw-rw---- 1 mysql mysql 8.7K 2011-06-27 10:55 procs_priv.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 procs_priv.MYD -rw-rw---- 1 mysql mysql 4.0K 2011-06-27 10:55 procs_priv.MYI -rw------- 1 mysql mysql 8.7K 2010-06-16 19:06 servers.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 servers.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 servers.MYI -rw-r----- 1 mysql mysql 8.8K 2010-06-16 19:06 slow_log.frm -rw-rw---- 1 mysql mysql 8.8K 2011-06-27 10:55 tables_priv.frm -rw-rw---- 1 mysql mysql 0 2011-06-27 10:55 tables_priv.MYD -rw-rw---- 1 mysql mysql 4.0K 2011-06-27 10:55 tables_priv.MYI -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 time_zone.frm -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 time_zone_leap_second.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 time_zone_leap_second.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 time_zone_leap_second.MYI -rw------- 1 mysql mysql 0 2010-06-16 19:06 time_zone.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 time_zone.MYI -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 time_zone_name.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 time_zone_name.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 time_zone_name.MYI -rw------- 1 mysql mysql 8.5K 2010-06-16 19:06 time_zone_transition.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 time_zone_transition.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 time_zone_transition.MYI -rw------- 1 mysql mysql 8.6K 2010-06-16 19:06 time_zone_transition_type.frm -rw------- 1 mysql mysql 0 2010-06-16 19:06 time_zone_transition_type.MYD -rw------- 1 mysql mysql 1.0K 2010-06-16 19:06 time_zone_transition_type.MYI -rw-rw---- 1 mysql mysql 11K 2011-06-27 10:55 user.frm -rw-rw---- 1 mysql mysql 4.4K 2011-06-27 10:55 user.MYD -rw-rw---- 1 mysql mysql 2.0K 2011-06-27 10:55 user.MYI [27-06-11 16:01:47] [root@server03.yomamma.com] [/mysql/mysql] # touch general_log.CSV [27-06-11 16:02:13] [root@server03.yomamma.com] [/mysql/mysql] # chown mysql:mysql general_log.CSV [27-06-11 16:03:01] [root@server03.yomamma.com] [/mysql/mysql] # touch slow_log.CSV [27-06-11 16:03:50] [root@server03.yomamma.com] [/mysql/mysql] # chown mysql:mysql slow_log.CSV [27-06-11 16:04:01] [root@server03.yomamma.com] [/mysql/mysql] #After that, all was fine:
MariaDB [(none)]> start slave;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.102
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mariadb-bin.000502
Read_Master_Log_Pos: 39269674
Relay_Log_File: relay-bin.001065
Relay_Log_Pos: 25655
Relay_Master_Log_File: mariadb-bin.000501
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 13
Last_Error: Error 'Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)' on query. Default database: 'mysql'. Query: 'ALTER TABLE slow_log
MODIFY start_time TIMESTAMP NOT NULL,
MODIFY user_host MEDIUMTEXT NOT NULL,
MODIFY query_time TIME NOT NULL,
MODIFY lock_time TIME NOT NULL,
MODIFY rows_sent INTEGER NOT NULL,
MODIFY rows_examined INTEGER NOT NULL,
MODIFY db VARCHAR(512) NOT NULL,
MODIFY last_insert_id INTEGER NOT NULL,
MODIFY insert_id INTEGER NOT NULL,
MODIFY server_id INTEGER UNSIGNED NOT NULL,
MODIFY sql_text MEDIUMTEXT NOT NULL'
Skip_Counter: 0
Exec_Master_Log_Pos: 240195
Relay_Log_Space: 40125
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 13
Last_SQL_Error: Error 'Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)' on query. Default database: 'mysql'. Query: 'ALTER TABLE slow_log
MODIFY start_time TIMESTAMP NOT NULL,
MODIFY user_host MEDIUMTEXT NOT NULL,
MODIFY query_time TIME NOT NULL,
MODIFY lock_time TIME NOT NULL,
MODIFY rows_sent INTEGER NOT NULL,
MODIFY rows_examined INTEGER NOT NULL,
MODIFY db VARCHAR(512) NOT NULL,
MODIFY last_insert_id INTEGER NOT NULL,
MODIFY insert_id INTEGER NOT NULL,
MODIFY server_id INTEGER UNSIGNED NOT NULL,
MODIFY sql_text MEDIUMTEXT NOT NULL'
1 row in set (0.00 sec)
MariaDB [(none)]> start slave;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.1.102
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mariadb-bin.000502
Read_Master_Log_Pos: 40247987
Relay_Log_File: relay-bin.001075
Relay_Log_Pos: 253
Relay_Master_Log_File: mariadb-bin.000502
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 40247987
Relay_Log_Space: 809
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
1 row in set (0.00 sec)
MariaDB [(none)]> show global variables;
+-------------------------------------------+-------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------------------------+-------------------------------------------------------------------------------------------+
| aria_block_size | 8192 |
| aria_checkpoint_interval | 30 |
| aria_force_start_after_recovery_failures | 0 |
| aria_group_commit | none |
| aria_group_commit_interval | 0 |
| aria_log_file_size | 1073741824 |
| aria_log_purge_type | immediate |
| aria_max_sort_file_size | 9223372036853727232 |
| aria_page_checksum | ON |
| aria_pagecache_age_threshold | 300 |
| aria_pagecache_buffer_size | 134213632 |
| aria_pagecache_division_limit | 100 |
| aria_recover | NORMAL |
| aria_repair_threads | 1 |
| aria_sort_buffer_size | 134217728 |
| aria_stats_method | nulls_unequal |
| aria_sync_log_dir | NEWFILE |
| aria_used_for_temp_tables | ON |
| 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 | MIXED |
| bulk_insert_buffer_size | 16777216 |
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| completion_type | 0 |
| concurrent_insert | 2 |
| connect_timeout | 5 |
| datadir | /mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| deadlock_search_depth_long | 15 |
| deadlock_search_depth_short | 4 |
| deadlock_timeout_long | 50000000 |
| deadlock_timeout_short | 10000 |
| 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 |
| 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_stopword_file | (built-in) |
| general_log | OFF |
| general_log_file | /var/run/mysqld/mysqld.log |
| group_concat_max_len | 1024 |
| have_community_features | YES |
| 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_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | DISABLED |
| have_symlink | YES |
| hostname | server03.yomamma.com |
| identity | 0 |
| ignore_builtin_innodb | OFF |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_adaptive_checkpoint | reflex |
| innodb_adaptive_flushing | OFF |
| innodb_adaptive_hash_index | ON |
| innodb_additional_mem_pool_size | 16777216 |
| innodb_auto_lru_dump | 0 |
| innodb_autoextend_increment | 8 |
| innodb_autoinc_lock_mode | 1 |
| innodb_buffer_pool_shm_checksum | ON |
| innodb_buffer_pool_shm_key | 0 |
| innodb_buffer_pool_size | 4294967296 |
| innodb_change_buffering | inserts |
| innodb_checkpoint_age_target | 0 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:100M:autoextend |
| innodb_data_home_dir | /mysql |
| innodb_dict_size_limit | 0 |
| innodb_doublewrite | ON |
| innodb_doublewrite_file | |
| innodb_enable_unsafe_group_commit | 0 |
| innodb_expand_import | 0 |
| innodb_extra_rsegments | 0 |
| innodb_extra_undoslots | OFF |
| innodb_fast_checksum | OFF |
| innodb_fast_recovery | OFF |
| innodb_fast_shutdown | 1 |
| innodb_file_format | Antelope |
| innodb_file_format_check | Barracuda |
| innodb_file_per_table | ON |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_log_at_trx_commit_session | 3 |
| innodb_flush_method | O_DIRECT |
| innodb_flush_neighbor_pages | 1 |
| innodb_force_recovery | 0 |
| innodb_ibuf_accel_rate | 100 |
| innodb_ibuf_active_contract | 1 |
| innodb_ibuf_max_size | 2147467264 |
| innodb_io_capacity | 800 |
| innodb_lazy_drop_table | 0 |
| innodb_lock_wait_timeout | 50 |
| 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 | /mysql |
| innodb_max_dirty_pages_pct | 90 |
| 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_overwrite_relay_log_info | OFF |
| innodb_page_size | 16384 |
| innodb_pass_corrupt_table | 0 |
| innodb_read_ahead | linear |
| innodb_read_ahead_threshold | 56 |
| innodb_read_io_threads | 4 |
| innodb_recovery_stats | OFF |
| innodb_replication_delay | 0 |
| innodb_rollback_on_timeout | OFF |
| 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 | 8 |
| innodb_thread_concurrency_timer_based | OFF |
| innodb_thread_sleep_delay | 10000 |
| innodb_use_purge_thread | 1 |
| innodb_use_sys_malloc | ON |
| innodb_use_sys_stats_table | OFF |
| innodb_version | 1.0.15-12.7 |
| innodb_write_io_threads | 4 |
| insert_id | 0 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| keep_files_on_create | OFF |
| key_buffer_size | 1073741824 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| key_cache_segments | 0 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| last_insert_id | 0 |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_basename | |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators | OFF |
| log_error | /var/log/mysql/mariadb-error.log |
| log_output | FILE |
| log_queries_not_using_indexes | ON |
| log_slave_updates | ON |
| log_slow_filter | |
| log_slow_queries | OFF |
| log_slow_rate_limit | 1000 |
| log_slow_time | 1.000000 |
| log_slow_verbosity | query_plan |
| log_warnings | 2 |
| long_query_time | 1.000000 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| maria_block_size | 8192 |
| maria_checkpoint_interval | 30 |
| maria_force_start_after_recovery_failures | 0 |
| maria_group_commit | none |
| maria_group_commit_interval | 0 |
| maria_log_file_size | 1073741824 |
| maria_log_purge_type | immediate |
| maria_max_sort_file_size | 9223372036853727232 |
| maria_page_checksum | ON |
| maria_pagecache_age_threshold | 300 |
| maria_pagecache_buffer_size | 134213632 |
| maria_pagecache_division_limit | 100 |
| maria_recover | NORMAL |
| maria_repair_threads | 1 |
| maria_sort_buffer_size | 134217728 |
| maria_stats_method | nulls_unequal |
| maria_sync_log_dir | NEWFILE |
| maria_used_for_temp_tables | ON |
| max_allowed_packet | 16777216 |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 268435456 |
| max_connect_errors | 10 |
| max_connections | 200 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 33554432 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_long_data_size | 16777216 |
| 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 | 0 |
| max_write_lock_count | 18446744073709551615 |
| min_examined_row_limit | 0 |
| multi_range_count | 256 |
| myisam_block_size | 1024 |
| 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 | 536870912 |
| 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 | 1411 |
| 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 |
| pbxt_auto_increment_mode | 0 |
| pbxt_checkpoint_frequency | 28MB |
| pbxt_data_file_grow_size | 2MB |
| pbxt_data_log_threshold | 64MB |
| pbxt_flush_log_at_trx_commit | 1 |
| pbxt_garbage_threshold | 50 |
| pbxt_index_cache_size | 32MB |
| pbxt_log_buffer_size | 256K |
| pbxt_log_cache_size | 16MB |
| pbxt_log_file_count | 3 |
| pbxt_log_file_threshold | 32MB |
| pbxt_max_threads | 207 |
| pbxt_offline_log_function | 0 |
| pbxt_record_cache_size | 32MB |
| pbxt_row_file_grow_size | 256K |
| pbxt_support_xa | ON |
| pbxt_sweeper_priority | 0 |
| pbxt_transaction_buffer_size | 1MB |
| pid_file | /var/run/mysqld/mysqld.pid |
| plugin_dir | /usr/lib/mysql/plugin |
| plugin_maturity | unknown |
| port | 3306 |
| preload_buffer_size | 32768 |
| profiling | OFF |
| profiling_history_size | 15 |
| protocol_version | 10 |
| pseudo_thread_id | 0 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 131072 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| rand_seed1 | |
| rand_seed2 | |
| range_alloc_block_size | 4096 |
| read_buffer_size | 2097152 |
| read_only | OFF |
| read_rnd_buffer_size | 1048576 |
| relay_log | /mysql/relay-bin |
| relay_log_index | /mysql/relay-bin.index |
| relay_log_info_file | /mysql/relay-bin.info |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| report_host | server03 |
| report_password | |
| report_port | 3306 |
| report_user | |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| secure_file_priv | |
| server_id | 11206 |
| skip_external_locking | ON |
| skip_name_resolve | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | 1 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 4194304 |
| sql_auto_is_null | ON |
| sql_big_selects | ON |
| sql_big_tables | OFF |
| sql_buffer_result | OFF |
| sql_log_bin | ON |
| sql_log_off | OFF |
| sql_log_update | ON |
| sql_low_priority_updates | OFF |
| sql_max_join_size | 18446744073709551615 |
| sql_mode | ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |
| sql_notes | ON |
| sql_quote_show_create | ON |
| sql_safe_updates | OFF |
| sql_select_limit | 18446744073709551615 |
| sql_slave_skip_counter | |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | InnoDB |
| sync_binlog | 5 |
| sync_frm | ON |
| system_time_zone | UTC |
| table_definition_cache | 256 |
| table_lock_wait_timeout | 50 |
| table_open_cache | 600 |
| table_type | InnoDB |
| thread_cache_size | 128 |
| thread_handling | one-thread-per-connection |
| thread_pool_size | 20 |
| thread_stack | 294912 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| timestamp | 1309190699 |
| tmp_table_size | 33554432 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| unique_checks | ON |
| updatable_views_with_limit | YES |
| userstat | OFF |
| version | 5.2.7-MariaDB-mariadb101~lenny-log |
| version_comment | (MariaDB - http://mariadb.com/) |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
| wait_timeout | 600 |
| warning_count | 0 |
+-------------------------------------------+-------------------------------------------------------------------------------------------+
392 rows in set (0.00 sec)