Overview

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.

Information

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:

1. Disk usage using the df -kh command.
2. CPU load using the top command.
3. Memory consumption using the free -m command.
4. Login to MySQL using mysql --login-path=mysql_root and provide the process list using the show full processlist; command.
5. The output of crontab -l for root and textpass users.
6. Any custom scripts that have been added to the crontab. If there are any custom queries that are being run (eg: select queries), 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
7. Output of tp_walk --tp_lgp lgpStatus command from the server/s where the issue is seen.