Skip to content

Instantly share code, notes, and snippets.

🚀
🌙

Michael Renner terrorobe

🚀
🌙
Block or report user

Report or block terrorobe

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:47685a8a01ea5a5dbe966fbd43c42103
icu (52.1-8+deb8u7) jessie-security; urgency=high
* Backport upstream security fix for CVE-2017-15422: Persian calendar
integer overflow (closes: #892766).
-- Laszlo Boszormenyi (GCS) <gcs@debian.org> Wed, 14 Mar 2018 18:28:21 +0000
icu (52.1-8+deb8u6) jessie; urgency=high
* Backport upstream security fix for CVE-2017-14952: double free in
View gist:71bd7c10efa3149e79361d60886d67a0
% numastat -m
Per-node system memory usage (in MBs):
Token Node not in hash table.
Token Node not in hash table.
Node 0 Total
--------------- ---------------
MemTotal 7853.46 7853.46
MemFree 274.07 274.07
MemUsed 7579.39 7579.39
View gist:8b6652b3b8bbf732ca5090299a17e80d
admin@gheaws-michaelrenner-at-primary:~$ free -m
total used free shared buffers cached
Mem: 15294 13549 1744 0 419 2293
-/+ buffers/cache: 10835 4458
Swap: 0 0 0
admin@gheaws-michaelrenner-at-primary:~$ free --version
free from procps-ng 3.3.9
admin@gheaws-michaelrenner-at-primary:~$
View gist:ca3a66f8b79a6c504711d668499e5c9e
Reading package lists...
Building dependency tree...
Reading state information...
NOTICE: 'systemd' packaging is maintained in the 'Git' version control system at:
git://anonscm.debian.org/pkg-systemd/systemd.git
Need to get 3,135 kB of source archives.
Get:1 http://security.debian.org/ jessie/updates/main systemd 215-17+deb8u8 (dsc) [3,804 B]
Get:2 http://security.debian.org/ jessie/updates/main systemd 215-17+deb8u8 (tar) [2,889 kB]
Get:3 http://security.debian.org/ jessie/updates/main systemd 215-17+deb8u8 (diff) [243 kB]
dpkg-source: info: extracting systemd in systemd-215
View gist:ee65df45dcae94c0673a5d122864a5b6
admin@gheaws-michaelrenner-at-replica:~$ sudo ls -la /data/user/mysql/
total 917180
drwx------ 7 mysql mysql 4096 Oct 12 14:42 .
drwxr-xr-x 21 root root 4096 Oct 11 09:41 ..
-rw-r--r-- 1 root root 309494019 Oct 12 14:37 database_seed_9fad21ae-0969-11e7-b01b-0a43d10d6233.sql
# What do you expect this to do
$ sudo rm -f /data/user/mysql/database_seed*.sql
View gist:4f2c05a1091e071b74ed631f26a7101f
-- 7 Billion Humans (2059) --
-- 20: Reverse Line --
if w == nothing or
e == nothing:
step s
pickup c
if e == hole:
jump a
endif
View gist:801610db3fd92ac3830abebf7616317f
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
View "fixed".txt
mysql> SET NAMES 'utf8mb4';
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like '%character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8 |
View 1_original_query.txt
mysql> explain SELECT sub.id, sub.oid AS oid, COUNT(sr.host) AS copies
-> FROM (
-> SELECT id, oid FROM storage_blobs
-> WHERE id BETWEEN 0 AND 1256276
-> ) AS sub
-> LEFT JOIN (
-> SELECT fs.host, fs.non_voting, sr.storage_blob_id
-> FROM storage_replicas AS sr
-> INNER JOIN storage_file_servers fs
-> ON sr.host = fs.host AND fs.non_voting = 1 AND fs.online = 1
View gist:c8bee5a1353c80f16778d5c69b332e9e
% time seconds usecs/call calls errors syscall
------ ----------- ----------- --------- --------- ----------------
99.86 31.482261 172979 182 2 wait4
0.09 0.027125 0 530621 422253 open
0.02 0.006698 0 115599 read
0.01 0.003159 0 108459 close
0.01 0.002586 0 108363 fstat
0.01 0.001630 9 178 vfork
0.00 0.000970 0 15283 lseek
0.00 0.000666 0 7922 write
You can’t perform that action at this time.