Hi Team,
From last one month my server utilization is increased over time and after 24-30 hours it got crashed .on the daily basis i have to reboot the server.I have 150-200 users for my CRM.
I’m not able to find…where is the issue.If anyone have idea about it,please suggest me how to resolved it.
Below is the required details.
SugarCRM : Version 7.6.5
Apache : Server version: Apache/2.4.23 (Amazon)
DataBase : mysql version : 5.7.16-log 2 CPU
[table]Table [b]Size (GB)[/td]
pgr
9 March 2018 13:48
#2
If you manage to upgrade to PHP 7 that should bring a considerable improvement in performance.
However most of the issues with SuiteCRM performance causing complaints are simply because of overgrown databases. Have you been running the “Prune database” scheduler? Maybe your tables are filled with rows with “deleted=1”…
You can read about some tricks here: https://pgorod.github.io/Database-tables-size/
That SQL query on top of that article is good to examine your database and indexes.
There is also a “log slow queries” option in SuiteCRM which might help.
If you can get the help of a competent DBA, he can probably point you to the exact tables and queries creating problems.
If none of these things help, you might simply have to come to terms with the fact that you have a big installation, and big tables, so you might need to start deleting old unnecessary data, or start looking into better hardware, or splitting database and web server into separate machines.
Thanks for your quick suggestions.
I don’t have any deleted record in table’s,but in securitygroups_records table i have 2203393 records.
Database and web server are already in separate machines .
From last one month the problem getting started,before that it was working fine.
1 Like
pgr
9 March 2018 15:04
#4
Try to look for orphaned records, for example, securitygroups_records that are pointing to deleted records.
If you already have two servers, I assume the server having problems is the database server, not the web server. This makes the PHP 7 upgrade less likely to have a significant impact, although it is still very advisable for security reasons.
Do you need all those emails? That’s probably where the overhead is…
You can also see this recent thread: https://github.com/salesagility/SuiteCRM/issues/5313
There are few things you can take from there:
clearing the job_queue table of “done” jobs
a query to find orphaned records
a reminders bug that you can check if it is the source of your problems, though I think not because your reminders tables don’t seem to have anything
Hi PGR,
I have enabled slow query log but nothing is showing in suitecrm.log file related to slow query.
Ram utilization is increasing for web server not for database server.
One more thing is that Saturday & Sunday less users are working on CRM,so in normal day within 30 hours RAM memory got fully utilized but in weekend it will utilized in 2 days.
pgr
12 March 2018 09:50
#6
If the problem is on the web server there’s not much point in looking for fixes in the database (although it is possible that excessive data is causing the problems, is seems less likely).
Can you try the PHP 7 upgrade? PHP is much faster (and more secure!), so it might fix things. And even if you are running into a bug, not just a performance problem, this might fix it. It’s the first thing to try, I would say - and even if it doesn’t solve your problem, it brings many benefits so it’s worth your time.
Thanks PGR for the support.https://pgorod.github.io/Database-tables-size
[table]
pgr
12 March 2018 10:37
#8
You have a pretty large database, it’s worth working to reduce it if possible.
Delete “deleted=1” records, delete orphaned records, delete unnecessary emails,optimize tables, reconsider your indexes (this is complex DBA work, if you can get the advice of an expert it helps).