# Uncomment the following if you are using InnoDB tables innodb_data_home_dir = /var/lib/mysql/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_arch_dir = /var/lib/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 = 16M innodb_additional_mem_pool_size = 2M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 5M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50
This is how it looks when I try to enable innodb, however, MySQL won't start with them uncommented, but it runs fine when I comment them out.
--
Hugh mailto: [EMAIL PROTECTED]
Victor Pendleton wrote:
Can you post the exact syntax from your my.cnf file?
-----Original Message----- From: Hugh Taylor To: [EMAIL PROTECTED] Sent: 7/12/04 3:17 PM Subject: Problem getting innodb enabled ...
Running MySQL 4.0.15 on SuSE 9 Professional. MySQL works fine until I try to allow innodb by uncommenting the lines in the my.cnf file. Once I
do this MySQLwill not start, the error message in the log is:
040712 15:25:39 mysqld started
/usr/sbin/mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/'
040712 15:25:39 mysqld ended
I found one thread in the SuSE listserv where someone fixed the problem
by deleting all the files and directories in /var/lib/mysql except mysql
and test, but that didn't work for me. The file permissions on /var/lib/mysql are:
drwxr-xr-x 9 mysql daemon 544 2004-07-12 15:58 mysql
and
drwxr-xr-x 9 mysql daemon 544 2004-07-12 15:58 .
drwxr-xr-x 41 root root 1056 2004-07-12 15:12 ..
drwx------ 2 mysql daemon 576 2004-07-12 11:12
CPIAInventory
drwx------ 2 mysql daemon 17976 2004-02-26 08:50 egroupware
drwx------ 2 mysql daemon 336 2004-06-28 16:21 EmployeeLog
drwxr-xr-x 2 mysql daemon 48 2004-07-12 15:22 innodb
drwx------ 2 mysql daemon 528 2003-11-12 18:13 mysql
-rw-rw---- 1 mysql daemon 2877 2004-07-12 15:58 mysqld.log
-rw-rw---- 1 mysql daemon 220 2004-06-29 15:56 mysqld.log-20040630.gz
-rw-rw---- 1 mysql daemon 220 2004-06-30 18:20 mysqld.log-20040701.gz
-rw-rw---- 1 mysql daemon 284 2004-07-07 18:04 mysqld.log-20040708.gz
-rw-rw---- 1 mysql daemon 223 2004-07-10 08:56 mysqld.log-20040710.gz
-rw-rw---- 1 mysql daemon 237 2004-07-11 11:55 mysqld.log-20040712.gz
-rw-rw---- 1 mysql daemon 5 2004-07-12 15:58 mysqld.pid
srwxrwxrwx 1 mysql daemon 0 2004-07-12 15:58 mysql.sock
drwx------ 2 mysql daemon 816 2004-06-28 15:29 phpmyadmin
drwx------ 2 mysql daemon 48 2003-11-12 18:13 test
Any ideas?
(I'm also posting this to the SuSE list.)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
