Tema: VPS hang
Pogledajte određenu poruku
Staro 20. 01. 2013.   #8
serge
član
Na probnom radu
 
Datum učlanjenja: 25.07.2008
Poruke: 39
Hvala: 5
11 "Hvala" u 8 poruka
serge is on a distinguished road
Default

Meni zadnja linija u tom logu je

Kôd:
# 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.
serge je offline   Odgovorite uz citat