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

Reply via email to