Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
innodb_data_file_path=ibdata1:200M
innodb_data_home_dir=f:/mysql/innodb/ibdata
innodb_log_group_home_dir=f:/mysql/innodb/iblogs
The directories specified in the above variables exist.
However when I try to run the service I get the error Could not start the
MySQL service on Local Computer... Error 1067: The process terminated
unexpectedly. No error is logged in the mysql.err file in the data
directory.
It seems you are missing a innodb_log_arch_dir directive. I remember
innodb complaining about this not having the same value as
innodb_log_group_home_dir. Anyway, you could probably try to start
the daemon from the dos prompt directly, so you see error messages -
at least that's what I do on linux. (Currently I start it through a
perl script with the following options (strip the unix_file_flush
stuff of course):
exec qw{
/usr/local/mysql/libexec/mysqld
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var
--pid-file=/usr/local/mysql/var/pflanze.pid
--skip-locking
--innodb_data_home_dir=/usr/local/mysql/
--innodb_data_file_path=ibdata/ibdata1:1000M
--set-variable=innodb_mirrored_log_groups=1
--innodb_log_group_home_dir=/usr/local/mysql/iblog/
--set-variable=innodb_log_files_in_group=3
--set-variable=innodb_log_file_size=50M
--set-variable=innodb_log_buffer_size=8M
--innodb_flush_log_at_trx_commit=1
--innodb_log_arch_dir=/usr/local/mysql/iblog/
--innodb_log_archive=0
--set-variable=innodb_buffer_pool_size=90M
--set-variable=innodb_additional_mem_pool_size=5M
--set-variable=innodb_file_io_threads=4
--set-variable=innodb_lock_wait_timeout=50
--innodb_unix_file_flush_method=O_DSYNC
};
)
christian.
-
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
RE: Using InnoDb table type - Urgent help required
Thanks a lot for your help Christian.
I tried running the server from the DOS prompt and it complained about the
innodb_log_arch_dir variable. It is running fine now.
Rashmi
-Original Message-
From: Christian Jaeger [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 11:32 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
innodb_data_file_path=ibdata1:200M
innodb_data_home_dir=f:/mysql/innodb/ibdata
innodb_log_group_home_dir=f:/mysql/innodb/iblogs
The directories specified in the above variables exist.
However when I try to run the service I get the error Could not start the
MySQL service on Local Computer... Error 1067: The process terminated
unexpectedly. No error is logged in the mysql.err file in the data
directory.
It seems you are missing a innodb_log_arch_dir directive. I remember
innodb complaining about this not having the same value as
innodb_log_group_home_dir. Anyway, you could probably try to start
the daemon from the dos prompt directly, so you see error messages -
at least that's what I do on linux. (Currently I start it through a
perl script with the following options (strip the unix_file_flush
stuff of course):
exec qw{
/usr/local/mysql/libexec/mysqld
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/var
--pid-file=/usr/local/mysql/var/pflanze.pid
--skip-locking
--innodb_data_home_dir=/usr/local/mysql/
--innodb_data_file_path=ibdata/ibdata1:1000M
--set-variable=innodb_mirrored_log_groups=1
--innodb_log_group_home_dir=/usr/local/mysql/iblog/
--set-variable=innodb_log_files_in_group=3
--set-variable=innodb_log_file_size=50M
--set-variable=innodb_log_buffer_size=8M
--innodb_flush_log_at_trx_commit=1
--innodb_log_arch_dir=/usr/local/mysql/iblog/
--innodb_log_archive=0
--set-variable=innodb_buffer_pool_size=90M
--set-variable=innodb_additional_mem_pool_size=5M
--set-variable=innodb_file_io_threads=4
--set-variable=innodb_lock_wait_timeout=50
--innodb_unix_file_flush_method=O_DSYNC
};
)
christian.
-
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
-
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
Using InnoDb table type - Urgent help required
Hi, I am using mySQL on Windows 2000. I need to use the InnoDb table type to get transaction support. I had initially installed mysql and was using the ISAM table type and everything was working fine. My NT service was configured to run the mysqld-nt.exe. For using the InnoDb type I un-installed the service and re-installed it with mysqld-max-nt.exe. I also modified my.ini to include the innodb variables as follows: innodb_data_file_path=ibdata1:200M innodb_data_home_dir=f:/mysql/innodb/ibdata innodb_log_group_home_dir=f:/mysql/innodb/iblogs The directories specified in the above variables exist. However when I try to run the service I get the error Could not start the MySQL service on Local Computer... Error 1067: The process terminated unexpectedly. No error is logged in the mysql.err file in the data directory. When I remove the above innodb specific variables the service runs fine. I also tried un-installing mysql completely and re-installing it but no luck. Can somebody please help me? Thanks Rashmi - 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
