Avatar of Gotham
Gotham
Flag for India asked on

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.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
SugarCRMMySQL Server

Avatar of undefined
Last Comment
David Favor

8/22/2022 - Mon
Gotham

ASKER
logged in through phpmyadmin and navigated to STATUS and under this advisor section and found the list of comments attached, can you please suggest which are the most critical in the attached to be done immediately and how and where this to be done, this will be a great help. thank you.
Possible-performance-issues.docx
ASKER CERTIFIED SOLUTION
David Favor

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
David Favor

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.
David Favor

Marking my debug setup as best solution.

Poster seems to have stopped posting.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck