Slow queries.

[hydn]

Any idea what causes these? Every few mins.

# Time: 090427 11:17:29
# Time: 090427 12:10:34
# User@Host: root[root] @ [localhost]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 73180
use ads;
select count(*) as newposts from post where dateline >= 1234277022 and visible = 1;


over 100 within 5 mins

[Lynne]

You should try to find where that query is coming from. I can't find it in default vb files so look at your plugins.

[hydn]

ok wil try

--------------- Added 1240865570 at 1240865570 ---------------

I disabled search and still get a bunch of these every few mins about 50 every 1 - 5 mins:


# Time: 090427 13:28:28
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62266
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# Time: 090427 13:30:57
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62271
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62271
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62271
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62271
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62271
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 62271
select count(*) as newposts from post where dateline >= 1235149680 and visible = 1;
# Time: 090427 13:35:42
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# Time: 090427 13:35:43
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
# User@Host: root[root] @ [192.168.10.xx]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 103861
select count(*) as newposts from post where dateline >= 1231798232 and visible = 1;
Any ideas of source so I can stop these?

Thanks,