Skip to main content

You do not have InnoDB enabled

BillyS
After upgrading from MySQL 5.5 to 5.6 I'm seeing the above warning in phpmyadmin. It's also stating the query cache is off. Looking at the details, it further states: The query cache is not enabled. Test value == 0 || query_cache_type == 'OFF' || query_cache_type == '0' You do not have InnoDB enabled. value != "YES"

Comments

3 comments

Date Votes
  • BillyS
    This is the contents of my.conf [mysqldump] max_allowed_packet=32M quick [mysql] no-auto-rehash [mysqld] default_storage_engine=InnoDB query_cache_size=48M local-infile=0 collation_server=utf8_unicode_ci query_cache_limit=1M max_connect_errors=1000000 character_set_server=utf8 read_rnd_buffer_size=1M table_open_cache=4096 thread_cache_size=50 tmp_table_size=48M sort_buffer_size=1M max_connections=150 max_allowed_packet=268435456 max_heap_table_size=48M interactive_timeout=300 join_buffer_size=1M open_files_limit=65535 table_definition_cache=2048 key_buffer_size=2M read_buffer_size=256K wait_timeout=30 innodb_buffer_pool_size=208M innodb_log_buffer_size=4M innodb_flush_method=O_DIRECT innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb_fast_shutdown=0 innodb_log_file_size=64M [isamchk] read_buffer=2M key_buffer_size=96M write_buffer=2M sort_buffer_size=64M [myisamchk] read_buffer=2M key_buffer_size=96M write_buffer=2M sort_buffer_size=64M
    0
  • BillyS
    Okay, this is strange... Immediately after I upgraded, I noticed phpmyadmin was still reporting MySQL as version 5.5. (I tried clearing the browser cache.) A couple of hours later, it's now saying 5.6.21. I'm looking in Status>Advisor and the message about Innodb has disappeared. I also see in the MySQL documentation that after 5.6.8 the default is off for query cache and it needs to be explicitly turned on. I'm still reading through documentation to see if it's still needed. If anyone has an insight, I'd appreciate it. I also see in the MySQL documentation on query_cache_size: The permissible values are multiples of 1024; other values are rounded down to the nearest multiple. Note that query_cache_size bytes of memory are allocated even if query_cache_type is set to 0. See Section 8.9.3.3, "Query Cache Configuration", for more information. Does that mean I can save 48M of memory by taking that line out of my.conf?
    0
  • cPanelMichael
    Hello :) I am happy to see the initial issue is now resolved. As far as your MySQL configuration values, you may want to consider running a MySQL tuner as mentioned in this thread: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post