| select SCHEMA_NAME, | |
| DIGEST, | |
| DIGEST_TEXT, | |
| FORMAT(COUNT_STAR, 0) as COUNT_STAR, | |
| CONCAT(ROUND(SUM_TIMER_WAIT * 0.000000000001, 2), 's') as SUM_TIMER_WAIT_S, | |
| CONCAT(ROUND(MIN_TIMER_WAIT * 0.000000001, 2), 'ms') as MIN_TIMER_WAIT_MS, | |
| CONCAT(ROUND(AVG_TIMER_WAIT * 0.000000000001, 2), 's') as AVG_TIMER_WAIT_S, | |
| CONCAT(ROUND(MAX_TIMER_WAIT * 0.000000001, 2), 'ms') as MAX_TIMER_WAIT_MS, | |
| CONCAT(ROUND(SUM_LOCK_TIME * 0.000000000001, 2), 's') as SUM_LOCK_TIME_S | |
| from events_statements_summary_by_digest |
| // Question: What is the result of running the following? | |
| function job() { | |
| return new Promise(function(resolve, reject) { | |
| reject(); | |
| }); | |
| } | |
| let promise = job(); |
| const net = require('net'); | |
| const { spawn } = require('child_process'); | |
| const HOST = '127.0.0.1'; | |
| const PORT = 6969; | |
| // Server ///// | |
| const _logServer = (p) => (s) => console.log(`[Server:${p}]`, s); | |
| const logServer = _logServer('main'); |
| class SSet extends Set { | |
| union(a) { | |
| return new SSet([...this, ...a]); | |
| } | |
| intersection(a) { | |
| return new SSet([...this].filter(x => a.has(x))); | |
| } | |
| difference(a) { | |
| return new SSet([...this].filter(x => !a.has(x))); | |
| } |
| # Chrome | |
| chrome://inspect/ | |
| Click: "Open dedicated DevTools for Node" link | |
| # index.js | |
| ... | |
| debugger; // stop here | |
| ... | |
| # node |
| #!/bin/bash | |
| # From: https://notes.tweakblogs.net/blog/7955/using-netcat-to-build-a-simple-tcp-proxy-in-linux.html | |
| LOCAL_PORT=$1 | |
| REMOTE_HOST=$2 | |
| REMOTE_PORT=$3 | |
| mkfifo fifo | |
| nc -k -l -p $LOCAL_PORT <fifo | nc $REMOTE_HOST $REMOTE_PORT >fifo | |
| rm fifo |
Most of the following is taken from the OpenSSL cookbook
OpenSSL does not come with any trusted root certificates (also known as a trust store). DL Mozilla's truststore [here](https://hg.mozilla.org/mozilla-central/raw-file/tip/security/nss/lib/ckfw/builtins... /certdata.txt). Note: It's in a custom format so needs conversion so use this tool.
| # Special | |
| \e # an ASCII escape character (033) | |
| \h # the hostname up to the first `.' | |
| \H # the hostname | |
| \j # the number of jobs currently managed by the shell | |
| \l # the basename of the shell's terminal device name | |
| \n # newline | |
| \r # carriage return | |
| \t # the current time in 24-hour HH:MM:SS format |
Write a production version of your docker compose file that overrides dev only features in the base (dev) version of the docker file. Run with docker-compose -f docker-compose.yml -f docker-compose-prod.yml up -d.
| ssh-keygen -t rsa -b 2048 |