mysql 创建索引 mysql 服务崩溃

[冠辰]

创建索引：
create index permissionruleuser_restype_resid on permissionruleuser(restype,resid);
create index permissionrulestation_restype_resid on permissionrulestation(restype,resid);

create index permissionrulegroup_typeid_restype on permissionrulegroup(typeid,restype);
create index permissionrulegroup_restype_resid on permissionrulegroup(restype,resid);
create index permissionrulegroup_resid_typeid on permissionrulegroup(resid,typeid);

create index permissionruleorg_restype_resid on permissionruleorg(restype,resid);

create index workflow_formid_catalogid on workflow(formid,catalogid);
create index workflow_formid_typeid on workflow(formid,typeid);

create index stepinfo_workflowid on stepinfo(workflowid);

create index steppath_workflowid_stepsource on steppath(workflowid,stepsource);
create index steppath_workflowid_stepTarget on steppath(workflowid,stepTarget);

create index stepoperator_stepid on stepoperator(stepid);

create index requestlog_requestid_staffId on requestlog(requestid,staffId);
create index requestlog_requestid_stepid on requestlog(requestid,stepid);

create index wfrequest_dataid_workflowid on wfrequest(dataid,workflowid);

create index requestoperator_requestid_stepid on requestoperator(requestid,stepid);
create index requestoperator_requestid_staffid on requestoperator(requestid,staffid);

create index requeststatus_requestid_stepid on requeststatus(requestid,stepid);

错误日志：
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.
2018-12-10T00:21:12.327369Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-12-10T00:21:12.327369Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-12-10T00:21:12.327369Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-12-10T00:21:12.327369Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-12-10T00:21:12.327369Z 0 [Note] E:\mysql\mysql-5.7.21-winx64\bin\mysqld (mysqld 5.7.21-log) starting as process 2392 ...
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: Uses event mutexes
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: Number of pools: 1
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-12-10T00:21:12.327369Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-12-10T00:21:12.342969Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-12-10T00:21:12.389769Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-12-10T00:21:12.405369Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 150245247
2018-12-10T00:21:12.405369Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 150245256
2018-12-10T00:21:12.405369Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-12-10T00:21:12.405369Z 0 [Note] InnoDB: Starting crash recovery.
2018-12-10T00:21:13.341369Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-12-10T00:21:13.341369Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-12-10T00:21:13.341369Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-12-10T00:21:15.462969Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-12-10T00:21:15.462969Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-12-10T00:21:15.462969Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-12-10T00:21:15.462969Z 0 [Note] InnoDB: Waiting for purge to start
2018-12-10T00:21:15.540969Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 150245256
2018-12-10T00:21:15.540969Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-12-10T00:21:15.540969Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql\data\ib_buffer_pool
2018-12-10T00:21:15.774969Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-12-10T00:21:15.774969Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-12-10T00:21:15.774969Z 0 [Note] IPv6 is available.
2018-12-10T00:21:15.774969Z 0 [Note] - '::' resolves to '::';
2018-12-10T00:21:15.774969Z 0 [Note] Server socket created on IP: '::'.
2018-12-10T00:21:15.821769Z 0 [Note] Event Scheduler: Loaded 0 events
2018-12-10T00:21:15.821769Z 0 [Note] E:\mysql\mysql-5.7.21-winx64\bin\mysqld: ready for connections.
Version: '5.7.21-log' socket: '' port: 3306 MySQL Community Server (GPL)
2018-12-10T00:21:16.149369Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181210 8:21:16