Views:

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.

                                                                                                                                 

This article is valid from DocuWare version:        6        to: