Bash Shell Script to Convert All MySQL Tables to use the Innodb Engine. 1 Reference Manual :: 11.7 Date and Time Functions. Flush and Reset MySQL Binary Logs | LegRoom.net. I had an issue with free disk space (or, more appropriately, a lack there of) on my server a while back. After some investigation, I discovered that my MySQL databases had ballooned in size to nearly 10 GB. Actually, figuring out that the /var/lib/mysql directory was taking up so much space wasn't that hard, but understanding why and what to do about it took a while (yes, I'm sometimes slow about such things).
It turns out I had two issues. The first is that MySQL configuration, by default, maintains binary logs. Complicating matters somewhat was the fact that the default name of the binary logs changed at some point (and, according to the current docs, now appears to have changed back. Like I said, recognizing that MySQL was taking up a lot of space is not hard, but I'm paranoid about my data and didn't want to risk losing anything. Note: This is meant for a standalone MySQL server.
First of all, the binary logs typically reside in /var/lib/mysql/. That's it. Flush and Reset MySQL Binary Logs | LegRoom.net. Mk-heartbeat - Monitor MySQL replication delay. Maatkit has become part of Percona Toolkit, and there will be no further development or releases of Maatkit separately from Percona Toolkit. mk-heartbeat - Monitor MySQL replication delay. Usage: mk-heartbeat [OPTION...] [DSN] --update|--monitor|--check|--stop mk-heartbeat measures replication lag on a MySQL or PostgreSQL server.
Start daemonized process to update test.heartbeat table on master: mk-heartbeat -D test --update -h master-server --daemonize Monitor replication lag on slave: mk-heartbeat -D test --monitor -h slave-server mk-heartbeat -D test --monitor -h slave-server --dbi-driver Pg Check slave lag once and exit (using optional DSN to specify slave host): mk-heartbeat -D test --check h=slave-server The following section is included to inform users about the potential risks, whether known or unknown, of using this tool. Mk-heartbeat merely reads and writes a single record in a table. At the time of this release, we know of no bugs that could cause serious harm to users.
--ask-pass --log. How to use mk-heartbeat to send notification - Maatkit Help. Help me understand mk-heartbeat. Issue 76 - maatkit - Add alerting mechanism to mk-heartbeat? - Project Hosting on Google Code. Script to Check MySQL Slave Heartbeat. Mk-heartbeat - Maatkit Help. How to backup your MySQL tables and data every night using a bash script and cron. Monitoring MySQL Replication with Munin and mk-heartbeat | Once a geek, forever a geek... MySQL: Adding User Accounts.
MySQL: Purge Binary Logs.