How can I analyze the performance of my NuoDB database? What do I do if there is an issue?
The following are diagnostic steps you can take to analyze your database performance. If you are experiencing an issue and you are unable to identify it, please capture the following information and contact firstname.lastname@example.org.
You can collect all of the following information and send it to NuoDB Support Team for analysis:
Check whether there are specific hours of the day that you have more load, at this range of time, we can we check periodically the number of connections, by:
SELECT count(*) from system.connections;
We can check which queries ran longer than 60 seconds since the last restart:
SELECT SQLSTRING from System.querystats Where RUNTIME>60000000;
Collect the output from the Linux “top” command.
You should create a diagnose, by:
nuocmd get diagnose-info --output-dir <output directory>
You can get metrics on a specific database process with the get stats command:
nuocmd get stats --db-name <database_name> --start-id <node_ID>
Other useful tips can be found in the Troubleshooting page of our documentation.