search

niftyisucon / isucon13

0 stars 0 forks source link

Benchmark result on isu2 #3

Open github-actions[bot] opened 10 months ago

github-actions[bot] commented 10 months ago
COUNT 1XX 2XX 3XX 4XX 5XX METHOD URI MIN MAX SUM AVG P90 P95 P99 STDDEV MIN(BODY) MAX(BODY) SUM(BODY) AVG(BODY)
573 0 569 0 4 0 GET /api/livestream 0.004 7.008 251.852 0.440 1.032 1.236 1.808 0.563 0.000 38629.000 4528581.000 7903.283
1784 0 1776 0 8 0 GET /api/user/[a-zA-Z0-9]+ 0.004 20.004 245.869 0.138 0.216 0.328 0.740 0.912 0.000 171848.000 101885138.000 57110.503
499 0 492 0 7 0 POST /api/livestream 0.004 7.992 166.192 0.333 0.428 0.664 4.932 0.751 0.000 2715.000 877326.000 1758.168
45 0 44 0 1 0 GET /api/livestream/search 0.172 6.936 121.536 2.701 4.276 6.152 6.936 1.613 0.000 132269.000 3238470.000 71966.000
200 0 197 0 2 1 POST /api/register 0.004 0.972 44.104 0.221 0.408 0.508 0.724 0.142 0.000 504.000 92356.000 461.780
97 0 93 0 4 0 POST /api/livestream/reservation 0.224 1.040 43.608 0.450 0.872 0.936 1.040 0.321 0.000 1492.000 104716.000 1079.546
197 0 197 0 0 0 POST /api/icon 0.008 1.128 30.812 0.156 0.360 0.520 0.756 0.162 14.000 16.000 3044.000 15.452
205 0 203 0 2 0 POST /api/login 0.004 0.876 21.320 0.104 0.320 0.468 0.624 0.153 0.000 64.000 128.000 0.624
1 0 1 0 0 0 POST /api/initialize 10.264 10.264 10.264 10.264 10.264 10.264 10.264 0.000 27.000 27.000 27.000 27.000
76 0 76 0 0 0 GET /api/tag 0.004 0.576 7.428 0.098 0.248 0.340 0.576 0.117 6089.000 6095.000 463028.000 6092.474
14 0 14 0 0 0 DELETE /api/livestream 0.004 0.660 2.084 0.149 0.564 0.660 0.660 0.204 0.000 0.000 0.000 0.000
5 0 5 0 0 0 GET /api/user/[a-zA-Z0-9]+/theme 0.012 0.260 0.316 0.063 0.260 0.260 0.260 0.099 38.000 38.000 190.000 38.000
1 0 1 0 0 0 GET / 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 396.000 396.000 396.000 396.000
1 0 1 0 0 0 GET /api/payment 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 21.000 21.000 21.000 21.000
3 0 3 0 0 0 GET /api/user/me 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 235.000 247.000 729.000 243.000
github-actions[bot] commented 10 months ago 
Reading from STDIN ...

# 28.4s user time, 150ms system time, 36.95M rss, 43.48M vsz
# Current date: Sat Nov 25 01:43:09 2023
# Hostname: ip-192-168-0-12
# Files: STDIN
# Overall: 455.78k total, 93 unique, 4.56k QPS, 4.85x concurrency ________
# Time range: 2023-11-25T01:40:16 to 2023-11-25T01:41:56
# Attribute          total     min     max     avg     95%  stddev  median
# ============     ======= ======= ======= ======= ======= ======= =======
# Exec time           485s     1us   353ms     1ms     4ms     4ms    66us
# Lock time          694ms       0    34ms     1us     1us   116us       0
# Rows sent        179.10k       0   7.32k    0.40    0.99   18.30       0
# Rows examine     147.04M       0  14.02k  338.29   1.33k   1.35k       0
# Query size        47.13M       5   1.94M  108.42  299.03   3.49k   31.70

# Profile
# Rank Query ID                           Response time  Calls  R/Call V/M
# ==== ================================== ============== ====== ====== ===
#    1 0xF7144185D9A142A426A36DC55C1D2623 136.8131 28.2%   5878 0.0233  0.01 SELECT livestream_tags
#    2 0x42EF7D7D98FBCC9723BF896EBFC51D24  48.9762 10.1%   7238 0.0068  0.00 SELECT records
#    3 0xDA556F9115773A1A99AA0165670CE848  42.9818  8.9% 133476 0.0003  0.00 ADMIN PREPARE
#    4 0x84B457C910C4A79FC9EBECB8B1065C66  42.2695  8.7%  10587 0.0040  0.01 SELECT icons
#    5 0xF1B8EF06D6CA63B24BFF433E06CCEB22  27.1317  5.6%   3801 0.0071  0.01 SELECT users livestreams livecomments
#    6 0xDB74D52D39A7090F224C4DEEAF3028C9  26.1591  5.4%   3803 0.0069  0.01 SELECT users livestreams reactions
#    7 0x3D83BC87F3B3A00D571FFC8104A6E50C  26.0657  5.4%   5327 0.0049  0.01 SELECT records
#    8 0x59F1B6DD8D9FEC059E55B3BFD624E8C3  17.1809  3.5%    790 0.0217  0.01 SELECT reservation_slots
#    9 0x38BC86A45F31C6B1EE324671506C898A  16.4841  3.4%   8819 0.0019  0.00 SELECT themes
#   10 0x4ADE2DC90689F1C4891749AF54FB8D14  14.1930  2.9%  29289 0.0005  0.00 DELETE SELECT livecomments
#   11 0x64CC8A4E8E4B390203375597CE4D611F   9.9471  2.1%    216 0.0461  0.01 SELECT ng_words
#   12 0xFFFCA4D67EA0A788813031B8BBC3B329   8.1843  1.7%   2095 0.0039  0.00 COMMIT
#   13 0xFBC5564AE716EAE82F20BFB45F6C37E7   7.6764  1.6%  21154 0.0004  0.00 SELECT tags
#   14 0x22279D81D51006139E0C76405B54C261   5.9207  1.2%   8688 0.0007  0.00 SELECT domains domainmetadata
#   15 0x8F7679D452333ED3C7D60D22131CEFD4   4.6681  1.0%  22294 0.0002  0.00 ADMIN RESET STMT
#   16 0xA3401CA3ABCC04C3AB221DB8AD5CBF26   4.3592  0.9%     94 0.0464  0.02 UPDATE reservation_slots
#   17 0xFD38427AE3D09E3883A680F7BAF95D3A   4.3234  0.9%  14992 0.0003  0.00 SELECT livestreams livecomments
#   18 0xD2A0864774622BA36F6557496405CF75   4.0755  0.8%   1197 0.0034  0.00 INSERT themes
#   19 0xDFFCC1D78939C4D781C7C58349101F50   4.0483  0.8%   1000 0.0040  0.00 INSERT users
#   20 0x7F9C0C0BA9473953B723EE16C08655F1   4.0481  0.8%     95 0.0426  0.02 SELECT reservation_slots
#   21 0xC499D81D570D361DB61FC43A94BB888A   3.7640  0.8%  14992 0.0003  0.00 SELECT livestreams reactions
#   22 0x9EAD6C0CE525E3693EE27FFC9AAF05A3   3.1988  0.7%     76 0.0421  0.01 SELECT livestreams
#   23 0x859BBB7E9D760686137A944406874C4D   3.0712  0.6%    197 0.0156  0.01 DELETE records
#   24 0xEA1E6309EEEFF9A6831AD2FB940FC23C   2.9209  0.6%   8617 0.0003  0.00 SELECT users
#   25 0x3A2B0EDA41C4E3576FCA6DA29A9B91DF   1.7267  0.4%    197 0.0088  0.01 INSERT icons
#   26 0x9AC623FA477E73A44D191D296850A025   1.7183  0.4%    394 0.0044  0.00 SELECT records
#   27 0xD6032FE08E1FE706A928B8B7CBA06B85   1.5276  0.3%   4501 0.0003  0.00 SELECT livestreams
#   28 0x07890000813C4CC7111FD2D3F3B3B4EB   1.5233  0.3% 133455 0.0000  0.00 ADMIN CLOSE STMT
#   29 0xEDE18C1523658A19E07525EAFCBA6BFE   1.3381  0.3%     25 0.0535  0.00 SELECT ng_words
#   30 0xB08B7B7486D2DFE2F2FE9CE78689FD79   1.0252  0.2%     20 0.0513  0.01 SELECT ng_words
#   31 0x3F155F5E71EFF856F0CF7B8430DE8C23   0.8401  0.2%   1985 0.0004  0.00 SELECT users
#   32 0xF1E5C5B0483E8BF764220BFACAE7CD16   0.8202  0.2%    197 0.0042  0.01 DELETE icons
#   33 0xFFF66E9B3D962FA319C8068B5C1997CD   0.7089  0.1%   1784 0.0004  0.00 ROLLBACK
#   34 0x9E2DA589A20EC24C34E11DDE0FBF5564   0.5977  0.1%   3693 0.0002  0.00 START
#   35 0xB78E63D0D9C72DDDAB7A3E53517FA04C   0.5680  0.1%    181 0.0031  0.00 SELECT livecomments
#   36 0xAD0C28443E1E5CFAFF1569DBB4F7E63A   0.4653  0.1%    213 0.0022  0.00 SELECT reactions
#   37 0x98F959E03B684A5538FD8402A0EE94AD   0.3845  0.1%    103 0.0037  0.00 INSERT tags
#   38 0x02B6A87E51A5A1B7646675DB67C57DE3   0.3535  0.1%      1 0.3535  0.00 INSERT ng_words
#   39 0x80E10371CE74ED05E09C79C72C73F8E1   0.2880  0.1%     95 0.0030  0.20 INSERT livestreams
#   40 0x41F805E95754958A974F41AE07BEA625   0.2798  0.1%     27 0.0104  0.01 SELECT livecomments
#   41 0x77FB9E134D073862D1E78FEEC3436291   0.2692  0.1%   1477 0.0002  0.00 INSERT records
#   42 0x0C1FCBB4E25B178AA3A46D4FECBA9BDC   0.2425  0.1%     22 0.0110  0.00 INSERT livestream_tags
#   43 0x651E3772B8767A368CB47EE7389EEB33   0.1685  0.0%     14 0.0120  0.01 SELECT livestream_tags
#   44 0xB9AC05A7AE6C4E30B5B45F6F3CE05BE0   0.1645  0.0%    396 0.0004  0.01 SET
#   45 0xF3A502CCF34F7DA288CC1B75AD5AFA37   0.1417  0.0%    215 0.0007  0.00 INSERT livecomments
#   46 0x5D469B53C536D19CD15E40763ACC23C7   0.1398  0.0%    392 0.0004  0.00 INSERT livestream_tags
#   47 0xDF0AAE38E2AAFC85E6F50569CEF2285D   0.1384  0.0%      1 0.1384  0.00 INSERT reservation_slots
#   48 0x64052B1C32B30DF53AB3292208B783B4   0.1237  0.0%    198 0.0006  0.00 INSERT users
#   49 0x5AEB6E4A781A3854CF642125E293FEE0   0.0786  0.0%    194 0.0004  0.00 INSERT reactions
#   50 0xEE4C51AE2BF74414C4892CBE11E894AA   0.0514  0.0%     22 0.0023  0.00 SELECT livecomments
#   51 0x81E419F4B58AEB9B280B03DE44DD8B94   0.0431  0.0%    125 0.0003  0.00 SELECT livecomments
#   52 0x544239977D2094F805A7B062DE95673A   0.0371  0.0%     76 0.0005  0.00 SELECT tags
#   53 0xE623383C5D789800DC0946925F90039F   0.0369  0.0%    198 0.0002  0.00 SELECT domains
#   54 0x19A1F14EFC0F221D30AFCB1E1344BEBD   0.0363  0.0%      6 0.0060  0.01 SELECT users
#   55 0xE64D50F7AFC1AD5F465809A92DF4935E   0.0324  0.0%     21 0.0015  0.00 SELECT reactions
#   56 0x253CA101A906B3D56A95D1B8DCEE28EF   0.0314  0.0%      1 0.0314  0.00 TRUNCATE TABLE icons
#   57 0x827F41D30F8E37F04D8BDCD46C556FB3   0.0311  0.0%     43 0.0007  0.00 INSERT livecomment_reports
#   58 0x07F6C3FF39ADD79FC63923A7EE938953   0.0310  0.0%      1 0.0310  0.00 INSERT livecomments
#   59 0xBB7F4DC4E67BF30E0588D296FFAF009F   0.0309  0.0%      1 0.0309  0.00 TRUNCATE TABLE tags
#   60 0x1FB70DBF74628C9F2E9F0C3478771936   0.0305  0.0%      1 0.0305  0.00 TRUNCATE TABLE ng_words
#   61 0x08A6ACD83D579DD8A808134B32AD376B   0.0287  0.0%      1 0.0287  0.00 TRUNCATE TABLE livestream_tags
#   62 0xDBB1C17D6ABA0156D8ABCE105DDDA1B2   0.0278  0.0%      1 0.0278  0.00 TRUNCATE TABLE users
#   63 0xAFFDC331C1D4BA089978A0B8DD00BFC8   0.0276  0.0%      1 0.0276  0.00 TRUNCATE TABLE livestreams
#   64 0xFB296F703ACC41C3F94A9B7D75044F3C   0.0275  0.0%      1 0.0275  0.00 TRUNCATE TABLE reactions
#   65 0x9C697B3F0446BBF7602663588252F020   0.0275  0.0%      1 0.0275  0.00 TRUNCATE TABLE livestream_viewers_history
#   66 0xA7C2E59AEF14D03CB65B227F3E3BA469   0.0269  0.0%      1 0.0269  0.00 TRUNCATE TABLE reservation_slots
#   67 0x4B6FA79E206C6CED71D433A2FC998D69   0.0264  0.0%     63 0.0004  0.00 SELECT
#   68 0x050F7D44808F43E5D33D0B90BCF57CC9   0.0252  0.0%      2 0.0126  0.00 SELECT livestreams
#   69 0x24C44C3518CE12293EF12410AEDA2393   0.0248  0.0%     31 0.0008  0.00 SELECT livestreams
#   70 0x2AAED5867123C749367FD8E4BBD796D2   0.0245  0.0%      1 0.0245  0.00 TRUNCATE TABLE livecomments
#   71 0xD2978B45C67B47B5D73AC532EB40A95E   0.0237  0.0%      1 0.0237  0.00 TRUNCATE TABLE themes
#   72 0x93A42F50BF286ACA749DF5F342FAC07B   0.0236  0.0%      1 0.0236  0.00 TRUNCATE TABLE livecomment_reports
#   73 0x74232BDFFB94C567F0340DBE3285E458   0.0202  0.0%      1 0.0202  0.00 INSERT reactions
#   74 0x466EE4C87B17CAD4E692DE1D44EAD84D   0.0150  0.0%     34 0.0004  0.00 SELECT livecomment_reports
#   75 0x8D589AFA4DFAEEED85FFF5AA78E5FF6A   0.0133  0.0%    198 0.0001  0.00 BEGIN
#   76 0xDFEFE5BA5D8654534DC8550C6E3DC9C0   0.0117  0.0%      1 0.0117  0.00 DELETE records
#   77 0xBF3194A2446AC20FC99B6CC7FA476A57   0.0112  0.0%     23 0.0005  0.00 INSERT livestream_viewers_history
#   78 0x2B760561C10B5D133155AA306D0F407C   0.0068  0.0%     18 0.0004  0.00 SELECT livecomments
#   79 0xB871CC5B0472067402F5739D108B2C1C   0.0044  0.0%     20 0.0002  0.00 SELECT livestreams
#   80 0x0C655718656DD9DDA39A0D11554A0C64   0.0040  0.0%     20 0.0002  0.00 INSERT ng_words
#   81 0x8B2044ADAE690405979131C33185F22A   0.0036  0.0%      5 0.0007  0.00 SELECT users
#   82 0xA0D956F292B7FEA0DCE68A5DD5F529E1   0.0027  0.0%     14 0.0002  0.00 DELETE livestream_viewers_history
#   83 0xF985E5835B84E84C7A721801818E98CE   0.0025  0.0%      2 0.0013  0.00 SELECT users livestreams reactions
#   84 0x49F80FBE1AC70F23A3DD076174FF1AA9   0.0023  0.0%      2 0.0011  0.00 SELECT users livestreams reactions
#   85 0x20CD15DC47AF2F861B8F3C25D195ABE9   0.0014  0.0%     14 0.0001  0.00 SELECT tags
#   86 0x2C17BCA1E1077820CDC2EC6106F4D93E   0.0011  0.0%     18 0.0001  0.00 SELECT livestream_viewers_history
#   87 0x0E7680C04FF2596BE3A3649C5FAC418D   0.0007  0.0%      9 0.0001  0.00 SELECT
#   88 0xEBE4AF9F935DE1D48BB5BB3558C7FCC4   0.0006  0.0%      2 0.0003  0.00 SELECT livestreams livecomments
#   89 0xEDBC971AEC392917AA353644DE4C4CB4   0.0006  0.0%    299 0.0000  0.00 ADMIN QUIT
#   90 0x8F885091E23CB955C051B1204EE7D91D   0.0005  0.0%      2 0.0003  0.00 SELECT livestreams reactions
#   91 0xC4625761E0CFD817F41B4802F152A489   0.0004  0.0%      1 0.0004  0.00 SELECT livecomments
#   92 0x394E66DDE2823A903078D4C0F235B948   0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livecomment_reports
#   93 0xF085F31DC1964EA538732B713E4B4108   0.0002  0.0%      2 0.0001  0.00 SELECT livestreams livestream_viewers_history

# Query 1: 65.31 QPS, 1.52x concurrency, ID 0xF7144185D9A142A426A36DC55C1D2623 at byte 50348985
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T01:40:26 to 2023-11-25T01:41:56
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    5878
# Exec time     28    137s     2ms    87ms    23ms    48ms    15ms    24ms
# Lock time      2    15ms       0     2ms     2us     1us    43us     1us
# Rows sent     11  20.67k       0      11    3.60    4.96    1.85    4.96
# Rows examine  42  62.44M  10.71k  11.09k  10.88k  10.80k     196  10.80k
# Query size     0 321.24k      54      56   55.96   54.21    0.14   54.21
# String:
# Databases    isupipe
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  #######################
#  10ms  ################################################################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'livestream_tags'\G
#    SHOW CREATE TABLE `isupipe`.`livestream_tags`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM livestream_tags WHERE livestream_id = 7501\G

# Query 2: 72.38 QPS, 0.49x concurrency, ID 0x42EF7D7D98FBCC9723BF896EBFC51D24 at byte 47243167
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T01:40:16 to 2023-11-25T01:41:56
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          1    7238
# Exec time     10     49s   695us    68ms     7ms    17ms     6ms     5ms
# Lock time      2    19ms       0     2ms     2us     1us    38us     1us
# Rows sent      0   1.43k       0       1    0.20    0.99    0.40       0
# Rows examine   6   9.61M   1.25k   1.45k   1.36k   1.39k   55.29   1.33k
# Query size     2 1000.22k     129     214  141.51  158.58   11.63  136.99
# String:
# Databases    isudns
# Hosts        localhost
# Users        isudns
# Query_time distribution
#   1us
#  10us
# 100us  #
#   1ms  ################################################################
#  10ms  #######################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isudns` LIKE 'records'\G
#    SHOW CREATE TABLE `isudns`.`records`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and name='*.u.isucon.dev' and domain_id=2\G

# Query 3: 1.33k QPS, 0.43x concurrency, ID 0xDA556F9115773A1A99AA0165670CE848 at byte 42512825
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.00
# Time range: 2023-11-25T01:40:16 to 2023-11-25T01:41:56
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count         29  133476
# Exec time      8     43s    22us   228ms   322us     1ms     1ms    73us
# Lock time      0     3us       0     3us       0       0       0       0
# Rows sent      0       0       0       0       0       0       0       0
# Rows examine   0       0       0       0       0       0       0       0
# Query size     8   3.82M      30      30      30      30       0      30
# String:
# Databases    isupipe (132281/99%), isudns (1195/0%)
# Hosts        localhost
# Users        isucon (132281/99%), isudns (1195/0%)
# Query_time distribution
#   1us
#  10us  ################################################################
# 100us  #####################################
#   1ms  #######
#  10ms  #
# 100ms  #
#    1s
#  10s+
administrator command: Prepare\G

# Query 4: 117.63 QPS, 0.47x concurrency, ID 0x84B457C910C4A79FC9EBECB8B1065C66 at byte 128197559
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T01:40:26 to 2023-11-25T01:41:56
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          2   10587
# Exec time      8     42s    47us    56ms     4ms    14ms     5ms     2ms
# Lock time      3    24ms       0     2ms     2us     1us    37us     1us
# Rows sent      4   7.63k       0       1    0.74    0.99    0.44    0.99
# Rows examine   0 908.48k       0     189   87.87  174.84   56.02   84.10
# Query size     0 452.45k      41      44   43.76   42.48    0.30   42.48
# String:
# Databases    isupipe
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us  ##############
# 100us  #####################
#   1ms  ################################################################
#  10ms  #############
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'icons'\G
#    SHOW CREATE TABLE `isupipe`.`icons`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT image FROM icons WHERE user_id = 1098\G

# Query 5: 42.23 QPS, 0.30x concurrency, ID 0xF1B8EF06D6CA63B24BFF433E06CCEB22 at byte 119590691
# This item is included in the report because it matches --limit.
# Scores: V/M = 0.01
# Time range: 2023-11-25T01:40:26 to 2023-11-25T01:41:56
# Attribute    pct   total     min     max     avg     95%  stddev  median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count          0    3801
# Exec time      5     27s     1ms    73ms     7ms    24ms     9ms     1ms
# Lock time      1    12ms       0     2ms     3us     1us    39us     1us
# Rows sent      2   3.71k       1       1       1       1       0       1
# Rows examine   5   7.66M   1.96k   2.27k   2.06k   2.27k  128.20   1.96k
# Query size     1 611.83k     163     166  164.83  158.58       0  158.58
# String:
# Databases    isupipe
# Hosts        localhost
# Users        isucon
# Query_time distribution
#   1us
#  10us
# 100us
#   1ms  ################################################################
#  10ms  ###########################
# 100ms
#    1s
#  10s+
# Tables
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'users'\G
#    SHOW CREATE TABLE `isupipe`.`users`\G
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'livestreams'\G
#    SHOW CREATE TABLE `isupipe`.`livestreams`\G
#    SHOW TABLE STATUS FROM `isupipe` LIKE 'livecomments'\G
#    SHOW CREATE TABLE `isupipe`.`livecomments`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT IFNULL(SUM(l2.tip), 0) FROM users u
        INNER JOIN livestreams l ON l.user_id = u.id    
        INNER JOIN livecomments l2 ON l2.livestream_id = l.id
        WHERE u.id = 76\G