DB size
Table sizes
SELECT
table_schema AS 'DB Name',
ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS 'DB Size in MB'
FROM
information_schema.tables
GROUP BY
table_schema;
Table sizes
SELECT
table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM
information_schema.TABLES
WHERE
table_schema = "<your-database-name>"
ORDER BY
(data_length + index_length) DESC;
❤1
Processes Signals in Linux
kill -KILL pid
kill -HUP pid
kill -TERM pid
pkill name
killall name
journalctl -t CRON --since "today"
journalctl -t CRON --since "30 minutes ago"
journalctl -t CRON --since "2023-01-25"
0 4 * * * /home/user/make-backup.sh 2>&1 | logger -t backups
journalctl -t backups --since "today"
journalctl -t backups -f
0 4 * * * /home/user/make-backup.sh > /tmp/backups.log 2>&1
0 4 * * * /home/user/make-backup.sh 2>&1 | ts >> /tmp/backups.log
https://blog.healthchecks.io/2023/01/using-logs-to-troubleshoot-failing-cron-jobs/
Healthchecks.io
Using Logs to Troubleshoot Failing Cron Jobs
Let's say you have a noscript that works when run in an interactive session, but does not produce expected results when run from cron. What could be the problem? Some potential culprits include:
The cron daemon does not see the new job. You added the job…
The cron daemon does not see the new job. You added the job…
Byobu Multiplexer
Shift-F2: Create a horizontal split.
Ctrl-F2: Create a vertical split.
Shift-Left/Right/Up/Down: Move focus among splits.
Shift-Alt-Left/Right/Up/Down: Resize a split.
Ctrl-F5: Reconnect ssh/gpg/dbus sockets.
Shift-F6: Detach session and do not logout.
Shift-F11: Zoom into a split, zoom out of a split.
Alt-PageUp/PageDown: Enter and move through scrollback.
👍1
docker buildx cloud
docker buildx create --driver cloud <ORG>/<BUILDER_NAME>
👍1