Results 1 to 14 of 14
Thread: enabling InnoDB in mysql
-
08-23-2009, 09:52 PM #1Junior Guru Wannabe
- Join Date
- Mar 2006
- Location
- Portugal
- Posts
- 46
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???
-
08-23-2009, 09:56 PM #2Junior Guru Wannabe
- Join Date
- Jul 2009
- Posts
- 63
have you checked the error logs?
-
08-23-2009, 10:05 PM #3Junior Guru Wannabe
- Join Date
- Mar 2006
- Location
- Portugal
- Posts
- 46
-
08-23-2009, 10:08 PM #4Web Hosting Master
- 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
-
08-23-2009, 10:14 PM #5Junior Guru Wannabe
- Join Date
- Mar 2006
- Location
- Portugal
- Posts
- 46
-
08-23-2009, 10:19 PM #6Corporate Member
- Join Date
- Feb 2008
- Location
- Houston, Texas, USA
- Posts
- 3,262
Look under /var/lib/mysql for the *.err file.
RegardsUNIXy - 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
-
08-23-2009, 10:22 PM #7Junior Guru Wannabe
- Join Date
- Mar 2006
- Location
- Portugal
- Posts
- 46
-
08-23-2009, 10:41 PM #8Web Hosting Master
- 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
-
08-23-2009, 10:43 PM #9Corporate Member
- Join Date
- Feb 2008
- Location
- Houston, Texas, USA
- Posts
- 3,262
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
-
08-24-2009, 07:34 AM #10Junior Guru Wannabe
- Join Date
- Mar 2006
- Location
- Portugal
- Posts
- 46
-
08-24-2009, 09:07 AM #11Junior Guru Wannabe
- 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.
-
08-24-2009, 10:19 AM #12Junior Guru Wannabe
- 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.
-
08-24-2009, 10:25 AM #13Junior Guru Wannabe
- Join Date
- Mar 2006
- Location
- Portugal
- Posts
- 46
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).
-
08-24-2009, 11:13 AM #14Web Hosting Master
- 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
-
MySQL InnoDB/MyISAM question
By Cyrian in forum Hosting Security and TechnologyReplies: 6Last Post: 02-26-2008, 09:54 PM -
mysql myisam and innodb
By zelf in forum Hosting Software and Control PanelsReplies: 2Last Post: 02-10-2005, 09:43 PM -
Mysql and Innodb
By Serverplan in forum Hosting Security and TechnologyReplies: 0Last Post: 11-24-2003, 09:36 AM -
Replication on InnoDB MySQL !!!!
By ljncb in forum Hosting Security and TechnologyReplies: 2Last Post: 06-20-2003, 12:43 AM -
MySQL-Max / InnoDb on RaQ4?
By ericabiz in forum Dedicated ServerReplies: 0Last Post: 06-30-2002, 08:17 PM