Actually no. I have a file that is determined to be requested by mysql (Top 100 site) What I am wanting to do is put the images and or files into Ram to serve them from there instead of the harddrive and conserve hd resources for "not known" tasks.
Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -----Original Message----- From: Eamon Daly [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 9:17 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: On but off topic Putting a file in Ram > The reason I ask this here. Is I have graphics that are loaded by Mysql > and > was wondering if I can do the same for them since some of these sites can > call my server 10-20,000 times a day for that same graphic. I assume you mean that you have image data stored in a MySQL table somewhere and are using a SELECT to fetch and serve it. I think the general consensus would be something along the lines of "Don't do that". Apache was /designed/ to serve files quickly, so let it do what it does best. Store just the filenames in MySQL and let Apache handle the rest. Once you've done that, you can do plenty of things to speed up or scale your system, such as mapping the files to memory with mod_file_cache, judicious use of a caching proxy, or the creation of a ramdisk. ____________________________________________________________ Eamon Daly ----- Original Message ----- From: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, November 22, 2004 8:20 PM Subject: On but off topic Putting a file in Ram >I have a small file that calls a search function at Findwhat in case Mysql > locally overloads. I just put on a new partner who looks like they may > call > my server 40 million times a month. > > I know there is some way to put a file into Ram for super fast response. > Question is how do I do this? > > Will it still write to Mysql from the Ram Drive? What is the downside of > doing this? > > The reason I ask this here. Is I have graphics that are loaded by Mysql > and > was wondering if I can do the same for them since some of these sites can > call my server 10-20,000 times a day for that same graphic. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
