I'm configuring a Mac 10.6 server and I'm having trouble getting MySQL configured correctly according to the "Step by Step Installation on a Mac OS X Server" instructions. I'm having trouble configuring MySQL database to support InnoDB. I haven't run the Moodle installation yet, I'm just trying to get my system set up so I can run the install.
I set the MySQL user name and password for root and also created a user called moodle21 as the directions request.
MySQL starts and works without a problem with my original my.cnf file. Here it is:
[mysqld]
#Don't resolve hostnames. All hostnames are IP's or 'localhost'.
skip-name-resolve
#Don't give threads different priorities.
skip-thread-priority
However, when I add the recommended code from the instructions to support InnoDB, MySQL will not start.
[mysqld]
#Don't resolve hostnames. All hostnames are IP's or 'localhost'.
skip-name-resolve
#Don't give threads different priorities.
skip-thread-priority
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir=/var/mysql/
innodb_data_file_path=ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir=/var/mysql/
innodb_log_arch_dir=/var/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size=384M
innodb_additional_mem_pool_size=20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size=100M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
I confirmed that /var/mysql/ exists and has correct permissions. I'm not sure how to troubleshoot mysql to learn what is causing the problem.
MySQL is located at /usr/local/ :
lrwxr-xr-x 1 root wheel 24 Aug 26 12:17 mysql -> mysql-5.5.15-osx10.6-x86
drwxr-xr-x 16 root wheel 544 Jul 13 16:26 mysql-5.5.15-osx10.6-x86
Thank you very much for your help.
Mike
