[rt-users] Slowness engine change after Mysql

Sebastian Parada sparada at uc.cl
Tue Nov 8 13:47:38 EST 2016


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




More information about the rt-users mailing list