SELECT in NULL state for a long time
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]
Re: SELECT in NULL state for a long time
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
RE: SELECT in NULL state for a long time
If you want MYSQL to process the SELECT, including information about how tables are joined and in which order usehttp://dev.mysql.com/doc/refman/5.0/en/using-explain.htmle.g. EXPLAIN [EXTENDED] SELECT select_optionsIf you want MySQL uses the stored key distribution to decide the order in which tables should be joined when you perform a join on something other than a constant. In addition, key distributions can be used when deciding which indexes to use for a specific table within a query. http://dev.mysql.com/doc/refman/5.0/en/analyze-table.htmlYou can also check your stored key distributionhttp://dev.mysql.com/doc/refman/5.0/en/show-index.htmlMartin __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. Date: Thu, 14 Aug 2008 17:35:00 +0530 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: SELECT in NULL state for a long time CC: mysql@lists.mysql.com 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 _ Get more from your digital life. Find out how. http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home2_082008