[rt-users] RT 3.0.4 very slow when replying to tickets via web interface

[Aleš Sušnik]

Scott,
 
there are some docs available on mysql's site, the transition from 3.x to
4.x should be painless, atleast it was in my case and we're running alot of
other applicatons using php & mysql...
Perhaps setup a test environment?
A.

-----Original Message-----
From: Scott Dexter [mailto:scott.dexter at mailsrv.prov.ingenta.com] 
Sent: Friday, September 12, 2003 3:06 AM
To: 'Aleš Sušnik'; 'RT'
Cc: rt-users at lists.fsck.com
Subject: RE: [rt-users] RT 3.0.4 very slow when replying to tickets via web
interface



Not sure if using MySQL4 will be possible since RT isn't the only web app
using MySQL.  I was watching top while do some entries, looks like
apache/perl may be more likely culprits. :-(

 

Scot

 

----

Scott Dexter

-----Original Message-----
From: Aleš Sušnik [mailto:alesh at sportina.si] 
Sent: Thursday, September 11, 2003 4:09 PM
To: 'Scott Dexter'; 'RT'
Cc: rt-users at lists.fsck.com
Subject: RE: [rt-users] RT 3.0.4 very slow when replying to tickets via web
interface

 

Scott,

 

which my.cnf are you using? my-large.cnf is recommended!

Also, hardware specifications? RAM, CPU?

And like Michael already responded, mysql 4.x is very highly recommended!

 

Search back the mailing list, for august 2003, there are some good mails
regarding speed issues!

 

A.

-----Original Message-----
From: rt-users-admin at lists.fsck.com [mailto:rt-users-admin at lists.fsck.com]
On Behalf Of Scott Dexter
Sent: Thursday, September 11, 2003 8:46 PM
To: 'RT'
Cc: rt-users at lists.fsck.com
Subject: RE: [rt-users] RT 3.0.4 very slow when replying to tickets via web
interface

I am running it on a Red Hat 8.0 box with MySQL3 and apache 1.3.27, the DB
isn't THAT big, not sure what could be causing this.  Not see any particular
load on the machine either, which is very perplexing.

 

Scott

 

----

Scott Dexter

-----Original Message-----
From: RT [mailto:RT at InterCept.Net] 
Sent: Thursday, September 11, 2003 2:42 PM
To: Scott Dexter
Cc: rt-users at lists.fsck.com
Subject: RE: [rt-users] RT 3.0.4 very slow when replying to tickets via web
interface

 

It's been said in here that mysql 4.0 gives better performance... what os
are you running this on? If you have the resources, backup ur rt3 dir and do
a mysqldump of your rt3 db and use that information on a server with apache2
and mysql 4 and maybe a newer distro of your os. 

 

Michael

 

-----Original Message-----
From: Scott Dexter [mailto:scott.dexter at mailsrv.prov.ingenta.com] 
Posted At: Thursday, September 11, 2003 2:14 PM
Posted To: RT
Conversation: [rt-users] RT 3.0.4 very slow when replying to tickets via web
interface
Subject: [rt-users] RT 3.0.4 very slow when replying to tickets via web
interface

 

 

We're using MySQL, and apache 1.3.27 with mod_perl. When you attempt to
reply with the web interface, it spins it's wheels for a Long time (60
seconds and more) then finally goes through.  Not seeing high loads on the
machine and RT only has 5 users at any given time, the DB has about 1500
tickets in it.  Any thoughts?

 

Scott

 

----

Scott Dexter

 

 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003

 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003


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