troubleshooting Question

sugarcrm application issue due to mysql performance

Avatar of D_wathi
D_wathiFlag for India asked on
SugarCRMMySQL Server
4 Comments1 Solution326 ViewsLast Modified:
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.cnf
#
# 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.cnf.d
-----------------------------------------------------------------------------------------------end--------------
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
David Favor
Fractional CTO
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros