Request-log-analyzer summary report

Version 1.13.4 - written by Willem van Bergen and Bart ten Brinke

Request summary

Processed File: /srv/analyzer/2019-09-16 15:40:56/mysql-slow.log
Parsed lines: 948997
Skipped lines: 513
Parsed requests: 249386
Skipped requests: 249368
Warnings: no_current_request: 513
First request: 2019-09-14 21:01:09
Last request: 2019-09-16 13:19:01
Total time analyzed: 2 days

Users with most queries

publiclab 18 hits 100.0%

Query time per user - by sum Hits Sum Mean StdDev Min Max 95 %tile
publiclab 18 10m26s 34.79s 47.30s 5.73s 2m30s 5.66s-2m32s

Query time per user - by mean Hits Sum Mean StdDev Min Max 95 %tile
publiclab 18 10m26s 34.79s 47.30s 5.73s 2m30s 5.66s-2m32s

Query time - by sum Hits Sum Mean StdDev Min Max 95 %tile
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 4m50s 2m25s 7.89s 2m19s 2m30s 2m18s-2m32s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 2m53s 1m26s 9.02s 1m20s 1m33s 1m20s-1m34s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 58.01s 29.01s 1.11s 28.22s 29.79s 27.93s-30.27s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 33.11s 16.55s 276ms 16.36s 16.75s 16.14s-16.94s
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 27.65s 6.91s 1.01s 5.84s 8.06s 5.75s-8.07s
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 26.11s 6.53s 974ms 5.73s 7.90s 5.66s-7.94s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 18.74s 9.37s 354ms 9.12s 9.62s 9.04s-9.64s

Query time - by mean Hits Sum Mean StdDev Min Max 95 %tile
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 4m50s 2m25s 7.89s 2m19s 2m30s 2m18s-2m32s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 2m53s 1m26s 9.02s 1m20s 1m33s 1m20s-1m34s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 58.01s 29.01s 1.11s 28.22s 29.79s 27.93s-30.27s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 33.11s 16.55s 276ms 16.36s 16.75s 16.14s-16.94s
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 18.74s 9.37s 354ms 9.12s 9.62s 9.04s-9.64s
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 27.65s 6.91s 1.01s 5.84s 8.06s 5.75s-8.07s
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 26.11s 6.53s 974ms 5.73s 7.90s 5.66s-7.94s

Lock time - by sum Hits Sum Mean StdDev Min Max 95 %tile
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms

Lock time - by mean Hits Sum Mean StdDev Min Max 95 %tile
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 0ms 0ms 0ms 0ms 0ms 0ms-0ms

Rows examined - by sum Hits Sum Mean StdDev Min Max 95 %tile
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 14M 7282k 43k 7251k 7313k 7161k-7673k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 5396k 2698k 1902 2696k 2699k 2630k-2818k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 1935k 967k 0 967k 967k 966k-1035k
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 1005k 251k 235 251k 251k 242k-260k
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 952k 238k 60k 182k 325k 177k-331k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 895k 447k 158 447k 447k 436k-467k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 68k 34k 2 34k 34k 33k-36k

Rows examined - by mean Hits Sum Mean StdDev Min Max 95 %tile
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 14M 7282k 43k 7251k 7313k 7161k-7673k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 5396k 2698k 1902 2696k 2699k 2630k-2818k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 1935k 967k 0 967k 967k 966k-1035k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 895k 447k 158 447k 447k 436k-467k
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 1005k 251k 235 251k 251k 242k-260k
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 952k 238k 60k 182k 325k 177k-331k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 68k 34k 2 34k 34k 33k-36k

Rows sent - by sum Hits Sum Mean StdDev Min Max 95 %tile
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 14M 7282k 43k 7251k 7313k 7161k-7673k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 5396k 2698k 1902 2696k 2699k 2630k-2818k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 1935k 967k 0 967k 967k 966k-1035k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 895k 447k 158 447k 447k 436k-467k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 68k 34k 2 34k 34k 33k-36k
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 80 20 0 20 20 19 -20
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 20 5 0 5 5 4 -5

Rows sent - by mean Hits Sum Mean StdDev Min Max 95 %tile
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rsessions 2 14M 7282k 43k 7251k 7313k 7161k-7673k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM impressions 2 5396k 2698k 1902 2696k 2699k 2630k-2818k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM profile_values 2 1935k 967k 0 967k 967k 966k-1035k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM rusers 2 895k 447k 158 447k 447k 436k-467k
publiclab@localhost: SELECT /*!:int SQL_NO_CACHE */ * FROM node_revisions 2 68k 34k 2 34k 34k 33k-36k
publiclab@172.24.0.2: SELECT DISTINCT rusers.* FROM rusers INNER JOIN node ON node.uid = rusers.id INNER JOIN node_revisions ON node_revisions.nid = node.nid WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) AND (node_revisions.status = :int) ORDER BY node_revisions.timestamp DESC LIMIT :int OFFSET :int 4 80 20 0 20 20 19 -20
publiclab@172.24.0.2: SELECT rusers.* FROM rusers WHERE (MATCH(bio, username) AGAINST(:string IN BOOLEAN MODE)) AND (rusers.status = :int) ORDER BY rusers.id DESC LIMIT :int 4 20 5 0 5 5 4 -5

Parse warnings

Parsable lines were encountered without a header line before it. It
could be that logging is not setup correctly for your application.
Visit this website for logging configuration tips:
http://github.com/wvanbergen/request-log-analyzer/wikis/configure-logging

Thanks for using request-log-analyzer

For more information please visit the Request-log-analyzer website

If you need an expert who can analyze your application, mail to contact@railsdoctors.com or visit us at http://railsdoctors.com.