alex95: http://www.faemalia.net/mysqlUtils/LiveJournalScalingPaper.pdf

Вход

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

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

alex95

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_post.php on line 382
http://www.faemalia.net/mysqlUtils/LiveJourna...gPaper.pdf

Nov 09 2009, 14:44

Facebook

DB Queries: 8 (0.0032s) | CACHE Queries: 15 (0.0014s) | Script Execution Time: 0.007 | Memory usage: 0.84MB | Server Load Average: 0.41, 0.38, 0.37

0.00025	SELECT user_id FROM posts_mentioned WHERE post_id="408628" LIMIT 1
0.00032	SELECT * FROM posts WHERE id<"408651" AND user_id="5950" ORDER BY id DESC LIMIT 1
0.00032	SELECT user_id FROM posts_mentioned WHERE post_id="408678" LIMIT 1
0.00033	SELECT * FROM posts WHERE id>"408651" AND user_id="5950" ORDER BY id ASC LIMIT 1
0.00029	SELECT id FROM groups WHERE is_public=0
0.00028	SELECT * FROM posts WHERE id="408651" LIMIT 1
0.00025	SELECT * FROM settings
0.00121	CONNECT 49.12.223.183:9906

0.00012	GET	f5dad\|1000\|n:1,userid:5597	object
0.00007	GET	f5dad\|1000\|n:1,group_invited_members:365	array
0.00007	GET	f5dad\|1000\|n:1,groupid:365	object
0.00009	GET	f5dad\|1000\|n:1,group_invited_members:358	array
0.00009	GET	f5dad\|1000\|n:1,groupid:358	object
0.00007	GET	f5dad\|1000\|n:1,group_invited_members:343	array
0.00008	GET	f5dad\|1000\|n:1,groupid:343	object
0.00007	GET	f5dad\|1000\|n:1,group_invited_members:240	array
0.00008	GET	f5dad\|1000\|n:1,groupid:240	object
0.00008	GET	f5dad\|1000\|n:1,group_invited_members:221	array
0.00007	GET	f5dad\|1000\|n:1,groupid:221	object
0.00008	GET	f5dad\|1000\|n:1,group_invited_members:132	array
0.00011	GET	f5dad\|1000\|n:1,groupid:132	object
0.00030	GET	f5dad\|1000\|n:1,userid:5950	object
0.00001	CONNECT	172.20.0.6:11211	TRUE