I have a lot (5m) of images and I decided for security reasons (corruption protection and COMMITs) to use a MySQL database to store them. Those images will be accessed pretty frequently, 100 per second. Most of them will be about 10kb or less (95%), but a few can be 100kb or more.
The above makes my life a pain because not all images fit in the VARCHAR
limit, and I am forced to use TEXT
.
From what I understand the database stores the 1st 768 bytes on page and the rest off page. This seems a pretty good idea for the average db out there, but I need to access those TEXT
too frequently. How can I force the database to store everything on page?