0.00026 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
0.00025 |
SELECT user_id FROM posts_mentioned WHERE post_id="1203182" LIMIT 1 |
0.00032 |
SELECT * FROM posts_comments WHERE post_id="1291886" ORDER BY id ASC |
0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1351532" LIMIT 1 |
0.00028 |
SELECT * FROM posts_comments WHERE post_id="1364538" ORDER BY id ASC |
0.00026 |
SELECT * FROM posts_comments WHERE post_id="1386266" ORDER BY id ASC |
0.00024 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1386266" LIMIT 1 |
0.00027 |
SELECT * FROM posts_comments WHERE post_id="1392682" ORDER BY id ASC |
0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1392682" LIMIT 1 |
0.00034 |
SELECT * FROM posts_comments WHERE post_id="1456699" ORDER BY id ASC |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139311" LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139310" LIMIT 2 |
0.00027 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139309" LIMIT 2 |
0.00022 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139305" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139300" LIMIT 1 |
0.00020 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139299" LIMIT 1 |
0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139298" LIMIT 1 |
0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139297" LIMIT 1 |
0.00028 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139295" LIMIT 1 |
0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139291" LIMIT 1 |
0.00036 |
SELECT * FROM posts_comments WHERE post_id="1466739" ORDER BY id ASC |
0.00033 |
SELECT * FROM posts_comments WHERE post_id="1467288" ORDER BY id ASC |
0.00032 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467288" LIMIT 1 |
0.23476 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%nginx%" OR id IN(1291886, 1291886, 1386266, 1392682, 1456699, 1456699, 1456699, 1466739)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15 |
0.48325 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%nginx%" OR id IN(1291886, 1291886, 1386266, 1392682, 1456699, 1456699, 1456699, 1466739)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
0.00030 |
SELECT id FROM groups WHERE is_public=0 |
0.07392 |
SELECT post_id FROM posts_comments WHERE message LIKE "%nginx%" |
0.00025 |
SELECT id FROM searches WHERE user_id="" AND search_key="afbdd46b6d5ed58e9431df7813180b46" LIMIT 1 |
0.00029 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
0.00027 |
SELECT * FROM settings |
0.00114 |
CONNECT 49.12.223.183:9906 |
0.00010 |
GET |
f5dad|1000|n:1,userid:120 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6774 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:5914 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:5757 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:1343 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:5950 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:585 |
object |
0.00013 |
GET |
f5dad|1000|n:1,userid:7129 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:86 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:9139 |
object |
0.00011 |
GET |
f5dad|1000|n:1,userid:6135 |
object |
0.00010 |
GET |
f5dad|1000|n:1,userid:7759 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:10647 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:38 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:1 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:8479 |
object |
0.00014 |
GET |
f5dad|1000|n:1,userid:383 |
object |
0.00012 |
GET |
f5dad|1000|n:1,userid:6742 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:5794 |
object |
0.00015 |
GET |
f5dad|1000|n:1,userid:6580 |
object |
0.00029 |
GET |
f5dad|1000|n:1,userid:2628 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:365 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:358 |
object |
0.00010 |
GET |
f5dad|1000|n:1,groupid:343 |
object |
0.00008 |
GET |
f5dad|1000|n:1,groupid:240 |
object |
0.00009 |
GET |
f5dad|1000|n:1,groupid:221 |
object |
0.00036 |
GET |
f5dad|1000|n:1,groupid:132 |
object |
0.00001 |
CONNECT |
172.20.0.6:11211 |
TRUE |
Ние защото минахме през elastic search ама е мега зле, ние държим доста редове и търси бързо (ако говорим за fulltext search)
Nov 21 2015, 16:45колко зле? що ние го тествахме с около 40 милиона записа с parent child връзки и подобни се държеше много добре също е важно и как си направиш индексите
Nov 21 2015, 21:19типовете, дали имаш computed полета, дали пазиш оригиналната стойност след индексация и на каква и колко машина/и имаш
Nov 21 2015, 21:20Самата информация я държим в mysql с tokudb, а в sphinx-а само нещата, по които се търси и имаме почти 500 милиона реда на един сървър 128GB ram, 32 CPU cores
Nov 23 2015, 21:54средно време за търсене е около 2 секунди, но някои от редовете са доста големи, сега сигурно ще се опитаме да го разделим на 2 сървъра.
Nov 23 2015, 21:56