Slow performance: select DISTINCT
Posted: 24 Sep 2007, 11:58
Hello,
I use Mantis 1.0.0a2, I have less than 2000 issues in my DB.
I have very slow performance: it could be linked to select DISTINCT requests that slow the application.
I recently imported around 1200 and the problem appeared after that, when the new users of this DB began to work with Mantis.
Has anybody an idea to solve that?
Thanks
the Mysql shoq process list :
Command Time State Info
Query 1035 Copying to tmp table SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
Query 941 Copying to tmp table SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
Query 918 Copying to tmp table SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
Query 908 Locked UPDATE mantis_bug_table SET last_updated= '2007-09-20 10:18:26' WHERE id='867'
Query 869 Locked SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
I use Mantis 1.0.0a2, I have less than 2000 issues in my DB.
I have very slow performance: it could be linked to select DISTINCT requests that slow the application.
I recently imported around 1200 and the problem appeared after that, when the new users of this DB began to work with Mantis.
Has anybody an idea to solve that?
Thanks
the Mysql shoq process list :
Command Time State Info
Query 1035 Copying to tmp table SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
Query 941 Copying to tmp table SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
Query 918 Copying to tmp table SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma
Query 908 Locked UPDATE mantis_bug_table SET last_updated= '2007-09-20 10:18:26' WHERE id='867'
Query 869 Locked SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, ma