Re: Bad Performance
Ugo Bellavance <[email protected]>
| Newsgroups | gmane.comp.otrs.user |
|---|---|
| Message-ID | <[email protected]> |
On 2017-06-15 02:33 PM, aledr wrote: > Hi! > > The content is the same for both URLs... 3.6k lines lenght. > First is shown as pure text and second is parsed as HTML. > > When opening the second link there is high CPU usage. Can you provide exact stats? During the problem occurence: vmstat 1 iostat -xN 1 mpstat 1 And please answer my questions from my previous post: One single server or DB on another? What operating system? Does this request take the same amount of time every time, if you run it 2 or 3 times in a row? Did you check your operating system monitoring tool to what happens when you run this query? CPU usage high? Disk latency? Swapping? > > On Wed, Jun 14, 2017 at 9:08 PM, Ugo Bellavance <[email protected] > <mailto:[email protected]>> wrote: > > On 2017-06-06 11:38 AM, Andreas Hummelbrunner wrote: > > Hello Aledr, > > Is the seconds Attachment especially large or in any other way > "special"? (Characters in filenames, etc...) > That could be an issue. > > Also: Check if you're saving attachments on the Filesystem or in > the Database and log the corresponding events. > > Regards, > Andreas > > Am 03.06.2017 um 00:49 schrieb aledr: > > Hi! > > Had some complains about performance and noticed that: > > otrs/index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=1 > <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=1> > <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=1 > <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=1>> > Took 99ms > > otrs/index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2 > <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2> > <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2 > <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2>> > Took 30s > > What would be the reason? > > > Please provide more information: > > One single server or DB on another? > What operating system? > Does this request take the same amount of time every time, if you > run it 2 or 3 times in a row? > Did you check your operating system monitoring tool to what happens > when you run this query? CPU usage high? Disk latency? Swapping? > > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > <http://lists.otrs.org/pipermail/otrs> > To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs > <http://lists.otrs.org/mailman/listinfo/otrs> > > > > > -- > [ ]'s > Aledr - Alexandre > > > --------------------------------------------------------------------- > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs > --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs