Slowness engine change after Mysql

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

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

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.

GuillaumeLe 04/11/2016 à 20:56, Sebastian Parada a écrit :

Hello, can anyone help me ? :frowning:

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.

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.

regardsOn 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 ? :frowning:

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