8.
On this page
The last step in this guide is considering any system changes and/or log hints.
-
Were there any operating system and/or application changes?
-
Check the Studio EVENTS page and
memsql.for any information about recent log events at a high level.log Sort by event_to see those that are critical.level -
For more verbose logs, obtain the tracelog from the master aggregator data directory (the default for this is
/var/lib/memsql/node-nodeHash/data/tracelogs). -
Find the
memsql.and runlog file tail -forcatandgrepforerror
and/orwarning
.
-
Final Recommendations
If nothing unusual arose in the investigation across all of this guide, but your cluster is still having performance issues, consider the following recommendations:
-
Did you properly capture the workload of interest in following the steps of this guide? It is possible an expensive query, queuing, or a resource problem was missed because the data was not examined at the right time.
Make sure that the workload of interest is running during the time of investigation. -
Does your system have a recommended configuration? Check the
sdb-reportoutput again and consider any configuration optimization suggestions in the check output. -
Is the system’s hardware healthy overall? Check disk and network performance.
It is possible that a hardware issue might be leading to performance bottlenecks. -
Refer to the Troubleshooting Reference to see if any of the reference topics included there are applicable to your cluster.
Last modified: July 30, 2024