Здравствуйте, возникла проблема следующая, сайт стал внезапно падать в момент не пиковой, а иногда даже минимальной нагрузки.
Выяснили, что запросы к бд в один из моментов такой ситуации отображают такую вот картинку:
Доступное кол-во обработчиков 3. Таблица b_iblock_Element INNODB
То есть судя по всему на ничем не выдающемся в плане вычислительной и структурной сложности запросе вида:
UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_START, now()), SHOW_COUNTER = ifnull(SHOW_COUNTER, 0) + 1 WH ERE ID=4254
все иногда рушится.
Кроме того интересный факт, если вбить часть этого запроса в Yandex UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, то открывается множество страниц на битрикс, где яндекс проиндексировал эту ошибку, видимо в момент когда она отображалась для пользователей, то есть предположительно нередкое явление.
Какие могут быть варианты?
Доп. данные настроек бд:
Выяснили, что запросы к бд в один из моментов такой ситуации отображают такую вот картинку:
| Код |
|---|
| 28658 | tech_onec | localhost | tech_onec | Sleep | 8 | | | 0 | 0 | 0 | | 30062 | tech_onec | localhost | tech_onec | Sleep | 4 | | | 0 | 0 | 0 | | 31365 | tech_shop | localhost | tech_shop | Query | 1609 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31367 | tech_shop | localhost | tech_shop | Query | 1608 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31373 | tech_shop | localhost | tech_shop | Query | 1607 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31374 | tech_shop | localhost | tech_shop | Query | 1607 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31375 | tech_shop | localhost | tech_shop | Query | 1606 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31379 | tech_shop | localhost | tech_shop | Query | 1606 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31404 | tech_shop | localhost | tech_shop | Query | 1600 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31450 | tech_shop | localhost | tech_shop | Query | 1596 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31467 | tech_onec | localhost | tech_onec | Sleep | 5 | | | 0 | 0 | 0 | | 31471 | tech_shop | localhost | tech_shop | Query | 1590 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 31478 | tech_shop | localhost | tech_shop | Query | 1586 | Waiting for table level lock | UPD ATE b_iblock_element SET TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32023 | tech_shop | localhost | tech_shop | Query | 570 | Waiting for table level lock | UPD ATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32024 | tech_shop | localhost | tech_shop | Query | 570 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32028 | tech_shop | localhost | tech_shop | Query | 564 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32034 | tech_shop | localhost | tech_shop | Query | 559 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32039 | tech_shop | localhost | tech_shop | Query | 554 | Waiting for table level lock | UPDATE b_sale_fuser SE T DATE_UPDATE=now() WHERE ID = 4621775 | 0 | 0 | 0 | | 32042 | tech_shop | localhost | tech_shop | Query | 550 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32046 | tech_shop | localhost | tech_shop | Query | 546 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32053 | tech_shop | localhost | tech_shop | Query | 538 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32071 | tech_shop | localhost | tech_shop | Query | 525 | Waiting for table level lock | UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_ST | 0 | 0 | 0 | | 32076 | tech_shop | localhost | tech_shop | Query | 520 | Waiting for table level lock | INS ERT INTO b_captcha (`DATE_CREATE`, `IP`, `CODE`, `ID`) VALUES (now(), '194.67.27.166', 'ZGLKN', ' | 0 | 0 | 0 | | 32328 | tech_shop | localhost | tech_shop | Query | 0 | Writing to net | SEL ECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FR OM `b_search_phrase` | 13522 | 0 | 0 | | 32329 | tech_shop | localhost | tech_shop | Query | 1 | Sending data | SEL ECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FR OM `b_sale_fuser` | 1022020 | 0 | 0 | | 32330 | tech_shop | localhost | tech_shop | Query | 0 | Sending data | SELECT /*!40001 SQL_NO_CACHE */ /*!50084 SQL_NO_FCACHE */ * FR OM `b_sale_fuser` | 139780 | 0 | 0 | |
То есть судя по всему на ничем не выдающемся в плане вычислительной и структурной сложности запросе вида:
UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, SHOW_COUNTER_START = ifnull(SHOW_COUNTER_START, now()), SHOW_COUNTER = ifnull(SHOW_COUNTER, 0) + 1 WH ERE ID=4254
все иногда рушится.
Кроме того интересный факт, если вбить часть этого запроса в Yandex UPDATE b_iblock_element SE T TIMESTAMP_X = TIMESTAMP_X, то открывается множество страниц на битрикс, где яндекс проиндексировал эту ошибку, видимо в момент когда она отображалась для пользователей, то есть предположительно нередкое явление.
Какие могут быть варианты?
Доп. данные настроек бд:
| Код |
|---|
"AUTOCOMMIT","ON" "AUTOMATIC_SP_PRIVILEGES","ON" "AUTO_INCREMENT_INCREMENT","1" "AUTO_INCREMENT_OFFSET","1" "BACK_LOG","50" "BASEDIR","/usr" "BIG_TABLES","OFF" "BINLOG_CACHE_SIZE","32768" "BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES","OFF" "BINLOG_FORMAT","STATEMENT" "BINLOG_STMT_CACHE_SIZE","32768" "BULK_INSERT_BUFFER_SIZE","8388608" "CHARACTER_SETS_DIR","/usr/share/mysql/charsets/" "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" "COLLATION_CONNECTION","utf8_general_ci" "COLLATION_DATABASE","utf8_general_ci" "COLLATION_SERVER","utf8_general_ci" "COMPLETION_TYPE","NO_CHAIN" "CONCURRENT_INSERT","AUTO" "CONNECT_TIMEOUT","30" "DATADIR","/var/lib/mysql/" "DATETIME_FORMAT","%Y-%m-%d %H:%i:%s" "DATE_FORMAT","%Y-%m-%d" "DEFAULT_STORAGE_ENGINE","MyISAM" "DEFAULT_WEEK_FORMAT","0" "DELAYED_INSERT_LIMIT","100" "DELAYED_INSERT_TIMEOUT","300" "DELAYED_QUEUE_SIZE","1000" "DELAY_KEY_WRITE","ON" "DIV_PRECISION_INCREMENT","4" "ENFORCE_STORAGE_ENGINE", "ENGINE_CONDITION_PUSHDOWN","ON" "EVENT_SCHEDULER","OFF" "EXPAND_FAST_INDEX_CREATION","OFF" "EXPIRE_LOGS_DAYS","0" "EXTRA_MAX_CONNECTIONS","1" "EXTRA_PORT","0" "FAST_INDEX_CREATION","ON" "FLUSH","OFF" "FLUSH_TIME","0" "FOREIGN_KEY_CHECKS","ON" "FT_BOOLEAN_SYNTAX","+ -><()~*:""""&|" "FT_MAX_WORD_LEN","84" "FT_MIN_WORD_LEN","4" "FT_QUERY_EXPANSION_LIMIT","20" "FT_STOPWORD_FILE","(built-in)" "GENERAL_LOG","OFF" "GENERAL_LOG_FILE","/var/lib/mysql/saa08.log" "GROUP_CONCAT_MAX_LEN","1024" "HAVE_COMPRESS","YES" "HAVE_CRYPT","YES" "HAVE_CSV","YES" "HAVE_DYNAMIC_LOADING","YES" "HAVE_FLASHCACHE","YES" "HAVE_GEOMETRY","YES" "HAVE_INNODB","YES" "HAVE_NDBCLUSTER","NO" "HAVE_OPENSSL","DISABLED" "HAVE_PARTITIONING","YES" "HAVE_PROFILING","YES" "HAVE_QUERY_CACHE","YES" "HAVE_RESPONSE_TIME_DISTRIBUTION","YES" "HAVE_RTREE_KEYS","YES" "HAVE_SSL","DISABLED" "HAVE_SYMLINK","YES" "HOSTNAME","saa08.timeweb.ru" "IGNORE_BUILTIN_INNODB","OFF" "INIT_CONNECT","SE T NAMES utf8" "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","2097152" "INNODB_AUTOEXTEND_INCREMENT","8" "INNODB_AUTOINC_LOCK_MODE","1" "INNODB_BLOCKING_BUFFER_POOL_RESTORE","OFF" "INNODB_BUFFER_POOL_INSTANCES","1" "INNODB_BUFFER_POOL_POPULATE","OFF" "INNODB_BUFFER_POOL_RESTORE_AT_STARTUP","0" "INNODB_BUFFER_POOL_SHM_CHECKSUM","ON" "INNODB_BUFFER_POOL_SHM_KEY","0" "INNODB_BUFFER_POOL_SIZE","2505048064" "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:max:12800M" "INNODB_DATA_HOME_DIR", "INNODB_DICT_SIZE_LIMIT","0" "INNODB_DOUBLEWRITE","ON" "INNODB_DOUBLEWRITE_FILE", "INNODB_FAKE_CHANGES","OFF" "INNODB_FAST_CHECKSUM","OFF" "INNODB_FAST_SHUTDOWN","1" "INNODB_FILE_FORMAT","Antelope" "INNODB_FILE_FORMAT_CHECK","ON" "INNODB_FILE_FORMAT_MAX","Antelope" "INNODB_FILE_PER_TABLE","ON" "INNODB_FLUSH_LOG_AT_TRX_COMMIT","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","1252507648" "INNODB_IMPORT_TABLE_FROM_XTRABACKUP","0" "INNODB_IO_CAPACITY","200" "INNODB_KILL_IDLE_TRANSACTION","0" "INNODB_LARGE_PREFIX","OFF" "INNODB_LAZY_DROP_TABLE","0" "INNODB_LOCKING_FAKE_CHANGES","ON" "INNODB_LOCKS_UNSAFE_FOR_BINLOG","OFF" "INNODB_LOCK_WAIT_TIMEOUT","100" "INNODB_LOG_BLOCK_SIZE","512" "INNODB_LOG_BUFFER_SIZE","8388608" "INNODB_LOG_FILES_IN_GROUP","2" "INNODB_LOG_FILE_SIZE","5242880" "INNODB_LOG_GROUP_HOME_DIR","./" "INNODB_MAX_BITMAP_FILE_SIZE","104857600" "INNODB_MAX_CHANGED_PAGES","1000000" "INNODB_MAX_DIRTY_PAGES_PCT","75" "INNODB_MAX_PURGE_LAG","0" "INNODB_MERGE_SORT_BLOCK_SIZE","1048576" "INNODB_MIRRORED_LOG_GROUPS","1" "INNODB_OLD_BLOCKS_PCT","37" "INNODB_OLD_BLOCKS_TIME","0" "INNODB_OPEN_FILES","300" "INNODB_PAGE_SIZE","16384" "INNODB_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","ON" "INNODB_STATS_SAMPLE_PAGES","8" "INNODB_STATS_UPDATE_NEED_LOCK","1" "INNODB_STRICT_MODE","OFF" "INNODB_SUPPORT_XA","ON" "INNODB_SYNC_SPIN_LOOPS","30" "INNODB_TABLE_LOCKS","ON" "INNODB_THREAD_CONCURRENCY","0" "INNODB_THREAD_CONCURRENCY_TIMER_BASED","OFF" "INNODB_THREAD_SLEEP_DELAY","10000" "INNODB_TRACK_CHANGED_PAGES","OFF" "INNODB_USE_ATOMIC_WRITES","OFF" "INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT","ON" "INNODB_USE_NATIVE_AIO","ON" "INNODB_USE_SYS_MALLOC","ON" "INNODB_USE_SYS_STATS_TABLE","OFF" "INNODB_VERSION","5.5.36-34.0-34.0" "INNODB_WRITE_IO_THREADS","4" "INTERACTIVE_TIMEOUT","60" "JOIN_BUFFER_SIZE","33554432" "KEEP_FILES_ON_CREATE","OFF" "KEY_BUFFER_SIZE","67108864" "KEY_CACHE_AGE_THRESHOLD","300" "KEY_CACHE_BLOCK_SIZE","1024" "KEY_CACHE_DIVISION_LIMIT","100" "LARGE_FILES_SUPPORT","ON" "LARGE_PAGES","OFF" "LARGE_PAGE_SIZE","0" "LC_MESSAGES","en_US" "LC_MESSAGES_DIR","/usr/share/mysql/" "LC_TIME_NAMES","en_US" "LICENSE","GPL" "LOCAL_INFILE","ON" "LOCKED_IN_MEMORY","OFF" "LOCK_WAIT_TIMEOUT","31536000" "LOG","OFF" "LOG_BIN","OFF" "LOG_BIN_TRUST_FUNCTION_CREATORS","OFF" "LOG_ERROR","/var/lib/mysql/mysqld.err" "LOG_OUTPUT","FILE" "LOG_QUERIES_NOT_USING_INDEXES","OFF" "LOG_SLAVE_UPDATES","OFF" "LOG_SLOW_ADMIN_STATEMENTS","OFF" "LOG_SLOW_FILTER", "LOG_SLOW_QUERIES","OFF" "LOG_SLOW_RATE_LIMIT","1" "LOG_SLOW_RATE_TYPE","session" "LOG_SLOW_SLAVE_STATEMENTS","OFF" "LOG_SLOW_SP_STATEMENTS","ON" "LOG_SLOW_VERBOSITY", "LOG_WARNINGS","1" "LOG_WARNINGS_SUPPRESS", "LONG_QUERY_TIME","10.000000" "LOWER_CASE_FILE_SYSTEM","OFF" "LOWER_CASE_TABLE_NAMES","0" "LOW_PRIORITY_UPDATES","OFF" "MAX_ALLOWED_PACKET","20971520" "MAX_BINLOG_CACHE_SIZE","18446744073709547520" "MAX_BINLOG_FILES","0" "MAX_BINLOG_SIZE","1073741824" "MAX_BINLOG_STMT_CACHE_SIZE","18446744073709547520" "MAX_CONNECTIONS","200" "MAX_CONNECT_ERRORS","10" "MAX_DELAYED_THREADS","20" "MAX_ERROR_COUNT","64" "MAX_HEAP_TABLE_SIZE","117440512" "MAX_INSERT_DELAYED_THREADS","20" "MAX_JOIN_SIZE","18446744073709551615" "MAX_LENGTH_FOR_SORT_DATA","1024" "MAX_LONG_DATA_SIZE","20971520" "MAX_PREPARED_STMT_COUNT","16382" "MAX_RELAY_LOG_SIZE","0" "MAX_SEEKS_FOR_KEY","18446744073709551615" "MAX_SLOWLOG_FILES","0" "MAX_SLOWLOG_SIZE","0" "MAX_SORT_LENGTH","1024" "MAX_SP_RECURSION_DEPTH","0" "MAX_TMP_TABLES","32" "MAX_USER_CONNECTIONS","60" "MAX_WRITE_LOCK_COUNT","18446744073709551615" "METADATA_LOCKS_CACHE_SIZE","1024" "MIN_EXAMINED_ROW_LIMIT","0" "MULTI_RANGE_COUNT","256" "MYISAM_DATA_POINTER_SIZE","6" "MYISAM_MAX_SORT_FILE_SIZE","9223372036853727232" "MYISAM_MMAP_SIZE","18446744073709551615" "MYISAM_RECOVER_OPTIONS","OFF" "MYISAM_REPAIR_THREADS","1" "MYISAM_SORT_BUFFER_SIZE","8388608" "MYISAM_STATS_METHOD","nulls_unequal" "MYISAM_USE_MMAP","OFF" "NET_BUFFER_LENGTH","8192" "NET_READ_TIMEOUT","200" "NET_RETRY_COUNT","10" "NET_WRITE_TIMEOUT","60" "NEW","OFF" "OLD","OFF" "OLD_ALTER_TABLE","OFF" "OLD_PASSWORDS","OFF" "OPEN_FILES_LIMIT","32979" "OPTIMIZER_FIX","ON" "OPTIMIZER_PRUNE_LEVEL","1" "OPTIMIZER_SEARCH_DEPTH","0" "OPTIMIZER_SWITCH","index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on" "PERFORMANCE_SCHEMA","OFF" "PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE","10000" "PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE","10" "PERFORMANCE_SCHEMA_MAX_COND_CLASSES","80" "PERFORMANCE_SCHEMA_MAX_COND_INSTANCES","1000" "PERFORMANCE_SCHEMA_MAX_FILE_CLASSES","50" "PERFORMANCE_SCHEMA_MAX_FILE_HANDLES","32768" "PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES","10000" "PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES","200" "PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES","1000000" "PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES","30" "PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES","1000000" "PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES","100000" "PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES","50000" "PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES","50" "PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES","1000" "PID_FILE","/var/run/mysqld/mysqld.pid" "PLUGIN_DIR","/usr/lib/mysql/plugin/" "PORT","3306" "PRELOAD_BUFFER_SIZE","32768" "PROFILING","OFF" "PROFILING_HISTORY_SIZE","15" "PROTOCOL_VERSION","10" "QUERY_ALLOC_BLOCK_SIZE","8192" "QUERY_CACHE_LIMIT","1048576" "QUERY_CACHE_MIN_RES_UNIT","4096" "QUERY_CACHE_SIZE","536870912" "QUERY_CACHE_STRIP_COMMENTS","OFF" "QUERY_CACHE_TYPE","ON" "QUERY_CACHE_WLOCK_INVALIDATE","OFF" "QUERY_PREALLOC_SIZE","8192" "QUERY_RESPONSE_TIME_RANGE_BASE","10" "QUERY_RESPONSE_TIME_STATS","OFF" "RANGE_ALLOC_BLOCK_SIZE","4096" "READ_BUFFER_SIZE","16777216" "READ_ONLY","OFF" "READ_RND_BUFFER_SIZE","524288" "RELAY_LOG", "RELAY_LOG_INDEX", "RELAY_LOG_INFO_FILE","relay-log.info" "RELAY_LOG_PURGE","ON" "RELAY_LOG_RECOVERY","OFF" "RELAY_LOG_SPACE_LIMIT","0" "REPORT_HOST", "REPORT_PASSWORD", "REPORT_PORT","3306" "REPORT_USER", "RPL_RECOVERY_RANK","0" "SECURE_AUTH","OFF" "SECURE_FILE_PRIV", "SERVER_ID","0" "SKIP_EXTERNAL_LOCKING","ON" "SKIP_NAME_RESOLVE","OFF" "SKIP_NETWORKING","OFF" "SKIP_SHOW_DATABASE","OFF" "SLAVE_COMPRESSED_PROTOCOL","OFF" "SLAVE_EXEC_MODE","STRICT" "SLAVE_LOAD_TMPDIR","/tmp/" "SLAVE_MAX_ALLOWED_PACKET","1073741824" "SLAVE_NET_TIMEOUT","3600" "SLAVE_SKIP_ERRORS","OFF" "SLAVE_TRANSACTION_RETRIES","10" "SLAVE_TYPE_CONVERSIONS", "SLOW_LAUNCH_TIME","2" "SLOW_QUERY_LOG","OFF" "SLOW_QUERY_LOG_ALWAYS_WRITE_TIME","10.000000" "SLOW_QUERY_LOG_FILE","/var/log/mysql/mysql-slow.log" "SLOW_QUERY_LOG_TIMESTAMP_ALWAYS","OFF" "SLOW_QUERY_LOG_TIMESTAMP_PRECISION","second" "SLOW_QUERY_LOG_USE_GLOBAL_CONTROL", "SOCKET","/var/run/mysqld/mysqld.sock" "SORT_BUFFER_SIZE","8388608" "SQL_AUTO_IS_NULL","OFF" "SQL_BIG_SELECTS","ON" "SQL_BIG_TABLES","OFF" "SQL_BUFFER_RESULT","OFF" "SQL_LOG_BIN","ON" "SQL_LOG_OFF","OFF" "SQL_LOW_PRIORITY_UPDATES","OFF" "SQL_MAX_JOIN_SIZE","18446744073709551615" "SQL_MODE", "SQL_NOTES","ON" "SQL_QUOTE_SHOW_CREATE","ON" "SQL_SAFE_UPDATES","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","MyISAM" "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","MSK" "TABLE_DEFINITION_CACHE","400" "TABLE_OPEN_CACHE","16384" "THREAD_CACHE_SIZE","4" "THREAD_CONCURRENCY","10" "THREAD_HANDLING","one-thread-per-connection" "THREAD_POOL_HIGH_PRIO_MODE","transactions" "THREAD_POOL_HIGH_PRIO_TICKETS","4294967295" "THREAD_POOL_IDLE_TIMEOUT","60" "THREAD_POOL_MAX_THREADS","100000" "THREAD_POOL_OVERSUBSCRIBE","3" "THREAD_POOL_SIZE","8" "THREAD_POOL_STALL_LIMIT","500" "THREAD_STACK","262144" "THREAD_STATISTICS","OFF" "TIMED_MUTEXES","OFF" "TIME_FORMAT","%H:%i:%s" "TIME_ZONE","SYSTEM" "TMPDIR","/tmp/" "TMP_TABLE_SIZE","117440512" "TRANSACTION_ALLOC_BLOCK_SIZE","8192" "TRANSACTION_PREALLOC_SIZE","4096" "TX_ISOLATION","READ-COMMITTED" "UNIQUE_CHECKS","ON" "UPDATABLE_VIEWS_WITH_LIMIT","YES" "USERSTAT","ON" "VERSION","5.5.36-34.0-632.precise" "VERSION_COMMENT","(Ubuntu)" "VERSION_COMPILE_MACHINE","x86_64" "VERSION_COMPILE_OS","debian-linux-gnu" "WAIT_TIMEOUT","60" |
