Problemer med MySQl
Min MySQL hænger nogen gange i op til 17 sek. når den skal lave forsp.Her er en kopi af loggen. Nogen der måske kan fortælle hvorfor??
Jeg er virkelig desperat :(
# Time: 040601 21:44:18
# User@Host: dbuser[dbuser] @ localhost [127.0.0.1]
# Query_time: 22 Lock_time: 10 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 22 Lock_time: 10 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 19 Lock_time: 7 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 11 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 11 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # Time: 040601 21:44:19 # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 24 Lock_time: 11 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 10 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 15 Lock_time: 2 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 12 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 3 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 24 Lock_time: 11 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 15 Lock_time: 2 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 24 Lock_time: 11 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 22 Lock_time: 9 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 10 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 5 Rows_examined: 18768 SELECT ID,Brand,ItemType,ForumID FROM Topics WHERE SOLD=0 ORDER BY Buy_Top DESC,Buy_Top_StartDate DESC LIMIT 0, 5; # User@Host: dbuser[dbuser] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 18773 SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10;
