Re: wait_timeout help

2006-11-08 Thread Sayed Hadi Rastgou Haghi
of 'wait_timeout' expired. For others, the mysql gets reconnected with 'reconnect flag' set to 1 in the MySQL structure... Thanks ViSolve DB Team - Original Message - *From:* Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] *To:* Visolve DB Team [EMAIL PROTECTED] *Cc:* mysql@lists.mysql.com

wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
Dear All, I want to set wait_timeout variable on mysqld startup. Is there any way to do that? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get FireFox! /a

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
or start mysqld with --wait_timeout=x along with other options. Thanks ViSolve DB Team - Original Message - From: Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006 2:08 PM Subject: wait_timeout help Dear All, I want to set

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
mysql set @@session.wait_timeout=15; mysql show variables; Thanks Visolve DB Team. - Original Message - From: Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006 3:21 PM Subject: Re: wait_timeout help

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
by the CLIENT_INTERACTIVE connect option to mysql_real_connect()) Thanks ViSolve DB Team. - Original Message - *From:* Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] *To:* Visolve DB Team [EMAIL PROTECTED] *Cc:* mysql@lists.mysql.com *Sent:* Tuesday, November 07, 2006 4:12 PM *Subject:* Re: wait_timeout help

Automatically Log Splitting.

2006-11-03 Thread Sayed Hadi Rastgou Haghi
Dear all, I know that there is a MERGE engine in mysql. It's great. I want to know is there a way to make new log tables and new merge table based on some criteria. Let me explain more with an example. I have a log_2004_09_01 table and a MERGE table on it called log. I want to automatically make

Best MySQL configuation

2006-09-26 Thread Sayed Hadi Rastgou Haghi
Dear All, What is the best configuration for a server with 2 XEON dual core CPU and 4GB Ram and 200GB RAID 5 hard? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get FireFox! /a

InnoDB Crash RECOVERY HELP (Urgent)

2006-09-21 Thread Sayed Hadi Rastgou Haghi
Dear all, our DB server crashed and when I try to start Mysql /etc/init.d/mysql/start I get these lins in my error log 060921 13:00:14 mysqld started 060921 13:00:14 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the