Anyone have any performance suggestions for the my.cnf/my.ini configuration file being used in the following type of environment:
J2EE server with persistence layer making ~10 connections at a time
About 120 x 1-meg images stored in the database accessed pretty frequently.
I've increased max_allowed_packet to 16M to help with the images, but are there any others I should increase? Also, can I build an index or preload the entire images table into memory to help with speedy requests of images?