VPS hang

[serge]

Meni zadnja linija u tom logu je

# Time: 130119 15:46:09
# User@Host: ***********[*******] @ **********[]
# Query_time: 12.539435  Lock_time: 0.000123 Rows_sent: 10  Rows_examined: 2832
SET timestamp=1358628369;
SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND (((wp_posts.post_title LIKE '%lions%') OR (wp_posts.post_content LIKE '%lions%') OR (wp_posts.post_content REGEXP '\\[table id=(["\']?)(3|13|15|16)(["\' ])')) AND ((wp_posts.post_title LIKE '%arch%') OR (wp_posts.post_content LIKE '%arch%') OR (wp_posts.post_content REGEXP '\\[table id=(["\']?)(3)(["\' ])')))  AND (wp_posts.post_password = '')  AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10;

Tacno se vidi datum query-ja, kao i duzina izvrsavanja (u sekundama). Ako ti imas slican query sa velikom duzinom izvrsavanja u zadnjim linijama, on bi mogao da bude uzrocnik zabadanja VPS-a.

[chachaker]

Hvala serge, ipak sam ja pocetnik za ovaj nivo. Identifikovao sam logove baze koja mi je sumnjiva.

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.