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:
- Disk usage using the
df -kh
command. - CPU load using the
top
command. - Memory consumption using the
free -m
command. - Login to MySQL using
mysql --login-path=mysql_root
and provide the process list using theshow full processlist;
command. - The output of
crontab -l
forroot
andtextpass
users. - 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 - Output of
tp_walk --tp_lgp lgpStatus
command from the server/s where the issue is seen.