I'm trying to grok the blob implementation. This scenario is contrived to understand blobs please don't suggest I shouldn't do this. If you have a theoretical machine. Ubuntu with 4 cores/4gb of ram and we'll say once mysql is running 500mb of free disk space.
I have a 500mb blob stored in a table and 30 concurrent requests come in to select the blob's bytes. How does mysql handle this situation @ an implementation level?
Would mysql buffer the blob data to the disk? Would mysql keep 30 large in memory buffers for the data?
I'd like to know when I would be @ risk of either filling up the disk or running out of ram in this situation. I'm also curious as to the code level details about how blobs are read and transmitted to a client.
Thanks, Adam
Mar 13
Rick James RE: Blob implementation question
Mar 13, 2013; 17:00
Rick James
RE: Blob implementation question
Mar 13
Adam Ilardi Re: Blob implementation question
Mar 13, 2013; 13:24
Adam Ilardi
Re: Blob implementation question
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!