Skip to content

Instantly share code, notes, and snippets.

Avatar
🎯
Focusing

Mark Callaghan mdcallag

🎯
Focusing
View GitHub Profile
View gist:f7b085a5f9fd8303166740da62d25acb
mysql> select * from information_schema.user_statistics limit 1\G
*************************** 1. row ***************************
USER_NAME: root
BINLOG_BYTES_WRITTEN: 1412
BINLOG_DISK_READS: 0
BYTES_RECEIVED: 756
BYTES_SENT: 37322
COMMANDS_DDL: 2
COMMANDS_DELETE: 1
COMMANDS_HANDLER: 0
View gist:19a678e7da777aa4de4d23ad3c8503f4
mysql> select * from information_schema.table_statistics limit 1\G
*************************** 1. row ***************************
TABLE_SCHEMA: mysql
TABLE_NAME: event
TABLE_ENGINE: MyISAM
ROWS_INSERTED: 0
ROWS_UPDATED: 0
ROWS_DELETED: 0
ROWS_READ: 0
ROWS_REQUESTED: 2
View gist:21ce47c03f3eb2de01b11769b5760cb0
g++ -fno-rtti -g -W -Wextra -Wall -Wsign-compare -Wshadow -Wunused-parameter -Werror -I. -I./include -std=c++11 -faligned-new -DHAVE_ALIGNED_NEW -DROCKSDB_PLATFORM_POSIX -DROCKSDB_LIB_IO_POSIX -DOS_LINUX -fno-builtin-memcmp -DROCKSD
B_FALLOCATE_PRESENT -DSNAPPY -DGFLAGS=1 -DZLIB -DLZ4 -DZSTD -DNUMA -DROCKSDB_MALLOC_USABLE_SIZE -DROCKSDB_PTHREAD_ADAPTIVE_MUTEX -DROCKSDB_BACKTRACE -DROCKSDB_RANGESYNC_PRESENT -DROCKSDB_SCHED_GETCPU_PRESENT -march=native -DHAVE_SSE42
-DHAVE_PCLMUL -DROCKSDB_SUPPORT_THREAD_LOCAL -DROCKSDB_JEMALLOC -DJEMALLOC_NO_DEMANGLE -isystem ./third-party/gtest-1.7.0/fused-src -O2 -fno-omit-frame-pointer -momit-leaf-frame-pointer -DNDEBUG -Woverloaded-virtual -Wnon-virtual-dto
r -Wno-missing-field-initializers -c db/column_family.cc -o db/column_family.o
In file included from ./db/memtable.h:21,
from ./db/memtable_list.h:17,
from ./db/column_family.h:17,
from ./db/db_impl/db_impl.h:22,
from tools/db_bench_tool.cc:32:
./d
View gist:710019d1f9cafc93f4c8a313a83e6d95
v64 v611 v612 v613 v614 v615 v616 v617 test
3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.2 fillrandom
14.3 14.4 13.4 13.1 13.9 13.5 14.1 14.0 overwrite
0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
14.5 17.2 16.0 16.1 16.1 19.6 19.5 14.6 readrandom
29.7 41.3 29.4 30.4 29.4 41.5 35.2 28.6 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
16.1 18.5 17.2 17.1 17.0 15.7 18.8 16.9 readrandom
34.5 46.0 32.6 34.8 34.0 31.0 40.3 33.4 seekrandom
33.4 46.0 32.7 34.5 34.4 31.2 42.1 35.2 seekrandom
View gist:55a7ff9baada1bd053c6a5328578ae68
v64 v611 v612 v613 v614 v615 v616 v617 test
3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.2 fillrandom
14.3 14.4 13.4 13.1 13.9 13.5 14.1 14.0 overwrite
0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
14.5 17.2 16.0 16.1 16.1 19.6 19.5 14.6 readrandom
29.7 41.3 29.4 30.4 29.4 41.5 35.2 28.6 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
16.1 18.5 17.2 17.1 17.0 15.7 18.8 16.9 readrandom
34.5 46.0 32.6 34.8 34.0 31.0 40.3 33.4 seekrandom
33.4 46.0 32.7 34.5 34.4 31.2 42.1 35.2 seekrandom
View gist:49c17bf658f89c160de5ad42703f9b28
v64 v611 v612 v613 v614 v615 v616 v617 test
3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.2 fillrandom
14.3 14.4 13.4 13.1 13.9 13.5 14.1 14.0 overwrite
0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
14.5 17.2 16.0 16.1 16.1 19.6 19.5 14.6 readrandom
29.7 41.3 29.4 30.4 29.4 41.5 35.2 28.6 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
16.1 18.5 17.2 17.1 17.0 15.7 18.8 16.9 readrandom
34.5 46.0 32.6 34.8 34.0 31.0 40.3 33.4 seekrandom
33.4 46.0 32.7 34.5 34.4 31.2 42.1 35.2 seekrandom
View gist:4a0a927c5965939e559af777a66d2b27
v64 v611 v612 v613 v614 v615 v616 v617 test
3.2 3.2 3.2 3.2 3.2 3.2 3.3 3.2 fillrandom
3.1 3.2 3.3 3.2 3.2 3.2 3.2 3.2 overwrite
0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
7.5 9.4 9.7 9.1 9.3 9.3 10.9 9.9 readrandom
16.9 17.2 17.0 17.1 17.3 16.5 25.3 17.0 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
6.2 7.3 7.8 7.7 7.8 7.6 7.7 7.5 readrandom
16.9 18.4 17.4 17.7 17.6 16.8 15.6 17.3 seekrandom
17.3 17.9 17.6 18.0 19.0 17.9 15.7 17.8 seekrandom
View gist:d90cdfb36c3f92ee8a0c51eb131d68b6
v64 v611 v612 v613 v614 v615 v616 v617 test
2.8 2.9 3.0 2.9 2.9 2.9 2.9 2.9 fillrandom
2.9 2.9 2.9 3.0 3.1 3.0 3.0 2.9 overwrite
0.4 0.4 0.3 0.3 0.3 0.4 0.4 0.4 readseq
6.3 7.7 8.3 8.1 8.2 7.4 8.3 7.3 readrandom
13.0 13.6 15.4 14.0 20.2 10.7 15.5 10.2 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
4.6 5.9 5.9 6.0 5.6 5.2 5.9 5.1 readrandom
13.0 13.5 14.9 13.6 12.0 10.5 15.0 10.3 seekrandom
13.0 13.7 15.2 14.0 12.3 10.7 15.4 10.6 seekrandom
View gist:d36ca71263da26bea192718545ca7bae
v64 v611 v612 v613 v614 v615 v616 v617 test
2.9 2.9 2.9 2.9 2.9 2.9 2.9 3.0 fillrandom
2.9 3.1 3.0 3.0 3.0 2.9 2.9 3.0 overwrite
0.3 0.4 0.3 0.4 0.4 0.4 0.4 0.4 readseq
6.0 7.5 7.6 8.9 8.3 8.3 11.5 8.3 readrandom
12.6 17.2 15.0 20.3 14.0 14.0 10.5 13.9 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
4.5 6.1 5.8 5.7 5.9 5.7 5.3 6.0 readrandom
12.4 16.9 14.8 12.0 13.6 13.6 10.6 13.5 seekrandom
12.7 17.2 15.3 12.2 13.8 13.9 10.8 13.8 seekrandom
View gist:dee88d2d915a28c2d8a5391dce899ebb
LSM tree shapes during the "Read-only after write-heavy" tests
LSM tree for 5.6.35
Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.5 14.5 0.0 1.0 0.0 255.9 57.88 52.37 81 0.715 0 0
L5 17/0 1004.18 MB 1.0 29.7 13.4 16.3 22.7 6.4 0.0 1.7 242.1 184.9 125.45 111.21 19 6.603 181M 33M
L6 28/0 2.00 GB 0.0 16.1 4.7 11.4 11.5 0.1 1.9 2.4 214.0 152.6 77.19 71.02 74 1.043 136M 24M
Sum 45/0 2.98 GB 0.0 45.8 18.1 27.7 48.6 21.0