Ram

RT Users
1

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

2

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@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Firas
Batal (QA/EMC)
Sent: Thursday, 29 March 2007 1:25 AM
To: rt-users@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

3

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?

The backing store for BLOB fields in MySQL is within the table space, which
translates physically to a file on the hard drive (but it’s not “one file
per attachment”, rather all the attachments go into the database table file).
The exact way in which they’re stored depends on which MySQL engine your
table uses (InnoDB, MyISAM, etc.).

Depending on how Perl handles HTTP POST requests, and possibly depending on
whether you are running RT in CGI mode or with mod_perl, the uploaded file
may be temporarily RAM-resident during the upload process, before it is
committed to the database. I’m not a Perl wiz, so I’ll defer to someone with
more expertise on that question.

By the way, there is a special MySQL engine (at least in MySQL 5…not sure
if it existed back at 4.0.x or not) that stores database records in RAM for
very fast – but volatile! – temporary tables. That feature is used in
very specialized situations, and isn’t normally relevant for RT. I mention it
here for completeness only. You are almost certainly NOT using this, because
anything in RAM vanishes if the system is rebooted.

Hope this helps.

Scott

Scott Courtney | “I don’t mind Microsoft making money. I mind them
scott@4th.com | having a bad operating system.” – Linus Torvalds
http://4th.com/ | (“The Rebel Code,” NY Times, 21 February 1999)
| PGP Public Key at http://4th.com/keys/scott.pubkey