Windows版Mysql服务意外停止error number 23 5C

MySQL日志如下:求帮助:
场景:查询一段很耗的sql会引起mysql服务非正常关闭(手动重启是ok的),如下异常日志,mysql需要怎么设置;
mysql 配置文件:
图片说明
2018-04-26T02:15:05.557394Z 24 [ERROR] InnoDB: Operating system error number 23 in a file operation.
2018-04-26T02:15:05.557394Z 24 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2018-04-26T02:15:05.572994Z 24 [ERROR] InnoDB: File .\mfg_db\sn_scan_ht.ibd: 'Windows aio' returned OS error 123. Cannot continue operation
2018-04-26T02:15:05.572994Z 24 [ERROR] InnoDB: Cannot continue operation.
2018-04-26T02:15:07.772598Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-04-26T02:16:54.819986Z 24 [Warning] InnoDB: 13 threads created by InnoDB had not exited at shutdown!
2018-04-26T02:17:11.605615Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-04-26T02:17:11.605615Z 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-04-26T02:17:11.605615Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2018-04-26T02:17:11.605615Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-04-26T02:17:11.605615Z 0 [Note] MySQL (mysqld 5.7.17-log) starting as process 10868 ...
2018-04-26T02:17:11.621215Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-04-26T02:17:11.621215Z 0 [Note] InnoDB: Uses event mutexes
2018-04-26T02:17:11.621215Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-04-26T02:17:11.621215Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-04-26T02:17:11.621215Z 0 [Note] InnoDB: Number of pools: 1
2018-04-26T02:17:11.636815Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-04-26T02:17:11.636815Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-04-26T02:17:11.652415Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-04-26T02:17:11.730415Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-04-26T02:17:11.746015Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 22526427804
2018-04-26T02:17:11.746015Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 22526427813
2018-04-26T02:17:11.746015Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 22526427813
2018-04-26T02:17:11.761615Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-04-26T02:17:11.761615Z 0 [Note] InnoDB: Starting crash recovery.
2018-04-26T02:17:11.886416Z 0 [Note] InnoDB: Last MySQL binlog file position 0 1457173, file name master-bin.000024
2018-04-26T02:17:12.089216Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-04-26T02:17:12.089216Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-04-26T02:17:12.089216Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-04-26T02:17:12.104816Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-04-26T02:17:12.104816Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-04-26T02:17:12.104816Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-04-26T02:17:12.104816Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 22526427813
2018-04-26T02:17:12.104816Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\DB_Data\MySql\ib_buffer_pool
2018-04-26T02:17:12.104816Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-04-26T02:17:12.120416Z 0 [Note] Recovering after a crash using master-bin
2018-04-26T02:17:12.151616Z 0 [Note] Starting crash recovery...
2018-04-26T02:17:12.151616Z 0 [Note] Crash recovery finished.
2018-04-26T02:17:12.214016Z 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-04-26T02:17:12.214016Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-04-26T02:17:12.214016Z 0 [Note] IPv6 is available.
2018-04-26T02:17:12.214016Z 0 [Note] - '::' resolves to '::';
2018-04-26T02:17:12.214016Z 0 [Note] Server socket created on IP: '::'.
2018-04-26T02:17:12.713217Z 0 [Note] Event Scheduler: Loaded 0 events
2018-04-26T02:17:12.713217Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2018-04-26T02:17:12.713217Z 0 [Note] Beginning of list of non-natively partitioned tables
2018-04-26T02:17:12.775617Z 0 [Note] End of list of non-natively partitioned tables
2018-04-26T02:17:12.775617Z 0 [Note] MySQL: ready for connections.
Version: '5.7.17-log' socket: '' port: 3306 MySQL Community Server (GPL)
2018-04-26T02:17:13.415218Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180426 10:17:13

1个回答

errno.23 is: Too many open files in system 系统打开文件太多

关闭杀毒软件,重启一下看看。

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
安装MySQL 最后一步出错 Error Number 1045
![图片说明](https://img-ask.csdn.net/upload/201605/20/1463738656_838157.png)
Mysql服务启动意外终止,下面是错误日志!求大神帮解决。。。
170210 10:33:11 [Note] Plugin 'FEDERATED' is disabled. D:\MySQL\MySQL Server 5.5\bin\mysqld: Table 'mysql.plugin' doesn't exist 170210 10:33:11 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 170210 10:33:11 InnoDB: The InnoDB memory heap is disabled 170210 10:33:11 InnoDB: Mutexes and rw_locks use Windows interlocked functions 170210 10:33:11 InnoDB: Compressed tables use zlib 1.2.3 170210 10:33:11 InnoDB: Initializing buffer pool, size = 93.0M 170210 10:33:11 InnoDB: Completed initialization of buffer pool 170210 10:33:11 InnoDB: highest supported file format is Barracuda. 170210 10:33:12 InnoDB: Waiting for the background threads to start 170210 10:33:13 InnoDB: 5.5.53 started; log sequence number 1806653 170210 10:33:13 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 170210 10:33:13 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 170210 10:33:13 [Note] Server socket created on IP: '0.0.0.0'. 170210 10:33:13 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
mysql InnoDB: Error: "mysql"."innodb_table_stats
附上错误日志: 2015-06-23 22:39:06 1252 [Note] Giving 0 client threads a chance to die gracefully 2015-06-23 22:39:06 1252 [Note] Shutting down slave threads 2015-06-23 22:39:06 1252 [Note] Forcefully disconnecting 0 remaining clients 2015-06-23 22:39:06 1252 [Note] Binlog end 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'partition' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'BLACKHOLE' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_METRICS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_CMPMEM' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_CMP' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_LOCKS' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'INNODB_TRX' 2015-06-23 22:39:09 1252 [Note] Shutting down plugin 'InnoDB' 2015-06-23 22:39:09 1252 [Note] InnoDB: FTS optimize thread exiting. 2015-06-23 22:39:09 1252 [Note] InnoDB: Starting shutdown... 2015-06-23 22:39:12 1252 [Note] InnoDB: Shutdown completed; log sequence number 44832642 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'ARCHIVE' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'MyISAM' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'CSV' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'MRG_MYISAM' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'MEMORY' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'sha256_password' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'mysql_old_password' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'mysql_native_password' 2015-06-23 22:39:12 1252 [Note] Shutting down plugin 'binlog' 2015-06-23 22:39:12 1252 [Note] /usr/sbin/mysqld: Shutdown complete 150623 22:39:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 150623 22:39:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2015-06-23 22:39:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2015-06-23 22:39:39 1190 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2015-06-23 22:39:39 1190 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000) 2015-06-23 22:39:39 1190 [Note] Plugin 'FEDERATED' is disabled. 2015-06-23 22:39:39 1190 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-23 22:39:39 1190 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-23 22:39:39 1190 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-23 22:39:39 1190 [Note] InnoDB: Memory barrier is not used 2015-06-23 22:39:39 1190 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-23 22:39:39 1190 [Note] InnoDB: Using Linux native AIO 2015-06-23 22:39:39 1190 [Note] InnoDB: Not using CPU crc32 instructions 2015-06-23 22:39:39 1190 [Note] InnoDB: Initializing buffer pool, size = 1.0G 2015-06-23 22:39:40 1190 [Note] InnoDB: Completed initialization of buffer pool 2015-06-23 22:39:40 1190 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-23 22:39:40 1190 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-23 22:39:40 1190 [Note] InnoDB: Waiting for purge to start 2015-06-23 22:39:40 1190 [Note] InnoDB: 5.6.22 started; log sequence number 44832642 2015-06-23 22:39:41 1190 [Note] Server hostname (bind-address): '*'; port: 3306 2015-06-23 22:39:41 1190 [Note] IPv6 is available. 2015-06-23 22:39:41 1190 [Note] - '::' resolves to '::'; 2015-06-23 22:39:41 1190 [Note] Server socket created on IP: '::'. 2015-06-23 22:39:41 1190 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(16), found type char(80). 2015-06-23 22:39:41 1190 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type char(77), found type char(141). 2015-06-23 22:39:41 1190 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A 2015-06-23 22:39:41 1190 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2015-06-23 22:39:41 1190 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2015-06-23 23:00:47 7f7038bc0700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2015-06-23 23:00:47 7f7038bc0700 InnoDB: Error: Fetch of persistent statistics requested for table "moodle"."mdl_config" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
启动mysql服务报ERROR:1067错误
这里是日志: 2014-09-01T06:12:49.816554Z 0 [Note] Plugin 'FEDERATED' is disabled. 2014-09-01T06:12:49.818554Z 0 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-09-01T06:12:49.820554Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2014-09-01T06:12:49.822554Z 0 [Note] InnoDB: Uses system mutexes 2014-09-01T06:12:49.824554Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-09-01T06:12:49.825555Z 0 [Warning] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB 2014-09-01T06:12:49.830555Z 0 [Note] InnoDB: Number of pools: 1 2014-09-01T06:12:49.832555Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2014-09-01T06:12:49.834555Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 2 2014-09-01T06:12:49.835555Z 0 [ERROR] Plugin 'InnoDB' init function returned error. 2014-09-01T06:12:49.837555Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2014-09-01T06:12:49.840555Z 0 [ERROR] Unknown/unsupported storage engine: innodb 2014-09-01T06:12:49.841555Z 0 [ERROR] Aborting 2014-09-01T06:12:49.842556Z 0 [Note] Binlog end 2014-09-01T06:12:50.010565Z 0 [Note] Shutting down plugin 'partition' 2014-09-01T06:12:50.015565Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-09-01T06:12:50.021566Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-09-01T06:12:50.027566Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-09-01T06:12:50.033566Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-09-01T06:12:50.039567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-09-01T06:12:50.043567Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-09-01T06:12:50.045567Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-09-01T06:12:50.048567Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-09-01T06:12:50.050567Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-09-01T06:12:50.052568Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-09-01T06:12:50.054568Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-09-01T06:12:50.057568Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-09-01T06:12:50.059568Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-09-01T06:12:50.061568Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-09-01T06:12:50.064568Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-09-01T06:12:50.066568Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-09-01T06:12:50.068568Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2014-09-01T06:12:50.071569Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2014-09-01T06:12:50.073569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-09-01T06:12:50.074569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-09-01T06:12:50.076569Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-09-01T06:12:50.078569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-09-01T06:12:50.079569Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-09-01T06:12:50.081569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-09-01T06:12:50.083569Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-09-01T06:12:50.084569Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-09-01T06:12:50.086569Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2014-09-01T06:12:50.087570Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-09-01T06:12:50.089570Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-09-01T06:12:50.091570Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2014-09-01T06:12:50.092570Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2014-09-01T06:12:50.094570Z 0 [Note] Shutting down plugin 'ARCHIVE' 2014-09-01T06:12:50.096570Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2014-09-01T06:12:50.097570Z 0 [Note] Shutting down plugin 'MyISAM' 2014-09-01T06:12:50.099570Z 0 [Note] Shutting down plugin 'MEMORY' 2014-09-01T06:12:50.100570Z 0 [Note] Shutting down plugin 'CSV' 2014-09-01T06:12:50.101570Z 0 [Note] Shutting down plugin 'sha256_password' 2014-09-01T06:12:50.103570Z 0 [Note] Shutting down plugin 'mysql_old_password' 2014-09-01T06:12:50.105571Z 0 [Note] Shutting down plugin 'mysql_native_password' 2014-09-01T06:12:50.107571Z 0 [Note] Shutting down plugin 'binlog' 2014-09-01T06:12:50.108571Z 0 [Note] F:\mysqlpath\MySQL\MySQL Server 5.7\bin\mysqld: Shutdown complete 有谁知道的吗?谢谢。。。
win10安装mysql 服务起不来
Macbook Pro 双系统 win10环境下安装mysql-5.7.17.msi 服务起不来 ![图片说明](https://img-ask.csdn.net/upload/201704/01/1491009614_793651.png) 安装日志: Beginning configuration step: Stopping Server [if necessary] Ended configuration step: Stopping Server [if necessary] Beginning configuration step: Writing configuration file Ended configuration step: Writing configuration file Beginning configuration step: Updating firewall Adding firewall rule for MySQLss on port 3306. Successfully added firewall rule. Ended configuration step: Updating firewall Beginning configuration step: Adjusting Windows service [if necessary] Attempting to grant Network Service require filesystem permissions. Granted permissions. Adding new service New service added Ended configuration step: Adjusting Windows service [if necessary] Beginning configuration step: Initializing Database [if necessary] Deleting Data folder shipped Attempting to run MySQL Server with --Initialize-insecure Running process: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console Waiting for the server stops: C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --initialize-insecure=on --console 2017-04-01T00:30:05.834747Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-04-01T00:30:05.834747Z 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. 2017-04-01T00:30:06.346757Z 0 [ERROR] InnoDB: Operating system error number 87 in a file operation. 2017-04-01T00:30:06.346757Z 0 [ERROR] InnoDB: File .\ib_logfile101: 'aio write' returned OS error 187. Cannot continue operation 2017-04-01T00:30:06.346757Z 0 [ERROR] InnoDB: Cannot continue operation. The attempt to initialize the database Failed Ended configuration step: Initializing Database [if necessary] Beginning configuration step: Starting Server Starting MySQL a
求助一个关于mysql复制的问题
各位大神好: 小弟是个新人,接手一个现有系统的维护,因想弄套测试环境想把正在使用的mysql数据库在另一台机器上复制一个,倒腾半天无法成功,求大神答惑。 背景:原服务器是windows2003系统,新服务器的系统相同。 1.首先在新服务上安装了一个mysql数据库,由于不了解原来的数据库配置所以瞎配置了一通, 也就是在运行MySQLInstanceConfig.exe的时候选择的内容可能跟原来的不同。 2.将目标服务器上的mysql通过net stop mysql命令关闭掉了,进程中已无mysql 3.将源服务器中的Mysql文件夹和Mysql_Data文件夹直接拷贝到对应的目标服务器的对应文件夹中,覆盖原来的所有文件。 4.修改my.ini文件,将basedir=修改为目标服务中Mysql文件夹的路径,datadir=修改为目标服务器中的Mysql_Data/Data的路径。 5.运行 net start mysql **出现如下提示:** ``` MySQL 服务正在启动 ... MySQL 服务无法启动。 系统出错。 发生系统错误 1067. 进程意外终止。 ``` **6.查看Mysql_Data\data 目录下的err文件发现如下内容:** ``` 150120 15:37:32 [Note] Plugin 'FEDERATED' is disabled. 150120 15:37:33 InnoDB: Initializing buffer pool, size = 2.0G 150120 15:37:37 InnoDB: Completed initialization of buffer pool 150120 15:37:37 InnoDB: Operating system error number 21 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html InnoDB: File name E:\MySQL-Data\ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation. ``` 以上为全部的操作,求大神解答如何mysql数据库无法启动了,我应该怎么处理,谢谢。
mysql服务启动报错1607 求助大神!
错误日志: InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 160817 17:41:01 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 160817 17:41:02 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 160817 17:41:02 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 160817 17:41:03 InnoDB: Started; log sequence number 0 0 160817 17:41:03 [Note] E:\mysqlserver\bin\mysqld-nt: ready for connections. Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 160826 16:38:33 [Note] E:\mysqlserver\bin\mysqld-nt: Normal shutdown 160826 16:38:35 InnoDB: Starting shutdown... 160826 16:38:38 InnoDB: Shutdown completed; log sequence number 0 133556 160826 16:38:38 [Note] E:\mysqlserver\bin\mysqld-nt: Shutdown complete 160826 16:40:24 InnoDB: Started; log sequence number 0 133556 160826 16:40:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 17:28:58 InnoDB: Started; log sequence number 0 133556 160827 17:28:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:25:59 InnoDB: Started; log sequence number 0 133556 160827 19:25:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:26:03 InnoDB: Started; log sequence number 0 133556 160827 19:26:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:26:07 InnoDB: Started; log sequence number 0 133556 160827 19:26:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:32:24 InnoDB: Started; log sequence number 0 133556 160827 19:32:24 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:36:18 InnoDB: Started; log sequence number 0 133556 160827 19:36:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:37:25 InnoDB: Started; log sequence number 0 133556 160827 19:37:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:40:55 InnoDB: Started; log sequence number 0 133556 160827 19:40:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 160827 19:50:49 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 160827 19:50:49 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 160827 19:50:50 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 160827 19:50:50 InnoDB: Started; log sequence number 0 0 160827 19:50:50 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:50:55 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 160827 19:50:55 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 160827 19:50:55 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 160827 19:50:56 InnoDB: Started; log sequence number 0 43655 160827 19:50:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 19:58:23 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 160827 19:58:23 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 160827 19:58:23 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 160827 19:58:24 InnoDB: Started; log sequence number 0 43655 160827 19:58:24 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 160827 20:00:24 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 160827 20:00:24 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 160827 20:00:24 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 160827 20:00:25 InnoDB: Started; log sequence number 0 0 160827 20:00:25 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 20:01:54 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 160827 20:01:54 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 160827 20:01:54 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 160827 20:01:55 InnoDB: Started; log sequence number 0 43655 160827 20:01:55 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 20:02:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 160827 20:02:09 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 160827 20:02:09 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 160827 20:02:10 InnoDB: Started; log sequence number 0 43655 160827 20:02:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 160827 21:37:52 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 160827 21:37:52 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 36808. InnoDB: Doing recovery: scanned up to log sequence number 0 43655 160827 21:37:52 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 160827 21:37:52 InnoDB: Started; log sequence number 0 43655 160827 21:37:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
wampserver安装好后mysql启动不了(内有mysql日志 ),求大神帮忙!
170319 12:23:55 [Note] Plugin 'FEDERATED' is disabled. 170319 12:23:55 InnoDB: The InnoDB memory heap is disabled 170319 12:23:55 InnoDB: Mutexes and rw_locks use Windows interlocked functions 170319 12:23:55 InnoDB: Compressed tables use zlib 1.2.3 170319 12:23:55 InnoDB: Initializing buffer pool, size = 128.0M 170319 12:23:55 InnoDB: Completed initialization of buffer pool 170319 12:23:55 InnoDB: highest supported file format is Barracuda. 170319 12:23:55 InnoDB: Operating system error number 87 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html InnoDB: File name .\ib_logfile0 InnoDB: File operation call: 'aio read'. InnoDB: Cannot continue operation.
【mysql不能登陆root】
mysql无法登陆root: ``` ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ``` 查了一下,删掉data文件夹下和数据库无关的文件,在my-default.ini中加上'skip-grant-tables'选项,跳过密码登陆依然失败,加tmpdir路径也不可以; ``` PS C:\Program Files\MySQL\MySQL Server 5.6\bin> mysqld --skip-grant-tables 2019-10-21 14:48:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-10-21 14:48:07 4416 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.6\data\DESKTOP-FVGQVE8.lower-test 2019-10-21 14:48:07 4416 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.6\data\DESKTOP-FVGQVE8.lower-test 2019-10-21 14:48:07 4416 [Note] Plugin 'FEDERATED' is disabled. 2019-10-21 14:48:07 4416 [Note] InnoDB: The InnoDB memory heap is disabled 2019-10-21 14:48:07 4416 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2019-10-21 14:48:07 4416 [Note] InnoDB: Compressed tables use zlib 1.2.3 2019-10-21 14:48:07 4416 [Note] InnoDB: CPU does not support crc32 instructions 2019-10-21 14:48:07 4416 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2019-10-21 14:48:07 4416 [Note] InnoDB: Completed initialization of buffer pool 2019-10-21 14:48:07 32d4 InnoDB: Operating system error number 5 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. It may also be you have created a subdirectory InnoDB: of the same name as a data file. 2019-10-21 14:48:07 32d4 InnoDB: File name .\ibdata1 2019-10-21 14:48:07 32d4 InnoDB: File operation call: 'create' returned OS error 105. 2019-10-21 14:48:07 32d4 InnoDB: Cannot continue operation. ``` 这是配置文件: ``` [mysqld] explicit_defaults_for_timestamp=true tmpdir="C:/Program Files/MySQL Server 5.6/temp/" skip-grant-tables old_passwords=0 # 设置3306端口 port=3306 # 设置mysql的安装目录 basedir="C:/Program Files/MySQL/MySQL Server 5.6 "# 设置mysql数据库的数据的存放目录 datadir="C:/Program Files/MySQL/MySQL Server 5.6/data "# 允许最大连接数 max_connections=200 # 允许连接失败的次数 max_connect_errors=10 # 服务端使用的字符集默认为UTF8 character-set-server=utf8 # 创建新表时将使用的默认存储引擎 default-storage-engine=MYISAM # 默认使用“mysql_native_password”插件认证 #mysql_native_password default_authentication_plugin=mysql_native_password [mysql] # 设置mysql客户端默认字符集 default-character-set=utf8 # 设置mysql客户端连接服务端时默认使用的端口 port=3306 default-character-set=utf8 innodb_buffer_pool_size=32M innodb_force_recovery = 1 ``` 请大神解答这是什么问题?
windows下部署mysql集群,sql节点连接不上?
C:\Users\Administrator>c:\mysql\bin\mysqld.exe --ndbcluster --ndb-connectstring= 172.22.41.111 --console 2018-11-01T07:49:22.719053Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc umentation for more details). 2018-11-01T07:49:22.719053Z 0 [Note] --secure-file-priv is set to NULL. Operatio ns related to importing and exporting data are disabled 2018-11-01T07:49:22.720053Z 0 [Note] c:\mysql\bin\mysqld.exe (mysqld 5.7.23-ndb- 7.6.7-cluster-gpl) starting as process 19948 ... 2018-11-01T07:49:22.731054Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows in terlocked functions 2018-11-01T07:49:22.732054Z 0 [Note] InnoDB: Uses event mutexes 2018-11-01T07:49:22.733054Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u sed for memory barrier 2018-11-01T07:49:22.733054Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-11-01T07:49:22.733054Z 0 [Note] InnoDB: Number of pools: 1 2018-11-01T07:49:22.734054Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2018-11-01T07:49:22.739054Z 0 [Note] InnoDB: Initializing buffer pool, total siz e = 128M, instances = 1, chunk size = 128M 2018-11-01T07:49:22.756055Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-11-01T07:49:22.771056Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat a1' must be writable 2018-11-01T07:49:22.772056Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat a1' must be writable 2018-11-01T07:49:22.773056Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2018-11-01T07:49:23.073073Z 0 [ERROR] Plugin 'InnoDB' init function returned err or. 2018-11-01T07:49:23.073073Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2018-11-01T07:49:23.073073Z 0 [ERROR] Failed to initialize builtin plugins. 2018-11-01T07:49:23.074073Z 0 [ERROR] Aborting 2018-11-01T07:49:23.074073Z 0 [Note] Binlog end 2018-11-01T07:49:23.075074Z 0 [Note] Shutting down plugin 'CSV' 2018-11-01T07:49:23.075074Z 0 [Note] c:\mysql\bin\mysqld.exe: Shutdown complete C:\Users\Administrator>
MySql服务启动不了,网上找不到类似的解决方法
错误日志如下: 151124 10:17:17 [Note] Plugin 'FEDERATED' is disabled. 151124 10:17:17 InnoDB: Initializing buffer pool, size = 107.0M 151124 10:17:17 InnoDB: Completed initialization of buffer pool 151124 10:17:17 InnoDB: Started; log sequence number 0 44556 151124 10:17:17 [ERROR] Aborting 151124 10:17:17 InnoDB: Starting shutdown... 151124 10:17:23 InnoDB: Shutdown completed; log sequence number 0 44556 151124 10:17:23 [Note] E:\MySQL\bin\mysqld: Shutdown complete
急求关于mysql数据库自动停止的问题
数据库:mysql5.6.17 OS: 2008SERVER 32位 业务正在运行,突然数据库就自动停止服务了,日志如下: 2016-12-03 11:14:06 4860 [ERROR] Can't create thread to handle request (errno= 12) 2016-12-03 11:15:25 4860 [ERROR] InnoDB: InnoDB: Unable to allocate memory of size 1065016. 2016-12-03 11:15:25 1398 InnoDB: Assertion failure in thread 5016 in file ha_innodb.cc line 17080 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.6/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2016-12-03 11:15:39 4860 [ERROR] Error log throttle: 7 'Can't create thread to handle new connection' error(s) suppressed 2016-12-03 11:15:39 4860 [ERROR] Can't create thread to handle request (errno= 12) 2016-12-03 11:16:40 4860 [ERROR] Error log throttle: 963 'Can't create thread to handle new connection' error(s) suppressed 2016-12-03 11:16:40 4860 [ERROR] Can't create thread to handle request (errno= 12) 2016-12-03 11:18:00 5108 [Note] Plugin 'FEDERATED' is disabled. 2016-12-03 11:18:00 171c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2016-12-03 11:18:00 5108 [Note] InnoDB: Using atomics to ref count buffer pool pages 2016-12-03 11:18:00 5108 [Note] InnoDB: The InnoDB memory heap is disabled 2016-12-03 11:18:00 5108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-12-03 11:18:00 5108 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-12-03 11:18:00 5108 [Note] InnoDB: Not using CPU crc32 instructions 2016-12-03 11:18:00 5108 [Note] InnoDB: Initializing buffer pool, size = 823.0M 2016-12-03 11:18:00 5108 [Note] InnoDB: Completed initialization of buffer pool 2016-12-03 11:18:00 5108 [Note] InnoDB: Highest supported file format is Barracuda. 2016-12-03 11:18:00 5108 [Note] InnoDB: Log scan progressed past the checkpoint lsn 37892781681 2016-12-03 11:18:00 5108 [Note] InnoDB: Database was not shutdown normally! 2016-12-03 11:18:00 5108 [Note] InnoDB: Starting crash recovery. 2016-12-03 11:18:00 5108 [Note] InnoDB: Reading tablespace information from the .ibd files... 2016-12-03 11:18:04 5108 [Note] InnoDB: Restoring possible half-written data pages 2016-12-03 11:18:04 5108 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 37893927335 InnoDB: 6 transaction(s) which must be rolled back or cleaned up InnoDB: in total 63 row operations to undo InnoDB: Trx id counter is 12591616 2016-12-03 11:18:05 5108 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 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 InnoDB: Apply batch completed 2016-12-03 11:18:06 5108 [Note] InnoDB: 128 rollback segment(s) are active. InnoDB: Starting in background the rollback of uncommitted transactions 我挂了五个tomcat搭载了nginx 。大约有100个客户端会频繁访问。想着应该没问题,但是连续两天数据库突然停止,急求大神帮忙解决,谢谢!
centos虚拟机重启后,MySQL服务启动不了了,求解?
#MySQL版本5.1.73 贴出日志如下: 170808 23:02:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170808 23:02:19 InnoDB: Initializing buffer pool, size = 8.0M 170808 23:02:19 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 170808 23:02:19 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 170808 23:02:19 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 170808 23:02:19 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 170808 23:02:19 InnoDB: Started; log sequence number 0 0 170808 23:02:19 [Note] Event Scheduler: Loaded 0 events 170808 23:02:19 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 170809 5:21:42 [Note] /usr/libexec/mysqld: Normal shutdown 170809 5:21:42 [Note] Event Scheduler: Purging the queue. 0 events 170809 5:21:42 InnoDB: Starting shutdown... 170809 5:21:45 InnoDB: Shutdown completed; log sequence number 0 89508 170809 5:21:45 [Note] /usr/libexec/mysqld: Shutdown complete 170809 05:21:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170810 18:53:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170810 18:53:14 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. /usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file 170810 18:53:14 [ERROR] Aborting 170810 18:53:14 [Note] /usr/libexec/mysqld: Shutdown complete 170810 18:53:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170810 18:54:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170810 18:54:30 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. /usr/libexec/mysqld: Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file 170810 18:54:30 [ERROR] Aborting 170810 18:54:30 [Note] /usr/libexec/mysqld: Shutdown complete 170810 18:54:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended ``` ```
scrapy存到mysql查询无数据
## 1. 问题描述 尝试使用scrapy框架爬取网站,将爬取的数据存储到mysql数据库,执行完毕之后没有报错,但是我查询数据时,显示没有数据 (代码框架参考使用该博主代码尝试运行: https://www.cnblogs.com/fromlantianwei/p/10607956.html) ## 2. 部分截图 1. scrapy项目: ![图片说明](https://img-ask.csdn.net/upload/202003/04/1583310103_446281.png) 数据库创建: ![图片说明](https://img-ask.csdn.net/upload/202003/04/1583310345_774265.png) ##3. 相关代码 scrapy框架代码: (1)tencent爬虫文件 ``` # -*- coding: utf-8 -*- import scrapy from urllib import parse import re from copy import deepcopy from ScrapyPro3.items import ScrapyPro3Item class tencentSpider(scrapy.Spider): name = 'tencent' allowed_domains = [] start_urls = [ 'http://tieba.baidu.com/mo/q----,sz@320_240-1-3---2/m?kw=%E6%A1%82%E6%9E%97%E7%94%B5%E5%AD%90%E7%A7%91%E6%8A%80%E5%A4%A7%E5%AD%A6%E5%8C%97%E6%B5%B7%E6%A0%A1%E5%8C%BA&pn=26140', ] def parse(self, response): # 总页面 item = ScrapyPro3Item() all_elements = response.xpath(".//div[@class='i']") # print(all_elements) for all_element in all_elements: content = all_element.xpath("./a/text()").extract_first() content = "".join(content.split()) change = re.compile(r'[\d]+.') content = change.sub('', content) item['comment'] = content person = all_element.xpath("./p/text()").extract_first() person = "".join(person.split()) # 去掉点赞数 评论数 change2 = re.compile(r'点[\d]+回[\d]+') person = change2.sub('', person) # 选择日期 change3 = re.compile(r'[\d]?[\d]?-[\d][\d](?=)') date = change3.findall(person) # 如果为今天则选择时间 change4 = re.compile(r'[\d]?[\d]?:[\d][\d](?=)') time = change4.findall(person) person = change3.sub('', person) person = change4.sub('', person) if time == []: item['time'] = date else: item['time'] = time item['name'] = person # 增加密码 活跃 item['is_active'] = '1' item['password'] = '123456' print(item) yield item # 下一页 """next_url = 'http://tieba.baidu.com/mo/q----,sz@320_240-1-3---2/' + parse.unquote( response.xpath(".//div[@class='bc p']/a/@href").extract_first()) print(next_url) yield scrapy.Request( next_url, callback=self.parse, )""" ``` (2)item文件 ``` # -*- coding: utf-8 -*- # Define here the models for your scraped items # # See documentation in: # https://doc.scrapy.org/en/latest/topics/items.html import scrapy class ScrapyPro3Item(scrapy.Item): # define the fields for your item here like: # name = scrapy.Field() comment = scrapy.Field() time = scrapy.Field() name = scrapy.Field() password = scrapy.Field() is_active = scrapy.Field() ``` (3)pipelines文件 # -*- coding: utf-8 -*- # Define your item pipelines here # # Don't forget to add your pipeline to the ITEM_PIPELINES setting # See: https://docs.scrapy.org/en/latest/topics/item-pipeline.html """class Scrapypro3Pipeline(object): def process_item(self, item, spider): return item""" import pymysql from twisted.enterprise import adbapi class Scrapypro3Pipeline(object): def __init__(self, dbpool): self.dbpool = dbpool @classmethod def from_settings(cls, settings): # 函数名固定,会被scrapy调用,直接可用settings的值 """ 数据库建立连接 :param settings: 配置参数 :return: 实例化参数 """ adbparams = dict( host='localhost', db='mu_ke', user='root', password='root', cursorclass=pymysql.cursors.DictCursor # 指定cursor类型 ) # 连接数据池ConnectionPool,使用pymysql或者Mysqldb连接 dbpool = adbapi.ConnectionPool('pymysql', **adbparams) # 返回实例化参数 return cls(dbpool) def process_item(self, item, spider): """ 使用twisted将MySQL插入变成异步执行。通过连接池执行具体的sql操作,返回一个对象 """ query = self.dbpool.runInteraction(self.do_insert, item) # 指定操作方法和操作数据 # 添加异常处理 query.addCallback(self.handle_error) # 处理异常 def do_insert(self, cursor, item): # 对数据库进行插入操作,并不需要commit,twisted会自动commit insert_sql = """ insert into login_person(name,password,is_active,comment,time) VALUES(%s,%s,%s,%s,%s) """ cursor.execute(insert_sql, (item['name'], item['password'], item['is_active'], item['comment'], item['time'])) def handle_error(self, failure): if failure: # 打印错误信息 print(failure)``` ``` (4) settings文件 ``` # -*- coding: utf-8 -*- # Scrapy settings for ScrapyPro3 project # # For simplicity, this file contains only settings considered important or # commonly used. You can find more settings consulting the documentation: # # https://doc.scrapy.org/en/latest/topics/settings.html # https://doc.scrapy.org/en/latest/topics/downloader-middleware.html # https://doc.scrapy.org/en/latest/topics/spider-middleware.html BOT_NAME = 'ScrapyPro3' SPIDER_MODULES = ['ScrapyPro3.spiders'] NEWSPIDER_MODULE = 'ScrapyPro3.spiders' # Crawl responsibly by identifying yourself (and your website) on the user-agent USER_AGENT = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.110 Safari/537.36' MYSQL_HOST = 'localhost' MYSQL_DBNAME = 'mu_ke' MYSQL_USER = 'root' MYSQL_PASSWD = 'root' # Obey robots.txt rules ROBOTSTXT_OBEY = False # Configure maximum concurrent requests performed by Scrapy (default: 16) #CONCURRENT_REQUESTS = 32 # Configure a delay for requests for the same website (default: 0) # See https://doc.scrapy.org/en/latest/topics/settings.html#download-delay # See also autothrottle settings and docs #DOWNLOAD_DELAY = 3 # The download delay setting will honor only one of: #CONCURRENT_REQUESTS_PER_DOMAIN = 16 #CONCURRENT_REQUESTS_PER_IP = 16 # Disable cookies (enabled by default) #COOKIES_ENABLED = False # Disable Telnet Console (enabled by default) #TELNETCONSOLE_ENABLED = False # Override the default request headers: #DEFAULT_REQUEST_HEADERS = { # 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8', # 'Accept-Language': 'en', #} # Enable or disable spider middlewares # See https://doc.scrapy.org/en/latest/topics/spider-middleware.html #SPIDER_MIDDLEWARES = { # 'ScrapyPro3.middlewares.ScrapyPro3SpiderMiddleware': 543, #} # Enable or disable downloader middlewares # See https://doc.scrapy.org/en/latest/topics/downloader-middleware.html #DOWNLOADER_MIDDLEWARES = { # 'ScrapyPro3.middlewares.ScrapyPro3DownloaderMiddleware': 543, #} # Enable or disable extensions # See https://doc.scrapy.org/en/latest/topics/extensions.html #EXTENSIONS = { # 'scrapy.extensions.telnet.TelnetConsole': None, #} # Configure item pipelines # See https://doc.scrapy.org/en/latest/topics/item-pipeline.html ITEM_PIPELINES = { 'ScrapyPro3.pipelines.Scrapypro3Pipeline':200, } # Enable and configure the AutoThrottle extension (disabled by default) # See https://doc.scrapy.org/en/latest/topics/autothrottle.html #AUTOTHROTTLE_ENABLED = True # The initial download delay #AUTOTHROTTLE_START_DELAY = 5 # The maximum download delay to be set in case of high latencies #AUTOTHROTTLE_MAX_DELAY = 60 # The average number of requests Scrapy should be sending in parallel to # each remote server #AUTOTHROTTLE_TARGET_CONCURRENCY = 1.0 # Enable showing throttling stats for every response received: #AUTOTHROTTLE_DEBUG = False # Enable and configure HTTP caching (disabled by default) # See https://doc.scrapy.org/en/latest/topics/downloader-middleware.html#httpcache-middleware-settings #HTTPCACHE_ENABLED = True #HTTPCACHE_EXPIRATION_SECS = 0 #HTTPCACHE_DIR = 'httpcache' #HTTPCACHE_IGNORE_HTTP_CODES = [] #HTTPCACHE_STORAGE = 'scrapy.extensions.httpcache.FilesystemCacheStorage' ``` (5)start文件——执行爬虫文件 ``` from scrapy import cmdline cmdline.execute(["scrapy","crawl","tencent"]) ``` 数据库创建代码: ``` create database mu_ke; CREATE TABLE `login_person` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `passsword` varchar(100) DEFAULT NULL, `is_active` varchar(100) DEFAULT NULL, `comment` varchar(100) DEFAULT NULL, `time` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1181 DEFAULT CHARSET=utf8; select count(name) from login_person;#查询结果条数为0 ``` # 运行完代码后查询数据,显示条数为0,这里面有什么问题吗? (1) 执行过程正常 (2)运行 pycharm2019.3 python3.8 mysql8.0(workbench8.0) (3) 数据连接没有
服务器断电后mysql无法启动
因意外导致服务器断电,重启后发现mysql起不来了 ``` [root@cacti ~]# service mysqld restart 停止 mysqld: [确定] MySQL Daemon failed to start. 正在启动 mysqld: [失败] ``` 查看日志: ``` [root@cacti ~]# tail -100 /var/log/mysqld.log 150520 12:21:12 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150520 12:21:12 InnoDB: Initializing buffer pool, size = 8.0M 150520 12:21:12 InnoDB: Completed initialization of buffer pool InnoDB: Log scan progressed past the checkpoint lsn 2 1552263436 150520 12:21:12 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 150520 12:21:12 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 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 InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 206. InnoDB: You may have to recover from a backup. 150520 12:21:12 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex cc507667000000ce0000000000000000000000025cabb0bc000200000000000000000000000000021e751eb0ffffffff0000ffffffff000000021dbb0000000000000002123200000001000000ce002c000000ce002c000000000304a196000000000304a1970001011000000000000000000000014....... .... .... .... oDB: End of page dump 150520 12:21:12 InnoDB: Page checksum 3392922109, prior-to-4.0.14-form checksum 1831220034 InnoDB: stored checksum 3427825255, prior-to-4.0.14-form stored checksum 2455963898 InnoDB: Page lsn 2 1554755772, low 4 bytes of lsn at page end 1556408857 InnoDB: Page number (if stored to page already) 206, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0 InnoDB: Page may be an update undo log page InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 206. InnoDB: You may have to recover from a backup. InnoDB: It is also possible that your operating InnoDB: system has corrupted its own file cache InnoDB: and rebooting your computer removes the InnoDB: error. InnoDB: If the corrupt page is an index page InnoDB: you can also try to fix the corruption InnoDB: by dumping, dropping, and reimporting InnoDB: the corrupt table. You can use CHECK InnoDB: TABLE to scan your table for corruption. InnoDB: See also http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. InnoDB: Ending processing because of a corrupt database page. 150520 12:21:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended ``` mysql新手一个,希望大家能帮帮忙分析下,谢谢!
Window2008 MYSQL 挂了
InnoDB: Operating system error number 23 in a file operation
mysql经常挂掉,重启主机就好了
# mysq日志 > 141211 10:50:25 mysqld_safe Starting mysqld daemon with databases from /alidata/server/mysql/data > 141211 10:50:26 [Note] Plugin 'FEDERATED' is disabled. > 141211 10:50:26 InnoDB: The InnoDB memory heap is disabled > 141211 10:50:26 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 141211 10:50:26 InnoDB: Compressed tables use zlib 1.2.3 > 141211 10:50:26 InnoDB: Using Linux native AIO > 141211 10:50:26 InnoDB: Initializing buffer pool, size = 128.0M > 141211 10:50:26 InnoDB: Completed initialization of buffer pool > 141211 10:50:26 InnoDB: highest supported file format is Barracuda. > InnoDB: The log sequence number in ibdata files does not match > InnoDB: the log sequence number in the ib_logfiles! > 141211 10:50:26 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 141211 10:50:27 InnoDB: Waiting for the background threads to start > 141211 10:50:28 InnoDB: 5.5.37 started; log sequence number 1595675 > 141211 10:50:28 [Note] Recovering after a crash using mysql-bin > 141211 10:50:28 [Note] Starting crash recovery... > 141211 10:50:28 [Note] Crash recovery finished. > 141211 10:50:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 > 141211 10:50:28 [Note] - '0.0.0.0' resolves to '0.0.0.0'; > 141211 10:50:28 [Note] Server socket created on IP: '0.0.0.0'. > 141211 10:50:28 [Note] Event Scheduler: Loaded 0 events > 141211 10:50:28 [Note] /alidata/server/mysql/bin/mysqld: ready for connections. > Version: '5.5.37-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) > 141211 10:53:25 [Note] /alidata/server/mysql/bin/mysqld: Normal shutdown > > 141211 10:53:25 [Note] Event Scheduler: Purging the queue. 0 events > 141211 10:53:25 InnoDB: Starting shutdown... > 141211 10:53:26 InnoDB: Shutdown completed; log sequence number 1595675 > 141211 10:53:26 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete > > 141211 10:53:26 mysqld_safe mysqld from pid file /alidata/server/mysql/data/iZ280q00p7cZ.pid ended > 141211 10:57:45 mysqld_safe Starting mysqld daemon with databases from /alidata/server/mysql/data > 141211 10:57:46 [Note] Plugin 'FEDERATED' is disabled. > 141211 10:57:46 InnoDB: The InnoDB memory heap is disabled > 141211 10:57:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 141211 10:57:46 InnoDB: Compressed tables use zlib 1.2.3 > 141211 10:57:46 InnoDB: Using Linux native AIO > 141211 10:57:46 InnoDB: Initializing buffer pool, size = 128.0M > 141211 10:57:46 InnoDB: Completed initialization of buffer pool > 141211 10:57:46 InnoDB: highest supported file format is Barracuda. > 141211 10:57:46 InnoDB: Waiting for the background threads to start > 141211 10:57:47 InnoDB: 5.5.37 started; log sequence number 1595675 > 141211 10:57:47 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 > 141211 10:57:47 [Note] - '0.0.0.0' resolves to '0.0.0.0'; > 141211 10:57:47 [Note] Server socket created on IP: '0.0.0.0'. > 141211 10:57:47 [Note] Event Scheduler: Loaded 0 events > 141211 10:57:47 [Note] /alidata/server/mysql/bin/mysqld: ready for connections. > Version: '5.5.37-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) > 141213 21:56:24 [Warning] IP address '42.156.250.117' could not be resolved: Name or service not known > 141215 0:09:33 [Warning] IP address '107.150.52.84' could not be resolved: Name or service not known > 141215 2:23:23 [Warning] IP address '114.113.55.141' could not be resolved: Name or service not known > 141215 16:43:01 [Warning] IP address '61.156.44.98' could not be resolved: Name or service not known > 141216 21:56:28 [Warning] IP address '42.120.142.220' could not be resolved: Name or service not known > 141217 11:07:01 mysqld_safe Number of processes running now: 0 > 141217 11:07:01 mysqld_safe mysqld restarted > 141217 11:07:01 [Note] Plugin 'FEDERATED' is disabled. > 141217 11:07:01 InnoDB: The InnoDB memory heap is disabled > 141217 11:07:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 141217 11:07:01 InnoDB: Compressed tables use zlib 1.2.3 > 141217 11:07:01 InnoDB: Using Linux native AIO > 141217 11:07:01 InnoDB: Initializing buffer pool, size = 128.0M > InnoDB: mmap(137363456 bytes) failed; errno 12 > 141217 11:07:01 InnoDB: Completed initialization of buffer pool > 141217 11:07:01 InnoDB: Fatal error: cannot allocate memory for the buffer pool > 141217 11:07:01 [ERROR] Plugin 'InnoDB' init function returned error. > 141217 11:07:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. > 141217 11:07:01 [ERROR] Unknown/unsupported storage engine: InnoDB > 141217 11:07:01 [ERROR] Aborting > > 141217 11:07:01 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete > > 141217 11:07:01 mysqld_safe mysqld from pid file /alidata/server/mysql/data/iZ280q00p7cZ.pid ended > 141217 11:09:15 mysqld_safe Starting mysqld daemon with databases from /alidata/server/mysql/data > 141217 11:09:15 [Note] Plugin 'FEDERATED' is disabled. > 141217 11:09:15 InnoDB: The InnoDB memory heap is disabled > 141217 11:09:15 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 141217 11:09:15 InnoDB: Compressed tables use zlib 1.2.3 > 141217 11:09:15 InnoDB: Using Linux native AIO > 141217 11:09:15 InnoDB: Initializing buffer pool, size = 128.0M > InnoDB: mmap(137363456 bytes) failed; errno 12 > 141217 11:09:15 InnoDB: Completed initialization of buffer pool > 141217 11:09:15 InnoDB: Fatal error: cannot allocate memory for the buffer pool > 141217 11:09:15 [ERROR] Plugin 'InnoDB' init function returned error. > 141217 11:09:15 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. > 141217 11:09:15 [ERROR] Unknown/unsupported storage engine: InnoDB > 141217 11:09:15 [ERROR] Aborting > > 141217 11:09:15 [Note] /alidata/server/mysql/bin/mysqld: Shutdown complete > > 141217 11:09:15 mysqld_safe mysqld from pid file /alidata/server/mysql/data/iZ280q00p7cZ.pid ended
mysql5.5 win10 提示1067
>D:\cs_app\mysql\mysql-5.5.40-winx64\bin>mysqld --console >170415 16:33:05 [Warning] Can't create test file D:\cs_app\mysql\mysql-5.5.40-winx64\data\??.lower-test >170415 16:33:05 [Warning] Can't create test file D:\cs_app\mysql\mysql-5.5.40-winx64\data\??.lower-test >170415 16:33:05 [Note] Plugin 'FEDERATED' is disabled. >170415 16:33:05 InnoDB: The InnoDB memory heap is disabled >170415 16:33:05 InnoDB: Mutexes and rw_locks use Windows interlocked functions >170415 16:33:05 InnoDB: Compressed tables use zlib 1.2.3 >170415 16:33:05 InnoDB: Initializing buffer pool, size = 128.0M >170415 16:33:05 InnoDB: Completed initialization of buffer pool >170415 16:33:05 InnoDB: highest supported file format is Barracuda. >170415 16:33:05 InnoDB: Waiting for the background threads to start >170415 16:33:06 InnoDB: 5.5.40 started; log sequence number 1595675 >170415 16:33:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 >170415 16:33:06 [Note] - '0.0.0.0' resolves to '0.0.0.0'; >170415 16:33:06 [Note] Server socket created on IP: '0.0.0.0'. >170415 16:33:06 [ERROR] mysqld: Can't create/write to file 'D:\cs_app\mysql\mysql-5.5.40-winx64\data\??.pid' (Errcode: 22) >170415 16:33:06 [ERROR] Can't start server: can't create PID file: Invalid argument my.ini [mysqld] basedir=D:\\cs_app\\mysql\\mysql-5.5.40-winx64 datadir=D:\\cs_app\\mysql\\mysql-5.5.40-winx64\\data character_set_server=utf8 [client] character_set_server=utf8 [WinMySQLAdmin] Server=D:\\cs_app\\mysql\\mysql-5.5.40-winx64\\bin\\mysqld.exe user=root 被卡了一天 。。。 你们怎么看?
MySQL 连接不到libmysqllib
``` #define _CRT_SECURE_NO_WARNINGS #include <windows.h> #include <stdio.h> #include <stdlib.h> #include <string.h> #include <mysql.h> #include <iostream> #pragma comment(lib,"libmysql64.lib")//连接MysQL需要的库 #pragma comment(lib,"libmysql.lib")//连接MysQL需要的库 using namespace std; int main() { const char user[] = "VISUAL_STUDIO1"; //username const char pswd[] = "ligh123456789"; //password const char host[] = "118.192.151.230"; //or"127.0.0.1" const char table[] = "testdb"; //database unsigned int port = 3306; //server port MYSQL myCont; MYSQL_RES *result; MYSQL_ROW sql_row; MYSQL_FIELD *fd; char column[32][32]; int res; mysql_init(&myCont); if (mysql_real_connect(&myCont, host, user, pswd, table, port, NULL, 0)) { cout << "connect succeed!" << endl; mysql_query(&myCont, "SET NAMES GBK"); //设置编码格式,否则在cmd下无法显示中文 res = mysql_query(&myCont, "select * from uc");//查询 if (!res) { result = mysql_store_result(&myCont);//保存查询到的数据到result if (result) { int i, j; cout << "number of result: " << (unsigned long)mysql_num_rows(result) << endl; for (i = 0; fd = mysql_fetch_field(result); i++)//获取列名 { strcpy(column[i], fd->name); } j = mysql_num_fields(result); for (i = 0; i<j; i++) { printf("%s\t", column[i]); } printf("\n"); while (sql_row = mysql_fetch_row(result))//获取具体的数据 { for (i = 0; i<j; i++) { printf("%s\n", sql_row[i]); } printf("\n"); } } } else { cout << "query sql failed!" << endl; } } else { cout << "connect failed!" << endl; } if (result != NULL) mysql_free_result(result);//释放结果资源 mysql_close(&myCont);//断开连接 return 0; } ``` 为什么运行结果会有这个:::::: 错误 1 error LNK1104: 无法打开文件“libmysql64.lib” d:\用户目录\我的文档\Visual Studio 2013\Projects\MySQL\MySQL\LINK
大学四年自学走来,这些私藏的实用工具/学习网站我贡献出来了
大学四年,看课本是不可能一直看课本的了,对于学习,特别是自学,善于搜索网上的一些资源来辅助,还是非常有必要的,下面我就把这几年私藏的各种资源,网站贡献出来给你们。主要有:电子书搜索、实用工具、在线视频学习网站、非视频学习网站、软件下载、面试/求职必备网站。 注意:文中提到的所有资源,文末我都给你整理好了,你们只管拿去,如果觉得不错,转发、分享就是最大的支持了。 一、电子书搜索 对于大部分程序员...
在中国程序员是青春饭吗?
今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...
《MySQL 性能优化》之理解 MySQL 体系结构
本文介绍 MySQL 的体系结构,包括物理结构、逻辑结构以及插件式存储引擎。
python自动下载图片
近日闲来无事,总有一种无形的力量萦绕在朕身边,让朕精神涣散,昏昏欲睡。 可是,像朕这么有职业操守的社畜怎么能在上班期间睡瞌睡呢,我不禁陷入了沉思。。。。 突然旁边的IOS同事问:‘嘿,兄弟,我发现一个网站的图片很有意思啊,能不能帮我保存下来提升我的开发灵感?’ 作为一个坚强的社畜怎么能说自己不行呢,当时朕就不假思索的答应:‘oh, It’s simple. Wait for me for a ...
一名大专同学的四个问题
【前言】   收到一封来信,赶上各种事情拖了几日,利用今天要放下工作的时机,做个回复。   2020年到了,就以这一封信,作为开年标志吧。 【正文】   您好,我是一名现在有很多困惑的大二学生。有一些问题想要向您请教。   先说一下我的基本情况,高考失利,不想复读,来到广州一所大专读计算机应用技术专业。学校是偏艺术类的,计算机专业没有实验室更不用说工作室了。而且学校的学风也不好。但我很想在计算机领...
复习一周,京东+百度一面,不小心都拿了Offer
京东和百度一面都问了啥,面试官百般刁难,可惜我全会。
达摩院十大科技趋势发布:2020 非同小可!
【CSDN编者按】1月2日,阿里巴巴发布《达摩院2020十大科技趋势》,十大科技趋势分别是:人工智能从感知智能向认知智能演进;计算存储一体化突破AI算力瓶颈;工业互联网的超融合;机器间大规模协作成为可能;模块化降低芯片设计门槛;规模化生产级区块链应用将走入大众;量子计算进入攻坚期;新材料推动半导体器件革新;保护数据隐私的AI技术将加速落地;云成为IT技术创新的中心 。 新的画卷,正在徐徐展开。...
轻松搭建基于 SpringBoot + Vue 的 Web 商城应用
首先介绍下在本文出现的几个比较重要的概念: 函数计算(Function Compute): 函数计算是一个事件驱动的服务,通过函数计算,用户无需管理服务器等运行情况,只需编写代码并上传。函数计算准备计算资源,并以弹性伸缩的方式运行用户代码,而用户只需根据实际代码运行所消耗的资源进行付费。Fun: Fun 是一个用于支持 Serverless 应用部署的工具,能帮助您便捷地管理函数计算、API ...
Python+OpenCV实时图像处理
目录 1、导入库文件 2、设计GUI 3、调用摄像头 4、实时图像处理 4.1、阈值二值化 4.2、边缘检测 4.3、轮廓检测 4.4、高斯滤波 4.5、色彩转换 4.6、调节对比度 5、退出系统 初学OpenCV图像处理的小伙伴肯定对什么高斯函数、滤波处理、阈值二值化等特性非常头疼,这里给各位分享一个小项目,可通过摄像头实时动态查看各类图像处理的特点,也可对各位调参、测试...
2020年一线城市程序员工资大调查
人才需求 一线城市共发布岗位38115个,招聘120827人。 其中 beijing 22805 guangzhou 25081 shanghai 39614 shenzhen 33327 工资分布 2020年中国一线城市程序员的平均工资为16285元,工资中位数为14583元,其中95%的人的工资位于5000到20000元之间。 和往年数据比较: yea...
为什么猝死的都是程序员,基本上不见产品经理猝死呢?
相信大家时不时听到程序员猝死的消息,但是基本上听不到产品经理猝死的消息,这是为什么呢? 我们先百度搜一下:程序员猝死,出现将近700多万条搜索结果: 搜索一下:产品经理猝死,只有400万条的搜索结果,从搜索结果数量上来看,程序员猝死的搜索结果就比产品经理猝死的搜索结果高了一倍,而且从下图可以看到,首页里面的五条搜索结果,其实只有两条才是符合条件。 所以程序员猝死的概率真的比产品经理大,并不是错...
害怕面试被问HashMap?这一篇就搞定了!
声明:本文以jdk1.8为主! 搞定HashMap 作为一个Java从业者,面试的时候肯定会被问到过HashMap,因为对于HashMap来说,可以说是Java集合中的精髓了,如果你觉得自己对它掌握的还不够好,我想今天这篇文章会非常适合你,至少,看了今天这篇文章,以后不怕面试被问HashMap了 其实在我学习HashMap的过程中,我个人觉得HashMap还是挺复杂的,如果真的想把它搞得明明白...
毕业5年,我问遍了身边的大佬,总结了他们的学习方法
我问了身边10个大佬,总结了他们的学习方法,原来成功都是有迹可循的。
python爬取百部电影数据,我分析出了一个残酷的真相
2019年就这么匆匆过去了,就在前几天国家电影局发布了2019年中国电影市场数据,数据显示去年总票房为642.66亿元,同比增长5.4%;国产电影总票房411.75亿元,同比增长8.65%,市场占比 64.07%;城市院线观影人次17.27亿,同比增长0.64%。 看上去似乎是一片大好对不对?不过作为一名严谨求实的数据分析师,我从官方数据中看出了一点端倪:国产票房增幅都已经高达8.65%了,为什...
推荐10个堪称神器的学习网站
每天都会收到很多读者的私信,问我:“二哥,有什么推荐的学习网站吗?最近很浮躁,手头的一些网站都看烦了,想看看二哥这里有什么新鲜货。” 今天一早做了个恶梦,梦到被老板辞退了。虽然说在我们公司,只有我辞退老板的份,没有老板辞退我这一说,但是还是被吓得 4 点多都起来了。(主要是因为我掌握着公司所有的核心源码,哈哈哈) 既然 4 点多起来,就得好好利用起来。于是我就挑选了 10 个堪称神器的学习网站,推...
这些软件太强了,Windows必装!尤其程序员!
Windows可谓是大多数人的生产力工具,集娱乐办公于一体,虽然在程序员这个群体中都说苹果是信仰,但是大部分不都是从Windows过来的,而且现在依然有很多的程序员用Windows。 所以,今天我就把我私藏的Windows必装的软件分享给大家,如果有一个你没有用过甚至没有听过,那你就赚了????,这可都是提升你幸福感的高效率生产力工具哦! 走起!???? NO、1 ScreenToGif 屏幕,摄像头和白板...
阿里面试,面试官没想到一个ArrayList,我都能跟他扯半小时
我是真的没想到,面试官会这样问我ArrayList。
曾经优秀的人,怎么就突然不优秀了。
职场上有很多辛酸事,很多合伙人出局的故事,很多技术骨干被裁员的故事。说来模板都类似,曾经是名校毕业,曾经是优秀员工,曾经被领导表扬,曾经业绩突出,然而突然有一天,因为种种原因,被裁员了,...
大学四年因为知道了这32个网站,我成了别人眼中的大神!
依稀记得,毕业那天,我们导员发给我毕业证的时候对我说“你可是咱们系的风云人物啊”,哎呀,别提当时多开心啦????,嗯,我们导员是所有导员中最帅的一个,真的???? 不过,导员说的是实话,很多人都叫我大神的,为啥,因为我知道这32个网站啊,你说强不强????,这次是绝对的干货,看好啦,走起来! PS:每个网站都是学计算机混互联网必须知道的,真的牛杯,我就不过多介绍了,大家自行探索,觉得没用的,尽管留言吐槽吧???? 社...
良心推荐,我珍藏的一些Chrome插件
上次搬家的时候,发了一个朋友圈,附带的照片中不小心暴露了自己的 Chrome 浏览器插件之多,于是就有小伙伴评论说分享一下我觉得还不错的浏览器插件。 我下面就把我日常工作和学习中经常用到的一些 Chrome 浏览器插件分享给大家,随便一个都能提高你的“生活品质”和工作效率。 Markdown Here Markdown Here 可以让你更愉快的写邮件,由于支持 Markdown 直接转电子邮...
看完这篇HTTP,跟面试官扯皮就没问题了
我是一名程序员,我的主要编程语言是 Java,我更是一名 Web 开发人员,所以我必须要了解 HTTP,所以本篇文章就来带你从 HTTP 入门到进阶,看完让你有一种恍然大悟、醍醐灌顶的感觉。 最初在有网络之前,我们的电脑都是单机的,单机系统是孤立的,我还记得 05 年前那会儿家里有个电脑,想打电脑游戏还得两个人在一个电脑上玩儿,及其不方便。我就想为什么家里人不让上网,我的同学 xxx 家里有网,每...
史上最全的IDEA快捷键总结
现在Idea成了主流开发工具,这篇博客对其使用的快捷键做了总结,希望对大家的开发工作有所帮助。
C++(数据结构与算法):62---搜索树(二叉搜索树、索引二叉搜索树)
一、搜索树的复杂度分析 本文考察二叉搜索树和索引二叉搜索树 二叉搜索树的渐进性能可以和跳表媲美: 查找、插入、删除操作所需的平均时间为Θ(logn) 查找、插入、删除操作的最坏情况的时间为Θ(n) 元素按升序输出时所需时间为Θ(n) 虽然在最坏情况下的查找、插入、删除操作,散列表和二叉搜索树的时间性能相同,但是散列表在最好的情况下具有超级性能Θ(1) 不过,对于一个指定的关键...
阿里程序员写了一个新手都写不出的低级bug,被骂惨了。
这种新手都不会范的错,居然被一个工作好几年的小伙子写出来,差点被当场开除了。
谁是华为扫地僧?
是的,华为也有扫地僧!2020年2月11-12日,“养在深闺人不知”的华为2012实验室扫地僧们,将在华为开发者大会2020(Cloud)上,和大家见面。到时,你可以和扫地僧们,吃一个洋...
AI 没让人类失业,搞 AI 的人先失业了
最近和几个 AI 领域的大佬闲聊 根据他们讲的消息和段子 改编出下面这个故事 如有雷同 都是巧合 1. 老王创业失败,被限制高消费 “这里写我跑路的消息实在太夸张了。” 王葱葱哼笑一下,把消息分享给群里。 阿杰也看了消息,笑了笑。在座几位也都笑了。 王葱葱是个有名的人物,21岁那年以全额奖学金进入 KMU 攻读人工智能博士,累计发表论文 40 余篇,个人技术博客更是成为深度学习领域内风向标。 ...
2020年,冯唐49岁:我给20、30岁IT职场年轻人的建议
点击“技术领导力”关注∆每天早上8:30推送 作者|Mr.K 编辑| Emma 来源|技术领导力(ID:jishulingdaoli) 前天的推文《冯唐:职场人35岁以后,方法论比经验重要》,收到了不少读者的反馈,觉得挺受启发。其实,冯唐写了不少关于职场方面的文章,都挺不错的。可惜大家只记住了“春风十里不如你”、“如何避免成为油腻腻的中年人”等不那么正经的文章。 本文整理了冯...
最全最强!世界大学计算机专业排名总结!
我正在参与CSDN200进20,希望得到您的支持,扫码续投票5次。感谢您! (为表示感谢,您投票后私信我,我把我总结的人工智能手推笔记和思维导图发送给您,感谢!) 目录 泰晤士高等教育世界大学排名 QS 世界大学排名 US News 世界大学排名 世界大学学术排名(Academic Ranking of World Universities) 泰晤士高等教育世界大学排名 中国共...
作为一名大学生,如何在B站上快乐的学习?
B站是个宝,谁用谁知道???? 作为一名大学生,你必须掌握的一项能力就是自学能力,很多看起来很牛X的人,你可以了解下,人家私底下一定是花大量的时间自学的,你可能会说,我也想学习啊,可是嘞,该学习啥嘞,不怕告诉你,互联网时代,最不缺的就是学习资源,最宝贵的是啥? 你可能会说是时间,不,不是时间,而是你的注意力,懂了吧! 那么,你说学习资源多,我咋不知道,那今天我就告诉你一个你必须知道的学习的地方,人称...
那些年,我们信了课本里的那些鬼话
教材永远都是有错误的,从小学到大学,我们不断的学习了很多错误知识。 斑羚飞渡 在我们学习的很多小学课文里,有很多是错误文章,或者说是假课文。像《斑羚飞渡》: 随着镰刀头羊的那声吼叫,整个斑羚群迅速分成两拨,老年斑羚为一拨,年轻斑羚为一拨。 就在这时,我看见,从那拨老斑羚里走出一只公斑羚来。公斑羚朝那拨年轻斑羚示意性地咩了一声,一只半大的斑羚应声走了出来。一老一少走到伤心崖,后退了几步,突...
立即提问