| 2017-10-18 06:38:25 |
王星宇 |
description |
Some machines turn on tokudb_directio parameters，can startup ，but other Startup failed
2017-10-17 13:44:00 34884 [ERROR] TokuDB: Cant open rollback
2017-10-17 13:44:00 34884 [ERROR] TokuDB unknown error 22
2017-10-17 13:44:00 34884 [ERROR] Plugin 'TokuDB' init function returned error.
2017-10-17 13:44:00 34884 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed.
2017-10-17 13:44:00 34884 [ERROR] Unknown/unsupported storage engine: TokuDB
2017-10-17 13:44:00 34884 [ERROR] Aborting |
Some machines turn on tokudb_directio parameters，can startup ，but other Startup failed
2017-10-17 13:44:00 34884 [ERROR] TokuDB: Cant open rollback
2017-10-17 13:44:00 34884 [ERROR] TokuDB unknown error 22
2017-10-17 13:44:00 34884 [ERROR] Plugin 'TokuDB' init function returned error.
2017-10-17 13:44:00 34884 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed.
2017-10-17 13:44:00 34884 [ERROR] Unknown/unsupported storage engine: TokuDB
2017-10-17 13:44:00 34884 [ERROR] Aborting
Specific reference
http://imysql.cn/2014/06/24/migrate-zabbix-db-to-tokudb.shtml
叶总 在my.cnf 里面加上tokudb_directio = 1，就报错… 注释了之后是没问题的，我是直接用的 5.5.40-tokudb-7.5.3-MariaDB 这个版本，剩下的参数都没问题。
[(none)]>show global variables like ‘%tokudb_directio%’
-> ;
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| tokudb_directio | OFF |
+—————–+——-+
1 row in set (0.00 sec)
17:04:43 [(none)]>set global tokudb_directio=1;
ERROR 1238 (HY000): Variable ‘tokudb_directio’ is a read only variable
[(none)]>
启动时候报错如下：
150105 0:42:16 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
150105 0:42:16 [Note] Event Scheduler: Purging the queue. 0 events
150105 0:42:16 InnoDB: Starting shutdown…
150105 0:42:17 InnoDB: Shutdown completed; log sequence number 1597939
150105 0:42:17 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
150105 00:42:17 mysqld_safe mysqld from pid file /data/mysql/mysql_3306/data/mysql.pid ended
150105 00:42:18 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3306/data
150105 0:42:18 InnoDB: The InnoDB memory heap is disabled
150105 0:42:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150105 0:42:18 InnoDB: Compressed tables use zlib 1.2.3
150105 0:42:18 InnoDB: Using Linux native AIO
150105 0:42:18 InnoDB: Initializing buffer pool, size = 1.0G
150105 0:42:18 InnoDB: Completed initialization of buffer pool
150105 0:42:18 InnoDB: highest supported file format is Barracuda.
150105 0:42:19 InnoDB: Waiting for the background threads to start
150105 0:42:20 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597939
150105 0:42:20 [Note] Plugin ‘FEEDBACK’ is disabled.
150105 0:42:20 [ERROR] TokuDB: Cant open rollback
150105 0:42:20 [ERROR] TokuDB unknown error 22
150105 0:42:20 [ERROR] Plugin ‘TokuDB’ init function returned error.
150105 0:42:20 [ERROR] Plugin ‘TokuDB’ registration as a STORAGE ENGINE failed.
150105 0:42:20 [ERROR] Unknown/unsupported storage engine: TokuDB
150105 0:42:20 [ERROR] Aborting
150105 0:42:20 InnoDB: Starting shutdown…
150105 0:42:21 InnoDB: Shutdown completed; log sequence number 1597939
150105 0:42:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
150105 00:42:21 mysqld_safe mysqld from pid file /data/mysql/mysql_3306/data/mysql.pid ended |
|
