Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

You do not have InnoDB enabled

Discussion in 'Database Discussion' started by BillyS, Nov 23, 2014.

  1. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    46
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    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"
     
  2. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    46
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    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
     
    #2 BillyS, Nov 23, 2014
    Last edited: Nov 23, 2014
  3. BillyS

    BillyS Well-Known Member

    Joined:
    Mar 22, 2013
    Messages:
    46
    Likes Received:
    2
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    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?
     
    #3 BillyS, Nov 23, 2014
    Last edited: Nov 23, 2014
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice