In the last issue of my current consulting saga, Detecting and Resolving LAMP Stack Performance Problems, we talked about a Drupal site that was being brought offline every few hours due to poor tuning of the LAMP stack. With the default settings, a site isn’t going to take much …
As a sysadmin, we sometimes run into performance problems with multiple angles and portions. It’s sometimes not particularly obvious where the actual performance problem is, and resolving one problem that you can see might bring another couple of problems to the surface.
The below comes from a consulting gig that …
Two years ago, I reported a bug in MySQL Query Browser that caused it to crash on OS X and Linux. For those not in the know, MySQL Workbench is an attempt to get a GUI tool comparable to Microsoft’s SQL Explorer off the ground.
Today, the bug was …
Apparently I’ve been living under a rock for the past three years.
group_concat. To use it is to know it, and to know it is to love it.
Version 0.5 of LÖVE – a 2d game engine for Lua – has dropped. Lua is a lightweight open-source scripting language that’s embeddable in other products and devices. I first encountered Lua using the MySQL Proxy.
LÖVE looks interesting, kind of like a relatively polished PyGame without …
Wow, this post by Jay Pipes on how MySQL handles time/date-related issues couldn’t come at a better time… more on that in another week or two.
Update: Jay posted his sample code.
Good article by Sheeri Cabral: Why you Want to Switch to MySQL 5.1. The 5.1 branch has gotten a bad rap, but there’s a few things in there like the table change locking that will help us with our replication environment.
The list of stopwords is essential if you’re thinking of using MySQL’s FULLTEXT index type, and it hasn’t been mentioned in other places I’ve seen the fulltext index discussed.
I think my pet peeve of the day today is going to be developers who think that no documentation or setup instructions should be necessary for their little chunk of code… especially when it mashes up as many things as Harald Kirschner’s Fancy Uploader does.
(Then again, I should …
Freshbooks ran into an interesting bit about selecting a MySQL Table Cache size:
The problem was caused by our new configuration of MySQL. The usual approach to setting MySQL’s table cache size is to make it large enough that it can hold all of your tables open, but
…
If you enjoy the content, consider subscribing to the feed(s).
1 Comment