The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Slow queries.
Any idea what causes these? Every few mins.
Code:
# 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; |
#2
|
||||
|
||||
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.
|
#3
|
|||
|
|||
ok wil try
--------------- Added [DATE]1240865570[/DATE] at [TIME]1240865570[/TIME] --------------- I disabled search and still get a bunch of these every few mins about 50 every 1 - 5 mins: Code:
# 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; Thanks, |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|