The TEXT/BLOB type columns you use in your schema, what's their actual maximum content? For text, the thing to realise is that in MySQL 5.0, the limit for a VARCHAR was raised from 255 to 65530 or so. Therefore you can convert TEXT columns to VARCHAR and get improved behaviour in various parts of the mysql server.
(there's more to it than that, but that's the basic story)
As a general rule, see if the contents are less than 20K.
You can emulate a BLOB type col by specifying VARCHAR(n) BINARY
Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at
http://openquery.com/blog/ &
http://twitter.com/openquery