-
-
Save zumoshi/db5fa871987ac5223df6a2114dc3c73a to your computer and use it in GitHub Desktop.
06/17 crashlog
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2019-06-17T14:01:08.350726Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). | |
2019-06-17T14:01:08.353442Z 0 [Note] mysqld (mysqld 5.7.25) starting as process 1 ... | |
2019-06-17T14:01:08.359272Z 0 [Note] InnoDB: PUNCH HOLE support available | |
2019-06-17T14:01:08.359373Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
2019-06-17T14:01:08.359446Z 0 [Note] InnoDB: Uses event mutexes | |
2019-06-17T14:01:08.359499Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
2019-06-17T14:01:08.359586Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 | |
2019-06-17T14:01:08.359610Z 0 [Note] InnoDB: Using Linux native AIO | |
2019-06-17T14:01:08.360250Z 0 [Note] InnoDB: Number of pools: 1 | |
2019-06-17T14:01:08.360599Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
2019-06-17T14:01:08.362946Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
2019-06-17T14:01:08.379746Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
2019-06-17T14:01:08.383209Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
2019-06-17T14:01:08.397002Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
2019-06-17T14:01:08.399207Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 46608144322 | |
2019-06-17T14:01:08.399359Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 46608144331 | |
2019-06-17T14:01:08.399426Z 0 [Note] InnoDB: Database was not shutdown normally! | |
2019-06-17T14:01:08.399487Z 0 [Note] InnoDB: Starting crash recovery. | |
2019-06-17T14:01:08.533006Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" | |
2019-06-17T14:01:08.533209Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
2019-06-17T14:01:08.533339Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
2019-06-17T14:01:08.580903Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
2019-06-17T14:01:08.584834Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
2019-06-17T14:01:08.585884Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
2019-06-17T14:01:08.586421Z 0 [Note] InnoDB: Waiting for purge to start | |
2019-06-17T14:01:08.637170Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 46608144331 | |
2019-06-17T14:01:08.638186Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
2019-06-17T14:01:08.638701Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
2019-06-17T14:01:08.647583Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. | |
2019-06-17T14:01:08.648091Z 0 [Warning] CA certificate ca.pem is self signed. | |
2019-06-17T14:01:08.664556Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
2019-06-17T14:01:08.665116Z 0 [Note] IPv6 is available. | |
2019-06-17T14:01:08.665309Z 0 [Note] - '::' resolves to '::'; | |
2019-06-17T14:01:08.665543Z 0 [Note] Server socket created on IP: '::'. | |
2019-06-17T14:01:08.667801Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. | |
2019-06-17T14:01:08.672174Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.672442Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.672598Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.672888Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.673056Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.673533Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.686208Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.686490Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T14:01:08.706129Z 0 [Note] Event Scheduler: Loaded 0 events | |
2019-06-17T14:01:08.706530Z 0 [Note] mysqld: ready for connections. | |
Version: '5.7.25' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) | |
2019-06-17T14:01:09.772202Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190617 14:01:09 | |
2019-06-17 14:01:52 0x7f11c01a5700 InnoDB: Assertion failure in thread 139714214123264 in file btr0pcur.cc line 452 | |
InnoDB: Failing assertion: page_is_comp(next_page) == page_is_comp(page) | |
InnoDB: We intentionally generate a memory trap. | |
InnoDB: Submit a detailed bug report to http://bugs.mysql.com. | |
InnoDB: If you get repeated assertion failures or crashes, even | |
InnoDB: immediately after the mysqld startup, there may be | |
InnoDB: corruption in the InnoDB tablespace. Please refer to | |
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html | |
InnoDB: about forcing recovery. | |
14:01:52 UTC - mysqld got signal 6 ; | |
This could be because you hit a bug. It is also possible that this binary | |
or one of the libraries it was linked against is corrupt, improperly built, | |
or misconfigured. This error can also be caused by malfunctioning hardware. | |
Attempting to collect some information that could help diagnose the problem. | |
As this is a crash and something is definitely wrong, the information | |
collection process might fail. | |
key_buffer_size=8388608 | |
read_buffer_size=131072 | |
max_used_connections=1 | |
max_threads=151 | |
thread_count=1 | |
connection_count=1 | |
It is possible that mysqld could use up to | |
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68196 K bytes of memory | |
Hope that's ok; if not, decrease some variables in the equation. | |
Thread pointer: 0x7f119c012360 | |
Attempting backtrace. You can use the following information to find out | |
where mysqld died. If you see no messages after this, something went | |
terribly wrong... | |
stack_bottom = 7f11c01a4e80 thread_stack 0x40000 | |
mysqld(my_print_stacktrace+0x2c)[0x55a5b59c681c] | |
mysqld(handle_fatal_signal+0x479)[0x55a5b52f1879] | |
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f11df4ac0c0] | |
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7f11ddc38fff] | |
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f11ddc3a42a] | |
mysqld(+0x628efb)[0x55a5b52c7efb] | |
mysqld(_Z26btr_pcur_move_to_next_pageP10btr_pcur_tP5mtr_t+0x188)[0x55a5b5bbad38] | |
mysqld(+0x626c13)[0x55a5b52c5c13] | |
mysqld(_Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm+0xf91)[0x55a5b5b0d471] | |
mysqld(_Z24row_scan_index_for_mysqlP14row_prebuilt_tPK12dict_index_tPm+0x585)[0x55a5b5aec145] | |
mysqld(_ZN11ha_innobase5checkEP3THDP15st_ha_check_opt+0x4c4)[0x55a5b5a04224] | |
mysqld(_ZN7handler8ha_checkEP3THDP15st_ha_check_opt+0x7b)[0x55a5b534070b] | |
mysqld(+0xc57e77)[0x55a5b58f6e77] | |
mysqld(_ZN19Sql_cmd_check_table7executeEP3THD+0x92)[0x55a5b58f7992] | |
mysqld(_Z21mysql_execute_commandP3THDb+0x2b52)[0x55a5b5792c72] | |
mysqld(_Z11mysql_parseP3THDP12Parser_state+0x395)[0x55a5b5796ff5] | |
mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xfc4)[0x55a5b57980b4] | |
mysqld(_Z10do_commandP3THD+0x197)[0x55a5b5799487] | |
mysqld(handle_connection+0x278)[0x55a5b5855f38] | |
mysqld(pfs_spawn_thread+0x1b4)[0x55a5b5d2e164] | |
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f11df4a2494] | |
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f11ddceeacf] | |
Trying to get some variables. | |
Some pointers may be invalid and cause the dump to abort. | |
Query (7f119c01cf90): CHECK TABLE `states` QUICK | |
Connection ID (thread ID): 3 | |
Status: NOT_KILLED | |
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains | |
information that should help you find out what is causing the crash. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2019-06-17T13:52:47.555328Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). | |
2019-06-17T13:52:47.557547Z 0 [Note] mysqld (mysqld 5.7.25) starting as process 1 ... | |
2019-06-17T13:52:47.568748Z 0 [Note] InnoDB: PUNCH HOLE support available | |
2019-06-17T13:52:47.568854Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
2019-06-17T13:52:47.568869Z 0 [Note] InnoDB: Uses event mutexes | |
2019-06-17T13:52:47.568879Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
2019-06-17T13:52:47.568889Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 | |
2019-06-17T13:52:47.568928Z 0 [Note] InnoDB: Using Linux native AIO | |
2019-06-17T13:52:47.569279Z 0 [Note] InnoDB: Number of pools: 1 | |
2019-06-17T13:52:47.572849Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
2019-06-17T13:52:47.575934Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
2019-06-17T13:52:47.594389Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
2019-06-17T13:52:47.631485Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
2019-06-17T13:52:47.645955Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
2019-06-17T13:52:47.655870Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 46608129908 | |
2019-06-17T13:52:47.655902Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 46608131931 | |
2019-06-17T13:52:47.659149Z 0 [Note] InnoDB: Database was not shutdown normally! | |
2019-06-17T13:52:47.659169Z 0 [Note] InnoDB: Starting crash recovery. | |
2019-06-17T13:52:47.726023Z 0 [Note] InnoDB: Starting an apply batch of log records to the database... | |
InnoDB: Progress in percent: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 | |
2019-06-17T13:52:48.246503Z 0 [Note] InnoDB: Apply batch completed | |
2019-06-17T13:52:48.373219Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" | |
2019-06-17T13:52:48.373242Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
2019-06-17T13:52:48.373471Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
2019-06-17T13:52:49.038736Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
2019-06-17T13:52:49.040168Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
2019-06-17T13:52:49.040200Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
2019-06-17T13:52:49.044348Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 46608131931 | |
2019-06-17T13:52:49.044867Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
2019-06-17T13:52:49.045522Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
2019-06-17T13:52:49.077529Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. | |
2019-06-17T13:52:49.078490Z 0 [Warning] CA certificate ca.pem is self signed. | |
2019-06-17T13:52:49.083965Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
2019-06-17T13:52:49.087931Z 0 [Note] IPv6 is available. | |
2019-06-17T13:52:49.088355Z 0 [Note] - '::' resolves to '::'; | |
2019-06-17T13:52:49.088421Z 0 [Note] Server socket created on IP: '::'. | |
2019-06-17T13:52:49.091286Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. | |
2019-06-17T13:52:49.100147Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.100231Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.100247Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.100542Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.100579Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.100819Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.128560Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.128637Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
2019-06-17T13:52:49.196286Z 0 [Note] Event Scheduler: Loaded 0 events | |
2019-06-17T13:52:49.196842Z 0 [Note] mysqld: ready for connections. | |
Version: '5.7.25' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) | |
2019-06-17T13:52:49.675021Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190617 13:52:49 | |
13:52:52 UTC - mysqld got signal 11 ; | |
This could be because you hit a bug. It is also possible that this binary | |
or one of the libraries it was linked against is corrupt, improperly built, | |
or misconfigured. This error can also be caused by malfunctioning hardware. | |
Attempting to collect some information that could help diagnose the problem. | |
As this is a crash and something is definitely wrong, the information | |
collection process might fail. | |
key_buffer_size=8388608 | |
read_buffer_size=131072 | |
max_used_connections=5 | |
max_threads=151 | |
thread_count=5 | |
connection_count=5 | |
It is possible that mysqld could use up to | |
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68196 K bytes of memory | |
Hope that's ok; if not, decrease some variables in the equation. | |
Thread pointer: 0x7fdf54000ae0 | |
Attempting backtrace. You can use the following information to find out | |
where mysqld died. If you see no messages after this, something went | |
terribly wrong... | |
stack_bottom = 7fdf8813ee80 thread_stack 0x40000 | |
mysqld(my_print_stacktrace+0x2c)[0x55d904be181c] | |
mysqld(handle_fatal_signal+0x479)[0x55d90450c879] | |
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fdfa64c60c0] | |
mysqld(_Z32page_cur_search_with_match_bytesPK11buf_block_tPK12dict_index_tPK8dtuple_t15page_cur_mode_tPmS9_S9_S9_P10page_cur_t+0x167)[0x55d904ca8be7] | |
mysqld(_Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP5mtr_t+0x989)[0x55d904dce1a9] | |
mysqld(+0x6268e6)[0x55d9044e08e6] | |
mysqld(_Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm+0xd81)[0x55d904d28261] | |
mysqld(_ZN11ha_innobase10index_readEPhPKhj16ha_rkey_function+0x244)[0x55d904c24e24] | |
mysqld(_ZN7handler10ha_rnd_posEPhS0_+0x8b)[0x55d9045599db] | |
mysqld(_ZN26QUICK_ROR_INTERSECT_SELECT8get_nextEv+0x336)[0x55d904af67a6] | |
mysqld(+0xa5bdef)[0x55d904915def] | |
mysqld(_Z10sub_selectP4JOINP7QEP_TABb+0x105)[0x55d904983bb5] | |
mysqld(_ZN4JOIN4execEv+0x370)[0x55d90497ca30] | |
mysqld(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x233)[0x55d9049ebeb3] | |
mysqld(+0x61cf32)[0x55d9044d6f32] | |
mysqld(_Z21mysql_execute_commandP3THDb+0x460d)[0x55d9049af72d] | |
mysqld(_Z11mysql_parseP3THDP12Parser_state+0x395)[0x55d9049b1ff5] | |
mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xfc4)[0x55d9049b30b4] | |
mysqld(_Z10do_commandP3THD+0x197)[0x55d9049b4487] | |
mysqld(handle_connection+0x278)[0x55d904a70f38] | |
mysqld(pfs_spawn_thread+0x1b4)[0x55d904f49164] | |
/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fdfa64bc494] | |
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fdfa4d08acf] | |
Trying to get some variables. | |
Some pointers may be invalid and cause the dump to abort. | |
Query (7fdf54005640): SELECT `id`, `state`, `param`, `cursor_row`, `cursor_column`, `can_send`, `createdAt`, `updatedAt`, `userId`, `botId` FROM `states` AS `state` WHERE `state`.`userId` = 314822 AND `state`.`botId` = 15017 LIMIT 1 | |
Connection ID (thread ID): 3 | |
Status: NOT_KILLED | |
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains | |
information that should help you find out what is causing the crash. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Variable_name:Value | |
auto_increment_increment:1 | |
auto_increment_offset:1 | |
autocommit:ON | |
automatic_sp_privileges:ON | |
avoid_temporal_upgrade:OFF | |
back_log:80 | |
basedir:/usr/ | |
big_tables:OFF | |
bind_address:* | |
binlog_cache_size:32768 | |
binlog_checksum:CRC32 | |
binlog_direct_non_transactional_updates:OFF | |
binlog_error_action:ABORT_SERVER | |
binlog_format:ROW | |
binlog_group_commit_sync_delay:0 | |
binlog_group_commit_sync_no_delay_count:0 | |
binlog_gtid_simple_recovery:ON | |
binlog_max_flush_queue_time:0 | |
binlog_order_commits:ON | |
binlog_row_image:FULL | |
binlog_rows_query_log_events:OFF | |
binlog_stmt_cache_size:32768 | |
binlog_transaction_dependency_history_size:25000 | |
binlog_transaction_dependency_tracking:COMMIT_ORDER | |
block_encryption_mode:aes-128-ecb | |
bulk_insert_buffer_size:8388608 | |
character_set_client:utf8 | |
character_set_connection:utf8 | |
character_set_database:latin1 | |
character_set_filesystem:binary | |
character_set_results:utf8 | |
character_set_server:latin1 | |
character_set_system:utf8 | |
character_sets_dir:/usr/share/mysql/charsets/ | |
check_proxy_users:OFF | |
collation_connection:utf8_general_ci | |
collation_database:latin1_swedish_ci | |
collation_server:latin1_swedish_ci | |
completion_type:NO_CHAIN | |
concurrent_insert:AUTO | |
connect_timeout:10 | |
core_file:OFF | |
datadir:/var/lib/mysql/ | |
date_format:%Y-%m-%d | |
datetime_format:%Y-%m-%d %H:%i:%s | |
default_authentication_plugin:mysql_native_password | |
default_password_lifetime:0 | |
default_storage_engine:InnoDB | |
default_tmp_storage_engine:InnoDB | |
default_week_format:0 | |
delay_key_write:ON | |
delayed_insert_limit:100 | |
delayed_insert_timeout:300 | |
delayed_queue_size:1000 | |
disabled_storage_engines: | |
disconnect_on_expired_password:ON | |
div_precision_increment:4 | |
end_markers_in_json:OFF | |
enforce_gtid_consistency:OFF | |
eq_range_index_dive_limit:200 | |
error_count:0 | |
event_scheduler:OFF | |
expire_logs_days:0 | |
explicit_defaults_for_timestamp:OFF | |
external_user: | |
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/a6d725244214.log | |
group_concat_max_len:1024 | |
gtid_executed_compression_period:1000 | |
gtid_mode:OFF | |
gtid_next:AUTOMATIC | |
gtid_owned: | |
gtid_purged: | |
have_compress:YES | |
have_crypt:YES | |
have_dynamic_loading:YES | |
have_geometry:YES | |
have_openssl:YES | |
have_profiling:YES | |
have_query_cache:YES | |
have_rtree_keys:YES | |
have_ssl:YES | |
have_statement_timeout:YES | |
have_symlink:DISABLED | |
host_cache_size:279 | |
hostname:a6d725244214 | |
identity:0 | |
ignore_builtin_innodb:OFF | |
ignore_db_dirs: | |
init_connect: | |
init_file: | |
init_slave: | |
innodb_adaptive_flushing:ON | |
innodb_adaptive_flushing_lwm:10 | |
innodb_adaptive_hash_index:ON | |
innodb_adaptive_hash_index_parts:8 | |
innodb_adaptive_max_sleep_delay:150000 | |
innodb_api_bk_commit_interval:5 | |
innodb_api_disable_rowlock:OFF | |
innodb_api_enable_binlog:OFF | |
innodb_api_enable_mdl:OFF | |
innodb_api_trx_level:0 | |
innodb_autoextend_increment:64 | |
innodb_autoinc_lock_mode:1 | |
innodb_buffer_pool_chunk_size:134217728 | |
innodb_buffer_pool_dump_at_shutdown:ON | |
innodb_buffer_pool_dump_now:OFF | |
innodb_buffer_pool_dump_pct:25 | |
innodb_buffer_pool_filename:ib_buffer_pool | |
innodb_buffer_pool_instances:1 | |
innodb_buffer_pool_load_abort:OFF | |
innodb_buffer_pool_load_at_startup:ON | |
innodb_buffer_pool_load_now:OFF | |
innodb_buffer_pool_size:134217728 | |
innodb_change_buffer_max_size:25 | |
innodb_change_buffering:all | |
innodb_checksum_algorithm:crc32 | |
innodb_checksums:ON | |
innodb_cmp_per_index_enabled:OFF | |
innodb_commit_concurrency:0 | |
innodb_compression_failure_threshold_pct:5 | |
innodb_compression_level:6 | |
innodb_compression_pad_pct_max:50 | |
innodb_concurrency_tickets:5000 | |
innodb_data_file_path:ibdata1:12M:autoextend | |
innodb_data_home_dir: | |
innodb_deadlock_detect:ON | |
innodb_default_row_format:dynamic | |
innodb_disable_sort_file_cache:OFF | |
innodb_doublewrite:ON | |
innodb_fast_shutdown:1 | |
innodb_file_format:Barracuda | |
innodb_file_format_check:ON | |
innodb_file_format_max:Barracuda | |
innodb_file_per_table:ON | |
innodb_fill_factor:100 | |
innodb_flush_log_at_timeout:1 | |
innodb_flush_log_at_trx_commit:1 | |
innodb_flush_method: | |
innodb_flush_neighbors:1 | |
innodb_flush_sync:ON | |
innodb_flushing_avg_loops:30 | |
innodb_force_load_corrupted:OFF | |
innodb_force_recovery:0 | |
innodb_ft_aux_table: | |
innodb_ft_cache_size:8000000 | |
innodb_ft_enable_diag_print:OFF | |
innodb_ft_enable_stopword:ON | |
innodb_ft_max_token_size:84 | |
innodb_ft_min_token_size:3 | |
innodb_ft_num_word_optimize:2000 | |
innodb_ft_result_cache_limit:2000000000 | |
innodb_ft_server_stopword_table: | |
innodb_ft_sort_pll_degree:2 | |
innodb_ft_total_cache_size:640000000 | |
innodb_ft_user_stopword_table: | |
innodb_io_capacity:200 | |
innodb_io_capacity_max:2000 | |
innodb_large_prefix:ON | |
innodb_lock_wait_timeout:50 | |
innodb_locks_unsafe_for_binlog:OFF | |
innodb_log_buffer_size:16777216 | |
innodb_log_checksums:ON | |
innodb_log_compressed_pages:ON | |
innodb_log_file_size:50331648 | |
innodb_log_files_in_group:2 | |
innodb_log_group_home_dir:./ | |
innodb_log_write_ahead_size:8192 | |
innodb_lru_scan_depth:1024 | |
innodb_max_dirty_pages_pct:75.000000 | |
innodb_max_dirty_pages_pct_lwm:0.000000 | |
innodb_max_purge_lag:0 | |
innodb_max_purge_lag_delay:0 | |
innodb_max_undo_log_size:1073741824 | |
innodb_monitor_disable: | |
innodb_monitor_enable: | |
innodb_monitor_reset: | |
innodb_monitor_reset_all: | |
innodb_numa_interleave:OFF | |
innodb_old_blocks_pct:37 | |
innodb_old_blocks_time:1000 | |
innodb_online_alter_log_max_size:134217728 | |
innodb_open_files:2000 | |
innodb_optimize_fulltext_only:OFF | |
innodb_page_cleaners:1 | |
innodb_page_size:16384 | |
innodb_print_all_deadlocks:OFF | |
innodb_purge_batch_size:300 | |
innodb_purge_rseg_truncate_frequency:128 | |
innodb_purge_threads:4 | |
innodb_random_read_ahead:OFF | |
innodb_read_ahead_threshold:56 | |
innodb_read_io_threads:4 | |
innodb_read_only:OFF | |
innodb_replication_delay:0 | |
innodb_rollback_on_timeout:OFF | |
innodb_rollback_segments:128 | |
innodb_sort_buffer_size:1048576 | |
innodb_spin_wait_delay:6 | |
innodb_stats_auto_recalc:ON | |
innodb_stats_include_delete_marked:OFF | |
innodb_stats_method:nulls_equal | |
innodb_stats_on_metadata:OFF | |
innodb_stats_persistent:ON | |
innodb_stats_persistent_sample_pages:20 | |
innodb_stats_sample_pages:8 | |
innodb_stats_transient_sample_pages:8 | |
innodb_status_output:OFF | |
innodb_status_output_locks:OFF | |
innodb_strict_mode:ON | |
innodb_support_xa:ON | |
innodb_sync_array_size:1 | |
innodb_sync_spin_loops:30 | |
innodb_table_locks:ON | |
innodb_temp_data_file_path:ibtmp1:12M:autoextend | |
innodb_thread_concurrency:0 | |
innodb_thread_sleep_delay:10000 | |
innodb_tmpdir: | |
innodb_undo_directory:./ | |
innodb_undo_log_truncate:OFF | |
innodb_undo_logs:128 | |
innodb_undo_tablespaces:0 | |
innodb_use_native_aio:ON | |
innodb_version:5.7.25 | |
innodb_write_io_threads:4 | |
insert_id:0 | |
interactive_timeout:28800 | |
internal_tmp_disk_storage_engine:InnoDB | |
join_buffer_size:262144 | |
keep_files_on_create:OFF | |
key_buffer_size:8388608 | |
key_cache_age_threshold:300 | |
key_cache_block_size:1024 | |
key_cache_division_limit:100 | |
keyring_operations:ON | |
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_bin:OFF | |
log_bin_basename: | |
log_bin_index: | |
log_bin_trust_function_creators:OFF | |
log_bin_use_v1_row_events:OFF | |
log_builtin_as_identified_by_password:OFF | |
log_error:stderr | |
log_error_verbosity:3 | |
log_output:FILE | |
log_queries_not_using_indexes:OFF | |
log_slave_updates:OFF | |
log_slow_admin_statements:OFF | |
log_slow_slave_statements:OFF | |
log_statements_unsafe_for_binlog:ON | |
log_syslog:OFF | |
log_syslog_facility:daemon | |
log_syslog_include_pid:ON | |
log_syslog_tag: | |
log_throttle_queries_not_using_indexes:0 | |
log_timestamps:UTC | |
log_warnings:2 | |
long_query_time:10.000000 | |
low_priority_updates:OFF | |
lower_case_file_system:OFF | |
lower_case_table_names:0 | |
master_info_repository:FILE | |
master_verify_checksum:OFF | |
max_allowed_packet:4194304 | |
max_binlog_cache_size:18446744073709547520 | |
max_binlog_size:1073741824 | |
max_binlog_stmt_cache_size:18446744073709547520 | |
max_connect_errors:100 | |
max_connections:151 | |
max_delayed_threads:20 | |
max_digest_length:1024 | |
max_error_count:64 | |
max_execution_time:0 | |
max_heap_table_size:16777216 | |
max_insert_delayed_threads:20 | |
max_join_size:18446744073709551615 | |
max_length_for_sort_data:1024 | |
max_points_in_geometry:65536 | |
max_prepared_stmt_count:16382 | |
max_relay_log_size:0 | |
max_seeks_for_key:18446744073709551615 | |
max_sort_length:1024 | |
max_sp_recursion_depth:0 | |
max_tmp_tables:32 | |
max_user_connections:0 | |
max_write_lock_count:18446744073709551615 | |
metadata_locks_cache_size:1024 | |
metadata_locks_hash_instances:8 | |
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 | |
mysql_native_password_proxy_users:OFF | |
net_buffer_length:16384 | |
net_read_timeout:30 | |
net_retry_count:10 | |
net_write_timeout:60 | |
new:OFF | |
ngram_token_size:2 | |
offline_mode:OFF | |
old:OFF | |
old_alter_table:OFF | |
old_passwords:0 | |
open_files_limit:1048576 | |
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,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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on | |
optimizer_trace:enabled=off,one_line=off | |
optimizer_trace_features:greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on | |
optimizer_trace_limit:1 | |
optimizer_trace_max_mem_size:16384 | |
optimizer_trace_offset:-1 | |
parser_max_mem_size:18446744073709551615 | |
performance_schema:ON | |
performance_schema_accounts_size:-1 | |
performance_schema_digests_size:10000 | |
performance_schema_events_stages_history_long_size:10000 | |
performance_schema_events_stages_history_size:10 | |
performance_schema_events_statements_history_long_size:10000 | |
performance_schema_events_statements_history_size:10 | |
performance_schema_events_transactions_history_long_size:10000 | |
performance_schema_events_transactions_history_size:10 | |
performance_schema_events_waits_history_long_size:10000 | |
performance_schema_events_waits_history_size:10 | |
performance_schema_hosts_size:-1 | |
performance_schema_max_cond_classes:80 | |
performance_schema_max_cond_instances:-1 | |
performance_schema_max_digest_length:1024 | |
performance_schema_max_file_classes:80 | |
performance_schema_max_file_handles:32768 | |
performance_schema_max_file_instances:-1 | |
performance_schema_max_index_stat:-1 | |
performance_schema_max_memory_classes:320 | |
performance_schema_max_metadata_locks:-1 | |
performance_schema_max_mutex_classes:210 | |
performance_schema_max_mutex_instances:-1 | |
performance_schema_max_prepared_statements_instances:-1 | |
performance_schema_max_program_instances:-1 | |
performance_schema_max_rwlock_classes:50 | |
performance_schema_max_rwlock_instances:-1 | |
performance_schema_max_socket_classes:10 | |
performance_schema_max_socket_instances:-1 | |
performance_schema_max_sql_text_length:1024 | |
performance_schema_max_stage_classes:150 | |
performance_schema_max_statement_classes:193 | |
performance_schema_max_statement_stack:10 | |
performance_schema_max_table_handles:-1 | |
performance_schema_max_table_instances:-1 | |
performance_schema_max_table_lock_stat:-1 | |
performance_schema_max_thread_classes:50 | |
performance_schema_max_thread_instances:-1 | |
performance_schema_session_connect_attrs_size:512 | |
performance_schema_setup_actors_size:-1 | |
performance_schema_setup_objects_size:-1 | |
performance_schema_users_size:-1 | |
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 | |
proxy_user: | |
pseudo_slave_mode:OFF | |
pseudo_thread_id:431 | |
query_alloc_block_size:8192 | |
query_cache_limit:1048576 | |
query_cache_min_res_unit:4096 | |
query_cache_size:1048576 | |
query_cache_type:OFF | |
query_cache_wlock_invalidate:OFF | |
query_prealloc_size:8192 | |
rand_seed1:0 | |
rand_seed2:0 | |
range_alloc_block_size:4096 | |
range_optimizer_max_mem_size:8388608 | |
rbr_exec_mode:STRICT | |
read_buffer_size:131072 | |
read_only:OFF | |
read_rnd_buffer_size:262144 | |
relay_log: | |
relay_log_basename:/var/lib/mysql/a6d725244214-relay-bin | |
relay_log_index:/var/lib/mysql/a6d725244214-relay-bin.index | |
relay_log_info_file:relay-log.info | |
relay_log_info_repository:FILE | |
relay_log_purge:ON | |
relay_log_recovery:OFF | |
relay_log_space_limit:0 | |
report_host: | |
report_password: | |
report_port:3306 | |
report_user: | |
require_secure_transport:OFF | |
rpl_stop_slave_timeout:31536000 | |
secure_auth:ON | |
secure_file_priv:/var/lib/mysql-files/ | |
server_id:0 | |
server_id_bits:32 | |
server_uuid:1386474c-5b26-11e8-9b3f-0242ac140004 | |
session_track_gtids:OFF | |
session_track_schema:ON | |
session_track_state_change:OFF | |
session_track_system_variables:time_zone,autocommit,character_set_client,character_set_results,character_set_connection | |
session_track_transaction_info:OFF | |
sha256_password_proxy_users:OFF | |
show_compatibility_56:OFF | |
show_create_table_verbosity:OFF | |
show_old_temporals:OFF | |
skip_external_locking:ON | |
skip_name_resolve:ON | |
skip_networking:OFF | |
skip_show_database:OFF | |
slave_allow_batching:OFF | |
slave_checkpoint_group:512 | |
slave_checkpoint_period:300 | |
slave_compressed_protocol:OFF | |
slave_exec_mode:STRICT | |
slave_load_tmpdir:/tmp | |
slave_max_allowed_packet:1073741824 | |
slave_net_timeout:60 | |
slave_parallel_type:DATABASE | |
slave_parallel_workers:0 | |
slave_pending_jobs_size_max:16777216 | |
slave_preserve_commit_order:OFF | |
slave_rows_search_algorithms:TABLE_SCAN,INDEX_SCAN | |
slave_skip_errors:OFF | |
slave_sql_verify_checksum:ON | |
slave_transaction_retries:10 | |
slave_type_conversions: | |
slow_launch_time:2 | |
slow_query_log:OFF | |
slow_query_log_file:/var/lib/mysql/a6d725244214-slow.log | |
socket:/var/run/mysqld/mysqld.sock | |
sort_buffer_size:262144 | |
sql_auto_is_null:OFF | |
sql_big_selects:ON | |
sql_buffer_result:OFF | |
sql_log_bin:ON | |
sql_log_off:OFF | |
sql_mode:ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | |
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:ca.pem | |
ssl_capath: | |
ssl_cert:server-cert.pem | |
ssl_cipher: | |
ssl_crl: | |
ssl_crlpath: | |
ssl_key:server-key.pem | |
stored_program_cache:256 | |
super_read_only:OFF | |
sync_binlog:1 | |
sync_frm:ON | |
sync_master_info:10000 | |
sync_relay_log:10000 | |
sync_relay_log_info:10000 | |
system_time_zone:UTC | |
table_definition_cache:1400 | |
table_open_cache:2000 | |
table_open_cache_instances:16 | |
thread_cache_size:9 | |
thread_handling:one-thread-per-connection | |
thread_stack:262144 | |
time_format:%H:%i:%s | |
time_zone:SYSTEM | |
timestamp:1560785221.951882 | |
tls_version:TLSv1,TLSv1.1 | |
tmp_table_size:16777216 | |
tmpdir:/tmp | |
transaction_alloc_block_size:8192 | |
transaction_allow_batching:OFF | |
transaction_isolation:REPEATABLE-READ | |
transaction_prealloc_size:4096 | |
transaction_read_only:OFF | |
transaction_write_set_extraction:OFF | |
tx_isolation:REPEATABLE-READ | |
tx_read_only:OFF | |
unique_checks:ON | |
updatable_views_with_limit:YES | |
version:5.7.25 | |
version_comment:MySQL Community Server (GPL) | |
version_compile_machine:x86_64 | |
version_compile_os:Linux | |
wait_timeout:28800 | |
warning_count:0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment