Your Hosting, Our Responsibility !

Tag mysql

Optimizing MySQL: Queries and Indexes

You know the scene. The database is just too slow. Queries are queuing up, backlogs growing, users being refused connection. Management is ready to spend millions on “upgrading” to some other system, when the problem is really that MySQL is… Continue Reading →

Repairing Database Corruption in MySQL

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 →

Optimizing the mysqld variables

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 Variables

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 →