[rt-users] RAM

[Sasha Gerrand]

Hi,
 
Use mysql to connect to the database that your rt instance runs on.
Then, run the following command:
 
SELECT id,Subject,Filename,ContentType,ContentEncoding,Content,Headers
FROM rt3.Attachments WHERE ContentType LIKE '%pdf' ORDER BY id DESC; 
 
As you can see, the file is kept in the 'Content' container.

Regards,
Sasha 

Sasha Gerrand 
Web & Database Developer 
  
Austbrokers Holdings Limited 
Level 21, 111 Pacific Highway 
North Sydney NSW 2060 
PO Box 1813 North Sydney NSW 2060 
  
Ph:       02 9935 2230 
Mobile:  0431 895 718 
Email:   sashag at austbrokers.com.au 
Web:    http://www.austbrokers.com.au <http://www.austbrokers.com.au/>  
  
NOTICE 
If you are not an authorised recipient of this email, please contact
Austbrokers Holdings immediately by return e-mail or by telephone on
+61-2-4920-6117. In this case, you should not read, print, re-transmit,
store or act on this e-mail or any attachments. Please destroy the
message and attachments. This e-mail and any attachments are
confidential and may contain legally privileged information and/or
copyright material of Austbrokers Holdings or third parties. You should
only re-transmit, distribute or commercialise the material if you are
authorised to do so. Internet e-mails are not necessarily secure,
Austbrokers Holdings does not accept responsibility for changes made to
this message after it was sent. This Notice should not be removed.

 

________________________________

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Firas
Batal (QA/EMC)
Sent: Thursday, 29 March 2007 1:25 AM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] RAM



Hi,

 

I do not know if this is the right forum for my question.  I will try to
see if someone has DB experience.

 

I have RT 3.2.1 running with MySQL 4.0.21.  I use MYSQL with RT, and I
have just created a ticket that contains a .zip attachment with a size
of 11MB.  I wonder if one could guide me through the following:  I know
that MYSQL need lots of RAM to breathe properly.  But, where is the file
kept? Is in stored in records in RAM or its stored on the hard drive
with a pointer of the location of the file stored in RAM?  

 

Thank you for your time and help
Firas 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070329/35c02087/attachment.htm>