> >Hi, > >I am currently running mysql-3.23.52-3 on Linux 8.0 and myodbc 3.51.05 on win2000 >machines respectively. >Users and host IP has been setup on mysql, and innodb has been setup with as below. > >innodb_data_file_path = ibdata1:10M:autoextend >set-variable = innodb_buffer_pool_size=70M >set-variable = innodb_additional_mem_pool_size=10M >set-variable = innodb_log_file_size=20M >set-variable = innodb_log_buffer_size=8M >innodb_flush_log_at_trx_commit=1 > >However, when I tried to test conection with myodbc, it prompts >Lost connection to Mysql server during query > >In the error log, it shows >mysqld process hanging, pid 2073 - killed >030203 12:42:55 mysqld restarted >030203 12:42:56 InnoDB: Database was not shut down normally. >InnoDB: Starting recovery from log files... >InnoDB: Starting log scan based on checkpoint at >InnoDB: log sequence number 0 43892 >InnoDB: Doing recovery: scanned up to log sequence number 0 43892 >030203 12:42:56 InnoDB: Flushing modified pages from the buffer pool... >030203 12:42:56 InnoDB: Started >/usr/libexec/mysqld: ready for connections > >Would anyone know what I have done wrong ?? >Your help is very much appreciated. > >Sherman
--------------------------------------------------------------------- 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
