Ah, the wonderful feeling of being hauled out of the spa/candlelit dinner/Quake game to be told in panicked tones that there is a ‘database error’. You rattle off the usual suspects, determining that their keyboard is actually plugged in, monitor… Continue Reading →
I assume you know all about the my.cnf file, and how to set variables. key_buffer_size The key_buffer_size is probably the most useful single variable to tweak. The larger you set it, the more of your MyISAM table indexes you store… Continue Reading →
MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the manual as well as on new page Jay has created. Still I see constant confusion out where which… Continue Reading →