[rt-users] Slowness engine change after Mysql

[Guillaume]

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.
>>
>
>