Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. Request Tracker>
  3. Users
Slowness engine change after Mysql
sparada at uc
Oct 11, 2016, 7:24 AM
Post #1 of 4 (1039 views)
Permalink
Hi there,

We are experiencing some issues and would like to have your opinion.

I have an installation of rt_4.0.10, with mysql 5.1 on a redhat 5 OS.

We have upgraded the Mysql to release 5.7 and the OS to Centos release
7, keeping the RT release 4.0.10. Once upgraded, the RT system start to
have performance issues, taking about 1 minute to display the starting
windows, more or less. We have noted that it depends on how many users
are connected.

Considering this, i would like to know if someone has noted tha same
issue or similar, or if maybe the Mysql and Centos releases currently
installed could be generating issues with the RT.

We know that we have to upgrade the RT release, but before that, i would
like to know the root cause of this performance issue.


Thanks in advance. Your opinion or diagnose would be appreciated.

Regards.

--
Atte
Sebastian Parada Ríos
Ingeniero de Sistemas
Subdirección Operaciones y Plataforma
Pontificia Universidad Católica de Chile
Teléfono: (56 2) 354 1323

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Boston - October 24-26
* Los Angeles - Q1 2017
Re: Slowness engine change after Mysql [ In reply to ]
sparada at uc
Nov 4, 2016, 12:56 PM
Post #2 of 4 (989 views)
Permalink
Hello, can anyone help me ? :(

On 11/10/16 11:24, Sebastian Parada wrote:
>
> Hi there,
>
> We are experiencing some issues and would like to have your opinion.
>
> I have an installation of rt_4.0.10, with mysql 5.1 on a redhat 5 OS.
>
> We have upgraded the Mysql to release 5.7 and the OS to Centos release
> 7, keeping the RT release 4.0.10. Once upgraded, the RT system start
> to have performance issues, taking about 1 minute to display the
> starting windows, more or less. We have noted that it depends on how
> many users are connected.
>
> Considering this, i would like to know if someone has noted tha same
> issue or similar, or if maybe the Mysql and Centos releases currently
> installed could be generating issues with the RT.
>
> We know that we have to upgrade the RT release, but before that, i
> would like to know the root cause of this performance issue.
>
>
> Thanks in advance. Your opinion or diagnose would be appreciated.
>
> Regards.
>


--
Atte
Sebastian Parada Ríos
Ingeniero de Sistemas
Subdirección Operaciones y Plataforma
Pontificia Universidad Católica de Chile
Teléfono: (56 2) 354 1323

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017
Re: Slowness engine change after Mysql [ In reply to ]
rt at shadowprojects
Nov 5, 2016, 4:14 AM
Post #3 of 4 (989 views)
Permalink
Try adding this to your my.cnf under [mysqld] :

sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

MySQL 5.7 is stricter than previous versions and it can cause some issues.


Guillaume

Le 04/11/2016 à 20:56, Sebastian Parada a écrit :
>
> Hello, can anyone help me ? :(
>
> On 11/10/16 11:24, Sebastian Parada wrote:
>>
>> Hi there,
>>
>> We are experiencing some issues and would like to have your opinion.
>>
>> I have an installation of rt_4.0.10, with mysql 5.1 on a redhat 5 OS.
>>
>> We have upgraded the Mysql to release 5.7 and the OS to Centos
>> release 7, keeping the RT release 4.0.10. Once upgraded, the RT
>> system start to have performance issues, taking about 1 minute to
>> display the starting windows, more or less. We have noted that it
>> depends on how many users are connected.
>>
>> Considering this, i would like to know if someone has noted tha same
>> issue or similar, or if maybe the Mysql and Centos releases currently
>> installed could be generating issues with the RT.
>>
>> We know that we have to upgrade the RT release, but before that, i
>> would like to know the root cause of this performance issue.
>>
>>
>> Thanks in advance. Your opinion or diagnose would be appreciated.
>>
>> Regards.
>>
>
>

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017
Re: Slowness engine change after Mysql [ In reply to ]
sparada at uc
Nov 8, 2016, 10:47 AM
Post #4 of 4 (978 views)
Permalink
Hello Guillaume,

Thanks for your help, but make the recommended change and I'm still slow
and many querys in sending data.

If anyone has any other suggestions I would appreciate it.

regards

On 05/11/16 08:14, Guillaume wrote:
> Try adding this to your my.cnf under [mysqld] :
>
> sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
>
>
> MySQL 5.7 is stricter than previous versions and it can cause some
> issues.
>
>
> Guillaume
>
> Le 04/11/2016 à 20:56, Sebastian Parada a écrit :
>>
>> Hello, can anyone help me ? :(
>>
>> On 11/10/16 11:24, Sebastian Parada wrote:
>>>
>>> Hi there,
>>>
>>> We are experiencing some issues and would like to have your opinion.
>>>
>>> I have an installation of rt_4.0.10, with mysql 5.1 on a redhat 5 OS.
>>>
>>> We have upgraded the Mysql to release 5.7 and the OS to Centos
>>> release 7, keeping the RT release 4.0.10. Once upgraded, the RT
>>> system start to have performance issues, taking about 1 minute to
>>> display the starting windows, more or less. We have noted that it
>>> depends on how many users are connected.
>>>
>>> Considering this, i would like to know if someone has noted tha same
>>> issue or similar, or if maybe the Mysql and Centos releases
>>> currently installed could be generating issues with the RT.
>>>
>>> We know that we have to upgrade the RT release, but before that, i
>>> would like to know the root cause of this performance issue.
>>>
>>>
>>> Thanks in advance. Your opinion or diagnose would be appreciated.
>>>
>>> Regards.
>>>
>>
>>
>
> ---------
> RT 4.4 and RTIR training sessions, and a new workshop day!
> https://bestpractical.com/training
> * Los Angeles - January 9-11 2017


--
Atte
Sebastian Parada Ríos
Ingeniero de Sistemas
Subdirección Operaciones y Plataforma
Pontificia Universidad Católica de Chile
Teléfono: (56 2) 354 1323

---------
RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training
* Los Angeles - January 9-11 2017

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal