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]
