Re: SELECT in NULL state for a long time

2008-08-14 Thread Krishna Chandra Prajapati
Record the query, execute and see the result. Make sure that you get the result. To me its seems that lots of request are comming and not full filled. Check the query for optimization. On Thu, Aug 14, 2008 at 5:17 PM, Vlad Shalnev [EMAIL PROTECTED] wrote: Hi, OS - Solaris 10, 32 Gb RAM, mysql

RE: SELECT in NULL state for a long time

2008-08-14 Thread Martin Gainty
and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 14 Aug 2008 17:35:00 +0530 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: SELECT in NULL state for a long time CC

RE: SELECT and NULL

2006-06-25 Thread Peter Lauri
SELECT * FROM table WHERE some_field IS NOT NULL; -Original Message- From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] Sent: Sunday, June 25, 2006 2:24 PM To: mysql@lists.mysql.com Subject: SELECT and NULL This my be a dumb question, but I have search the docs without finding the