| Description | I came across a Mantis installation today with over a million records in mantis_plugin_Source_file_table and hundreds of thousands of records mantis_plugin_Source_changeset_table.
When going to http://www.domain.com/plugin.php?page=Source/index [^] the whole things crashed my server and it took me a while to find out that this was caused by the function stats() in Source.API.php where there is a select statement like this:
SELECT COUNT(DISTINCT filename) FROM $t_file_table AS f
JOIN $t_changeset_table AS c
ON c.id=f.change_id
WHERE c.repo_id=#
Now, looking into the tables mentiond above there are no indeces defined for neither f.filename nor for f.change_id nor for any of the other fields required for that statement and it doesn't take much to understand that those statements could take hours even on a powerful server.
After I've added an individual index on each of those fields, the whole thing worked just fine again.
My recommendation would be to add at least those indeces by default if not more. |
Relationships 
Relationships 
