You confirmed that the cloud LGP database has a slow performance and the custom queries that you have created take a while to execute and give an output. You want to perform a health check on this database to see if there's an issue and if this performance can be improved.
Since these are custom queries, the NewNet Lithium team cannot support optimizations for the queries that are executed directly on the MySQL server. This falls under MySQL/Oracle's support scope.
If the purpose of these queries is data mining, then it is not recommended to use the production LGP server for the same as it risks impacting the LGP server performance because it consumes additional LGP resources. It is recommended to take a MySQL dump and execute queries in some external server.
LGP is designed to process logs and make them available for log searches via the MGR GUI. Anything other than the main LGP functionalities must be discussed with NewNet Sales, so enhancements or new solutions to the existing system can be considered as a feature request in the LGR component.
If the above explanation doesn't suffice and you think Support should be involved, then you can open a Support ticket and provide the below information from the LGP server/s where the issue is seen. You will need SSH access to the server/s:
- Disk usage using the
- CPU load using the
- Memory consumption using the
- Login to MySQL using
mysql --login-path=mysql_rootand provide the process list using the
show full processlist;command.
- The output of
- Any custom scripts that have been added to the
crontab. If there are any custom queries that are being run (eg:
selectqueries), then they should also be sent. These queries could be the ones where you are running them every few seconds/minutes to get the data for processing
- Output of
tp_walk --tp_lgp lgpStatuscommand from the server/s where the issue is seen.