Thanks again I have some questions that may help me explain my problem well.
1- What's this mean: mysql> SHOW PROCESSLIS; +------+-------+----------------------+--------+---------------+---------+--------+-----------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-------+----------------------+--------+---------------+---------+---------+----------------+ | 1 | usr | myhost:36336 | mydb | Sleep | 2587 | | NULL | | 11 | usr | myhost:36341 | mydb | Sleep | 2587 | | NULL | | 12 | usr | myhost:36348 | mydb | Sleep | 2587 | | NULL | | 3732| usr | myhost:43940 | mydb | Sleep | 2587 | | NULL | +------+-------+----------------------+--------+---------------+---------+---------+----------------+ Are these processes idle? If yes why MySQL doesn't kill them? 2- If I set wait_timeout variable, will they be killed on that time? 3- If I set interactive_timeout, what will happen to queries that take time longer than interactive_timeout? On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote:
Hi Try command line option, like 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 > Thanks > But this sets. GLOBAL wait_timeout variable. > Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES; > > On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote: >> >> Hi >> >> specify it in the .cnf file in the mysqld options: wait_timeout=x >> or specify it at the command line : set wait_timeout=x >> 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 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=affiliates&id=0&t=1 "> >> > Get >> > FireFox! </a> >> > >> >> > > > -- > Sincerely, > Hadi Rastgou > A Google Account is the key that unlocks the world of Google. > <a href= "http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"> > Get > FireFox! </a> >
-- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. <a href= "http://www.spreadfirefox.com/?q=affiliates&id=0&t=1"> Get FireFox! </a>