Re: [rt-users] Attachments table of RT's Mysql database
Dear Mr. Lytochkin, There are two very good reasons to not store attachments outside of the database. First, if everything is inside a database, then a simple backup of the database will get everything related to a particular RT instance. Second, in many cases you would like to isolate the front-end from the back-end information store. Once you need access to the filesystem, everything becomes much more involved. I am certain that there are other reasons, but those two are certainly enough for me. I have appreciated the ease of generating a consistent backup of my RT information store. Ken On Tue, Aug 07, 2007 at 04:15:02PM +0400, Boris Lytochkin wrote: I wrote a patch that allows to store non-text attachments to be stored out of DB - in my case it greatly reduced DB swelling. Just for now it uses constant string in Attachments-Content to indicate that file is written to FS. You will need to specify some variables in RT_Siteconfig.pm: Set($AttachmentsDirectory, '/var/RT/attachments'); Set($LogAttachmentsLoading, 1); Set($LogAttachmentsSaving, 1); Set($StoreNonTextAttachmensInDB, undef); #Set($StoreNonTextAttachmensInDB, 1); A new share/html/Ticket/Attachment/dhandler and attach.patch for rest of RT distribution is in attachment. Gregory Harper, you can find more complex set of patches allowing to produce show image thumbs automaticly in attachment too. Some more variables must be specified in RT_Siteconfig.pm Set($ShowTransactionImages, 1); Set($ProduceImageThumbs, 1); Set($ImageThumbsDirectory, '/var/RT/thumbs'); I wonder why bestprcactical is not interested in intergating these patches into RT: From: Jesse Vincent Sent: 21 march 2007 ?., 23:53 To: lytochkin Subject: [RT 3.6] Storing attachments away from DB Hi Boris, Thanks very much for the mail, but I think we're not really interested in offering this feature within RT. Best, Jesse -- Boris Lytochkin, JSC e-port, Moscow web: www.e-port.ru, wap: wap.e-port.ru tel: +7 (495) 777 1872, ext. 251 Date: Mon, 06 Aug 2007 12:31:31 -0500 From: Gregory Harper [EMAIL PROTECTED] Subject: Re: [rt-users] Attachments table of RT's Mysql database To: Justin Brodley [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Justin Brodley wrote: We actually had to disable the attachment feature as we were having our customers attach enormous files and killed our DB processing. Ultimately we are looking into rewriting the attachment feature to store the attachments on the web server to alleviate this overhead from the DB. I understand that the attachment table also stores all updates to a ticket, not just the attachments. Justin Brodley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gregory Harper Sent: Wednesday, August 01, 2007 12:41 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Attachments table of RT's Mysql database Hello everybody. We've been using RT for more than three months as part of our customer concern processes. Overall, things have been going well. The configuration includes Mysql, Apache2 and Postfix running on Ubuntu 6.06. I've made no modifications to the databases. The primary concern at this point is that the Attachments table of the Mysql database is growing significantly. Our CSR's want to attach PDFs, jpegs, etc. to the tickets with the jpegs usually created by our customers. The digital photos are the main culprit. I've read about scaling back the photos, creating thumbnails, etc. and we need to find a way to limit the attachment size prior to attachment. Has anyone else using RT had this type of problem? What are the best approaches for minimizing and controlling the size of the Attachments table? Any information, feedback and guidance are appreciated. thanks - Gregory Harper , Stevens Industries ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com Thanks Justin for the feedback. Anyone else have input regarding their experiences with Attachments and RT? thanks - Greg -- Message: 3 Date: Mon, 6 Aug 2007 11:53:13 -0700 (PDT) From: Ed Matthews [EMAIL PROTECTED] Subject: [rt-users] Kwiki Table Rendering? To: rt-users@lists.bestpractical.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Happy Monday. Does anyone know why Kwiki renders tables on this page, http://wiki.bestpractical.com/view/ManualScrips but not on this page http
Re: [rt-users] Attachments table of RT's Mysql database
I guess it all comes down to different strokes for different folks. Perhaps this could be put up on the wiki and then if someone needs this capability they can easily get it? DB Boris Lytochkin wrote: Ken, First, if everything is inside a database, then a simple backup of the database will get everything related to a particular RT instance. Wrong. We _stopped_ backup process of RT database due to LARGE amount data every day. We have no such amount of tape to store DB's everyday backups. Now, DB backup is done every day and attachment backup is done separately. As a result we have everyday SQL-backup of DB and incremental backup for attachments. It uses much less space. Second, in many cases you would like to isolate the front-end from the back-end information store. Once you need access to the filesystem, everything becomes much more involved. I understand that storing attachments out of RT involves much more than DB-only solution, BUT 10 Gb DB with 9.5 Gb of images involves much more. Anyway, it is up to admin to decide whether to store attachments separate or not. Tuesday, August 7, 2007, 4:22:49 PM, you wrote: Dear Mr. Lytochkin, There are two very good reasons to not store attachments outside of the database. First, if everything is inside a database, then a simple backup of the database will get everything related to a particular RT instance. Second, in many cases you would like to isolate the front-end from the back-end information store. Once you need access to the filesystem, everything becomes much more involved. I am certain that there are other reasons, but those two are certainly enough for me. I have appreciated the ease of generating a consistent backup of my RT information store. Ken On Tue, Aug 07, 2007 at 04:15:02PM +0400, Boris Lytochkin wrote: I wrote a patch that allows to store non-text attachments to be stored out of DB - in my case it greatly reduced DB swelling. Just for now it uses constant string in Attachments-Content to indicate that file is written to FS. You will need to specify some variables in RT_Siteconfig.pm: Set($AttachmentsDirectory, '/var/RT/attachments'); Set($LogAttachmentsLoading, 1); Set($LogAttachmentsSaving, 1); Set($StoreNonTextAttachmensInDB, undef); #Set($StoreNonTextAttachmensInDB, 1); A new share/html/Ticket/Attachment/dhandler and attach.patch for rest of RT distribution is in attachment. Gregory Harper, you can find more complex set of patches allowing to produce show image thumbs automaticly in attachment too. Some more variables must be specified in RT_Siteconfig.pm Set($ShowTransactionImages, 1); Set($ProduceImageThumbs, 1); Set($ImageThumbsDirectory, '/var/RT/thumbs'); I wonder why bestprcactical is not interested in intergating these patches into RT: From: Jesse Vincent Sent: 21 march 2007 ?., 23:53 To: lytochkin Subject: [RT 3.6] Storing attachments away from DB Hi Boris, Thanks very much for the mail, but I think we're not really interested in offering this feature within RT. Best, Jesse -- Boris Lytochkin, JSC e-port, Moscow web: www.e-port.ru, wap: wap.e-port.ru tel: +7 (495) 777 1872, ext. 251 Date: Mon, 06 Aug 2007 12:31:31 -0500 From: Gregory Harper [EMAIL PROTECTED] Subject: Re: [rt-users] Attachments table of RT's Mysql database To: Justin Brodley [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Message-ID: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1; format=flowed Justin Brodley wrote: We actually had to disable the attachment feature as we were having our customers attach enormous files and killed our DB processing. Ultimately we are looking into rewriting the attachment feature to store the attachments on the web server to alleviate this overhead from the DB. I understand that the attachment table also stores all updates to a ticket, not just the attachments. Justin Brodley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gregory Harper Sent: Wednesday, August 01, 2007 12:41 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Attachments table of RT's Mysql database Hello everybody. We've been using RT for more than three months as part of our customer concern processes. Overall, things have been going well. The configuration includes Mysql, Apache2 and Postfix running on Ubuntu 6.06. I've made no modifications to the databases. The primary concern at this point is that the Attachments table of the Mysql database is growing significantly. Our CSR's want to attach PDFs, jpegs, etc. to the tickets with the jpegs usually created by our customers. The digital photos are the main culprit. I've read about scaling back the photos, creating thumbnails, etc. and we need to find a way to limit
RE: [rt-users] Attachments table of RT's Mysql database
We actually had to disable the attachment feature as we were having our customers attach enormous files and killed our DB processing. Ultimately we are looking into rewriting the attachment feature to store the attachments on the web server to alleviate this overhead from the DB. I understand that the attachment table also stores all updates to a ticket, not just the attachments. Justin Brodley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gregory Harper Sent: Wednesday, August 01, 2007 12:41 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Attachments table of RT's Mysql database Hello everybody. We've been using RT for more than three months as part of our customer concern processes. Overall, things have been going well. The configuration includes Mysql, Apache2 and Postfix running on Ubuntu 6.06. I've made no modifications to the databases. The primary concern at this point is that the Attachments table of the Mysql database is growing significantly. Our CSR's want to attach PDFs, jpegs, etc. to the tickets with the jpegs usually created by our customers. The digital photos are the main culprit. I've read about scaling back the photos, creating thumbnails, etc. and we need to find a way to limit the attachment size prior to attachment. Has anyone else using RT had this type of problem? What are the best approaches for minimizing and controlling the size of the Attachments table? Any information, feedback and guidance are appreciated. thanks - Gregory Harper , Stevens Industries ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com