Web Hosting - WestHost Web Hosting
Old 10-27-2009, 10:30 AM   #1
TonyL
Member
 
Join Date: Oct 2005
Location: RI, USA
Posts: 49
Default InnoDB won't enable

I cannot see the InnoDB engine as an option even though the /etc/my.cnf file has the "skip-innodb" liine commented out and the MySQL has been restarted.

Any thoughts? The my.cnf file reads:

Code:
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
password =XXXXXXXXXXXXXXXXX
port = 3306
user = root
socket = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306

socket = /var/lib/mysql/mysql.sock
datadir = /var/lib/mysql
basedir = /usr/local/mysql
#bind-address =

skip-locking
#skip-innodb
join_buffer_size = 4M
key_buffer_size = 12M
query_cache_limit = 128K
query_cache_size = 2M
query_cache_type = 1
max_allowed_packet = 1M
max_heap_table_size = 8M
read_buffer_size = 2M
record_buffer = 3M
sort_buffer_size = 1M
table_cache = 1024
thread_cache_size = 20
thread_stack = 128K
tmp_table_size = 8M
innodb_file_per_table
innodb_log_file_size = 5M
innodb_log_buffer_size = 1M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_thread_concurrency = 4
innodb_buffer_pool_size = 16M
innodb_flush_log_at_trx_commit=1

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
#
skip-networking

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[mysqlhotcopy]
interactive-timeout

[mysql_upgrade]
basedir = /usr/local/mysql
datadir = /var/lib/mysql
Thanks -- Tony
__________________
Tony Lush
Advance Web Marketing
Jamestown | RI | USA
TonyL is offline   Reply With Quote
Old 10-28-2009, 10:09 AM   #2
dattas
Member
 
dattas's Avatar
 
Join Date: Jan 2008
Posts: 87
Send a message via AIM to dattas Send a message via MSN to dattas Send a message via Yahoo to dattas
Default

There could be a lot of reasons. Are you running the newest version? 5.1.37? If not, you may want to try upgrading to the latest version.
When you changed the my.cnf, did you restart the account to make it take effect?
__________________
Unofficial technical support for the world.

Last edited by dattas; 10-28-2009 at 10:17 AM.
dattas is offline   Reply With Quote
Old 10-28-2009, 12:47 PM   #3
TonyL
Member
 
Join Date: Oct 2005
Location: RI, USA
Posts: 49
Default

It was an older MySQL 5, which had InnoDB bugs. Upgrading seems to have helped.

Thanks -- Tony
__________________
Tony Lush
Advance Web Marketing
Jamestown | RI | USA
TonyL is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 07:15 AM.

- Archive - Top

Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.