为了能快速了解并处理您的问题,请提供以下基础信息:
问题描述:mysql服务过一段时间就会自动停止,里面的数据库也会被删除。
相关截图(日志、错误):2024-04-01T22:03:14.595420Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2024-04-01T22:03:14.596719Z 0 [Note] Binlog end 2024-04-01T22:03:14.610452Z 0 [Note] Shutting down plugin 'ngram' 2024-04-01T22:03:14.610484Z 0 [Note] Shutting down plugin 'partition' 2024-04-01T22:03:14.610489Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2024-04-01T22:03:14.610494Z 0 [Note] Shutting down plugin 'ARCHIVE' 2024-04-01T22:03:14.610498Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2024-04-01T22:03:14.610539Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2024-04-01T22:03:14.610545Z 0 [Note] Shutting down plugin 'MyISAM' 2024-04-01T22:03:14.610567Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2024-04-01T22:03:14.610572Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2024-04-01T22:03:14.610575Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2024-04-01T22:03:14.610579Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2024-04-01T22:03:14.610583Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2024-04-01T22:03:14.610586Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2024-04-01T22:03:14.610590Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2024-04-01T22:03:14.610593Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2024-04-01T22:03:14.610597Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2024-04-01T22:03:14.610600Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2024-04-01T22:03:14.610604Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2024-04-01T22:03:14.610607Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2024-04-01T22:03:14.610611Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2024-04-01T22:03:14.610614Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2024-04-01T22:03:14.610618Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2024-04-01T22:03:14.610621Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2024-04-01T22:03:14.610624Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2024-04-01T22:03:14.610628Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2024-04-01T22:03:14.610631Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2024-04-01T22:03:14.610635Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2024-04-01T22:03:14.610638Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2024-04-01T22:03:14.610642Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2024-04-01T22:03:14.610646Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2024-04-01T22:03:14.610649Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2024-04-01T22:03:14.610653Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2024-04-01T22:03:14.610656Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2024-04-01T22:03:14.610660Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2024-04-01T22:03:14.610664Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2024-04-01T22:03:14.610667Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2024-04-01T22:03:14.610671Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2024-04-01T22:03:14.610674Z 0 [Note] Shutting down plugin 'InnoDB' 2024-04-01T22:03:14.610721Z 0 [Note] InnoDB: FTS optimize thread exiting. 2024-04-01T22:03:14.610867Z 0 [Note] InnoDB: Starting shutdown... 2024-04-01T22:03:14.711074Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool 2024-04-01T22:03:14.711529Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 240402 6:03:14 2024-04-01T22:03:15.940049Z 0 [Note] InnoDB: Shutdown completed; log sequence number 3051449 2024-04-01T22:03:15.940411Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2024-04-01T22:03:15.940432Z 0 [Note] Shutting down plugin 'MEMORY' 2024-04-01T22:03:15.940439Z 0 [Note] Shutting down plugin 'CSV' 2024-04-01T22:03:15.940445Z 0 [Note] Shutting down plugin 'sha256_password' 2024-04-01T22:03:15.940450Z 0 [Note] Shutting down plugin 'mysql_native_password' 2024-04-01T22:03:15.940609Z 0 [Note] Shutting down plugin 'binlog' 2024-04-01T22:03:15.943344Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete
|