Re: Slowness engine change after Mysql

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