I hereby claim:
- I am lefred on github.
- I am lefred (https://keybase.io/lefred) on keybase.
- I have a public key whose fingerprint is 3FC1 BFE9 6874 1F85 E9C1 6ACC 3330 C753 DD8A B51D
To claim this, I am signing this object:
USE test; DROP FUNCTION IF EXISTS galeraWaitUntilEmptyRecvQueue; | |
DELIMITER $$ | |
CREATE | |
DEFINER=root@localhost FUNCTION galeraWaitUntilEmptyRecvQueue() | |
RETURNS INT UNSIGNED READS SQL DATA | |
BEGIN | |
DECLARE queue INT UNSIGNED; | |
DECLARE starttime TIMESTAMP; | |
DECLARE blackhole INT UNSIGNED; | |
SET starttime = SYSDATE(); |
SELECT ROUND(SUM(trx)/60) AS transactions_per_second FROM | |
(SELECT VARIABLE_VALUE * -1 AS trx | |
FROM information_schema.GLOBAL_STATUS | |
WHERE VARIABLE_NAME = 'wsrep_last_committed' | |
UNION ALL SELECT sleep(60) AS trx | |
UNION ALL SELECT VARIABLE_VALUE AS trx | |
FROM information_schema.GLOBAL_STATUS | |
WHERE VARIABLE_NAME = 'wsrep_last_committed') AS COUNTED; |
SELECT ROUND(SUM(bytes)/1024/1024*60) AS megabytes_per_hour | |
FROM ( | |
SELECT SUM(VARIABLE_VALUE) * -1 AS bytes | |
FROM information_schema.GLOBAL_STATUS | |
WHERE VARIABLE_NAME IN ('wsrep_received_bytes', 'wsrep_replicated_bytes') | |
UNION ALL SELECT sleep(60) AS bytes | |
UNION ALL SELECT SUM(VARIABLE_VALUE) AS bytes | |
FROM information_schema.GLOBAL_STATUS | |
WHERE VARIABLE_NAME IN ('wsrep_received_bytes', | |
'wsrep_replicated_bytes') |
From To Length Content | |
----- ---- ------- --------------------------- | |
0 31 32 Bits 0-31 of Coordinated Universal Time (UTC) as a count of 100-nanosecond | |
intervals since 00:00:00.00, 15 October 1582, encoded as big-endian 32-bit | |
number. | |
32 47 16 Bits 32-47 of UTC as a count of 100-nanosecond intervals since 00:00:00.00, | |
15 October 1582, encoded as big-endian 16-bit number. | |
48 59 12 Bits 48-59 of UTC as a count of 100-nanosecond intervals since 00:00:00.00, | |
15 October 1582, encoded as big-endian 16-bit number. | |
60 63 4 UUID version number: always equal to 1 (DCE UUID). |
global | |
log 127.0.0.1 local0 | |
log 127.0.0.1 local1 notice | |
maxconn 4096 | |
uid 99 | |
gid 99 | |
daemon | |
defaults | |
log global |
I hereby claim:
To claim this, I am signing this object: