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 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: [EMAIL PROTECTED] > > "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/[EMAIL PROTECTED] > > -- Krishna Chandra Prajapati
