Results 1 to 14 of 14
  1. #1
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46

    Question enabling InnoDB in mysql

    Hi,

    I have a VPS with Debian 5.0. I am trying to enable InnoDB, but when I type show engines in mysql it shows InnoDB disabled. This is what I have in my.cnf:

    [mysqld]
    port = 3306
    socket = /var/run/mysqld/mysqld.sock
    skip-locking
    #skip-networking
    key_buffer = 1M
    max_allowed_packet = 1M
    table_cache = 40
    sort_buffer_size = 64K
    read_buffer_size = 256K
    read_rnd_buffer_size = 256K
    net_buffer_length = 2K
    thread_stack = 64K
    max_connections = 50

    skip-bdb
    #skip-innodb

    innodb_data_home_dir = /var/lib/mysql/
    innodb_log_group_home_dir = /usr/local/mysql/data/
    innodb_log_arch_dir = /usr/local/mysql/data/
    innodb_buffer_pool_size = 1M
    innodb_additional_mem_pool_size = 128K
    innodb_log_buffer_size = 256K
    innodb_log_file_size = 256K
    innodb_flush_log_at_trx_commit = 4
    innodb_lock_wait_timeout = 50
    innodb_file_io_threads = 4
    innodb_thread_concurrency = 4

    [mysqldump]
    quick
    max_allowed_packet = 1M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer = 1M
    sort_buffer_size = 1M

    [myisamchk]
    key_buffer = 1M
    sort_buffer_size = 1M

    [mysqlhotcopy]
    interactive-timeout

    What am I missing to enable InnoDB???

  2. #2
    have you checked the error logs?

  3. #3
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46
    Quote Originally Posted by icyshout View Post
    have you checked the error logs?
    Yes, /var/log mysq.log and /var/log/mysql.err are empty and /var/log/mysql doesn't have any files.

  4. #4
    Join Date
    Apr 2004
    Location
    Pacific Palisades, CA
    Posts
    3,641
    Where is

    innodb_data_file_path = ibdata1:10M:autoextend

    Check the log files also for error messages
    Collabora Hosting - Unlimited Windows and Linux Hosting
    Web Security - VPS - Dedicated Servers
    Cloud and Managed WordPress Hosting
    Read how we do Unlimited Hosting at the Unlimited FAQ

  5. #5
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46
    Quote Originally Posted by Collabora View Post
    Where is

    innodb_data_file_path = ibdata1:10M:autoextend

    Check the log files also for error messages
    I've put that line in my.cnf and restarted mysql. Still showing InnoDB as disabled. Checked log files again and they are still empty.

  6. #6
    Join Date
    Feb 2008
    Location
    Houston, Texas, USA
    Posts
    3,262
    Look under /var/lib/mysql for the *.err file.

    Regards
    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    Server Management - Unlimited Servers. Unlimited Requests. One Plan!
    cPanel Varnish Plugin -- Seamless SSL Caching (Let's Encrypt, AutoSSL, etc)
    Slow Site or Server? Unable to handle traffic? Same day performance fix: joe@unixy

  7. #7
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46
    Quote Originally Posted by UNIXy View Post
    Look under /var/lib/mysql for the *.err file.

    Regards
    did a find on /var/lib/mysql and cound't find any .err file.

  8. #8
    Join Date
    Apr 2004
    Location
    Pacific Palisades, CA
    Posts
    3,641
    Is this a fresh install of mysql? What version and which distribution?
    Collabora Hosting - Unlimited Windows and Linux Hosting
    Web Security - VPS - Dedicated Servers
    Cloud and Managed WordPress Hosting
    Read how we do Unlimited Hosting at the Unlimited FAQ

  9. #9
    Join Date
    Feb 2008
    Location
    Houston, Texas, USA
    Posts
    3,262
    Quote Originally Posted by IraqiGeek View Post
    did a find on /var/lib/mysql and cound't find any .err file.
    Add this line in [mysqld] then restart:

    error=mysql_error_file
    It should end up in your data directory, which is /var/lib/mysql.

    Regards
    UNIXy - Fully Managed Servers and Clusters - Established in 2006
    Server Management - Unlimited Servers. Unlimited Requests. One Plan!
    cPanel Varnish Plugin -- Seamless SSL Caching (Let's Encrypt, AutoSSL, etc)
    Slow Site or Server? Unable to handle traffic? Same day performance fix: joe@unixy

  10. #10
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46
    Quote Originally Posted by Collabora View Post
    Is this a fresh install of mysql? What version and which distribution?
    Yes, its a fresh install of the whole VPS. Debian 5.0 and MySQL 5.0.51a

    Quote Originally Posted by UNIXy View Post
    Add this line in [mysqld] then restart:

    It should end up in your data directory, which is /var/lib/mysql.

    Regards
    If I add that to [mysqld] mysql will fail to start with nothing in mysql.log and mysql.err in /var/log/ and nothing in /var/lib/mysql???

  11. #11
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46
    Seems something was wrong with my.cnf. I copied the default my.cnf from another debian installation and edited that to change the values to what I had in the my.cnf I was using. InnoDB was enabled once I restarted mysql.

    Thanks for all your help guys.

  12. #12
    Join Date
    Aug 2009
    Posts
    83
    Hi,

    Could you post that my.cnf file? If you have found what was worng it could be helpful for me.

  13. #13
    Join Date
    Mar 2006
    Location
    Portugal
    Posts
    46
    Quote Originally Posted by angathan View Post
    Hi,

    Could you post that my.cnf file? If you have found what was worng it could be helpful for me.
    Sure, you can see it at http://www.ainlabs.com/my.cnf.working.txt

    I still need to tweak InnoDB settings to reduce mysql memory usage (currently at 112MB).

  14. #14
    Join Date
    Apr 2004
    Location
    Pacific Palisades, CA
    Posts
    3,641
    Maybe it was a line break at end of file?
    Collabora Hosting - Unlimited Windows and Linux Hosting
    Web Security - VPS - Dedicated Servers
    Cloud and Managed WordPress Hosting
    Read how we do Unlimited Hosting at the Unlimited FAQ

Similar Threads

  1. MySQL InnoDB/MyISAM question
    By Cyrian in forum Hosting Security and Technology
    Replies: 6
    Last Post: 02-26-2008, 09:54 PM
  2. mysql myisam and innodb
    By zelf in forum Hosting Software and Control Panels
    Replies: 2
    Last Post: 02-10-2005, 09:43 PM
  3. Mysql and Innodb
    By Serverplan in forum Hosting Security and Technology
    Replies: 0
    Last Post: 11-24-2003, 09:36 AM
  4. Replication on InnoDB MySQL !!!!
    By ljncb in forum Hosting Security and Technology
    Replies: 2
    Last Post: 06-20-2003, 12:43 AM
  5. MySQL-Max / InnoDb on RaQ4?
    By ericabiz in forum Dedicated Server
    Replies: 0
    Last Post: 06-30-2002, 08:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •