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