Re: On but off topic Putting a file in Ram

[Victor Pendleton]

Are you inquiring about database heap/memory tables or file system 
memory tables? This is the link for MySQL heap/memory tables, 
http://dev.mysql.com/doc/mysql/en/MEMORY_storage_engine.html. As for the 
file system you could look at using ramfs, 
http://www.linuxfocus.org/English/July2001/article210.shtml, or just 
google for it.

[EMAIL PROTECTED] wrote:
Heap/Memory tables that is the phrase I couldn't remember.  The data is
stored in the file system.
I have one file that that is linked to via JavaScript to run a php file and
send an output.  That file accesses MySql  OR if I am overloaded it bypasses
my local system and goes directly to Findwhat.com to produce the search.  By
putting that file into memory I should be able to handle any load fairly
easily.
Any suggestions on where I should read to learn how to use heap/memory on
Linux/enterprise?
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183

-----Original Message-----
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 11:10 AM
To: [EMAIL PROTECTED]
Cc: Eamon Daly; [EMAIL PROTECTED]
Subject: Re: On but off topic Putting a file in Ram
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]