Re: [rt-users] 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
Re: [rt-users] Slowness engine change after Mysql
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
Re: [rt-users] Slowness engine change after Mysql
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. -- 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
