mysql

rq tool now on fedorahosted

So the RPM Query (rq) tool that I inherited as ‘srpm’ from Stew Benedict back in the day at Mandriva is now on fedorahosted,org. Unfortunately, it’s missing history because I had a dickens of a time trying to extract it from my existing svn repo (I got it so just the relevant commits where in(…)

Monitoring MySQL with mytop

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).

Managing MySQL with MySQL Workbench

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 like what I’m seeing. The tip discusses what makes make(…)

Why PostgreSQL is a better enterprise database than MySQL

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 choice still exists, and that the “runner up” might actually be(…)

Firewall MySQL with GreenSQL

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 to really dig into it as I can really see it being(…)

Improve MySQL performance with MySQLTuner

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 optimize your MySQL databases.