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=10... Took 99ms

otrs/index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2 http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=10... 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?

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 mailto:ugob@lubik.ca> 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=10... <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=10... http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=10...> Took 99ms

otrs/index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2 http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=10... <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=10... http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=10...> 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