Forbidden PTY allocation request with ssh
no-pty,no-X11-forwarding,permitopen="localhost:3306",command="/bin/echo do-not-send-commands"
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…