0.00025 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00022 |
SELECT user_id FROM posts_mentioned WHERE post_id="882693" LIMIT 1 |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="882715" LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_mentioned WHERE post_id="882715" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_mentioned WHERE post_id="884237" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_mentioned WHERE post_id="1204685" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_mentioned WHERE post_id="1208808" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1291886" ORDER BY id ASC |
0.00029 |
SELECT * FROM posts_comments WHERE post_id="1319152" ORDER BY id ASC |
0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1319152" LIMIT 1 |
0.00031 |
SELECT * FROM posts_comments WHERE post_id="1399868" ORDER BY id ASC |
0.00022 |
SELECT * FROM groups WHERE id="54" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="55164" LIMIT 1 |
0.00024 |
SELECT * FROM users_details WHERE user_id="16977" LIMIT 1 |
0.00032 |
SELECT * FROM users WHERE id="16977" LIMIT 1 |
0.00068 |
SELECT * FROM posts_comments WHERE post_id="1406151" ORDER BY id ASC |
0.00039 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1406151" LIMIT 1 |
0.00050 |
SELECT * FROM posts_comments WHERE post_id="1456699" ORDER BY id ASC |
0.30504 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%htaccess%" OR id IN(1291886, 1319152, 1399868, 1406151, 1456699)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.48379 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%htaccess%" OR id IN(1291886, 1319152, 1399868, 1406151, 1456699)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00029 |
SELECT id FROM groups WHERE is_public=0 |
0.07811 |
SELECT post_id FROM posts_comments WHERE message LIKE "%htaccess%" |
0.00029 |
SELECT id FROM searches WHERE user_id="" AND search_key="14a596ae66643913d23a67f22fe8b691" LIMIT 1 |
0.00028 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00029 |
SELECT * FROM settings |
0.00107 |
CONNECT 49.12.223.183:9906 |
0.00010 |
GET |
f5dad|1000|n:1,userid:9381 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:9139 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:1243 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:879 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:3403 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6502 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:2257 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:5914 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:5757 |
object |
0.00009 |
GET |
f5dad|1000|n:1,userid:6213 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:7347 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:471 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:14704 |
object |
0.00010 |
SET |
f5dad|1000|n:1,groupid:54 |
TRUE |
0.00010 |
GET |
f5dad|1000|n:1,groupid:54 |
FALSE |
0.00010 |
GET |
f5dad|1000|n:1,userid:8 |
object |
0.00014 |
SET |
f5dad|1000|n:1,userid:16977 |
TRUE |
0.00015 |
GET |
f5dad|1000|n:1,userid:16977 |
FALSE |
0.00019 |
GET |
f5dad|1000|n:1,userid:5011 |
object |
0.00018 |
GET |
f5dad|1000|n:1,userid:10647 |
object |
0.00276 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00016 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00030 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00005 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00006 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00007 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00027 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00001 |
CONNECT |
172.20.0.6:11211 |
TRUE |
nginx! Обаче има чутовно по-сложна настройка, ако си свикнал само със htaccess.
Mar 28 2014, 17:44
Mar 28 2014, 17:45Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_postcomment.php on line 102
И аз засега това чета http://arstechnica.com/series/web-served/
зависи за какво ти трябва и колко трафик ще имаш, ако очакваш 10 000+ на ден nginx пред апачето
Mar 28 2014, 21:44Всъщност настройката на nginx поне за мен върви много логично и приятно, ако имаш някакви проблеми може да драскаш
Mar 28 2014, 22:49