Peter,
Friday, September 20, 2002, 9:20:36 AM, you wrote:
PG> The relevant section of my.cnf is:
PG> # Uncomment the following if you are using InnoDB tables
PG> innodb_data_home_dir = /
PG> innodb_data_file_path =
PG> data1/ibdata1:100M:autoextend;data2/ibdata2:100M:autoextend;data3/ibdata3:10
PG> 0M:autoextend
PG> innodb_log_group_home_dir =index1/
PG> innodb_log_arch_dir = index1/
PG> # You can set .._buffer_pool_size up to 50 - 80 %
PG> # of RAM but beware of setting memory usage too high
PG> set-variable = innodb_buffer_pool_size=256M
PG> set-variable = innodb_additional_mem_pool_size=20M
PG> # Set .._log_file_size to 25 % of buffer pool size
PG> set-variable = innodb_log_file_size=64M
PG> set-variable = innodb_log_buffer_size=8M
PG> set-variable = innodb_log_files_in_group=4
PG> innodb_flush_log_at_trx_commit=1
PG> set-variable = innodb_lock_wait_timeout=50
PG> set-variable = innodb_file_io_threads=4
PG> My system has the following mount points for database files.
PG> /data1, /data2, /data3, /index1, /index2
PG> mysql user can create files in all of these mount points.
PG> The errors from starting mysql are;
PG> 020920 14:28:56 mysqld started
PG> 020920 14:28:56 InnoDB: syntax error in innodb_data_file_path
PG> 020920 14:28:56 Can't init databases
PG> 020920 14:28:56 mysqld ended
[skip]
PG> Can anyone tell me what the problem is?
Only last datafile can be specified as autoextending. Check the manual
for the correct syntax:
http://www.mysql.com/doc/en/InnoDB_start.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
