List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:August 14 2008 12:05pm
Subject:Re: SELECT in NULL state for a long time
View as plain text  
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 <vlad@stripped> wrote:

> Hi,
>
> OS - Solaris 10, 32 Gb RAM, mysql 64-bit 4.1.22
>
> Every day I see in processlist many SELECT queries that stay in NULL state
> for a long time. Something Like this
>
> | 368966 | radius | fire-u1:35671       | srg_conf     | Query   |   106 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM s
>
> | 368967 | radius | fire-u1-1:35672     | srg_conf     | Query   |   105 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM s
>
> | 368968 | radius | fire-u1-1:35673     | srg_conf     | Query   |   101 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM s
>
> | 368969 | radius | fire-u1:35674       | srg_conf     | Query   |   101 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM s
>
> | 368970 | radius | fire-u1:35675       | srg_conf     | Query   |   100 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM s
>
> |     28 | mysql  | fire-u1:58138       | hnt_cn       | Query   |   116 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM h
>
> |     48 | radius | fire-u1:58166       | hnt_cn       | Query   |   114 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM h
>
> |     49 | radius | fire-u1-1:58165     | srg_cn       | Query   |   127 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM s
>
> |     50 | mysql  | fire-u1-1:58163     | blr_cn       | Query   |   120 |
> NULL           |SELECT id, deleted_id, status, name, LEFT( value, 1000 )
> FROM b
>
> Connections grow up during this time and after a couple minutes this
> problem gonna away.
>
> Explain me please why it happens and how can I solve this problem
>
> Thanks
>
> --
>
> --------------------------------------------------------------------------------
> Vlad A. Shalnev
> E-mail: vlad@stripped
>
> "Gravity can't be blamed
>        for someone
>                falling in love"
>
>                        ( Albert Einstein )
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Krishna Chandra Prajapati

Thread
SELECT in NULL state for a long timeVlad Shalnev14 Aug
  • Re: SELECT in NULL state for a long timeKrishna Chandra Prajapati14 Aug
    • RE: SELECT in NULL state for a long timeMartin Gainty14 Aug