![]() |
Slow queries. I've been getting a bunch of these every few mins: Code: # Time: 090427 11:17:29 # User@Host: root[root] @ [localhost] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; # User@Host: root[root] @ [localhost] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 73126 select count(*) as newdb_posts from db_post where dateline >= 1234277022 and visible = 1; I ideas of source so I can stop these? Thanks, |
الساعة الآن 09:17 AM |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir