CentOS 6.3에서 아래처럼 플러그인 초기화 실패 에러가 나오네요..


130814 10:13:15  InnoDB: Waiting for the background threads to start

130814 10:13:16 Percona XtraDB (http://www.percona.com) 5.5.30-tokudb-7.0.4-MariaDB-30.1 started; log sequence number 0

130814 10:07:58 mysqld_safe Starting mysqld daemon with databases from /data/mariadb/data

130814 10:07:58 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.

130814 10:07:59 [ERROR] InnoDB: syntax error in innodb_data_file_path

130814 10:07:59 [ERROR] Plugin 'InnoDB' init function returned error.

130814 10:07:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

130814 10:07:59 [Note] Plugin 'FEEDBACK' is disabled.

Transparent huge pages are enabled, according to /sys/kernel/mm/redhat_transparent_hugepage/enabled

130814 10:07:59 [ERROR] Plugin 'TokuDB' init function returned error.

130814 10:07:59 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed.

130814 10:07:59 [ERROR] mysqld: File '/data/mariadb/mysql_query.log' not found (Errcode: 13)

130814 10:07:59 [ERROR] Unknown/unsupported storage engine: TokuDB

130814 10:07:59 [ERROR] Aborting



위 메세지중 붉은색 메세지를 참조하여 아래와 같이 해주면 끝이네요.

# echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled



#vi /etc/init.d/mysql(mariadb) 스크립트 start 부분에 추가


# 추가되는 부분.

if test -f /sys/kernel/mm/redhat_transparent_hugepage/enabled; then

   echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled

fi

if test -f /sys/kernel/mm/redhat_transparent_hugepage/defrag; then

   echo never > /sys/kernel/mm/redhat_transparent_hugepage/defrag

fi




참조 #1(30p)  http://www.tokutek.com/wp-content/uploads/2013/05/Percona-Live-Tutorial-2013.pdf

참조 #2(34p~38p)  http://www.slideshare.net/sprdd/linux-performan-tuning-part-1

블로그 이미지

유효하지않음

,