Ubutu installation Tokudb

Http://www.cnblogs.com/zhoujinyi/p/4494472.html (turn from)

Http://imysql.cn/2014/06/24/migrate-zabbix-db-to-tokudb.shtml(turn from)

Get:1 http://mirrors.163.com/ubuntu/trusty-security/main Mysql-common All 5.5.50-0ubuntu0.14.04.1 [12.9 KB]

Get:2 http://mirrors.163.com/ubuntu/trusty-security/main libmysqlclient18 amd64 5.5.50-0ubuntu0.14.04.1 [595 KB]

Get:3 http://repo.percona.com/apt/trusty/main percona-server-common-5.6 amd64 5.6.32-78.0-1.trusty [12.0 KB]

Get:4 http://repo.percona.com/apt/trusty/main libperconaserverclient18.1 amd64 5.6.32-78.0-1.trusty [569 KB]

Get:5 http://repo.percona.com/apt/trusty/main percona-server-client-5.6 amd64 5.6.32-78.0-1.trusty [1,337 KB]

Get:6 http://repo.percona.com/apt/trusty/main percona-server-server-5.6 amd64 5.6.32-78.0-1.trusty [11.6 MB]

See http://www.percona.com/doc/percona-server/5.6/management/udf_percona_toolkit.html for more details

sudo apt-get install percona-server-server-5.6

sudo apt-get install percona-server-client-5.6

sudo apt-get autoremove percona-server-client-5.6--purge

sudo apt-get autoremove percona-server-server-5.6--purge

Notice to modify MY.CNF:

1. Stop the instance and add the configuration file Tokudb engine parameters

If you use default parameters, you can keep the instance

If you want to modify Tokudb_data_dir/tokudb_log_dir, you need to delete the instance data directory under Tokudb load file,-bash "Rm-rf *tokudb*"

2. The first load succeeds Tokudb, and then the automatic load is started, but the tokudb_* configuration error causes the engine registration to fail, the TOKUDB engine table cannot be used

Tokudb parameter optimization

Http://www.cnblogs.com/manong792/p/5016457.html

Http://imysql.cn/2014/06/24/migrate-zabbix-db-to-tokudb.shtml

Ubuntu Common error--could not get Lock/var/lib/dpkg/lock-open

sudo rm/var/cache/apt/archives/lock

sudo rm/var/lib/dpkg/lock

Analog Build Table:

CREATE TABLE ' Login_log_toku ' (

' UserID ' varchar (255) Not NULL

) Engine=tokudb DEFAULT Charset=utf8;

Percond Tookit Tool Use

Http://www.jb51.net/article/75080.htm

160909 13:09:21 mysqld_safe mysqld from PID File/var/run/mysqld/mysqld.pid ended

160909 13:09:23 mysqld_safe Transparent Huge pages are already set To:never.

160909 13:09:23 Mysqld_safe starting mysqld daemon with databases From/var/lib/mysql

2016-09-09 13:09:23 0 [ERROR]/usr/sbin/mysqld:ambiguous option ' I. ' (Ignore-db-dir, Interactiv

E_timeout)

2016-09-09 13:09:23 0 [ERROR] aborting

2016-09-09 13:09:23 0 [Note] Binlog End

This article is from the "Faint Tears" blog, please be sure to keep this source http://lijuntao.blog.51cto.com/11691147/1946637

Ubutu installation Tokudb