| 0.00032 |
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC |
| 0.00038 |
SELECT * FROM posts_comments WHERE post_id="1464225" ORDER BY id ASC |
| 0.00044 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464225" LIMIT 1 |
| 0.00027 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="133557" LIMIT 1 |
| 0.00040 |
SELECT * FROM posts_comments WHERE post_id="1464314" ORDER BY id ASC |
| 0.00039 |
SELECT * FROM posts_comments WHERE post_id="1464456" ORDER BY id ASC |
| 0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464456" LIMIT 1 |
| 0.00046 |
SELECT * FROM posts_comments WHERE post_id="1464546" ORDER BY id ASC |
| 0.00027 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464546" LIMIT 1 |
| 0.00043 |
SELECT user_id FROM posts_mentioned WHERE post_id="1464546" LIMIT 1 |
| 0.00032 |
SELECT * FROM posts_comments WHERE post_id="1464839" ORDER BY id ASC |
| 0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1464839" LIMIT 1 |
| 0.00032 |
SELECT * FROM posts_comments WHERE post_id="1464891" ORDER BY id ASC |
| 0.00029 |
SELECT * FROM posts_comments WHERE post_id="1465169" ORDER BY id ASC |
| 0.00026 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1465169" LIMIT 2 |
| 0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135943" LIMIT 2 |
| 0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135940" LIMIT 1 |
| 0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135936" LIMIT 1 |
| 0.00021 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="135916" LIMIT 1 |
| 0.00034 |
SELECT * FROM posts_comments WHERE post_id="1465432" ORDER BY id ASC |
| 0.00023 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1465432" LIMIT 1 |
| 0.00023 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="138453" LIMIT 1 |
| 0.00026 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="138447" LIMIT 1 |
| 0.00038 |
SELECT * FROM posts_comments WHERE post_id="1466379" ORDER BY id ASC |
| 0.00030 |
SELECT * FROM posts_comments WHERE post_id="1466928" ORDER BY id ASC |
| 0.00025 |
SELECT user_id FROM posts_mentioned WHERE post_id="1466928" LIMIT 1 |
| 0.00025 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139845" LIMIT 1 |
| 0.00024 |
SELECT user_id FROM posts_comments_mentioned WHERE comment_id="139842" LIMIT 1 |
| 0.00037 |
SELECT * FROM posts_comments WHERE post_id="1466969" ORDER BY id ASC |
| 0.00033 |
SELECT * FROM posts_comments WHERE post_id="1467208" ORDER BY id ASC |
| 0.00025 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467208" LIMIT 1 |
| 0.00026 |
SELECT user_id FROM posts_reshares WHERE post_id="1467217" ORDER BY id DESC LIMIT 1 |
| 0.00037 |
SELECT * FROM posts_comments WHERE post_id="1467217" ORDER BY id ASC |
| 0.00038 |
SELECT * FROM posts_comments WHERE post_id="1467288" ORDER BY id ASC |
| 0.00034 |
SELECT id, type, data FROM posts_attachments WHERE post_id="1467288" LIMIT 1 |
| 0.01199 |
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%cs%" OR id IN(1291523, 1291523, 1308483, 1292746, 1293939, 1294369, 1294927, 1294879, 1294476, 1295035, 1306859, 1316513, 1316976, 1316976, 1318472, 1321786, 1327985, 1329078, 1330776, 1330833, 1332400, 1334878, 1336293, 1336680, 1336680, 1336680, 1336803, 1337321, 1389826, 1337321, 1341476, 1334969, 1341818, 1342041, 1342041, 1342409, 1346145, 1346145, 1346172, 1348203, 1362617, 1357088, 1357088, 1361212, 1324755, 1364239, 1364239, 1366972, 1366972, 1367264, 1367264, 1367264, 1367695, 1368794, 1369066, 1370071, 1370684, 1370684, 1368507, 1388947, 1376329, 1377275, 1377318, 1447620, 1379699, 1379699, 1379728, 1380746, 1381392, 1383393, 1383469, 1383469, 1383997, 1383997, 1386567, 1390371, 1391091, 1392291, 1393323, 1393649, 1393649, 1393649, 1471742, 1394775, 1395454, 1396619, 1396640, 1396862, 1421238, 1399633, 1400247, 1400264, 1402061, 1444218, 1404539, 1404856, 1405934, 1406581, 1407424, 1408564, 1410758, 1410898, 1410898, 1410898, 1411642, 1411973, 1413896, 1447788, 1467292, 1401662, 1413441, 1416883, 1416938, 1417216, 1417910, 1418639, 1418157, 1419514, 1419679, 1420813, 1421031, 1421031, 1421204, 1421550, 1423097, 1423080, 1423372, 1423798, 1424008, 1457320, 1424152, 1424152, 1424247, 1424247, 1424247, 1432558, 1424755, 1424902, 1424902, 1471522, 1467505, 1424980, 1424902, 1432601, 1468017, 1426145, 1470619, 1427047, 1427871, 1427904, 1428207, 1429017, 1429137, 1429246, 1429347, 1429347, 1429321, 1429646, 1430328, 1430381, 1430381, 1430701, 1430975, 1431472, 1431656, 1457950, 1432983, 1432983, 1432983, 1433117, 1433698, 1433831, 1433913, 1434236, 1441930, 1436318, 1436673, 1436854, 1457055, 1438138, 1438138, 1438308, 1438456, 1470966, 1438553, 1438969, 1438984, 1470812, 1439333, 1457052, 1439638, 1439739, 1439814, 1470580, 1470580, 1441509, 1441915, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1442021, 1442553, 1442825, 1443286, 1443452, 1443604, 1443657, 1443837, 1471314, 1444777, 1445472, 1445820, 1446081, 1446251, 1446251, 1446476, 1446650, 1448100, 1448285, 1449490, 1457917, 1457950, 1451874, 1452128, 1452440, 1452910, 1453049, 1453265, 1453277, 1453370, 1454912, 1454908, 1455449, 1455680, 1455813, 1456134, 1456271, 1456414, 1458301, 1458833, 1458855, 1459560, 1459961, 1460540, 1460985, 1461295, 1461437, 1461508, 1461535, 1461637, 1461822, 1461972, 1462538, 1463118, 1463240, 1463419, 1463437, 1463431, 1463988, 1464456, 1464314, 1464546, 1464839, 1464891, 1465169, 1467645, 1466379, 1465432, 1466928, 1466969, 1470465, 1467208, 1467217, 1468181, 1469228, 1469220, 1469220, 1468216, 1468561, 1469715, 1469810, 1469810)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 30, 15 |
| 0.46938 |
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%cs%" OR id IN(1291523, 1291523, 1308483, 1292746, 1293939, 1294369, 1294927, 1294879, 1294476, 1295035, 1306859, 1316513, 1316976, 1316976, 1318472, 1321786, 1327985, 1329078, 1330776, 1330833, 1332400, 1334878, 1336293, 1336680, 1336680, 1336680, 1336803, 1337321, 1389826, 1337321, 1341476, 1334969, 1341818, 1342041, 1342041, 1342409, 1346145, 1346145, 1346172, 1348203, 1362617, 1357088, 1357088, 1361212, 1324755, 1364239, 1364239, 1366972, 1366972, 1367264, 1367264, 1367264, 1367695, 1368794, 1369066, 1370071, 1370684, 1370684, 1368507, 1388947, 1376329, 1377275, 1377318, 1447620, 1379699, 1379699, 1379728, 1380746, 1381392, 1383393, 1383469, 1383469, 1383997, 1383997, 1386567, 1390371, 1391091, 1392291, 1393323, 1393649, 1393649, 1393649, 1471742, 1394775, 1395454, 1396619, 1396640, 1396862, 1421238, 1399633, 1400247, 1400264, 1402061, 1444218, 1404539, 1404856, 1405934, 1406581, 1407424, 1408564, 1410758, 1410898, 1410898, 1410898, 1411642, 1411973, 1413896, 1447788, 1467292, 1401662, 1413441, 1416883, 1416938, 1417216, 1417910, 1418639, 1418157, 1419514, 1419679, 1420813, 1421031, 1421031, 1421204, 1421550, 1423097, 1423080, 1423372, 1423798, 1424008, 1457320, 1424152, 1424152, 1424247, 1424247, 1424247, 1432558, 1424755, 1424902, 1424902, 1471522, 1467505, 1424980, 1424902, 1432601, 1468017, 1426145, 1470619, 1427047, 1427871, 1427904, 1428207, 1429017, 1429137, 1429246, 1429347, 1429347, 1429321, 1429646, 1430328, 1430381, 1430381, 1430701, 1430975, 1431472, 1431656, 1457950, 1432983, 1432983, 1432983, 1433117, 1433698, 1433831, 1433913, 1434236, 1441930, 1436318, 1436673, 1436854, 1457055, 1438138, 1438138, 1438308, 1438456, 1470966, 1438553, 1438969, 1438984, 1470812, 1439333, 1457052, 1439638, 1439739, 1439814, 1470580, 1470580, 1441509, 1441915, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1441930, 1442021, 1442553, 1442825, 1443286, 1443452, 1443604, 1443657, 1443837, 1471314, 1444777, 1445472, 1445820, 1446081, 1446251, 1446251, 1446476, 1446650, 1448100, 1448285, 1449490, 1457917, 1457950, 1451874, 1452128, 1452440, 1452910, 1453049, 1453265, 1453277, 1453370, 1454912, 1454908, 1455449, 1455680, 1455813, 1456134, 1456271, 1456414, 1458301, 1458833, 1458855, 1459560, 1459961, 1460540, 1460985, 1461295, 1461437, 1461508, 1461535, 1461637, 1461822, 1461972, 1462538, 1463118, 1463240, 1463419, 1463437, 1463431, 1463988, 1464456, 1464314, 1464546, 1464839, 1464891, 1465169, 1467645, 1466379, 1465432, 1466928, 1466969, 1470465, 1467208, 1467217, 1468181, 1469228, 1469220, 1469220, 1468216, 1468561, 1469715, 1469810, 1469810)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) |
| 0.00033 |
SELECT id FROM groups WHERE is_public=0 |
| 0.07141 |
SELECT post_id FROM posts_comments WHERE message LIKE "%cs%" |
| 0.00025 |
SELECT id FROM searches WHERE user_id="" AND search_key="858c5c893d0c42439d9742716bd7e598" LIMIT 1 |
| 0.00024 |
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1 |
| 0.00025 |
SELECT * FROM settings |
| 0.00122 |
CONNECT 49.12.223.183:9906 |
blacksnoopy
.ToList()
_e7
Ние защото минахме през 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