search

major / MySQLTuner-perl

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
GNU General Public License v3.0
8.92k stars 1.28k forks source link

Memory used > 100% ? #260

Closed jppo closed 6 years ago

jppo commented 8 years ago

Hello, I get some strange results with the last version :

[!!] Maximum reached memory usage: 1.1G (111055.85% of installed RAM) [!!] Maximum possible memory usage: 1.1G (114318.35% of installed RAM) [!!] Overall possible memory usage with other process exceeded memory ...... Variables to adjust: * MySQL's maximum memory usage is dangerously high * * Add RAM before increasing MySQL buffer variables *

System is Debian 8.6 RAM 16Go CPU core I5 5765 Some disks ... Mysql version : 5.6.30-1~bpo8+1-log

Two lines of "top" about memory : KiB Mem: 16174796 total, 15736004 used, 438792 free, 311712 buffers KiB Swap: 20688888 total, 92488 used, 20596400 free. 4099568 cached Mem

Regards

JP P

jmrenouard commented 8 years ago

Hi @jppo Can you give all information with --debug ?

Thanks

jppo commented 8 years ago

Hello,

I enclose the output of a run with "--debug".

Hope this helps, ready to another try ...

Regards

JP P

De: "Jean-Marie Renouard" notifications@github.com À: "major/MySQLTuner-perl" MySQLTuner-perl@noreply.github.com Cc: "jppo" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com Envoyé: Dimanche 23 Octobre 2016 14:24:25 Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi @jppo Can you give all information with --debug ?

Thanks

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub , or mute the thread .

jmrenouard commented 8 years ago

Hi @jppo

Can you push the output result for mysqltumer.pl --debug

Thanks @jmrenouard

jppo commented 8 years ago

Hello/bonjour,

The result of mysqltuner.pl --debug is attached ...

Regards

JP Pozzi

De: "Jean-Marie Renouard" notifications@github.com À: "major" MySQLTuner-perl@noreply.github.com Cc: "jppo" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com Envoyé: Jeudi 27 Octobre 2016 21:19:16 Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi @jppo

Can you push the output result for mysqltumer.pl --debug

Thanks @jmrenouard

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub , or mute the thread .

jmrenouard commented 7 years ago

Hi @jppo

Sorry, I doesn't get any attachment file. @jmrenouard

jmrenouard commented 7 years ago

Hi @jppo

I don't get any atachment with debug. So I can help us to diagnose and fix this potential bug.

Can you give me your debug file ?

Thanks

jppo commented 7 years ago

Hello,

Sorry, here a brand new trace list.

The list gives always fantastic percentages : [!!] Maximum reached memory usage: 4.5G (463993.95% of installed RAM) [!!] Maximum possible memory usage: 4.5G (463250.20% of installed RAM)

System Ram is 16G, #6.6G allocated to Hugepages

Regards

JP Pozzi

De: "Jean-Marie Renouard" notifications@github.com À: "major" MySQLTuner-perl@noreply.github.com Cc: "jp pozzi" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com Envoyé: Mardi 7 Février 2017 06:23:19 Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi [ https://github.com/jppo | @jppo ]

I don't get any atachment with debug. So I can help us to diagnose and fix this potential bug.

Can you give me your debug file ?

Thanks

— You are receiving this because you were mentioned. Reply to this email directly, [ https://github.com/major/MySQLTuner-perl/issues/260#issuecomment-277904849 | view it on GitHub ] , or [ https://github.com/notifications/unsubscribe-auth/AGT0qxBJ2UeiHqBTS8XDWYOCvd5FGwpPks5rZ__HgaJpZM4KdofW | mute the thread ] .

jmrenouard commented 7 years ago

Hi @jppo

Can you give me the full output result from the following command ? $ mysqltuner.pl --debug &>/tmp/debug.txt And send me /tmp/debug.txt file ?

Thanks by advance,

jppo commented 7 years ago

Hello,

I have done the test, but I can't see any more "fantastic" percentages, but I have made some system upgrade since the first time, and 1 month holidays in Asia ! The data shown seems to be correct, the only problem ie with the password tests which failed for every "select" as there is not a "password" column in the mysql.user table, messages are : failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE password = PASSWORD('1') OR password = PASSWORD(UPPER('1')) OR password = PASSWORD(CONCAT(UPPER(LEFT('1', 1)), SUBSTRING('1', 2, LENGTH('1')))) FAIL Execute SQL / return code: 256 ......

I enclose the debug file and the trace without "--debug".

Regards

JP Pozzi

De: "Jean-Marie Renouard" notifications@github.com À: "major" MySQLTuner-perl@noreply.github.com Cc: "jp pozzi" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com Envoyé: Lundi 13 Février 2017 14:58:05 Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi [ https://github.com/jppo | @jppo ]

Can you give me the full output result from the following command ? $ mysqltuner.pl --debug &>/tmp/debug.txt And send me /tmp/debug.txt file ?

Thanks by advance,

— You are receiving this because you were mentioned. Reply to this email directly, [ https://github.com/major/MySQLTuner-perl/issues/260#issuecomment-279399172 | view it on GitHub ] , or [ https://github.com/notifications/unsubscribe-auth/AGT0q2ISjPp8q5g8e3RuI0U4P3s_q4hGks5rcGFtgaJpZM4KdofW | mute the thread ] .

MySQLTuner 1.7.0 - Major Hayden major@mhtx.net Bug reports, feature requests, and downloads at http://mysqltuner.com/ Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script [DG] MySQL Client: /usr/bin/mysql would have been started with the following arguments:

[DG] MySQL Client: /usr/bin/mysql [--] Performing tests on localhost:3306 [OK] Logged in using credentials passed on the command line [DG] Physical Memory: 16620273664 [DG] Swap Memory: 21185421312 [DG] PERFORM: SELECT VERSION() [DG] select_array: return code : 0 [DG] VERSION: 5.6.30 [DG] PERFORM: SHOW VARIABLES [DG] select_array: return code : 0 [DG] PERFORM: SHOW GLOBAL VARIABLES [DG] select_array: return code : 0 [DG] V: auto_increment_increment = 1 [DG] V: auto_increment_offset = 1 [DG] V: autocommit = ON [DG] V: automatic_sp_privileges = ON [DG] V: avoid_temporal_upgrade = OFF [DG] V: back_log = 56 [DG] V: basedir = /usr [DG] V: big_tables = OFF [DG] V: bind_address = 0.0.0.0 [DG] V: binlog_cache_size = 32768 [DG] V: binlog_checksum = CRC32 [DG] V: binlog_direct_non_transactional_updates = OFF [DG] V: binlog_error_action = IGNORE_ERROR [DG] V: binlog_format = STATEMENT [DG] V: binlog_gtid_simple_recovery = OFF [DG] V: binlog_max_flush_queue_time = 0 [DG] V: binlog_order_commits = ON [DG] V: binlog_row_image = MINIMAL [DG] V: binlog_rows_query_log_events = OFF [DG] V: binlog_stmt_cache_size = 32768 [DG] V: binlogging_impossible_mode = IGNORE_ERROR [DG] V: block_encryption_mode = aes-128-ecb [DG] V: bulk_insert_buffer_size = 8388608 [DG] V: character_set_client = utf8 [DG] V: character_set_connection = utf8 [DG] V: character_set_database = latin1 [DG] V: character_set_filesystem = binary [DG] V: character_set_results = utf8 [DG] V: character_set_server = latin1 [DG] V: character_set_system = utf8 [DG] V: character_sets_dir = /usr/share/mysql/charsets/ [DG] V: collation_connection = utf8_general_ci [DG] V: collation_database = latin1_swedish_ci [DG] V: collation_server = latin1_swedish_ci [DG] V: completion_type = NO_CHAIN [DG] V: concurrent_insert = AUTO [DG] V: connect_timeout = 10 [DG] V: core_file = OFF [DG] V: datadir = /DATA/VAR_LIB/mysql/ [DG] V: date_format = %Y-%m-%d [DG] V: datetime_format = %Y-%m-%d %H:%i:%s [DG] V: default_storage_engine = InnoDB [DG] V: default_tmp_storage_engine = InnoDB [DG] V: default_week_format = 0 [DG] V: delay_key_write = ON [DG] V: delayed_insert_limit = 100 [DG] V: delayed_insert_timeout = 300 [DG] V: delayed_queue_size = 1000 [DG] V: disconnect_on_expired_password = ON [DG] V: div_precision_increment = 4 [DG] V: end_markers_in_json = OFF [DG] V: enforce_gtid_consistency = OFF [DG] V: eq_range_index_dive_limit = 10 [DG] V: error_count = 0 [DG] V: event_scheduler = ON [DG] V: expire_logs_days = 5 [DG] V: explicit_defaults_for_timestamp = OFF [DG] V: external_user = [DG] V: flush = OFF [DG] V: flush_time = 0 [DG] V: foreign_key_checks = ON [DG] V: ft_boolean_syntax = + -><()~*:""&| [DG] V: ft_max_word_len = 84 [DG] V: ft_min_word_len = 4 [DG] V: ft_query_expansion_limit = 20 [DG] V: ft_stopword_file = (built-in) [DG] V: general_log = OFF [DG] V: general_log_file = /var/log/mysql/mysql.log [DG] V: group_concat_max_len = 1024 [DG] V: gtid_executed = [DG] V: gtid_mode = OFF [DG] V: gtid_next = AUTOMATIC [DG] V: gtid_owned = [DG] V: gtid_purged = [DG] V: have_compress = YES [DG] V: have_crypt = YES [DG] V: have_dynamic_loading = YES [DG] V: have_geometry = YES [DG] V: have_openssl = DISABLED [DG] V: have_profiling = YES [DG] V: have_query_cache = YES [DG] V: have_rtree_keys = YES [DG] V: have_ssl = DISABLED [DG] V: have_symlink = DISABLED [DG] V: host_cache_size = 160 [DG] V: hostname = portail.jpp.fr [DG] V: identity = 0 [DG] V: ignore_builtin_innodb = OFF [DG] V: ignore_db_dirs = [DG] V: init_connect = [DG] V: init_file = [DG] V: init_slave = [DG] V: innodb_adaptive_flushing = ON [DG] V: innodb_adaptive_flushing_lwm = 10 [DG] V: innodb_adaptive_hash_index = ON [DG] V: innodb_adaptive_max_sleep_delay = 150000 [DG] V: innodb_additional_mem_pool_size = 8388608 [DG] V: innodb_api_bk_commit_interval = 5 [DG] V: innodb_api_disable_rowlock = OFF [DG] V: innodb_api_enable_binlog = OFF [DG] V: innodb_api_enable_mdl = OFF [DG] V: innodb_api_trx_level = 0 [DG] V: innodb_autoextend_increment = 64 [DG] V: innodb_autoinc_lock_mode = 1 [DG] V: innodb_buffer_pool_dump_at_shutdown = OFF [DG] V: innodb_buffer_pool_dump_now = OFF [DG] V: innodb_buffer_pool_filename = ib_buffer_pool [DG] V: innodb_buffer_pool_instances = 4 [DG] V: innodb_buffer_pool_load_abort = OFF [DG] V: innodb_buffer_pool_load_at_startup = OFF [DG] V: innodb_buffer_pool_load_now = OFF [DG] V: innodb_buffer_pool_size = 4294967296 [DG] V: innodb_change_buffer_max_size = 25 [DG] V: innodb_change_buffering = all [DG] V: innodb_checksum_algorithm = innodb [DG] V: innodb_checksums = ON [DG] V: innodb_cmp_per_index_enabled = OFF [DG] V: innodb_commit_concurrency = 0 [DG] V: innodb_compression_failure_threshold_pct = 5 [DG] V: innodb_compression_level = 6 [DG] V: innodb_compression_pad_pct_max = 50 [DG] V: innodb_concurrency_tickets = 5000 [DG] V: innodb_data_file_path = ibdata1:12M:autoextend [DG] V: innodb_data_home_dir = [DG] V: innodb_disable_sort_file_cache = OFF [DG] V: innodb_doublewrite = ON [DG] V: innodb_fast_shutdown = 1 [DG] V: innodb_file_format = Antelope [DG] V: innodb_file_format_check = ON [DG] V: innodb_file_format_max = Antelope [DG] V: innodb_file_per_table = ON [DG] V: innodb_flush_log_at_timeout = 1 [DG] V: innodb_flush_log_at_trx_commit = 2 [DG] V: innodb_flush_method = O_DIRECT [DG] V: innodb_flush_neighbors = 1 [DG] V: innodb_flushing_avg_loops = 30 [DG] V: innodb_force_load_corrupted = OFF [DG] V: innodb_force_recovery = 0 [DG] V: innodb_ft_aux_table = [DG] V: innodb_ft_cache_size = 8000000 [DG] V: innodb_ft_enable_diag_print = OFF [DG] V: innodb_ft_enable_stopword = ON [DG] V: innodb_ft_max_token_size = 84 [DG] V: innodb_ft_min_token_size = 3 [DG] V: innodb_ft_num_word_optimize = 2000 [DG] V: innodb_ft_result_cache_limit = 2000000000 [DG] V: innodb_ft_server_stopword_table = [DG] V: innodb_ft_sort_pll_degree = 2 [DG] V: innodb_ft_total_cache_size = 640000000 [DG] V: innodb_ft_user_stopword_table = [DG] V: innodb_io_capacity = 200 [DG] V: innodb_io_capacity_max = 2000 [DG] V: innodb_large_prefix = OFF [DG] V: innodb_lock_wait_timeout = 50 [DG] V: innodb_locks_unsafe_for_binlog = OFF [DG] V: innodb_log_buffer_size = 8388608 [DG] V: innodb_log_compressed_pages = ON [DG] V: innodb_log_file_size = 536870912 [DG] V: innodb_log_files_in_group = 2 [DG] V: innodb_log_group_home_dir = ./ [DG] V: innodb_lru_scan_depth = 1024 [DG] V: innodb_max_dirty_pages_pct = 75 [DG] V: innodb_max_dirty_pages_pct_lwm = 0 [DG] V: innodb_max_purge_lag = 0 [DG] V: innodb_max_purge_lag_delay = 0 [DG] V: innodb_mirrored_log_groups = 1 [DG] V: innodb_monitor_disable = [DG] V: innodb_monitor_enable = [DG] V: innodb_monitor_reset = [DG] V: innodb_monitor_reset_all = [DG] V: innodb_old_blocks_pct = 37 [DG] V: innodb_old_blocks_time = 1000 [DG] V: innodb_online_alter_log_max_size = 134217728 [DG] V: innodb_open_files = 491 [DG] V: innodb_optimize_fulltext_only = OFF [DG] V: innodb_page_size = 16384 [DG] V: innodb_print_all_deadlocks = OFF [DG] V: innodb_purge_batch_size = 300 [DG] V: innodb_purge_threads = 1 [DG] V: innodb_random_read_ahead = OFF [DG] V: innodb_read_ahead_threshold = 56 [DG] V: innodb_read_io_threads = 2 [DG] V: innodb_read_only = OFF [DG] V: innodb_replication_delay = 0 [DG] V: innodb_rollback_on_timeout = OFF [DG] V: innodb_rollback_segments = 128 [DG] V: innodb_sort_buffer_size = 1048576 [DG] V: innodb_spin_wait_delay = 6 [DG] V: innodb_stats_auto_recalc = ON [DG] V: innodb_stats_method = nulls_equal [DG] V: innodb_stats_on_metadata = OFF [DG] V: innodb_stats_persistent = ON [DG] V: innodb_stats_persistent_sample_pages = 512 [DG] V: innodb_stats_sample_pages = 8 [DG] V: innodb_stats_transient_sample_pages = 8 [DG] V: innodb_status_output = OFF [DG] V: innodb_status_output_locks = OFF [DG] V: innodb_strict_mode = OFF [DG] V: innodb_support_xa = ON [DG] V: innodb_sync_array_size = 1 [DG] V: innodb_sync_spin_loops = 30 [DG] V: innodb_table_locks = ON [DG] V: innodb_thread_concurrency = 0 [DG] V: innodb_thread_sleep_delay = 10000 [DG] V: innodb_tmpdir = [DG] V: innodb_undo_directory = . [DG] V: innodb_undo_logs = 128 [DG] V: innodb_undo_tablespaces = 0 [DG] V: innodb_use_native_aio = ON [DG] V: innodb_use_sys_malloc = ON [DG] V: innodb_version = 5.6.30 [DG] V: innodb_write_io_threads = 2 [DG] V: insert_id = 0 [DG] V: interactive_timeout = 28800 [DG] V: join_buffer_size = 4194304 [DG] V: keep_files_on_create = OFF [DG] V: key_buffer_size = 2097152 [DG] V: key_cache_age_threshold = 300 [DG] V: key_cache_block_size = 1024 [DG] V: key_cache_division_limit = 100 [DG] V: large_files_support = ON [DG] V: large_page_size = 0 [DG] V: large_pages = OFF [DG] V: last_insert_id = 0 [DG] V: lc_messages = en_US [DG] V: lc_messages_dir = /usr/share/mysql/ [DG] V: lc_time_names = en_US [DG] V: license = GPL [DG] V: local_infile = OFF [DG] V: lock_wait_timeout = 31536000 [DG] V: locked_in_memory = OFF [DG] V: log_bin = ON [DG] V: log_bin_basename = /var/log/mysql/mysql-bin [DG] V: log_bin_index = /var/log/mysql/mysql-bin.index [DG] V: log_bin_trust_function_creators = OFF [DG] V: _row_events = OFF [DG] V: log_error = /var/log/mysql/error.log [DG] V: log_output = FILE [DG] V: log_queries_not_using_indexes = OFF [DG] V: log_slave_updates = OFF [DG] V: log_slow_admin_statements = OFF [DG] V: log_slow_slave_statements = OFF [DG] V: log_throttle_queries_not_using_indexes = 0 [DG] V: log_warnings = 1 [DG] V: long_query_time = 10.000000 [DG] V: low_priority_updates = OFF [DG] V: lower_case_file_system = OFF [DG] V: lower_case_table_names = 0 [DG] V: master_info_repository = FILE [DG] V: master_verify_checksum = OFF [DG] V: max_allowed_packet = 536870912 [DG] V: max_binlog_cache_size = 18446744073709547520 [DG] V: max_binlog_size = 134217728 [DG] V: max_binlog_stmt_cache_size = 18446744073709547520 [DG] V: max_connect_errors = 100 [DG] V: max_connections = 32 [DG] V: max_delayed_threads = 20 [DG] V: max_digest_length = 1024 [DG] V: max_error_count = 64 [DG] V: max_heap_table_size = 268435456 [DG] V: max_insert_delayed_threads = 20 [DG] V: max_join_size = 18446744073709551615 [DG] V: max_length_for_sort_data = 1024 [DG] V: max_prepared_stmt_count = 16382 [DG] V: max_relay_log_size = 0 [DG] V: max_seeks_for_key = 18446744073709551615 [DG] V: max_sort_length = 1024 [DG] V: max_sp_recursion_depth = 0 [DG] V: max_tmp_tables = 32 [DG] V: max_user_connections = 0 [DG] V: max_write_lock_count = 18446744073709551615 [DG] V: metadata_locks_cache_size = 1024 [DG] V: metadata_locks_hash_instances = 8 [DG] V: min_examined_row_limit = 0 [DG] V: multi_range_count = 256 [DG] V: myisam_data_pointer_size = 6 [DG] V: myisam_max_sort_file_size = 9223372036853727232 [DG] V: myisam_mmap_size = 18446744073709551615 [DG] V: myisam_recover_options = BACKUP [DG] V: myisam_repair_threads = 1 [DG] V: myisam_sort_buffer_size = 8388608 [DG] V: myisam_stats_method = nulls_unequal [DG] V: myisam_use_mmap = OFF [DG] V: net_buffer_length = 16384 [DG] V: net_read_timeout = 30 [DG] V: net_retry_count = 10 [DG] V: net_write_timeout = 60 [DG] V: new = OFF [DG] V: old = OFF [DG] V: old_alter_table = OFF [DG] V: old_passwords = 0 [DG] V: open_files_limit = 1024 [DG] V: optimizer_prune_level = 1 [DG] V: optimizer_search_depth = 62 [DG] V: 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,subquery_materialization_cost_based=on,use_index_extensions=on [DG] V: optimizer_trace = enabled=off,one_line=off [DG] V: optimizer_trace_features = greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on [DG] V: optimizer_trace_limit = 1 [DG] V: optimizer_trace_max_mem_size = 16384 [DG] V: optimizer_trace_offset = -1 [DG] V: performance_schema = ON [DG] V: performance_schema_accounts_size = 100 [DG] V: performance_schema_digests_size = 5000 [DG] V: performance_schema_events_stages_history_long_size = 1000 [DG] V: performance_schema_events_stages_history_size = 10 [DG] V: performance_schema_events_statements_history_long_size = 1000 [DG] V: performance_schema_events_statements_history_size = 10 [DG] V: performance_schema_events_waits_history_long_size = 1000 [DG] V: performance_schema_events_waits_history_size = 10 [DG] V: performance_schema_hosts_size = 100 [DG] V: performance_schema_max_cond_classes = 80 [DG] V: performance_schema_max_cond_instances = 895 [DG] V: performance_schema_max_digest_length = 1024 [DG] V: performance_schema_max_file_classes = 50 [DG] V: performance_schema_max_file_handles = 32768 [DG] V: performance_schema_max_file_instances = 2170 [DG] V: performance_schema_max_mutex_classes = 200 [DG] V: performance_schema_max_mutex_instances = 4509 [DG] V: performance_schema_max_rwlock_classes = 40 [DG] V: performance_schema_max_rwlock_instances = 2526 [DG] V: performance_schema_max_socket_classes = 10 [DG] V: performance_schema_max_socket_instances = 60 [DG] V: performance_schema_max_stage_classes = 150 [DG] V: performance_schema_max_statement_classes = 168 [DG] V: performance_schema_max_table_handles = 702 [DG] V: performance_schema_max_table_instances = 569 [DG] V: performance_schema_max_thread_classes = 50 [DG] V: performance_schema_max_thread_instances = 118 [DG] V: performance_schema_session_connect_attrs_size = 512 [DG] V: performance_schema_setup_actors_size = 100 [DG] V: performance_schema_setup_objects_size = 100 [DG] V: performance_schema_users_size = 100 [DG] V: pid_file = /var/run/mysqld/mysqld.pid [DG] V: plugin_dir = /usr/lib/mysql/plugin/ [DG] V: port = 3306 [DG] V: preload_buffer_size = 32768 [DG] V: profiling = OFF [DG] V: profiling_history_size = 15 [DG] V: protocol_version = 10 [DG] V: proxy_user = [DG] V: pseudo_slave_mode = OFF [DG] V: pseudo_thread_id = 37 [DG] V: query_alloc_block_size = 8192 [DG] V: query_cache_limit = 0 [DG] V: query_cache_min_res_unit = 4096 [DG] V: query_cache_size = 0 [DG] V: query_cache_type = OFF [DG] V: query_cache_wlock_invalidate = OFF [DG] V: query_prealloc_size = 8192 [DG] V: = 0 [DG] V: = 0 [DG] V: range_alloc_block_size = 4096 [DG] V: read_buffer_size = 2097152 [DG] V: read_only = OFF [DG] V: read_rnd_buffer_size = 262144 [DG] V: relay_log = [DG] V: relay_log_basename = [DG] V: relay_log_index = [DG] V: relay_log_info_file = relay-log.info [DG] V: relay_log_info_repository = FILE [DG] V: relay_log_purge = ON [DG] V: relay_log_recovery = OFF [DG] V: relay_log_space_limit = 0 [DG] V: report_host = [DG] V: report_password = [DG] V: report_port = 3306 [DG] V: report_user = [DG] V: rpl_stop_slave_timeout = 31536000 [DG] V: secure_auth = ON [DG] V: secure_file_priv = [DG] V: server_id = 10 [DG] V: server_id_bits = 32 [DG] V: server_uuid = e33c168c-6a23-11e6-86fb-408d5cbae206 [DG] V: show_old_temporals = OFF [DG] V: simplified_binlog_gtid_recovery = OFF [DG] V: skip_external_locking = ON [DG] V: skip_name_resolve = ON [DG] V: skip_networking = OFF [DG] V: skip_show_database = OFF [DG] V: slave_allow_batching = OFF [DG] V: slave_checkpoint_group = 512 [DG] V: slave_checkpoint_period = 300 [DG] V: slave_compressed_protocol = OFF [DG] V: slave_exec_mode = STRICT [DG] V: slave_load_tmpdir = /tmp [DG] V: slave_max_allowed_packet = 1073741824 [DG] V: slave_net_timeout = 3600 [DG] V: slave_parallel_workers = 0 [DG] V: slave_pending_jobs_size_max = 16777216 [DG] V: slave_rows_search_algorithms = TABLE_SCAN,INDEX_SCAN [DG] V: slave_skip_errors = OFF [DG] V: slave_sql_verify_checksum = ON [DG] V: slave_transaction_retries = 10 [DG] V: slave_type_conversions = [DG] V: slow_launch_time = 2 [DG] V: slow_query_log = OFF [DG] V: slow_query_log_file = /DATA/VAR_LIB/mysql/portail-slow.log [DG] V: socket = /var/run/mysqld/mysqld.sock [DG] V: sort_buffer_size = 1048576 [DG] V: sql_auto_is_null = OFF [DG] V: sql_big_selects = ON [DG] V: sql_buffer_result = OFF [DG] V: sql_log_bin = ON [DG] V: sql_log_off = OFF [DG] V: sql_mode = NO_ENGINE_SUBSTITUTION [DG] V: sql_notes = ON [DG] V: sql_quote_show_create = ON [DG] V: sql_safe_updates = OFF [DG] V: sql_select_limit = 18446744073709551615 [DG] V: sql_slave_skip_counter = 0 [DG] V: sql_warnings = OFF [DG] V: ssl_ca = [DG] V: ssl_capath = [DG] V: ssl_cert = [DG] V: ssl_cipher = [DG] V: ssl_crl = [DG] V: ssl_crlpath = [DG] V: ssl_key = [DG] V: storage_engine = InnoDB [DG] V: stored_program_cache = 256 [DG] V: sync_binlog = 1 [DG] V: sync_frm = ON [DG] V: sync_master_info = 10000 [DG] V: sync_relay_log = 10000 [DG] V: sync_relay_log_info = 10000 [DG] V: system_time_zone = CET [DG] V: table_definition_cache = 512 [DG] V: table_open_cache = 491 [DG] V: table_open_cache_instances = 1 [DG] V: thread_cache_size = 15 [DG] V: thread_concurrency = 15 [DG] V: thread_handling = one-thread-per-connection [DG] V: thread_stack = 196608 [DG] V: time_format = %H:%i:%s [DG] V: time_zone = SYSTEM [DG] V: timed_mutexes = OFF [DG] V: timestamp = 1487022455.962737 [DG] V: tmp_table_size = 268435456 [DG] V: tmpdir = /tmp [DG] V: transaction_alloc_block_size = 8192 [DG] V: transaction_allow_batching = OFF [DG] V: transaction_prealloc_size = 4096 [DG] V: tx_isolation = REPEATABLE-READ [DG] V: tx_read_only = OFF [DG] V: unique_checks = ON [DG] V: updatable_views_with_limit = YES [DG] V: validate_password_dictionary_file = [DG] V: validate_password_length = 8 [DG] V: validate_password_mixed_case_count = 1 [DG] V: validate_password_number_count = 1 [DG] V: validate_password_policy = MEDIUM [DG] V: validate_password_special_char_count = 1 [DG] V: version = 5.6.30-1~bpo8+1-log [DG] V: version_comment = (Debian) [DG] V: version_compile_machine = x86_64 [DG] V: version_compile_os = debian-linux-gnu [DG] V: wait_timeout = 28800 [DG] V: warning_count = 0 [DG] V: auto_increment_increment = 1 [DG] V: auto_increment_offset = 1 [DG] V: autocommit = ON [DG] V: automatic_sp_privileges = ON [DG] V: avoid_temporal_upgrade = OFF [DG] V: back_log = 56 [DG] V: basedir = /usr [DG] V: big_tables = OFF [DG] V: bind_address = 0.0.0.0 [DG] V: binlog_cache_size = 32768 [DG] V: binlog_checksum = CRC32 [DG] V: binlog_direct_non_transactional_updates = OFF [DG] V: binlog_error_action = IGNORE_ERROR [DG] V: binlog_format = STATEMENT [DG] V: binlog_gtid_simple_recovery = OFF [DG] V: binlog_max_flush_queue_time = 0 [DG] V: binlog_order_commits = ON [DG] V: binlog_row_image = MINIMAL [DG] V: binlog_rows_query_log_events = OFF [DG] V: binlog_stmt_cache_size = 32768 [DG] V: binlogging_impossible_mode = IGNORE_ERROR [DG] V: block_encryption_mode = aes-128-ecb [DG] V: bulk_insert_buffer_size = 8388608 [DG] V: character_set_client = latin1 [DG] V: character_set_connection = latin1 [DG] V: character_set_database = latin1 [DG] V: character_set_filesystem = binary [DG] V: character_set_results = latin1 [DG] V: character_set_server = latin1 [DG] V: character_set_system = utf8 [DG] V: character_sets_dir = /usr/share/mysql/charsets/ [DG] V: collation_connection = latin1_swedish_ci [DG] V: collation_database = latin1_swedish_ci [DG] V: collation_server = latin1_swedish_ci [DG] V: completion_type = NO_CHAIN [DG] V: concurrent_insert = AUTO [DG] V: connect_timeout = 10 [DG] V: core_file = OFF [DG] V: datadir = /DATA/VAR_LIB/mysql/ [DG] V: date_format = %Y-%m-%d [DG] V: datetime_format = %Y-%m-%d %H:%i:%s [DG] V: default_storage_engine = InnoDB [DG] V: default_tmp_storage_engine = InnoDB [DG] V: default_week_format = 0 [DG] V: delay_key_write = ON [DG] V: delayed_insert_limit = 100 [DG] V: delayed_insert_timeout = 300 [DG] V: delayed_queue_size = 1000 [DG] V: disconnect_on_expired_password = ON [DG] V: div_precision_increment = 4 [DG] V: end_markers_in_json = OFF [DG] V: enforce_gtid_consistency = OFF [DG] V: eq_range_index_dive_limit = 10 [DG] V: event_scheduler = ON [DG] V: expire_logs_days = 5 [DG] V: explicit_defaults_for_timestamp = OFF [DG] V: flush = OFF [DG] V: flush_time = 0 [DG] V: foreign_key_checks = ON [DG] V: ft_boolean_syntax = + -><()~*:""&| [DG] V: ft_max_word_len = 84 [DG] V: ft_min_word_len = 4 [DG] V: ft_query_expansion_limit = 20 [DG] V: ft_stopword_file = (built-in) [DG] V: general_log = OFF [DG] V: general_log_file = /var/log/mysql/mysql.log [DG] V: group_concat_max_len = 1024 [DG] V: gtid_executed = [DG] V: gtid_mode = OFF [DG] V: gtid_owned = [DG] V: gtid_purged = [DG] V: have_compress = YES [DG] V: have_crypt = YES [DG] V: have_dynamic_loading = YES [DG] V: have_geometry = YES [DG] V: have_openssl = DISABLED [DG] V: have_profiling = YES [DG] V: have_query_cache = YES [DG] V: have_rtree_keys = YES [DG] V: have_ssl = DISABLED [DG] V: have_symlink = DISABLED [DG] V: host_cache_size = 160 [DG] V: hostname = portail.jpp.fr [DG] V: ignore_builtin_innodb = OFF [DG] V: ignore_db_dirs = [DG] V: init_connect = [DG] V: init_file = [DG] V: init_slave = [DG] V: innodb_adaptive_flushing = ON [DG] V: innodb_adaptive_flushing_lwm = 10 [DG] V: innodb_adaptive_hash_index = ON [DG] V: innodb_adaptive_max_sleep_delay = 150000 [DG] V: innodb_additional_mem_pool_size = 8388608 [DG] V: innodb_api_bk_commit_interval = 5 [DG] V: innodb_api_disable_rowlock = OFF [DG] V: innodb_api_enable_binlog = OFF [DG] V: innodb_api_enable_mdl = OFF [DG] V: innodb_api_trx_level = 0 [DG] V: innodb_autoextend_increment = 64 [DG] V: innodb_autoinc_lock_mode = 1 [DG] V: innodb_buffer_pool_dump_at_shutdown = OFF [DG] V: innodb_buffer_pool_dump_now = OFF [DG] V: innodb_buffer_pool_filename = ib_buffer_pool [DG] V: innodb_buffer_pool_instances = 4 [DG] V: innodb_buffer_pool_load_abort = OFF [DG] V: innodb_buffer_pool_load_at_startup = OFF [DG] V: innodb_buffer_pool_load_now = OFF [DG] V: innodb_buffer_pool_size = 4294967296 [DG] V: innodb_change_buffer_max_size = 25 [DG] V: innodb_change_buffering = all [DG] V: innodb_checksum_algorithm = innodb [DG] V: innodb_checksums = ON [DG] V: innodb_cmp_per_index_enabled = OFF [DG] V: innodb_commit_concurrency = 0 [DG] V: innodb_compression_failure_threshold_pct = 5 [DG] V: innodb_compression_level = 6 [DG] V: innodb_compression_pad_pct_max = 50 [DG] V: innodb_concurrency_tickets = 5000 [DG] V: innodb_data_file_path = ibdata1:12M:autoextend [DG] V: innodb_data_home_dir = [DG] V: innodb_disable_sort_file_cache = OFF [DG] V: innodb_doublewrite = ON [DG] V: innodb_fast_shutdown = 1 [DG] V: innodb_file_format = Antelope [DG] V: innodb_file_format_check = ON [DG] V: innodb_file_format_max = Antelope [DG] V: innodb_file_per_table = ON [DG] V: innodb_flush_log_at_timeout = 1 [DG] V: innodb_flush_log_at_trx_commit = 2 [DG] V: innodb_flush_method = O_DIRECT [DG] V: innodb_flush_neighbors = 1 [DG] V: innodb_flushing_avg_loops = 30 [DG] V: innodb_force_load_corrupted = OFF [DG] V: innodb_force_recovery = 0 [DG] V: innodb_ft_aux_table = [DG] V: innodb_ft_cache_size = 8000000 [DG] V: innodb_ft_enable_diag_print = OFF [DG] V: innodb_ft_enable_stopword = ON [DG] V: innodb_ft_max_token_size = 84 [DG] V: innodb_ft_min_token_size = 3 [DG] V: innodb_ft_num_word_optimize = 2000 [DG] V: innodb_ft_result_cache_limit = 2000000000 [DG] V: innodb_ft_server_stopword_table = [DG] V: innodb_ft_sort_pll_degree = 2 [DG] V: innodb_ft_total_cache_size = 640000000 [DG] V: innodb_ft_user_stopword_table = [DG] V: innodb_io_capacity = 200 [DG] V: innodb_io_capacity_max = 2000 [DG] V: innodb_large_prefix = OFF [DG] V: innodb_lock_wait_timeout = 50 [DG] V: innodb_locks_unsafe_for_binlog = OFF [DG] V: innodb_log_buffer_size = 8388608 [DG] V: innodb_log_compressed_pages = ON [DG] V: innodb_log_file_size = 536870912 [DG] V: innodb_log_files_in_group = 2 [DG] V: innodb_log_group_home_dir = ./ [DG] V: innodb_lru_scan_depth = 1024 [DG] V: innodb_max_dirty_pages_pct = 75 [DG] V: innodb_max_dirty_pages_pct_lwm = 0 [DG] V: innodb_max_purge_lag = 0 [DG] V: innodb_max_purge_lag_delay = 0 [DG] V: innodb_mirrored_log_groups = 1 [DG] V: innodb_monitor_disable = [DG] V: innodb_monitor_enable = [DG] V: innodb_monitor_reset = [DG] V: innodb_monitor_reset_all = [DG] V: innodb_old_blocks_pct = 37 [DG] V: innodb_old_blocks_time = 1000 [DG] V: innodb_online_alter_log_max_size = 134217728 [DG] V: innodb_open_files = 491 [DG] V: innodb_optimize_fulltext_only = OFF [DG] V: innodb_page_size = 16384 [DG] V: innodb_print_all_deadlocks = OFF [DG] V: innodb_purge_batch_size = 300 [DG] V: innodb_purge_threads = 1 [DG] V: innodb_random_read_ahead = OFF [DG] V: innodb_read_ahead_threshold = 56 [DG] V: innodb_read_io_threads = 2 [DG] V: innodb_read_only = OFF [DG] V: innodb_replication_delay = 0 [DG] V: innodb_rollback_on_timeout = OFF [DG] V: innodb_rollback_segments = 128 [DG] V: innodb_sort_buffer_size = 1048576 [DG] V: innodb_spin_wait_delay = 6 [DG] V: innodb_stats_auto_recalc = ON [DG] V: innodb_stats_method = nulls_equal [DG] V: innodb_stats_on_metadata = OFF [DG] V: innodb_stats_persistent = ON [DG] V: innodb_stats_persistent_sample_pages = 512 [DG] V: innodb_stats_sample_pages = 8 [DG] V: innodb_stats_transient_sample_pages = 8 [DG] V: innodb_status_output = OFF [DG] V: innodb_status_output_locks = OFF [DG] V: innodb_strict_mode = OFF [DG] V: innodb_support_xa = ON [DG] V: innodb_sync_array_size = 1 [DG] V: innodb_sync_spin_loops = 30 [DG] V: innodb_table_locks = ON [DG] V: innodb_thread_concurrency = 0 [DG] V: innodb_thread_sleep_delay = 10000 [DG] V: innodb_tmpdir = [DG] V: innodb_undo_directory = . [DG] V: innodb_undo_logs = 128 [DG] V: innodb_undo_tablespaces = 0 [DG] V: innodb_use_native_aio = ON [DG] V: innodb_use_sys_malloc = ON [DG] V: innodb_version = 5.6.30 [DG] V: innodb_write_io_threads = 2 [DG] V: interactive_timeout = 28800 [DG] V: join_buffer_size = 4194304 [DG] V: keep_files_on_create = OFF [DG] V: key_buffer_size = 2097152 [DG] V: key_cache_age_threshold = 300 [DG] V: key_cache_block_size = 1024 [DG] V: key_cache_division_limit = 100 [DG] V: large_files_support = ON [DG] V: large_page_size = 0 [DG] V: large_pages = OFF [DG] V: lc_messages = en_US [DG] V: lc_messages_dir = /usr/share/mysql/ [DG] V: lc_time_names = en_US [DG] V: license = GPL [DG] V: local_infile = OFF [DG] V: lock_wait_timeout = 31536000 [DG] V: locked_in_memory = OFF [DG] V: log_bin = ON [DG] V: log_bin_basename = /var/log/mysql/mysql-bin [DG] V: log_bin_index = /var/log/mysql/mysql-bin.index [DG] V: log_bin_trust_function_creators = OFF [DG] V: _row_events = OFF [DG] V: log_error = /var/log/mysql/error.log [DG] V: log_output = FILE [DG] V: log_queries_not_using_indexes = OFF [DG] V: log_slave_updates = OFF [DG] V: log_slow_admin_statements = OFF [DG] V: log_slow_slave_statements = OFF [DG] V: log_throttle_queries_not_using_indexes = 0 [DG] V: log_warnings = 1 [DG] V: long_query_time = 10.000000 [DG] V: low_priority_updates = OFF [DG] V: lower_case_file_system = OFF [DG] V: lower_case_table_names = 0 [DG] V: master_info_repository = FILE [DG] V: master_verify_checksum = OFF [DG] V: max_allowed_packet = 536870912 [DG] V: max_binlog_cache_size = 18446744073709547520 [DG] V: max_binlog_size = 134217728 [DG] V: max_binlog_stmt_cache_size = 18446744073709547520 [DG] V: max_connect_errors = 100 [DG] V: max_connections = 32 [DG] V: max_delayed_threads = 20 [DG] V: max_digest_length = 1024 [DG] V: max_error_count = 64 [DG] V: max_heap_table_size = 268435456 [DG] V: max_insert_delayed_threads = 20 [DG] V: max_join_size = 18446744073709551615 [DG] V: max_length_for_sort_data = 1024 [DG] V: max_prepared_stmt_count = 16382 [DG] V: max_relay_log_size = 0 [DG] V: max_seeks_for_key = 18446744073709551615 [DG] V: max_sort_length = 1024 [DG] V: max_sp_recursion_depth = 0 [DG] V: max_tmp_tables = 32 [DG] V: max_user_connections = 0 [DG] V: max_write_lock_count = 18446744073709551615 [DG] V: metadata_locks_cache_size = 1024 [DG] V: metadata_locks_hash_instances = 8 [DG] V: min_examined_row_limit = 0 [DG] V: multi_range_count = 256 [DG] V: myisam_data_pointer_size = 6 [DG] V: myisam_max_sort_file_size = 9223372036853727232 [DG] V: myisam_mmap_size = 18446744073709551615 [DG] V: myisam_recover_options = BACKUP [DG] V: myisam_repair_threads = 1 [DG] V: myisam_sort_buffer_size = 8388608 [DG] V: myisam_stats_method = nulls_unequal [DG] V: myisam_use_mmap = OFF [DG] V: net_buffer_length = 16384 [DG] V: net_read_timeout = 30 [DG] V: net_retry_count = 10 [DG] V: net_write_timeout = 60 [DG] V: new = OFF [DG] V: old = OFF [DG] V: old_alter_table = OFF [DG] V: old_passwords = 0 [DG] V: open_files_limit = 1024 [DG] V: optimizer_prune_level = 1 [DG] V: optimizer_search_depth = 62 [DG] V: 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,subquery_materialization_cost_based=on,use_index_extensions=on [DG] V: optimizer_trace = enabled=off,one_line=off [DG] V: optimizer_trace_features = greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on [DG] V: optimizer_trace_limit = 1 [DG] V: optimizer_trace_max_mem_size = 16384 [DG] V: optimizer_trace_offset = -1 [DG] V: performance_schema = ON [DG] V: performance_schema_accounts_size = 100 [DG] V: performance_schema_digests_size = 5000 [DG] V: performance_schema_events_stages_history_long_size = 1000 [DG] V: performance_schema_events_stages_history_size = 10 [DG] V: performance_schema_events_statements_history_long_size = 1000 [DG] V: performance_schema_events_statements_history_size = 10 [DG] V: performance_schema_events_waits_history_long_size = 1000 [DG] V: performance_schema_events_waits_history_size = 10 [DG] V: performance_schema_hosts_size = 100 [DG] V: performance_schema_max_cond_classes = 80 [DG] V: performance_schema_max_cond_instances = 895 [DG] V: performance_schema_max_digest_length = 1024 [DG] V: performance_schema_max_file_classes = 50 [DG] V: performance_schema_max_file_handles = 32768 [DG] V: performance_schema_max_file_instances = 2170 [DG] V: performance_schema_max_mutex_classes = 200 [DG] V: performance_schema_max_mutex_instances = 4509 [DG] V: performance_schema_max_rwlock_classes = 40 [DG] V: performance_schema_max_rwlock_instances = 2526 [DG] V: performance_schema_max_socket_classes = 10 [DG] V: performance_schema_max_socket_instances = 60 [DG] V: performance_schema_max_stage_classes = 150 [DG] V: performance_schema_max_statement_classes = 168 [DG] V: performance_schema_max_table_handles = 702 [DG] V: performance_schema_max_table_instances = 569 [DG] V: performance_schema_max_thread_classes = 50 [DG] V: performance_schema_max_thread_instances = 118 [DG] V: performance_schema_session_connect_attrs_size = 512 [DG] V: performance_schema_setup_actors_size = 100 [DG] V: performance_schema_setup_objects_size = 100 [DG] V: performance_schema_users_size = 100 [DG] V: pid_file = /var/run/mysqld/mysqld.pid [DG] V: plugin_dir = /usr/lib/mysql/plugin/ [DG] V: port = 3306 [DG] V: preload_buffer_size = 32768 [DG] V: profiling = OFF [DG] V: profiling_history_size = 15 [DG] V: protocol_version = 10 [DG] V: query_alloc_block_size = 8192 [DG] V: query_cache_limit = 0 [DG] V: query_cache_min_res_unit = 4096 [DG] V: query_cache_size = 0 [DG] V: query_cache_type = OFF [DG] V: query_cache_wlock_invalidate = OFF [DG] V: query_prealloc_size = 8192 [DG] V: range_alloc_block_size = 4096 [DG] V: read_buffer_size = 2097152 [DG] V: read_only = OFF [DG] V: read_rnd_buffer_size = 262144 [DG] V: relay_log = [DG] V: relay_log_basename = [DG] V: relay_log_index = [DG] V: relay_log_info_file = relay-log.info [DG] V: relay_log_info_repository = FILE [DG] V: relay_log_purge = ON [DG] V: relay_log_recovery = OFF [DG] V: relay_log_space_limit = 0 [DG] V: report_host = [DG] V: report_password = [DG] V: report_port = 3306 [DG] V: report_user = [DG] V: rpl_stop_slave_timeout = 31536000 [DG] V: secure_auth = ON [DG] V: secure_file_priv = [DG] V: server_id = 10 [DG] V: server_id_bits = 32 [DG] V: server_uuid = e33c168c-6a23-11e6-86fb-408d5cbae206 [DG] V: show_old_temporals = OFF [DG] V: simplified_binlog_gtid_recovery = OFF [DG] V: skip_external_locking = ON [DG] V: skip_name_resolve = ON [DG] V: skip_networking = OFF [DG] V: skip_show_database = OFF [DG] V: slave_allow_batching = OFF [DG] V: slave_checkpoint_group = 512 [DG] V: slave_checkpoint_period = 300 [DG] V: slave_compressed_protocol = OFF [DG] V: slave_exec_mode = STRICT [DG] V: slave_load_tmpdir = /tmp [DG] V: slave_max_allowed_packet = 1073741824 [DG] V: slave_net_timeout = 3600 [DG] V: slave_parallel_workers = 0 [DG] V: slave_pending_jobs_size_max = 16777216 [DG] V: slave_rows_search_algorithms = TABLE_SCAN,INDEX_SCAN [DG] V: slave_skip_errors = OFF [DG] V: slave_sql_verify_checksum = ON [DG] V: slave_transaction_retries = 10 [DG] V: slave_type_conversions = [DG] V: slow_launch_time = 2 [DG] V: slow_query_log = OFF [DG] V: slow_query_log_file = /DATA/VAR_LIB/mysql/portail-slow.log [DG] V: socket = /var/run/mysqld/mysqld.sock [DG] V: sort_buffer_size = 1048576 [DG] V: sql_auto_is_null = OFF [DG] V: sql_big_selects = ON [DG] V: sql_buffer_result = OFF [DG] V: sql_log_bin = ON [DG] V: sql_log_off = OFF [DG] V: sql_mode = NO_ENGINE_SUBSTITUTION [DG] V: sql_notes = ON [DG] V: sql_quote_show_create = ON [DG] V: sql_safe_updates = OFF [DG] V: sql_select_limit = 18446744073709551615 [DG] V: sql_slave_skip_counter = 0 [DG] V: sql_warnings = OFF [DG] V: ssl_ca = [DG] V: ssl_capath = [DG] V: ssl_cert = [DG] V: ssl_cipher = [DG] V: ssl_crl = [DG] V: ssl_crlpath = [DG] V: ssl_key = [DG] V: storage_engine = InnoDB [DG] V: stored_program_cache = 256 [DG] V: sync_binlog = 1 [DG] V: sync_frm = ON [DG] V: sync_master_info = 10000 [DG] V: sync_relay_log = 10000 [DG] V: sync_relay_log_info = 10000 [DG] V: system_time_zone = CET [DG] V: table_definition_cache = 512 [DG] V: table_open_cache = 491 [DG] V: table_open_cache_instances = 1 [DG] V: thread_cache_size = 15 [DG] V: thread_concurrency = 15 [DG] V: thread_handling = one-thread-per-connection [DG] V: thread_stack = 196608 [DG] V: time_format = %H:%i:%s [DG] V: time_zone = SYSTEM [DG] V: timed_mutexes = OFF [DG] V: tmp_table_size = 268435456 [DG] V: tmpdir = /tmp [DG] V: transaction_alloc_block_size = 8192 [DG] V: transaction_prealloc_size = 4096 [DG] V: tx_isolation = REPEATABLE-READ [DG] V: tx_read_only = OFF [DG] V: unique_checks = ON [DG] V: updatable_views_with_limit = YES [DG] V: validate_password_dictionary_file = [DG] V: validate_password_length = 8 [DG] V: validate_password_mixed_case_count = 1 [DG] V: validate_password_number_count = 1 [DG] V: validate_password_policy = MEDIUM [DG] V: validate_password_special_char_count = 1 [DG] V: version = 5.6.30-1~bpo8+1-log [DG] V: version_comment = (Debian) [DG] V: version_compile_machine = x86_64 [DG] V: version_compile_os = debian-linux-gnu [DG] V: wait_timeout = 28800 [DG] PERFORM: SHOW STATUS [DG] select_array: return code : 0 [DG] PERFORM: SHOW GLOBAL STATUS [DG] select_array: return code : 0 [DG] V: Aborted_clients = 9 [DG] V: Aborted_connects = 1 [DG] V: Binlog_cache_disk_use = 0 [DG] V: Binlog_cache_use = 4624 [DG] V: Binlog_stmt_cache_disk_use = 0 [DG] V: Binlog_stmt_cache_use = 0 [DG] V: Bytes_received = 251 [DG] V: Bytes_sent = 181 [DG] V: Com_admin_commands = 0 [DG] V: Com_assign_to_keycache = 0 [DG] V: Com_alter_db = 0 [DG] V: Com_alter_db_upgrade = 0 [DG] V: Com_alter_event = 0 [DG] V: Com_alter_function = 0 [DG] V: Com_alter_procedure = 0 [DG] V: Com_alter_server = 0 [DG] V: Com_alter_table = 0 [DG] V: Com_alter_tablespace = 0 [DG] V: Com_alter_user = 0 [DG] V: Com_analyze = 0 [DG] V: Com_begin = 0 [DG] V: Com_binlog = 0 [DG] V: Com_call_procedure = 0 [DG] V: Com_change_db = 0 [DG] V: Com_change_master = 0 [DG] V: Com_check = 0 [DG] V: Com_checksum = 0 [DG] V: Com_commit = 0 [DG] V: Com_create_db = 0 [DG] V: Com_create_event = 0 [DG] V: Com_create_function = 0 [DG] V: Com_create_index = 0 [DG] V: Com_create_procedure = 0 [DG] V: Com_create_server = 0 [DG] V: Com_create_table = 0 [DG] V: Com_create_trigger = 0 [DG] V: Com_create_udf = 0 [DG] V: Com_create_user = 0 [DG] V: Com_create_view = 0 [DG] V: Com_dealloc_sql = 0 [DG] V: Com_delete = 0 [DG] V: Com_delete_multi = 0 [DG] V: Com_do = 0 [DG] V: Com_drop_db = 0 [DG] V: Com_drop_event = 0 [DG] V: Com_drop_function = 0 [DG] V: Com_drop_index = 0 [DG] V: Com_drop_procedure = 0 [DG] V: Com_drop_server = 0 [DG] V: Com_drop_table = 0 [DG] V: Com_drop_trigger = 0 [DG] V: Com_drop_user = 0 [DG] V: Com_drop_view = 0 [DG] V: Com_empty_query = 0 [DG] V: Com_execute_sql = 0 [DG] V: Com_flush = 0 [DG] V: Com_get_diagnostics = 0 [DG] V: Com_grant = 0 [DG] V: Com_ha_close = 0 [DG] V: Com_ha_open = 0 [DG] V: Com_ha_read = 0 [DG] V: Com_help = 0 [DG] V: Com_insert = 0 [DG] V: Com_insert_select = 0 [DG] V: Com_install_plugin = 0 [DG] V: Com_kill = 0 [DG] V: Com_load = 0 [DG] V: Com_lock_tables = 0 [DG] V: Com_optimize = 0 [DG] V: Com_preload_keys = 0 [DG] V: Com_prepare_sql = 0 [DG] V: Com_purge = 0 [DG] V: Com_purge_before_date = 0 [DG] V: Com_release_savepoint = 0 [DG] V: Com_rename_table = 0 [DG] V: Com_rename_user = 0 [DG] V: Com_repair = 0 [DG] V: Com_replace = 0 [DG] V: Com_replace_select = 0 [DG] V: Com_reset = 0 [DG] V: Com_resignal = 0 [DG] V: Com_revoke = 0 [DG] V: Com_revoke_all = 0 [DG] V: Com_rollback = 0 [DG] V: Com_rollback_to_savepoint = 0 [DG] V: Com_savepoint = 0 [DG] V: Com_select = 1 [DG] V: Com_set_option = 0 [DG] V: Com_signal = 0 [DG] V: Com_show_binlog_events = 0 [DG] V: Com_show_binlogs = 0 [DG] V: Com_show_charsets = 0 [DG] V: Com_show_collations = 0 [DG] V: Com_show_create_db = 0 [DG] V: Com_show_create_event = 0 [DG] V: Com_show_create_func = 0 [DG] V: Com_show_create_proc = 0 [DG] V: Com_show_create_table = 0 [DG] V: Com_show_create_trigger = 0 [DG] V: Com_show_databases = 0 [DG] V: Com_show_engine_logs = 0 [DG] V: Com_show_engine_mutex = 0 [DG] V: Com_show_engine_status = 0 [DG] V: Com_show_events = 0 [DG] V: Com_show_errors = 0 [DG] V: Com_show_fields = 0 [DG] V: Com_show_function_code = 0 [DG] V: Com_show_function_status = 0 [DG] V: Com_show_grants = 0 [DG] V: Com_show_keys = 0 [DG] V: Com_show_master_status = 0 [DG] V: Com_show_open_tables = 0 [DG] V: Com_show_plugins = 0 [DG] V: Com_show_privileges = 0 [DG] V: Com_show_procedure_code = 0 [DG] V: Com_show_procedure_status = 0 [DG] V: Com_show_processlist = 0 [DG] V: Com_show_profile = 0 [DG] V: Com_show_profiles = 0 [DG] V: Com_show_relaylog_events = 0 [DG] V: Com_show_slave_hosts = 0 [DG] V: Com_show_slave_status = 0 [DG] V: Com_show_status = 1 [DG] V: Com_show_storage_engines = 0 [DG] V: Com_show_table_status = 0 [DG] V: Com_show_tables = 0 [DG] V: Com_show_triggers = 0 [DG] V: Com_show_variables = 0 [DG] V: Com_show_warnings = 0 [DG] V: Com_slave_start = 0 [DG] V: Com_slave_stop = 0 [DG] V: Com_stmt_close = 0 [DG] V: Com_stmt_execute = 0 [DG] V: Com_stmt_fetch = 0 [DG] V: Com_stmt_prepare = 0 [DG] V: Com_stmt_reprepare = 0 [DG] V: Com_stmt_reset = 0 [DG] V: Com_stmt_send_long_data = 0 [DG] V: Com_truncate = 0 [DG] V: Com_uninstall_plugin = 0 [DG] V: Com_unlock_tables = 0 [DG] V: Com_update = 0 [DG] V: Com_update_multi = 0 [DG] V: Com_xa_commit = 0 [DG] V: Com_xa_end = 0 [DG] V: Com_xa_prepare = 0 [DG] V: Com_xa_recover = 0 [DG] V: Com_xa_rollback = 0 [DG] V: Com_xa_start = 0 [DG] V: Compression = OFF [DG] V: Connection_errors_accept = 0 [DG] V: Connection_errors_internal = 0 [DG] V: Connection_errors_max_connections = 0 [DG] V: Connection_errors_peer_address = 0 [DG] V: Connection_errors_select = 0 [DG] V: Connection_errors_tcpwrap = 0 [DG] V: Connections = 40 [DG] V: Created_tmp_disk_tables = 0 [DG] V: Created_tmp_files = 6 [DG] V: Created_tmp_tables = 0 [DG] V: Delayed_errors = 0 [DG] V: Delayed_insert_threads = 0 [DG] V: Delayed_writes = 0 [DG] V: Flush_commands = 1 [DG] V: Handler_commit = 0 [DG] V: Handler_delete = 0 [DG] V: Handler_discover = 0 [DG] V: Handler_external_lock = 0 [DG] V: Handler_mrr_init = 0 [DG] V: Handler_prepare = 0 [DG] V: Handler_read_first = 0 [DG] V: Handler_read_key = 0 [DG] V: Handler_read_last = 0 [DG] V: Handler_read_next = 0 [DG] V: Handler_read_prev = 0 [DG] V: Handler_read_rnd = 0 [DG] V: Handler_read_rnd_next = 0 [DG] V: Handler_rollback = 0 [DG] V: Handler_savepoint = 0 [DG] V: Handler_savepoint_rollback = 0 [DG] V: Handler_update = 0 [DG] V: Handler_write = 0 [DG] V: Innodb_buffer_pool_dump_status = not started [DG] V: Innodb_buffer_pool_load_status = not started [DG] V: Innodb_buffer_pool_pages_data = 1145 [DG] V: Innodb_buffer_pool_bytes_data = 18759680 [DG] V: Innodb_buffer_pool_pages_dirty = 0 [DG] V: Innodb_buffer_pool_bytes_dirty = 0 [DG] V: Innodb_buffer_pool_pages_flushed = 8597 [DG] V: Innodb_buffer_pool_pages_free = 260991 [DG] V: Innodb_buffer_pool_pages_misc = 6 [DG] V: Innodb_buffer_pool_pages_total = 262142 [DG] V: Innodb_buffer_pool_read_ahead_rnd = 0 [DG] V: Innodb_buffer_pool_read_ahead = 63 [DG] V: Innodb_buffer_pool_read_ahead_evicted = 0 [DG] V: Innodb_buffer_pool_read_requests = 5056064 [DG] V: Innodb_buffer_pool_reads = 691 [DG] V: Innodb_buffer_pool_wait_free = 0 [DG] V: Innodb_buffer_pool_write_requests = 1529304 [DG] V: Innodb_data_fsyncs = 1957 [DG] V: Innodb_data_pending_fsyncs = 0 [DG] V: Innodb_data_pending_reads = 0 [DG] V: Innodb_data_pending_writes = 0 [DG] V: Innodb_data_read = 12472320 [DG] V: Innodb_data_reads = 798 [DG] V: Innodb_data_writes = 15012 [DG] V: Innodb_data_written = 345663488 [DG] V: Innodb_dblwr_pages_written = 8597 [DG] V: Innodb_dblwr_writes = 483 [DG] V: Innodb_have_atomic_builtins = ON [DG] V: Innodb_log_waits = 0 [DG] V: Innodb_log_write_requests = 120220 [DG] V: Innodb_log_writes = 4774 [DG] V: Innodb_os_log_fsyncs = 549 [DG] V: Innodb_os_log_pending_fsyncs = 0 [DG] V: Innodb_os_log_pending_writes = 0 [DG] V: Innodb_os_log_written = 63872512 [DG] V: Innodb_page_size = 16384 [DG] V: Innodb_pages_created = 390 [DG] V: Innodb_pages_read = 755 [DG] V: Innodb_pages_written = 8597 [DG] V: Innodb_row_lock_current_waits = 0 [DG] V: Innodb_row_lock_time = 0 [DG] V: Innodb_row_lock_time_avg = 0 [DG] V: Innodb_row_lock_time_max = 0 [DG] V: Innodb_row_lock_waits = 0 [DG] V: Innodb_rows_deleted = 396 [DG] V: Innodb_rows_inserted = 410 [DG] V: Innodb_rows_read = 5709880 [DG] V: Innodb_rows_updated = 737086 [DG] V: Innodb_num_open_files = 34 [DG] V: Innodb_truncated_status_writes = 0 [DG] V: Innodb_available_undo_logs = 128 [DG] V: Key_blocks_not_flushed = 0 [DG] V: Key_blocks_unused = 1671 [DG] V: Key_blocks_used = 3 [DG] V: Key_read_requests = 6 [DG] V: Key_reads = 3 [DG] V: Key_write_requests = 0 [DG] V: Key_writes = 0 [DG] V: Last_query_cost = 0.000000 [DG] V: Last_query_partial_plans = 0 [DG] V: Max_used_connections = 7 [DG] V: Not_flushed_delayed_rows = 0 [DG] V: Open_files = 18 [DG] V: Open_streams = 0 [DG] V: Open_table_definitions = 96 [DG] V: Open_tables = 91 [DG] V: Opened_files = 164 [DG] V: Opened_table_definitions = 0 [DG] V: Opened_tables = 0 [DG] V: Performance_schema_accounts_lost = 0 [DG] V: Performance_schema_cond_classes_lost = 0 [DG] V: Performance_schema_cond_instances_lost = 0 [DG] V: Performance_schema_digest_lost = 0 [DG] V: Performance_schema_file_classes_lost = 0 [DG] V: Performance_schema_file_handles_lost = 0 [DG] V: Performance_schema_file_instances_lost = 0 [DG] V: Performance_schema_hosts_lost = 0 [DG] V: Performance_schema_locker_lost = 0 [DG] V: Performance_schema_mutex_classes_lost = 0 [DG] V: Performance_schema_mutex_instances_lost = 0 [DG] V: Performance_schema_rwlock_classes_lost = 0 [DG] V: Performance_schema_rwlock_instances_lost = 0 [DG] V: Performance_schema_session_connect_attrs_lost = 0 [DG] V: Performance_schema_socket_classes_lost = 0 [DG] V: Performance_schema_socket_instances_lost = 0 [DG] V: Performance_schema_stage_classes_lost = 0 [DG] V: Performance_schema_statement_classes_lost = 0 [DG] V: Performance_schema_table_handles_lost = 0 [DG] V: Performance_schema_table_instances_lost = 0 [DG] V: Performance_schema_thread_classes_lost = 0 [DG] V: Performance_schema_thread_instances_lost = 0 [DG] V: Performance_schema_users_lost = 0 [DG] V: Prepared_stmt_count = 0 [DG] V: Qcache_free_blocks = 0 [DG] V: Qcache_free_memory = 0 [DG] V: Qcache_hits = 0 [DG] V: Qcache_inserts = 0 [DG] V: Qcache_lowmem_prunes = 0 [DG] V: Qcache_not_cached = 0 [DG] V: Qcache_queries_in_cache = 0 [DG] V: Qcache_total_blocks = 0 [DG] V: Queries = 64297 [DG] V: Questions = 2 [DG] V: Select_full_join = 0 [DG] V: Select_full_range_join = 0 [DG] V: Select_range = 0 [DG] V: Select_range_check = 0 [DG] V: Select_scan = 0 [DG] V: Slave_heartbeat_period = 0.000 [DG] V: Slave_last_heartbeat = [DG] V: Slave_open_temp_tables = 0 [DG] V: Slave_received_heartbeats = 0 [DG] V: Slave_retried_transactions = 0 [DG] V: Slave_running = OFF [DG] V: Slow_launch_threads = 0 [DG] V: Slow_queries = 0 [DG] V: Sort_merge_passes = 0 [DG] V: Sort_range = 0 [DG] V: Sort_rows = 0 [DG] V: Sort_scan = 0 [DG] V: Ssl_accept_renegotiates = 0 [DG] V: Ssl_accepts = 0 [DG] V: Ssl_callback_cache_hits = 0 [DG] V: Ssl_cipher = [DG] V: Ssl_cipher_list = [DG] V: Ssl_client_connects = 0 [DG] V: Ssl_connect_renegotiates = 0 [DG] V: Ssl_ctx_verify_depth = 0 [DG] V: Ssl_ctx_verify_mode = 0 [DG] V: Ssl_default_timeout = 0 [DG] V: Ssl_finished_accepts = 0 [DG] V: Ssl_finished_connects = 0 [DG] V: Ssl_server_not_after = [DG] V: Ssl_server_not_before = [DG] V: Ssl_session_cache_hits = 0 [DG] V: Ssl_session_cache_misses = 0 [DG] V: Ssl_session_cache_mode = NONE [DG] V: Ssl_session_cache_overflows = 0 [DG] V: Ssl_session_cache_size = 0 [DG] V: Ssl_session_cache_timeouts = 0 [DG] V: Ssl_sessions_reused = 0 [DG] V: Ssl_used_session_cache_entries = 0 [DG] V: Ssl_verify_depth = 0 [DG] V: Ssl_verify_mode = 0 [DG] V: Ssl_version = [DG] V: Table_locks_immediate = 38238 [DG] V: Table_locks_waited = 0 [DG] V: Table_open_cache_hits = 0 [DG] V: Table_open_cache_misses = 0 [DG] V: Table_open_cache_overflows = 0 [DG] V: Tc_log_max_pages_used = 0 [DG] V: Tc_log_page_size = 0 [DG] V: Tc_log_page_waits = 0 [DG] V: Threads_cached = 0 [DG] V: Threads_connected = 7 [DG] V: Threads_created = 7 [DG] V: Threads_running = 2 [DG] V: Uptime = 3116 [DG] V: Uptime_since_flush_status = 3116 [DG] V: validate_password_dictionary_file_last_parsed = 2017-02-13 21:55:53 [DG] V: validate_password_dictionary_file_words_count = 0 [DG] V: Aborted_clients = 9 [DG] V: Aborted_connects = 1 [DG] V: Binlog_cache_disk_use = 0 [DG] V: Binlog_cache_use = 4624 [DG] V: Binlog_stmt_cache_disk_use = 0 [DG] V: Binlog_stmt_cache_use = 0 [DG] V: Bytes_received = 5962513 [DG] V: Bytes_sent = 25224680 [DG] V: Com_admin_commands = 29134 [DG] V: Com_assign_to_keycache = 0 [DG] V: Com_alter_db = 0 [DG] V: Com_alter_db_upgrade = 0 [DG] V: Com_alter_event = 0 [DG] V: Com_alter_function = 0 [DG] V: Com_alter_procedure = 0 [DG] V: Com_alter_server = 0 [DG] V: Com_alter_table = 0 [DG] V: Com_alter_tablespace = 0 [DG] V: Com_alter_user = 0 [DG] V: Com_analyze = 0 [DG] V: Com_begin = 22 [DG] V: Com_binlog = 0 [DG] V: Com_call_procedure = 0 [DG] V: Com_change_db = 0 [DG] V: Com_change_master = 0 [DG] V: Com_check = 0 [DG] V: Com_checksum = 0 [DG] V: Com_commit = 51 [DG] V: Com_create_db = 0 [DG] V: Com_create_event = 0 [DG] V: Com_create_function = 0 [DG] V: Com_create_index = 0 [DG] V: Com_create_procedure = 0 [DG] V: Com_create_server = 0 [DG] V: Com_create_table = 0 [DG] V: Com_create_trigger = 0 [DG] V: Com_create_udf = 0 [DG] V: Com_create_user = 0 [DG] V: Com_create_view = 0 [DG] V: Com_dealloc_sql = 0 [DG] V: Com_delete = 684 [DG] V: Com_delete_multi = 108 [DG] V: Com_do = 0 [DG] V: Com_drop_db = 0 [DG] V: Com_drop_event = 0 [DG] V: Com_drop_function = 0 [DG] V: Com_drop_index = 0 [DG] V: Com_drop_procedure = 0 [DG] V: Com_drop_server = 0 [DG] V: Com_drop_table = 0 [DG] V: Com_drop_trigger = 0 [DG] V: Com_drop_user = 0 [DG] V: Com_drop_view = 0 [DG] V: Com_empty_query = 0 [DG] V: Com_execute_sql = 0 [DG] V: Com_flush = 0 [DG] V: Com_get_diagnostics = 0 [DG] V: Com_grant = 0 [DG] V: Com_ha_close = 0 [DG] V: Com_ha_open = 0 [DG] V: Com_ha_read = 0 [DG] V: Com_help = 0 [DG] V: Com_insert = 410 [DG] V: Com_insert_select = 0 [DG] V: Com_install_plugin = 0 [DG] V: Com_kill = 0 [DG] V: Com_load = 0 [DG] V: Com_lock_tables = 0 [DG] V: Com_optimize = 0 [DG] V: Com_preload_keys = 0 [DG] V: Com_prepare_sql = 0 [DG] V: Com_purge = 0 [DG] V: Com_purge_before_date = 0 [DG] V: Com_release_savepoint = 0 [DG] V: Com_rename_table = 0 [DG] V: Com_rename_user = 0 [DG] V: Com_repair = 0 [DG] V: Com_replace = 0 [DG] V: Com_replace_select = 0 [DG] V: Com_reset = 0 [DG] V: Com_resignal = 0 [DG] V: Com_revoke = 0 [DG] V: Com_revoke_all = 0 [DG] V: Com_rollback = 0 [DG] V: Com_rollback_to_savepoint = 0 [DG] V: Com_savepoint = 0 [DG] V: Com_select = 29391 [DG] V: Com_set_option = 31 [DG] V: Com_signal = 0 [DG] V: Com_show_binlog_events = 0 [DG] V: Com_show_binlogs = 0 [DG] V: Com_show_charsets = 0 [DG] V: Com_show

jmrenouard commented 6 years ago

Hi @jppo

I can't reproduce this issue !

Can you tell me if we can close it ?

Ideas is that this issue can be reopened at every moment.

Thanks for your feedback.

jppo commented 6 years ago

Hello,

Yes you can close that issue ... if I can close your issu concerning OSSEC-GUI ?

That was a joke, there is no issue more.

Regards

JP Pozzi

De: "Yvan GODARD" notifications@github.com À: "major" MySQLTuner-perl@noreply.github.com Cc: "jp pozzi" jp.pozzi@izzop.net, "Mention" mention@noreply.github.com Envoyé: Mardi 25 Septembre 2018 17:15:07 Objet: Re: [major/MySQLTuner-perl] Memory used > 100% ? (#260)

Hi [ https://github.com/jppo | @jppo ]

I can't reproduce this issue !

Can you tell me if we can close it ?

Ideas is that this issue can be reopened at every moment.

Thanks for your feedback.

— You are receiving this because you were mentioned. Reply to this email directly, [ https://github.com/major/MySQLTuner-perl/issues/260#issuecomment-424382872 | view it on GitHub ] , or [ https://github.com/notifications/unsubscribe-auth/AGT0qwEeYLf-qjgxhNe2qGbFAjeGKwlVks5uekh7gaJpZM4KdofW | mute the thread ] .

jmrenouard commented 6 years ago

Thanks @jppo