Comment 3 for bug 488373

Revision history for this message
Ancoron Luziferis (ancoron) wrote :

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.