I have this problem since I updated package from version 5.1.37-1ubuntu5 to 5.1.37-1ubuntu5.1. InnoDB supported silently dissappeared:
$ mysql -u root -p -e 'SHOW ENGINES\G' | egrep '(Engine|Support): ' Enter password: Engine: MyISAM Support: DEFAULT Engine: MRG_MYISAM Support: YES Engine: BLACKHOLE Support: YES Engine: CSV Support: YES Engine: MEMORY Support: YES Engine: FEDERATED Support: NO Engine: ARCHIVE Support: YES
My InnoDB configuration is:
$ grep 'innodb' /etc/mysql/my.cnf innodb innodb_data_home_dir = /srv/mysql/innodb innodb_data_file_path = ibdata1:2G:autoextend innodb_autoextend_increment = 64M innodb_status_file = 1 innodb_thread_concurrency = 4 innodb_file_per_table innodb_support_xa = 0 innodb_buffer_pool_size = 2G innodb_additional_mem_pool_size = 20M innodb_log_file_size = 512M innodb_log_buffer_size = 64M innodb_flush_log_at_trx_commit = 0 innodb_lock_wait_timeout = 50
There is nothing in /etc/mysql/conf.d/ except the file from mysql-server-5.1 package:
$ dpkg -S /etc/mysql/conf.d/* mysql-server-5.1: /etc/mysql/conf.d/mysqld_safe_syslog.cnf
AppArmor is also realigned for my configuration and doesn't complain.
I have this problem since I updated package from version 5.1.37-1ubuntu5 to 5.1.37-1ubuntu5.1. InnoDB supported silently dissappeared:
$ mysql -u root -p -e 'SHOW ENGINES\G' | egrep '(Engine|Support): '
Enter password:
Engine: MyISAM
Support: DEFAULT
Engine: MRG_MYISAM
Support: YES
Engine: BLACKHOLE
Support: YES
Engine: CSV
Support: YES
Engine: MEMORY
Support: YES
Engine: FEDERATED
Support: NO
Engine: ARCHIVE
Support: YES
My InnoDB configuration is:
$ grep 'innodb' /etc/mysql/my.cnf data_home_ dir = /srv/mysql/innodb data_file_ path = ibdata1: 2G:autoextend autoextend_ increment = 64M thread_ concurrency = 4 file_per_ table buffer_ pool_size = 2G additional_ mem_pool_ size = 20M log_file_ size = 512M log_buffer_ size = 64M flush_log_ at_trx_ commit = 0 lock_wait_ timeout = 50
innodb
innodb_
innodb_
innodb_
innodb_status_file = 1
innodb_
innodb_
innodb_support_xa = 0
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
There is nothing in /etc/mysql/conf.d/ except the file from mysql-server-5.1 package:
$ dpkg -S /etc/mysql/conf.d/* conf.d/ mysqld_ safe_syslog. cnf
mysql-server-5.1: /etc/mysql/
AppArmor is also realigned for my configuration and doesn't complain.