Category Archives: MySQL
The cost of table locking and index flushing in MySQL
This post may not apply to the large majority of applications out there, but I think it’s interesting enough. When doing sequential bulk inserts into MyISAM tables, you may think you’re getting rather good performance number wise. On low end … Continue reading
MySQL’s non-GPL adventure
I’m a bit late on this piece of news, and it’s been treated by more or less everyone who owns a blog. The news in short is that MySQL has decided to not release their online backup tool/driver to the … Continue reading
MySQL Proxy on RHEL5
Just a little timesaver; When attempting to install mysql proxy on RHEL5, you will most likely soon be staring at this message: … checking for LUA… checking for LUA… configure: error: Package requirements (lua5.1 >= 5.1) were not met: No … Continue reading
Queries per second
It’s obviously very important to know how your application and DBs are performing during business as usual. Otherwise you might find yourself in a situation where you’re facing performance degradation, and you have no clue what it’s down to. One important aspect of … Continue reading
MySQL query cache vs. memcached? Ridiculous!
Reading around on mailing lists, blog comments and forums etc. about methods of effective caching, I’ve seen people dismiss any form of caching, such as memcache, with the argument that MySQL has got a query cache anyways. This is what … Continue reading