Avatar billede falslev Nybegynder
01. juni 2004 - 22:33 Der er 4 kommentarer og
1 løsning

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;
Avatar billede mahler Nybegynder
01. juni 2004 - 22:35 #1
Kan du ikke lige smide en:
EXPLAIN SELECT ID,ForumID,Brand,ItemType FROM Topics WHERE SOLD=0 ORDER BY Sold,ID DESC LIMIT 0, 10;

og en

DESC Topics;
Avatar billede arne_v Ekspert
01. juni 2004 - 23:06 #2
Er der index på SOLD ?
Avatar billede falslev Nybegynder
01. juni 2004 - 23:25 #3
table  type  possible_keys  key  key_len  ref  rows  Extra 
Topics ref Sold Sold 1 const 18674 Using where; Using filesort
Avatar billede falslev Nybegynder
01. juni 2004 - 23:28 #4
Disser indexer er der:

INDEX  4325 User,Sold 
INDEX  203 ForumID,Isearch,Sold 
INDEX  4 Isearch, Sold
INDEX  2 Sold 
INDEX  34603 Brand, ItemType, ItemColor, Isearch, Sold
Avatar billede falslev Nybegynder
24. juni 2004 - 09:24 #5
Jeg læste denne artikel om at indexere og optimere og det hjalp MEGET.
Kan godt anbefales:

http://www.databasejournal.com/features/mysql/article.php/1382791
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester