Re: [rt-users] WebRT 3.8.7 Slow Performance

sda2              0.00   249.85  1.10 47.75     8.79  2381.62    48.93 0.27    5.58   1.06   5.19 Best Regards Ronald Higgins -- View this message in context: http://old.nabble.com/WebRT-3.8.7-Slow-Performance-tp28287648p28287648.html Sent from the Request Tracker - User mailing list archive

[rt-users] shredder access

Good Morning Fellow RT Users. I'm very much new to the RT scene so apologies if this has come up before. 1 of our RT queues has +-300k false tickets (autoresponders, spam etc etc). The queue administrator would like access to remove those tickets via Shredder (built into RT). Now logged in as

[rt-users] mass user rename

Hi RT users. I need to perform a mass rename on 80% of our user account usernames, other than as root going CONFIGURATION-Users-TargetUser changing the username on a per user basis is there a quicker method to perform this ? Regards Ronald Discover RT's hidden secrets with RT Essentials from

[rt-users] migrating database

Hi All, We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) running on Centos 5.4. Due to performance issues i am looking at partitioning the Attachments Tickets tables to try and squeeze out some performance. However, MySQL 5.1 isnt available via Centos 5.4. So my solution is too

Re: [rt-users] migrating database

Thanks very much for the info all. On Wed, Jun 9, 2010 at 2:52 PM, Emmanuel Lacour elac...@easter-eggs.com wrote: On Wed, Jun 09, 2010 at 02:37:59PM +0200, ronald higgins wrote: Hi All, We're currently running RT 3.8.0 plugging into MySQL 5.0 (local) running on Centos 5.4. Due

[rt-users] Moving RT Database to remote host

Hi RT Users, I currently have an RT Deployment, the web app and mysql db lives on the same machine. However, because Centos currently does not support a MySQL Server Version that supports partitioning I would like to move the DB to a remote host with MySQL 5.1 installed. Once i've imported the

[rt-users] MySQL Performance

Hi RT Users, We've started experiencing degraded performance within RT over the last few days and I am struggling to pin point where exactly the problem is lying. I suspect it might be MySQL, i've inserted a show innodb status below if anyone could perhaps take a gander and read something out of

Re: [rt-users] New install of RT3.8.8 - 64bit?

32bit systems cannot address more than 4GB memory so go with 64bit so you don't find yourself needing to reinstall the O.S in a year or 2 because you need more RAM. IMHO of course. Regards Ronald Sent via my BlackBerry from Vodacom - let your email find you! -Original Message- From:

[rt-users] RT + MySQL Query optimization for improved slow ticket fetching

Hi fellow RT Users, hope you're having a good day and might be able to offer a much needed assist. I'm troubleshooting some tickets in RT taking nearly a minute to display to the users. I'm currently running a 3.8.7 Version of RT on a VMWare Virtual Machine assigned 4CPU's 10GB RAM. Centos 5.4

[rt-users] speeding up rt-shredder

Hi all. I'm trying to use rt-shredder to delete 700K tickets out of the RT Database but at the moment it's moving incredibly slowly. 1 ticket every few minutes is being deleted. Is there anyway to speed up rt-shredder deletes ? Command being issued: rt-shredder --plugin Tickets=query,Subject

Re: [rt-users] speeding up rt-shredder

Thanks for the link, it's helped, but hoping for more gains. I've applied the indexes as described and edited the Record.pm and it's knocked the deletes down to 40 seconds per ticket. Which translates to about 115 200 records per day or a week solid to delete my required 700 000 tickets. Any

Re: [rt-users] speeding up rt-shredder

to run shredder? For me, the best way to speed it up, was to ensure that I was specifying a date range, and to break it down into chunks(like one command per month) Max On 7/27/2010 10:45 AM, ronald higgins wrote: Thanks for the link, it's helped, but hoping for more gains. I've applied

Re: [rt-users] speeding up rt-shredder

Thanks for the script Garry :) Unfortunately it's pretty much the same, every delete taking about 40 seconds, so it doesnt look like adding the SQL logging in is adding any overhead :( pitty. On Tue, Jul 27, 2010 at 8:18 PM, G.Booth g.bo...@lboro.ac.uk wrote: On Tue, 27 Jul 2010 13:58:25 -0400

Re: [rt-users] speeding up rt-shredder

:) On Tue, Jul 27, 2010 at 9:20 PM, G.Booth g.bo...@lboro.ac.uk wrote: On Tue, 27 Jul 2010 20:33:03 +0200  ronald higgins ronald.higg...@gmail.com wrote: Thanks for the script Garry :) Unfortunately it's pretty much the same, every delete taking about 40 seconds, so it doesnt look like

Re: [rt-users] speeding up rt-shredder

OMFG indeed :) I'm use to working with much smaller DB's, this has been a challenge to say the least. We're using sendmail for RT, but RT itself is sitting behind MailMarshall Exchange and i believe the MS Admins have set a max message of 10MB so should be good. On Tue, Jul 27, 2010 at 10:16

Re: [rt-users] speeding up rt-shredder

Well, @ 1 ticket deleted per 40 seconds it will only take 324 days to clean up the DB. This is a bit crazy. On Tue, Jul 27, 2010 at 10:33 PM, Maxwell Rathbone mrathb...@sagonet.com wrote:  I'd love the ability to export the attachments and store them on the filesystem instead of in the

[rt-users] Search in MySQL for Queue changed from SOMEQUEUE to ANOTHERQUEUE

Hi Guys, I urgently need some assistance. There has been an incorrect build update and the only way I can track is by looking in the Ticket History it says Queue changed from queue1 to queue2. Is there any place in the MySQL DB i can search for that string to build up a list of ID's ? Regards

[rt-users] Scrips and Recipients

Hi Fellow RT Users, Hopefully this is a quick and easy question. On our RT system every queue has a Scrips and Recipients section under the Reply/Resolve tab. I've come across 1 queue where the tickets do not have this Scrips and Recipients under Reply/Resolve, is there a queue specific place

Re: [rt-users] Scrips and Recipients

My good sir. You're a legend. That indeed was the problem. And i twice glazed over the group rights and didnt pick it up. Thanks again! Ronald On Wed, Aug 18, 2010 at 4:56 PM, Kevin Falcone falc...@bestpractical.com wrote: On Wed, Aug 18, 2010 at 04:47:04PM +0200, ronald higgins wrote

Re: [rt-users] Highest known ticket count?

Hi Christopher, From my side, +- 1.5 million tickets in the DB. A lot of image attachments and the DB size is around 240GB. We had some performance issues but partitioning the RT DB boosted the performance. Regards Ronald On Mon, Sep 13, 2010 at 12:30 PM, Christopher Kunz

[rt-users] RT - Multiple DB's

Hi All. Has anyone found a mechanism for RT to write to 2 different DB's but read from 1 ? This would be useful for testing different DB configurations without to much Impact to users? Regards Ronald Higgins Sent via my BlackBerry from Vodacom - let your email find you! RT Training

[rt-users] RT Ticket History Search

Greetings List Members, Does anyone know how to search through the ticket history. I'm trying to trace all the tickets that a particular user has worked on and not necessarily closed, possibly handed over to another user, is there a way to do this via the front or back end ? Regards Ronald

[rt-users] RT Archiving Tickets

Greets fellow users, We have an RT 3.8.7 Deployment running on Centos with a MySQL backend. The DB itself has grown quite large, currently around 300GB with 2.1 million tickets, this due to customers sending through images which is part of the ticket. About a year ago we partitioned the RT

[rt-users] Slow Excel Export Download

Greets Gents, I'm experiencing the most bizarre issue and hoping someone can shed light on the process that happens on the backend when someone exports to excel. Exporting and saving to disk the throughput from the RT server the download comes down in bits per second, download attachments or any

[rt-users] Image Linking

Hi RT-Users, A quick google didnt hit up any results so I am hoping some list members might have some info. Is there a way/mechanism that will allow for images within tickets to be stored on the disk filesystem/nfs share as opposed to within the MySQL Database? Regards Ronald

[rt-users] Adding/Removing/Rename Fields under Basics

Hi All, Under a given Ticket's Basic page there are a few fields such as Status, Queue, Owner, Time Worked, Time Estimated Time Left. Is it possible to add more fields to the Basic page or rename the Time Worked/Time Estimated/Time Left? Regards Ronald

[rt-users] rt4 attachment offloading

Greets list members. I'm looking at leaving our RT3 deployment behind and starting fresh with an RT4 deployment. One of the issues we had with RT3 was the amount of images and attachments that got stored in the tickets and db which at this stage is sitting at 350GB. Is there a mechanism with RT4

[rt-users] Slow Bulk Update Display Screen

Hi Guys, I have an RT3.8.7 deployments (I know, we're still a little behind). The system is pretty nippy, even with Tickets closing in on 3millions in the MySQL DB. An issue has recently cropped up where using Bulk Update on the web interface takes extremely long to load, it's only this that is

[rt-users] Attachment extraction from DB

Hi All, Has anyone ever had to extract files (docs,pdf's) out of the RT DB onto files on the filesystem? If so would you mind sharing how you went about it? Regards Ronald

Re: [rt-users] Attachment extraction from DB

right clicking through 1.2 million tickets might cause some finger strain :) indeed, i meant a method to dump directly from mySQL to disk. i shall look into how to interact via the api then. thanks On 2 Jul 2012 23:58, Kevin Riggle kev...@bestpractical.com wrote: Excerpts from ronald higgins's