Re: Slowness engine change after Mysql
Guillaume <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.request-tracker.user |
|---|---|
| Message-ID | <[email protected]> |
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