debian lennyでのmysql innnodb plugin使い方
ちょっといれてみたくなったからめも
backports設定
vi /etc/apt/sources.list deb http://backports.debian.org/debian-backports lenny-backports main
install
aptitude -t lenny-backports install mysql-server-5.1
InnnoDB設定
vi /et/mysql/my.cnf
# 有効化 ignore-builtin-innodb plugin-load = innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so; innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so; innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so; innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so # データ圧縮機能 innodb_file_per_table innodb_file_format=Barracuda
確認
select @@innodb_version;