Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.37
-
None
-
None
Description
Trying to optimize the following query
Explain select count(*) from EVENEMENT e INNER JOIN REPRESENTATION r ON r.evenement_id=e.id where r.fin_des_ventes > '2014-12-18 12:54:00' and e.is_en_vente=1 and r.etat='1';
|
Done an analyze table EVENEMENT
It was fast but processlist become crazy see attached log
We stayed like this for while because max_connection was reach and would not like to restart the server to soon.
I had this brian idea to exit the mysql client i was doing the analyze and all came back normal again.
table definition
REPRESENTATION | CREATE TABLE `REPRESENTATION` (
|
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
`SALLE_ID` int(10) unsigned NOT NULL DEFAULT '0',
|
`EVENEMENT_ID` int(10) unsigned NOT NULL DEFAULT '0',
|
`DEBUT` datetime DEFAULT NULL,
|
`NB_PLACES_TOTAL` int(10) unsigned DEFAULT NULL,
|
`NB_PLACES_VENDUES` int(10) unsigned DEFAULT '0',
|
`NB_INVITATIONS` int(10) unsigned DEFAULT NULL,
|
`NB_PLACES_RESERVEES` mediumint(6) NOT NULL DEFAULT '0',
|
`DEBUT_DES_VENTES` datetime DEFAULT NULL,
|
`FIN_DES_VENTES` datetime DEFAULT NULL,
|
`PREMIERE_PARTIE` varchar(90) DEFAULT NULL,
|
`MESSAGE_ORGANISATEUR` varchar(500) DEFAULT NULL,
|
`FIN` datetime DEFAULT NULL,
|
`PLAN_SALLE_ID` int(10) unsigned DEFAULT '0',
|
`ETAT_VALIDATION` tinyint(2) unsigned DEFAULT NULL,
|
`DATE_VALIDATION` datetime DEFAULT NULL,
|
`IS_TARIFS_COMMUNS` tinyint(1) unsigned DEFAULT '0',
|
`IS_PLAN_SALLE_MULTIPLE` tinyint(1) DEFAULT '0',
|
`IS_BILLET_MONO_PLACE` tinyint(1) DEFAULT '0',
|
`NB_CODES_BARRES_PAR_BILLET` int(2) unsigned DEFAULT '1',
|
`IS_TELECHARGEABLE_MOBILE` tinyint(1) unsigned DEFAULT '1',
|
`LISTE_ID_COMPOSTAGE_MULTIPLE` text NOT NULL,
|
`SYBIEX_TYPE` enum('customer1','customer2','customer3','customer4','customer5','customer5','customer8','customer9','customer10','customer11','customer12','customer13','customer14','customer15') DEFAULT NULL,
|
`TYPE_CODE_BARRE` int(10) unsigned NOT NULL DEFAULT '1',
|
`TYPE_CHOIX_PLACE` int(2) unsigned NOT NULL DEFAULT '1',
|
`ABONNEMENT_ID` int(10) NOT NULL DEFAULT '0',
|
`IS_PRIORITE_ABONNEMENT` tinyint(1) unsigned DEFAULT NULL,
|
`HAS_SALE_PRIORITY` tinyint(3) unsigned DEFAULT '0',
|
`ETAT` tinyint(1) unsigned DEFAULT '2',
|
`ETAT_INFO` text,
|
`PLANNING_ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
|
`TYPE_REP` enum('classic','rType','comptage','hidden') NOT NULL DEFAULT 'classic',
|
`VENTE_PRIVEE_ID` int(10) unsigned NOT NULL DEFAULT '0',
|
`DATE_JOURNEE_TYPE_ID` int(11) NOT NULL DEFAULT '0',
|
`NB_PLACES_PAR_BILLET` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
`IS_FORTE_DEMANDE` tinyint(1) NOT NULL DEFAULT '0',
|
`VENTE_LIEE_ID` int(10) unsigned NOT NULL DEFAULT '0',
|
`LAST_UPDATE` datetime NOT NULL DEFAULT '2010-01-01 00:00:00',
|
`FA_JAUGE_ACHAT` int(10) unsigned NOT NULL DEFAULT '0',
|
`FA_JAUGE_ATTENTE` int(10) unsigned NOT NULL DEFAULT '0',
|
`FA_URL_REDIRECTION` varchar(1024) NOT NULL DEFAULT '',
|
`FA_BOUTON_REDIRECTION` varchar(255) NOT NULL DEFAULT '',
|
`FA_COMPLETE` tinyint(1) NOT NULL DEFAULT '0',
|
`PACK_ID` int(10) unsigned DEFAULT '0',
|
`UPDATED_AT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
PRIMARY KEY (`ID`),
|
KEY `REPRESENTATION_FKIndex1` (`EVENEMENT_ID`),
|
KEY `REPRESENTATION_FKIndex2` (`SALLE_ID`),
|
KEY `IDX_REPRESENTATION_DEBUT` (`DEBUT`),
|
KEY `REPRESENTATION_FK_ABONNEMENT` (`ABONNEMENT_ID`),
|
KEY `IDX_REPRESENTATION_FIN` (`FIN`),
|
KEY `IDX_REPRESENTATION_DEBUT_DES_VENTES` (`DEBUT_DES_VENTES`),
|
KEY `IDX_REPRESENTATION_FIN_DES_VENTES` (`FIN_DES_VENTES`),
|
KEY `IDX_TYPE_CODE_BARRE` (`TYPE_CODE_BARRE`),
|
KEY `FK_PLANNING` (`PLANNING_ID`),
|
KEY `IDX_DATE_JOURNEE_TYPE_ID` (`DATE_JOURNEE_TYPE_ID`),
|
KEY `IDX_HAS_SALE_PRIORITY` (`HAS_SALE_PRIORITY`)
|
) ENGINE=InnoDB AUTO_INCREMENT=2884853 DEFAULT CHARSET=latin1 |
|
Performance schema
select * from events_waits_summary_by_thread_by_event_name order by AVG_TIMER_WAIT desc limit 10000 ;
|
+-----------+-------------------------------------------------------------------+-------------+--------------------+-----------------+-----------------+-----------------+
|
| THREAD_ID | EVENT_NAME | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT |
|
+-----------+-------------------------------------------------------------------+-------------+--------------------+-----------------+-----------------+-----------------+
|
| 162449794 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 422326421818128 | 422326421818128 | 422326421818128 | 422326421818128 |
|
| 163027168 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 421978424345468 | 421978424345468 | 421978424345468 | 421978424345468 |
|
| 162878477 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 421954651269472 | 421954651269472 | 421954651269472 | 421954651269472 |
|
| 162908141 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 421873857425896 | 421873857425896 | 421873857425896 | 421873857425896 |
|
| 163111925 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 421698362604172 | 421698362604172 | 421698362604172 | 421698362604172 |
|
| 162929098 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 421221646065752 | 421221646065752 | 421221646065752 | 421221646065752 |
|
| 162945081 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 420938126288258 | 420938126288258 | 420938126288258 | 420938126288258 |
|
| 162946095 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 420686557693176 | 420686557693176 | 420686557693176 | 420686557693176 |
|
| 163021080 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 420336046797680 | 420336046797680 | 420336046797680 | 420336046797680 |
|
| 162900047 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 420094245240512 | 420094245240512 | 420094245240512 | 420094245240512 |
|
| 161956959 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 418391596786970 | 418391596786970 | 418391596786970 | 418391596786970 |
|
| 162068472 | wait/synch/cond/sql/MDL_context::COND_wait_status | 1 | 413333832352716 | 413333832352716 | 413333832352716 | 413333832352716 |
|
| 0 | wait/io/file/sql/misc | 2 | 1256835526526 | 9520504 | 628417763263 | 1256826006022 |
|
| 19 | wait/synch/cond/sql/COND_queue_state | 1 | 493685842500 | 493685842500 | 493685842500 | 493685842500 |
|
| 145505416 | wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond | 19879231 | 481709889855231528 | 9960278 | 24231817108 | 2060758240170 |
|
| 142592242 | wait/synch/cond/sql/MYSQL_BIN_LOG::update_cond | 23129420 | 533471747849999752 | 9662314 | 23064640092 | 2060708910828 |
|
| 145505416 | wait/synch/mutex/sql/MYS
|
 |
show variables
+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Variable_name | Value |
|
+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| aria_block_size | 8192 |
|
| aria_checkpoint_interval | 30 |
|
| aria_checkpoint_log_activity | 1048576 |
|
| 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 | 134217728 |
|
| 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 | 2 |
|
| auto_increment_offset | 1 |
|
| autocommit | ON |
|
| automatic_sp_privileges | ON |
|
| back_log | 1024 |
|
| basedir | /usr |
|
| big_tables | OFF |
|
| binlog_annotate_row_events | OFF |
|
| binlog_cache_size | 32768 |
|
| binlog_checksum | NONE |
|
| binlog_direct_non_transactional_updates | OFF |
|
| binlog_format | MIXED |
|
| binlog_optimize_thread_scheduling | ON |
|
| binlog_stmt_cache_size | 32768 |
|
| bulk_insert_buffer_size | 16777216 |
|
| character_set_client | latin1 |
|
| character_set_connection | latin1 |
|
| character_set_database | utf8 |
|
| character_set_filesystem | binary |
|
| character_set_results | latin1 |
|
| character_set_server | latin1 |
|
| character_set_system | utf8 |
|
| character_sets_dir | /usr/share/mysql/charsets/ |
|
| collation_connection | latin1_swedish_ci |
|
| collation_database | utf8_general_ci |
|
| collation_server | latin1_swedish_ci |
|
| completion_type | NO_CHAIN |
|
| concurrent_insert | ALWAYS |
|
| connect_timeout | 5 |
|
| datadir | /var/lib/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 |
|
| debug_no_thread_alarm | OFF |
|
| default_storage_engine | InnoDB |
|
| default_week_format | 0 |
|
| delay_key_write | ON |
|
| delayed_insert_limit | 100 |
|
| delayed_insert_timeout | 300 |
|
| delayed_queue_size | 1000 |
|
| div_precision_increment | 4 |
|
| engine_condition_pushdown | OFF |
|
| error_count | 0 |
|
| event_scheduler | ON |
|
| expensive_subquery_limit | 100 |
|
| expire_logs_days | 3 |
|
| external_user | |
|
| 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 | digbs-db04.log |
|
| group_concat_max_len | 1024 |
|
| have_compress | YES |
|
| have_crypt | YES |
|
| have_csv | YES |
|
| have_dynamic_loading | YES |
|
| have_geometry | YES |
|
| have_innodb | YES |
|
| have_ndbcluster | NO |
|
| have_openssl | DISABLED |
|
| have_partitioning | YES |
|
| have_profiling | YES |
|
| have_query_cache | YES |
|
| have_rtree_keys | YES |
|
| have_ssl | DISABLED |
|
| have_symlink | YES |
|
| hostname | digbs-db04 |
|
| identity | 0 |
|
| ignore_builtin_innodb | OFF |
|
| ignore_db_dirs | |
|
| in_transaction | 0 |
|
| 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 | 8 |
|
| innodb_buffer_pool_populate | OFF |
|
| innodb_buffer_pool_restore_at_startup | 900 |
|
| innodb_buffer_pool_shm_checksum | ON |
|
| innodb_buffer_pool_shm_key | 0 |
|
| innodb_buffer_pool_size | 85899345920 |
|
| innodb_change_buffering | all |
|
| 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 | Barracuda |
|
| innodb_file_format_check | ON |
|
| innodb_file_format_max | Antelope |
|
| innodb_file_per_table | ON |
|
| innodb_flush_log_at_trx_commit | 2 |
|
| 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 | 42949607424 |
|
| innodb_import_table_from_xtrabackup | 0 |
|
| innodb_io_capacity | 400 |
|
| 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 | 134217728 |
|
| innodb_log_file_size | 943718400 |
|
| innodb_log_files_in_group | 4 |
|
| innodb_log_group_home_dir | ./ |
|
| innodb_max_bitmap_file_size | 104857600 |
|
| innodb_max_changed_pages | 1000000 |
|
| innodb_max_dirty_pages_pct | 30 |
|
| 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 | 2048 |
|
| innodb_page_size | 16384 |
|
| innodb_print_all_deadlocks | OFF |
|
| 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 | OFF |
|
| innodb_stats_sample_pages | 32 |
|
| 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_atomic_writes | OFF |
|
| innodb_use_fallocate | OFF |
|
| innodb_use_global_flush_log_at_trx_commit | ON |
|
| innodb_use_native_aio | ON |
|
| innodb_use_stacktrace | OFF |
|
| innodb_use_sys_malloc | ON |
|
| innodb_use_sys_stats_table | OFF |
|
| innodb_version | 5.5.37-MariaDB-34.0 |
|
| innodb_write_io_threads | 4 |
|
| insert_id | 0 |
|
| interactive_timeout | 200 |
|
| join_buffer_size | 4194304 |
|
| join_buffer_space_limit | 2097152 |
|
| join_cache_level | 2 |
|
| keep_files_on_create | OFF |
|
| key_buffer_size | 33554432 |
|
| key_cache_age_threshold | 300 |
|
| key_cache_block_size | 1024 |
|
| key_cache_division_limit | 100 |
|
| key_cache_segments | 0 |
|
| large_files_support | ON |
|
| large_page_size | 0 |
|
| large_pages | OFF |
|
| last_insert_id | 0 |
|
| lc_messages | en_US |
|
| lc_messages_dir | /usr/share/mysql |
|
| lc_time_names | en_US |
|
| license | GPL |
|
| local_infile | ON |
|
| lock_wait_timeout | 31536000 |
|
| locked_in_memory | OFF |
|
| log | OFF |
|
| log_bin | ON |
|
| log_bin_trust_function_creators | OFF |
|
| log_error | /var/lib/mysql/digbs-db04.err |
|
| log_output | FILE |
|
| log_queries_not_using_indexes | OFF |
|
| log_slave_updates | ON |
|
| log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
|
| log_slow_queries | ON |
|
| log_slow_rate_limit | 1 |
|
| log_slow_verbosity | query_plan |
|
| log_warnings | 2 |
|
| long_query_time | 20.000000 |
|
| low_priority_updates | OFF |
|
| lower_case_file_system | OFF |
|
| lower_case_table_names | 0 |
|
| master_verify_checksum | OFF |
|
| max_allowed_packet | 16777216 |
|
| max_binlog_cache_size | 18446744073709547520 |
|
| max_binlog_size | 104857600 |
|
| max_binlog_stmt_cache_size | 18446744073709547520 |
|
| max_connect_errors | 100000 |
|
| max_connections | 500 |
|
| max_delayed_threads | 20 |
|
| max_error_count | 64 |
|
| max_heap_table_size | 67108864 |
|
| max_insert_delayed_threads | 20 |
|
| max_join_size | 18446744073709551615 |
|
| max_length_for_sort_data | 1024 |
|
| max_long_data_size | 16777216 |
|
| max_prepared_stmt_count | 16382 |
|
| max_relay_log_size | 0 |
|
| max_seeks_for_key | 4294967295 |
|
| max_sort_length | 1024 |
|
| max_sp_recursion_depth | 0 |
|
| max_tmp_tables | 32 |
|
| max_user_connections | 0 |
|
| max_write_lock_count | 4294967295 |
|
| metadata_locks_cache_size | 1024 |
|
| min_examined_row_limit | 0 |
|
| mrr_buffer_size | 262144 |
|
| 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 |
|
| old | OFF |
|
| old_alter_table | OFF |
|
| old_mode | |
|
| old_passwords | OFF |
|
| open_files_limit | 65535 |
|
| 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,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off |
|
| performance_schema | ON |
|
| performance_schema_events_waits_history_long_size | 10000 |
|
| performance_schema_events_waits_history_size | 10 |
|
| performance_schema_max_cond_classes | 80 |
|
| performance_schema_max_cond_instances | 1000 |
|
| performance_schema_max_file_classes | 50 |
|
| performance_schema_max_file_handles | 32768 |
|
| performance_schema_max_file_instances | 10000 |
|
| performance_schema_max_mutex_classes | 200 |
|
| performance_schema_max_mutex_instances | 1000000 |
|
| performance_schema_max_rwlock_classes | 30 |
|
| performance_schema_max_rwlock_instances | 1000000 |
|
| performance_schema_max_table_handles | 100000 |
|
| performance_schema_max_table_instances | 50000 |
|
| performance_schema_max_thread_classes | 50 |
|
| performance_schema_max_thread_instances | 1000 |
|
| pid_file | /var/run/mysqld/mysqld.pid |
|
| plugin_dir | /usr/lib/mysql/plugin/ |
|
| plugin_maturity | unknown |
|
| port | 3306 |
|
| preload_buffer_size | 32768 |
|
| profiling | OFF |
|
| profiling_history_size | 15 |
|
| progress_report_time | 5 |
|
| protocol_version | 10 |
|
| proxy_user | |
|
| pseudo_slave_mode | OFF |
|
| pseudo_thread_id | 163388033 |
|
| query_alloc_block_size | 8192 |
|
| query_cache_limit | 131072 |
|
| query_cache_min_res_unit | 4096 |
|
| query_cache_size | 0 |
|
| query_cache_strip_comments | OFF |
|
| query_cache_type | OFF |
|
| query_cache_wlock_invalidate | OFF |
|
| query_prealloc_size | 8192 |
|
| rand_seed1 | 0 |
|
| rand_seed2 | 0 |
|
| range_alloc_block_size | 4096 |
|
| read_buffer_size | 524288 |
|
| read_only | OFF |
|
| read_rnd_buffer_size | 1048576 |
|
| relay_log | /var/lib/mysql/relay-bin |
|
| relay_log_index | /var/lib/mysql/relay-bin.index |
|
| relay_log_info_file | /var/lib/mysql/relay-bin.info |
|
| relay_log_purge | ON |
|
| relay_log_recovery | OFF |
|
| relay_log_space_limit | 0 |
|
| replicate_annotate_row_events | OFF |
|
| replicate_do_db | |
|
| replicate_do_table | |
|
| replicate_events_marked_for_skip | replicate |
|
| replicate_ignore_db | |
|
| replicate_ignore_table | |
|
| replicate_wild_do_table | |
|
| replicate_wild_ignore_table | |
|
| report_host | |
|
| report_password | |
|
| report_port | 3306 |
|
| report_user | |
|
| rowid_merge_buff_size | 8388608 |
|
| rpl_recovery_rank | 0 |
|
| secure_auth | OFF |
|
| secure_file_priv | |
|
| server_id | 40 |
|
| skip_external_locking | ON |
|
| skip_name_resolve | ON |
|
| skip_networking | OFF |
|
| skip_replication | OFF |
|
| skip_show_database | OFF |
|
| slave_compressed_protocol | OFF |
|
| slave_exec_mode | STRICT |
|
| slave_load_tmpdir | /tmp-mysql |
|
| slave_max_allowed_packet | 1073741824 |
|
| slave_net_timeout | 3600 |
|
| slave_skip_errors | 1690 |
|
| slave_sql_verify_checksum | ON |
|
| slave_transaction_retries | 10 |
|
| slave_type_conversions | |
|
| slow_launch_time | 2 |
|
| slow_query_log | ON |
|
| slow_query_log_file | /var/log/mysql/mariadb-slow.log |
|
| socket | /var/run/mysqld/mysqld.sock |
|
| sort_buffer_size | 1048576 |
|
| sql_auto_is_null | OFF |
|
| sql_big_selects | ON |
|
| sql_big_tables | OFF |
|
| sql_buffer_result | OFF |
|
| sql_log_bin | ON |
|
| sql_log_off | OFF |
|
| sql_low_priority_updates | OFF |
|
| sql_max_join_size | 18446744073709551615 |
|
| sql_mode | NO_UNSIGNED_SUBTRACTION |
|
| sql_notes | ON |
|
| sql_quote_show_create | ON |
|
| sql_safe_updates | OFF |
|
| sql_select_limit | 18446744073709551615 |
|
| sql_slave_skip_counter | 0 |
|
| sql_warnings | OFF |
|
| ssl_ca | |
|
| ssl_capath | |
|
| ssl_cert | |
|
| ssl_cipher | |
|
| ssl_key | |
|
| storage_engine | InnoDB |
|
| stored_program_cache | 256 |
|
| sync_binlog | 0 |
|
| sync_frm | ON |
|
| sync_master_info | 0 |
|
| sync_relay_log | 0 |
|
| sync_relay_log_info | 0 |
|
| system_time_zone | CET |
|
| table_definition_cache | 400 |
|
| table_open_cache | 400 |
|
| thread_cache_size | 128 |
|
| thread_concurrency | 10 |
|
| thread_handling | one-thread-per-connection |
|
| thread_pool_idle_timeout | 60 |
|
| thread_pool_max_threads | 500 |
|
| thread_pool_oversubscribe | 3 |
|
| thread_pool_size | 24 |
|
| thread_pool_stall_limit | 500 |
|
| thread_stack | 294912 |
|
| time_format | %H:%i:%s |
|
| time_zone | SYSTEM |
|
| timed_mutexes | OFF |
|
| timestamp | 1418909086.009918 |
|
| tmp_table_size | 67108864 |
|
| tmpdir | /tmp-mysql |
|
| transaction_alloc_block_size | 8192 |
|
| transaction_prealloc_size | 4096 |
|
| tx_isolation | READ-COMMITTED |
|
| unique_checks | ON |
|
| updatable_views_with_limit | YES |
|
| userstat | OFF |
|
| version | 5.5.37-MariaDB-1~squeeze-log |
|
| version_comment | mariadb.org binary distribution |
|
| version_compile_machine | x86_64 |
|
| version_compile_os | debian-linux-gnu |
|
| wait_timeout | 200 |
|
| warning_count | 0
|
 |