OS: Linux 32bit
Distro: openSUSE 13.1
MySQL Ver: 5.6.12
This is my first time working with Mysql version 5.6.x and I have to admit that I have been having trouble getting it to start with my specific settings. I would like to have MySQL with the lowest memory footprint.
[mysqld]
port = 3306
socket = /var/lib/mysql/mysqld.sock
explicit_defaults_for_timestamp = TRUE
#skip-locking
skip-networking
key_buffer = 16K
max_allowed_packet = 1M
#table_cache = 4
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
#innodb=OFF
ignore-builtin-innodb
skip-innodb
default-storage-engine=myisam
default-tmp-storage-engine=myisam
As you can see, I like to have myisam as the default engine but unfortunately, and according to this bug report
http://bugs.mysql.com/bug.php?id=68438 (now closed without a solution) re. post:
mysql_install_db incorrectly tried to create the
mysql.innodb_table_stats and mysql.innodb_index_stats tables if
InnoDB was not available.
I end up with this error "ERROR: 1286 Unknown storage engine 'INNODB'". I am not quite sure what to do next ? Is there a work around ?