MySQL server config for table that has longblob field
Posted on 2009-03-30
I have a server that right now is pretty much just used for MySQL. The DB has various tables but one of the main tables is one used for storing binary files in a longblob field. The files can be anywhere from a few hunder KB in size to a few MB. Another field is "program" and that is a always used in the query to get binary files just for the "program." For the most common program the fields can be > 45 for a specific version and total 700+ records for that program. A field "version" is also used to narrow down the results. The "query" will just end up getting one record if any at all.
This is hosted on a Windows 2003 SBS server if that matters.
The problem is the "download" of the blob seems to be taking some time. If the server is restarted, the number of records with the same program are lowered, or with "programs" that have fewer records and smaller binaries the download is at a normal speed. What are configurations in the INI that would make the most difference in this type of DB and table? What are status or server variables (in MySQL Admin) that will be especially useful in narrowing down problems that would cause this? There are other uses for the server (e.g. web server) and DB (e.g. other tables with records that aren't blob fields) so let me know if those could be negatively impacted or factor into any of this.
I am familiar with MySQL but just not an expert in its set up, especially in a situation like this. Let me know if you need any other info. Thanks!