sugarcrm application issue due to mysql performance
Dear Experts
We are having SugarCRM enterprise with good hardware very frequently users are getting httpd 500 server error this happens to all users at the same time, once restart the mysql server then works for some time like 30 mins to one hour approx and again the same issue httpd 500 server error just before this occurs very slow experience and then finally ends up with httpd 500 server error, some times if users reload it works some times I have to restart the mysql service, I am running mysql 5.6.
my.cnf below posted
/etc/opt/rh/rh-mysql56/my.
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# This group is read by the server
#
[mysqld]
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#
#
#[mysqld]
max_connections=5000
# include all files from the config directory
#
!includedir /etc/opt/rh/rh-mysql56/my.
--------------------------
just added max_connections=5000 as mentioned above but not sure this will resolve can you please suggest best practice performance steps setting up for mysql server , thanks in advance
We are having SugarCRM enterprise with good hardware very frequently users are getting httpd 500 server error this happens to all users at the same time, once restart the mysql server then works for some time like 30 mins to one hour approx and again the same issue httpd 500 server error just before this occurs very slow experience and then finally ends up with httpd 500 server error, some times if users reload it works some times I have to restart the mysql service, I am running mysql 5.6.
my.cnf below posted
/etc/opt/rh/rh-mysql56/my.
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# This group is read by the server
#
[mysqld]
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#
#
#[mysqld]
max_connections=5000
# include all files from the config directory
#
!includedir /etc/opt/rh/rh-mysql56/my.
--------------------------
just added max_connections=5000 as mentioned above but not sure this will resolve can you please suggest best practice performance steps setting up for mysql server , thanks in advance
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
One last database item. Be sure you do use mysqltuner on a regular basis + clear up all diagnostics it emits.
Also make sure you storage engines + indexes are all setup correctly.
I only use InnoDB, as MyISAM has to many challenges to use in almost any application.
Also make sure you storage engines + indexes are all setup correctly.
I only use InnoDB, as MyISAM has to many challenges to use in almost any application.
Marking my debug setup as best solution.
Poster seems to have stopped posting.
Poster seems to have stopped posting.
ASKER
Possible-performance-issues.docx