Hvala serge, ipak sam ja pocetnik za ovaj nivo. Identifikovao sam logove baze koja mi je sumnjiva.
Kôd:
SELECT arhiva.*, list.* FROM list LEFT JOIN arhiva ON list.InvertarniBroj = arhiva.arhivaid WHERE arhiva.VrstaGradje LIKE '%5%' AND ( arhiva.Autor
LIKE '%pamela%' AND arhiva.Autor LIKE '%aidan%') GROUP BY arhiva.arhivaid LI$
# Time: 130116 19:05:28
# User@Host: * @ localhost []
# Query_time: 11.257197 Lock_time: 0.000077 Rows_sent: 10 Rows_examined: 37356
SET timestamp=1358359528;
SELECT arhiva.*, list.* FROM list LEFT JOIN arhiva ON list.InvertarniBroj = arhiva.arhivaid WHERE arhiva.VrstaGradje LIKE '%4%' AND (
list.Odrednice LIKE '%остра%') LIMIT 140, 10;
# Time: 130117 19:51:55
# User@Host: * @ localhost []
# Query_time: 11.061628 Lock_time: 0.000079 Rows_sent: 0 Rows_examined: 46709
SET timestamp=1358448715;
SELECT arhiva.*, list.* FROM list LEFT JOIN arhiva ON list.InvertarniBroj = arhiva.arhivaid WHERE arhiva.VrstaGradje LIKE '%%' AND (
list.Odrednice LIKE '%ana%' AND list.Odrednice LIKE '%karenjina%');
# Time: 130117 21:11:30
# User@Host: * @ localhost []
# Query_time: 476.310182 Lock_time: 0.000026 Rows_sent: 27726 Rows_examined: 27726
SET timestamp=1358453490;
SELECT * FROM `*`.`list`;
# Time: 130117 21:38:34
# User@Host: * @ localhost []
# Query_time: 266.563287 Lock_time: 0.000026 Rows_sent: 46709 Rows_examined: 46709
SET timestamp=1358455114;
SELECT * FROM `*`.`list`;
Ono sto sam pirmetio je i veiki broj logova vezanih za dve WordPress baze koje koristimo, bas u periodu kada smo imali intenzivirane pomenute probleme. U poslednjih nedelju dana tih logova vise nema, ostaju ovi gornji koji se ticu baze koja gura digitalnu biblioteku.