mdcallag
/ gist:b09e642d7ca71fc3655a7404603fd9db
Created
December 1, 2021 00:52
r.10mrows.300s.1u.prep0 - o.sumr.r1.my
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| db_1 = x.my5649.y8.pk1 | |
| db_2 = x.my5735.y8.pk1 | |
| db_3 = x.my8020.y8.pk1 | |
| db_4 = x.my8022.y8.pk1 | |
| db_5 = x.my8023.y8.pk1 | |
| db_6 = x.my8026.y8.pk1 | |
| db_7 = x.my8027.y8.pk1 | |
| db_1 db_2 db_3 db_4 db_5 db_6 db_7 | |
| 1.00 1.07 0.81 0.77 0.76 0.81 0.81 point-query.warm.range100.pk1 |
mdcallag
/ gist:24789ce7b1b525fd43f964554d76b92b
Created
November 30, 2021 17:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ops_sec mb_sec size_gb c_wgb w_amp c_mbps c_secs usec_op p50 p99 p99.9 p99.99 pmax uptime stall% Nstall u_cpu s_cpu test date version job_id | |
| 557865 223.4 0.0 41.87 1.0 126.10 538.7 1.8 1.2 5 19 99 9310 340 0.3 6 0.7 0.1 fillseq.wal_disabled.v400 2021-11-22T12:07:30 6.0 | |
| 523826 209.8 0.0 43.68 1.0 117.67 608.2 1.9 1.3 6 19 122 88700 380 2.6 113 0.8 0.1 fillseq.wal_disabled.v400 2021-11-22T15:19:46 6.1 | |
| 543829 217.8 0.0 42.97 1.0 122.20 527.2 1.8 1.3 5 18 89 8570 360 0.0 0 0.7 0.1 fillseq.wal_disabled.v400 2021-11-22T18:36:15 6.2 | |
| 489522 196.1 0.0 42.80 1.0 109.56 628.8 2.0 1.4 7 19 127 156652 400 2.1 130 0.8 0.1 fillseq.wal_disabled.v400 2021-11-22T21:54:11 6.3 | |
| 539178 216.0 0.0 42.54 1 |
mdcallag
/ gist:9b3ff377e2b4716fdd94beac1baf9f97
Created
November 17, 2021 16:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ./db/version_edit.h:86:8: error: implicitly-declared ‘constexpr rocksdb::FileDescriptor::FileDescriptor(const rocksdb::FileDescriptor&)’ is deprecated [-Werror=deprecated-copy] | |
| 86 | struct FileMetaData { | |
| | ^~~~~~~~~~~~ | |
| ./db/version_edit.h:55:19: note: because ‘rocksdb::FileDescriptor’ has user-provided ‘rocksdb::FileDescriptor& rocksdb::FileDescriptor::operator=(const rocksdb::FileDescriptor&)’ | |
| 55 | FileDescriptor& operator=(const FileDescriptor& fd) { | |
| | ^~~~~~~~ |
mdcallag
/ gist:7537db9b3754a0221deb51ca78d58c52
Created
August 1, 2021 00:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Process: FinderSyncAPIExtension [535] | |
| Path: /Applications/Backup and Sync.app/Contents/PlugIns/FinderSyncAPIExtension.appex/Contents/MacOS/FinderSyncAPIExtension | |
| Identifier: com.google.GoogleDrive.FinderSyncAPIExtension | |
| Version: 1.0 (1) | |
| Code Type: X86-64 (Native) | |
| Parent Process: ??? [1] | |
| Responsible: FinderSyncAPIExtension [535] | |
| User ID: 501 | |
| Date/Time: 2021-07-31 17:15:52.041 -0700 |
mdcallag
/ gist:f7b085a5f9fd8303166740da62d25acb
Created
March 11, 2021 01:02
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
mdcallag
/ gist:19a678e7da777aa4de4d23ad3c8503f4
Created
March 11, 2021 01:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
mdcallag
/ gist:21ce47c03f3eb2de01b11769b5760cb0
Created
February 24, 2021 23:03
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
mdcallag
/ gist:710019d1f9cafc93f4c8a313a83e6d95
Created
February 18, 2021 16:15
m5ad.12xlarge, 16 threads
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
mdcallag
/ gist:55a7ff9baada1bd053c6a5328578ae68
Created
February 18, 2021 16:14
m5ad.12xlarge, 8 threads
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
mdcallag
/ gist:49c17bf658f89c160de5ad42703f9b28
Created
February 18, 2021 16:13
m5ad.12xlarge, 4 threads
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |