mantis slow

[angelibot]

for a few months, mantis is very slow to report incidents or consult the database weighs 3 GB because it has many attachments, this is the cause of the slowness? that I can do to improve performance?

[atrol]

this is the cause of the slowness?

Maybe, maybe not

You can trace database access by adding the following lines to file config_inc.php

Code: Select all

	$g_show_queries_count	= ON;
	$g_show_queries_list	= ON;

[angelibot]

turn it into a test environment, apparently no delays, but there are queries that appear in red, for example:

SELECT * FROM WHERE mantis_filters_table (OR project_id project_id = 13 = 0) AND name! ='' ORDER BY is_public DESC, name ASC

and there are shorter sentence.


also note, when I consult an incident, it took a long time, sometimes does not open fully, I have to lower and raise the services, and I can see the trail so we have activated

in theory no more errors. Do not know if maybe updating the version to get something extra

[atrol]

Can you show the output at the end of the trace, e.g.

Code: Select all

	0.5253	SQL Queries Total Time
	1.9151	Page Request Total Time

Search for the statements with largest number in column 2
e.g.
23 0.0721 tag_api.php:567 tag_bug_get_attached()
SELECT t.*, b.user_id as user_attached, b.date_attached FROM mantis_tag_table as t LEFT JOIN mantis_bug_tag_table as b on t.id=b.tag_id WHERE b.bug_id=15593