Issue:
Sometimes there are problems with the performance of DocuWare, storing a document or searching for documents when you use MySQL. For example, in some cases the query runs into a timeout.
Solution:
To log the problematic SQL queries you can add the following entries in the my.ini (Windows) or in the mysql.cnf (Linux):
[mysqld]
log-slow-queries = /var/log/mysql/slow.log
log-queries-not-using-indexes = /var/log/mysql/no-index.log
long_query_time = 1
or
[mysqld]
log-slow-queries = c:\my-log-files\slow.log
log-queries-not-using-indexes = c:\my-log-files\no-index.log
long_query_time = 1
With the program mysqldumpslow you can analyze the log files.