OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
SELECT in NULL state for a long time

From: Vlad Shalnev (vladasv.ru)
Date: Thu Aug 14 2008 - 06:47:34 CDT

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: vladasv.ru

"Gravity can't be blamed
         for someone
                 falling in love"

                         ( Albert Einstein )

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql