Is the actual data stored in the database or somewhere in the file
system? If you do not have text or blob columns you may be able to use
heap/memory tables.
[EMAIL PROTECTED] wrote:
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]
