mysqld.err110213 05:17:25 mysqld_safe Starting mysqld daemon with databases from /data/mysql
110213 5:17:25 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
110213 5:17:25 [ERROR] Use --lc-messages-dir without language specific part instead.
110213 5:17:25 [Note] Plugin 'FEDERATED' is disabled.
110213 5:17:25 InnoDB: The InnoDB memory heap is disabled
110213 5:17:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110213 5:17:25 InnoDB: Compressed tables use zlib 1.2.3
110213 5:17:25 InnoDB: Using Linux native AIO
110213 5:17:25 InnoDB: Initializing buffer pool, size = 2.0G
110213 5:17:26 InnoDB: Completed initialization of buffer pool
110213 5:17:26 InnoDB: highest supported file format is Barracuda.
110213 5:17:26 InnoDB: Waiting for the background threads to start
110213 5:17:27 InnoDB: 1.1.5 started; log sequence number 1595645
110213 5:17:36 [Note] Event Scheduler: Loaded 0 events
110213 5:17:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.9-log' socket: '/data/mysql/mysqld.sock' port: 3306 MySQL Community Server (GPL)
110213 12:27:12 mysqld_safe Number of processes running now: 0
110213 12:27:12 mysqld_safe mysqld restarted
110213 12:27:13 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
110213 12:27:13 [ERROR] Use --lc-messages-dir without language specific part instead.
110213 12:27:13 [Note] Plugin 'FEDERATED' is disabled.
110213 12:27:14 InnoDB: The InnoDB memory heap is disabled
110213 12:27:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110213 12:27:14 InnoDB: Compressed tables use zlib 1.2.3
110213 12:27:14 InnoDB: Using Linux native AIO
110213 12:27:14 InnoDB: Initializing buffer pool, size = 2.0G
110213 12:27:17 InnoDB: Completed initialization of buffer pool
110213 12:27:17 InnoDB: highest supported file format is Barracuda.
110213 12:27:19 InnoDB: Waiting for the background threads to start
110213 12:27:20 InnoDB: 1.1.5 started; log sequence number 1595645
110213 12:27:20 [Note] Recovering after a crash using mysql-bin
110213 12:27:20 [Note] Starting crash recovery...
110213 12:27:20 [Note] Crash recovery finished.
110213 12:27:46 [Note] Event Scheduler: Loaded 0 events
110213 12:27:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.9-log' socket: '/data/mysql/mysqld.sock' port: 3306 MySQL Community Server (GPL)
110213 12:44:51 mysqld_safe Number of processes running now: 0
110213 12:44:51 mysqld_safe mysqld restarted
110213 12:44:52 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
110213 12:44:52 [ERROR] Use --lc-messages-dir without language specific part instead.
110213 12:44:52 [Note] Plugin 'FEDERATED' is disabled.
110213 12:44:52 InnoDB: The InnoDB memory heap is disabled
110213 12:44:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110213 12:44:52 InnoDB: Compressed tables use zlib 1.2.3
110213 12:44:52 InnoDB: Using Linux native AIO
110213 12:44:52 InnoDB: Initializing buffer pool, size = 2.0G
110213 12:44:54 InnoDB: Completed initialization of buffer pool
110213 12:44:54 InnoDB: highest supported file format is Barracuda.
110213 12:44:56 InnoDB: Waiting for the background threads to start
110213 12:44:57 InnoDB: 1.1.5 started; log sequence number 1595645
110213 12:44:57 [Note] Recovering after a crash using mysql-bin
110213 12:44:57 [Note] Starting crash recovery...
110213 12:44:57 [Note] Crash recovery finished.
110213 12:45:48 mysqld_safe mysqld from pid file /data/mysql/mysqld.pid ended
110213 5:17:25 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
110213 5:17:25 [ERROR] Use --lc-messages-dir without language specific part instead.
110213 5:17:25 [Note] Plugin 'FEDERATED' is disabled.
110213 5:17:25 InnoDB: The InnoDB memory heap is disabled
110213 5:17:25 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110213 5:17:25 InnoDB: Compressed tables use zlib 1.2.3
110213 5:17:25 InnoDB: Using Linux native AIO
110213 5:17:25 InnoDB: Initializing buffer pool, size = 2.0G
110213 5:17:26 InnoDB: Completed initialization of buffer pool
110213 5:17:26 InnoDB: highest supported file format is Barracuda.
110213 5:17:26 InnoDB: Waiting for the background threads to start
110213 5:17:27 InnoDB: 1.1.5 started; log sequence number 1595645
110213 5:17:36 [Note] Event Scheduler: Loaded 0 events
110213 5:17:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.9-log' socket: '/data/mysql/mysqld.sock' port: 3306 MySQL Community Server (GPL)
110213 12:27:12 mysqld_safe Number of processes running now: 0
110213 12:27:12 mysqld_safe mysqld restarted
110213 12:27:13 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
110213 12:27:13 [ERROR] Use --lc-messages-dir without language specific part instead.
110213 12:27:13 [Note] Plugin 'FEDERATED' is disabled.
110213 12:27:14 InnoDB: The InnoDB memory heap is disabled
110213 12:27:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110213 12:27:14 InnoDB: Compressed tables use zlib 1.2.3
110213 12:27:14 InnoDB: Using Linux native AIO
110213 12:27:14 InnoDB: Initializing buffer pool, size = 2.0G
110213 12:27:17 InnoDB: Completed initialization of buffer pool
110213 12:27:17 InnoDB: highest supported file format is Barracuda.
110213 12:27:19 InnoDB: Waiting for the background threads to start
110213 12:27:20 InnoDB: 1.1.5 started; log sequence number 1595645
110213 12:27:20 [Note] Recovering after a crash using mysql-bin
110213 12:27:20 [Note] Starting crash recovery...
110213 12:27:20 [Note] Crash recovery finished.
110213 12:27:46 [Note] Event Scheduler: Loaded 0 events
110213 12:27:46 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.9-log' socket: '/data/mysql/mysqld.sock' port: 3306 MySQL Community Server (GPL)
110213 12:44:51 mysqld_safe Number of processes running now: 0
110213 12:44:51 mysqld_safe mysqld restarted
110213 12:44:52 [ERROR] An old style --language value with language specific part detected: /usr/share/mysql/english/
110213 12:44:52 [ERROR] Use --lc-messages-dir without language specific part instead.
110213 12:44:52 [Note] Plugin 'FEDERATED' is disabled.
110213 12:44:52 InnoDB: The InnoDB memory heap is disabled
110213 12:44:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110213 12:44:52 InnoDB: Compressed tables use zlib 1.2.3
110213 12:44:52 InnoDB: Using Linux native AIO
110213 12:44:52 InnoDB: Initializing buffer pool, size = 2.0G
110213 12:44:54 InnoDB: Completed initialization of buffer pool
110213 12:44:54 InnoDB: highest supported file format is Barracuda.
110213 12:44:56 InnoDB: Waiting for the background threads to start
110213 12:44:57 InnoDB: 1.1.5 started; log sequence number 1595645
110213 12:44:57 [Note] Recovering after a crash using mysql-bin
110213 12:44:57 [Note] Starting crash recovery...
110213 12:44:57 [Note] Crash recovery finished.
110213 12:45:48 mysqld_safe mysqld from pid file /data/mysql/mysqld.pid ended
解决方案 »
- !!!postgres月份计算!!!
- mysql 数据迁移
- mysql中IN 与 INNER JOIN 效率对比
- 数据库表两列如何变成一列输出
- MYSQL 5.1.12为什么不生成查询日志文件
- (做了5天了,求求高手了)无法创建下列URL的连接: jdbc:mysql://localhost:3306/decor?user=root&password=root&useUnicode=true&charac
- 自从安装了mysqlodbc3.51.12后,odbc出故障了,连接任何数据库都非常慢
- 一个在mysql中插入记录所产生的问题
- 那里有pgAdmin II的下在阿,官方网站的那个不能下载了
- 请教一个mysql创建表名的问题?
- MYSQL 表分区问题
- Mysql触发器里能动态创建表吗?
2. 有人在生产环境中部署5.5.x了吗?
==>
那是你测试的方法和环境有问题..
2. 有人在生产环境中部署5.5.x了吗?
==》
应该有 不过很少
[mysqld] 中增加一行 tmpdir="盘符:/MySQL/data/"
110213 12:44:51 mysqld_safe mysqld restarted
我觉得问题可能在这里,但还是没有能找出来解决办法,降级到5.1.55依然存在这个问题。
已经有了
tmpdir = /tmp/
110215 18:00:09 mysqld_safe mysqld restarted
110215 18:00:09 [Note] Plugin 'FEDERATED' is disabled.
110215 18:00:10 InnoDB: Initializing buffer pool, size = 6.0G
110215 18:00:11 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110215 18:00: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...
InnoDB: Last MySQL binlog file position 0 418509414, file name ./mysql-bin.000017
110215 18:00:14 InnoDB: Started; log sequence number 0 3710959790
110215 18:00:14 [Note] Recovering after a crash using mysql-bin
110215 18:00:14 [Note] Starting crash recovery...
110215 18:00:14 [Note] Crash recovery finished.
110215 18:01:04 mysqld_safe mysqld from pid file /data/mysql/mysqld.pid ended
110215 18:41:21 mysqld_safe Starting mysqld daemon with databases from /data/mysql
110215 18:41:21 [Note] Plugin 'FEDERATED' is disabled.
110215 18:41:22 InnoDB: Initializing buffer pool, size = 6.0G
110215 18:41:24 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110215 18:41:25 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...
InnoDB: Last MySQL binlog file position 0 418509414, file name ./mysql-bin.000017
110215 18:41:26 InnoDB: Started; log sequence number 0 3710959790
110215 18:41:26 [Note] Recovering after a crash using mysql-bin
110215 18:41:26 [Note] Starting crash recovery...
110215 18:41:26 [Note] Crash recovery finished.
110215 18:42:05 [Note] Event Scheduler: Loaded 0 events
110215 18:42:05 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.55-community-log' socket: '/data/mysql/mysqld.sock' port: 3306 MySQL Community Server (GPL)