crimsonsoul: VPS MySQL оптимизация и следене

Вход

Начало Потребители Групи

Следващ пост Профил на crimsonsoul Предишен пост

crimsonsoul

VPS MySQL оптимизация и следене

Oct 12 2009, 12:48

Facebook

DB Queries: 9 (0.0039s) | CACHE Queries: 15 (0.0012s) | Script Execution Time: 0.007 | Memory usage: 0.85MB | Server Load Average: 0.35, 0.27, 0.23

0.00022	SELECT id, type, data FROM posts_attachments WHERE post_id="378833" LIMIT 1
0.00069	SELECT * FROM posts WHERE id<"378853" AND user_id="7129" ORDER BY id DESC LIMIT 1
0.00022	SELECT user_id FROM posts_mentioned WHERE post_id="386271" LIMIT 1
0.00072	SELECT * FROM posts WHERE id>"378853" AND user_id="7129" ORDER BY id ASC LIMIT 1
0.00020	SELECT id FROM groups WHERE is_public=0
0.00025	SELECT id, type, data FROM posts_attachments WHERE post_id="378853" LIMIT 1
0.00024	SELECT * FROM posts WHERE id="378853" LIMIT 1
0.00026	SELECT * FROM settings
0.00112	CONNECT 49.12.223.183:9906