Problem
flex.bi server gets very slow response times to from import or report queries. Sometimes this is visible as timeout of reportscauses a report execution timeouts, sometimes as error messages about not being able to lock records or other database related messages in queues log file.
Solution
Enabling logging of slow queries might help to trace the cause of the problem if it is database configuration problem. Enter these commands in you mysql configuration (
...
usually
/etc/my.cnf
file):Code Block long_query_time = 10 slow_query_log = 1 slow_query_log_file = /var/log/mysql/log-slow-queries.log
...
Create the file
/var/log/
...
messages.log-slow-queries.log
...
and make sure it can be accessed by the system user running mysql - usually user mysql.
For example:Code Block
...
mkdir /var/log/mysql
...
touch /var/log/mysql/log-slow-queries.log
...
chown mysql:mysql /var/log/mysql/log-slow-queries.log
Then restart mysql service and monitor the file.
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
hidden | true |
---|
...
Code Block systemctl restart mysqld