List:General Discussion« Previous MessageNext Message »
From:Vlad Shalnev Date:August 14 2008 11:47am
Subject:SELECT in NULL state for a long time
View as plain text  
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 )
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