Здравствуйте, возникла проблема следующая, сайт стал внезапно падать в момент не пиковой, а иногда даже минимальной нагрузки.
Выяснили, что запросы к бд в один из моментов такой ситуации отображают такую вот картинку:
[CODE]| 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 |[/CODE]Доступное кол-во обработчиков 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, то открывается множество страниц на битрикс, где яндекс проиндексировал эту ошибку, видимо в момент когда она отображалась для пользователей, то есть предположительно нередкое явление.
Какие могут быть варианты?
Доп. данные настроек бд:[CODE]"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"
[/CODE]
Выяснили, что запросы к бд в один из моментов такой ситуации отображают такую вот картинку:
[CODE]| 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 |[/CODE]Доступное кол-во обработчиков 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, то открывается множество страниц на битрикс, где яндекс проиндексировал эту ошибку, видимо в момент когда она отображалась для пользователей, то есть предположительно нередкое явление.
Какие могут быть варианты?
Доп. данные настроек бд:[CODE]"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"
[/CODE]