Monitoring MySQL with mytop
May 27, 2010
This week’s techmail is Monitoring MySQL with mytop which looks at the mytop perl tool that can help monitor and diagnose problems with MySQL (mytop is essentially a top for MySQL).
Mysql
Managing MySQL with MySQL Workbench
May 7, 2010
This week’s techmail was Managing MySQL with MySQL Workbench. I’ve always been a CLI guy when it comes to MySQL (as with most things: mutt, irssi, etc.), and when I needed something GUIrific I went with phpMyAdmin. However, I’ve looked at MySQL Workbench and I …
Why PostgreSQL is a better enterprise database than MySQL
January 25, 2010
This week’s techmail is Why PostgreSQL is a better enterprise database than MySQL which takes a look at what makes PostgreSQL a compelling database, when compared to MySQL. Particularly in light of the whole Oracle/MySQL thing, I think it’s good to remind people that …
Set up rsyslog to store syslog messages in MySQL
January 12, 2010
This week’s TechMail is Set up rsyslog to store syslog messages in MySQL which gives a brief rundown of how to setup rsyslog to log messages in a MySQL database so that you can use a viewer such as phpLogCon in order to view/filter them. For me, this is a novelty thing more …
Firewall MySQL with GreenSQL
January 8, 2009
This past week’s TechMail is Firewall MySQL with GreenSQL which talks about a really cool little application-level firewall that sits between your database-accessing code and MySQL. Really neat concept and although I’ve played with it a bit, I need to find some time …
Improve MySQL performance with MySQLTuner
October 24, 2008
This week’s techmail is Improve MySQL performance with MySQLTuner which discusses how to use the MySQLTuner perl script to tune the MySQL server to ensure you’re not over-committing resources, that your configuration is sane, and giving helpful pointers on how to …
Use command-line MySQL for additional flexibility
April 9, 2008
This week’s TechMail is Use command-line MySQL for additional flexibility which delves into some quickie commands useful on the MySQL CLI client, such as setting prompts, using mysql output in scripts, etc.
Configure Snort to log packets to MySQL
March 26, 2008
This week’s TechMail is Configure Snort to log packets to MySQL which looks at using MySQL to store snort logs and BASE to view them. Already there’s a comment there about someone wanting to know how to do it on Windows. I’m sure it’s possible, but my …