Hello,
My users of the Mantis bugtracker system are reporting slowness when reporting an issue or updating an issue. I created a test ticket and have been able to reproduce the issue. This issue appears to be with the entire system rather than one or two specific projects. Could anyone provide some assistance as to what could be causing this? We are using mantis version 1.2.5 and MySQL 5.1 as our backend database.
To give a little more information, I enabled SQL tracing into the config_inc.php file and this was the output after adding a note to a ticket:
Logged in as: sshah (Sheel Shah - administrator) 2014-02-05 11:46 CST Project:
________________________________________
Copyright © 2000 - 2011 MantisBT Group
sshah@site.org
43 total queries executed.
38 unique queries executed.
1 0.0000 database_api.php:105 db_connect()
SET NAMES UTF8
2 0.0000 plugin_api.php:771 plugin_register_installed()
SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC
3 0.0000 config_api.php:124 config_get()
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
4 0.0000 authentication_api.php:759 auth_is_cookie_valid()
SELECT * FROM mantis_user_table WHERE cookie_string='29c4acfe8ad42cd715ed2fd16812f89db6e378965b6f04c4039cf49089aa287d'
5 0.0000 user_pref_api.php:171 user_pref_cache_row()
SELECT * FROM mantis_user_pref_table WHERE user_id=112 AND project_id=0
6 0.0000 tokens_api.php:263 token_purge_expired()
DELETE FROM mantis_tokens_table WHERE 1391622308 > expiry
7 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=112
8 0.0000 bug_api.php:596 bug_cache_row()
SELECT * FROM mantis_bug_table WHERE id=26589
9 0.0000 bug_api.php:708 bug_text_cache_row()
SELECT bt.* FROM mantis_bug_text_table bt, mantis_bug_table b WHERE b.id=26589 AND b.bug_text_id = bt.id
10 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=10
11 0.0156 bugnote_api.php:155 bugnote_add()
INSERT INTO mantis_bugnote_text_table ( note ) VALUES ( 'test from sheel 4' )
12 0.0000 bugnote_api.php:180 bugnote_add()
INSERT INTO mantis_bugnote_table (bug_id, reporter_id, bugnote_text_id, view_state, date_submitted, last_modified, note_type, note_attr, time_tracking ) VALUES (26589, 112,'21019', 10, 1391622308,1391622308, 0, '', 0 )
13 0.0000 bug_api.php:1718 bug_update_date()
UPDATE mantis_bug_table SET last_updated= 1391622308 WHERE id=26589
14 0.0000 history_api.php:94 history_log_event_special()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, type, old_value, new_value, field_name ) VALUES ( 112, 26589, 1391622308, 2, '0021019','', '')
15 0.0000 bug_api.php:596 bug_cache_row()
SELECT * FROM mantis_bug_table WHERE id=26589
16 0.0000 bugnote_api.php:433 bugnote_get_all_bugnotes()
SELECT b.*, t.note FROM mantis_bugnote_table b LEFT JOIN mantis_bugnote_text_table t ON b.bugnote_text_id = t.id WHERE b.bug_id=26589 ORDER BY b.id ASC
17 0.0156 email_api.php:234 email_collect_recipients()
SELECT DISTINCT user_id FROM mantis_bug_monitor_table WHERE bug_id=26589
18 0.0000 bugnote_api.php:336 bugnote_get_latest_id()
SELECT id FROM mantis_bugnote_table WHERE bug_id=26589 ORDER by last_modified DESC
19 0.0000 email_api.php:256 email_collect_recipients()
SELECT DISTINCT reporter_id FROM mantis_bugnote_table WHERE bug_id = 26589
20 0.0000 user_api.php:99 user_cache_array_rows()
SELECT * FROM mantis_user_table WHERE id IN (55)
21 0.0000 user_pref_api.php:221 user_pref_cache_array_rows()
SELECT * FROM mantis_user_pref_table WHERE user_id IN (55) AND project_id=0
22 0.0000 user_pref_api.php:221 user_pref_cache_array_rows()
SELECT * FROM mantis_user_pref_table WHERE user_id IN (112,55) AND project_id=10
23 0.0000 access_api.php:175 access_cache_matrix_user()
SELECT project_id, access_level FROM mantis_project_user_list_table WHERE user_id=55
24 0.0000 category_api.php:292 category_get_row()
SELECT * FROM mantis_category_table WHERE id=97
25 0.0000 custom_field_api.php:1062 custom_field_get_all_linked_fields()
SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM mantis_custom_field_project_table p INNER JOIN mantis_custom_field_table f ON p.field_id = f.id LEFT JOIN mantis_custom_field_string_table s ON p.field_id=s.field_id AND s.bug_id='26589' WHERE p.project_id = '10' ORDER BY p.sequence ASC, f.name ASC
26 0.0000 history_api.php:151 history_get_raw_events_array()
SELECT * FROM mantis_bug_history_table WHERE bug_id=26589 ORDER BY date_modified ASC,id
27 0.0156 relationship_api.php:333 relationship_get_all_src()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.destination_bug_id = mantis_bug_table.id WHERE source_bug_id=26589 ORDER BY relationship_type, mantis_bug_relationship_table.id
28 0.0000 relationship_api.php:377 relationship_get_all_dest()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.source_bug_id = mantis_bug_table.id WHERE destination_bug_id=26589 ORDER BY relationship_type, mantis_bug_relationship_table.id
29 0.0000 email_queue_api.php:101 email_queue_add()
INSERT INTO mantis_email_table ( email, subject, body, submitted, metadata) VALUES ( 'sshah@site.org', '[Web Updates (Webwork) 0026589]: Test ticket to test slowness', 'A NOTE has been added to this issue. ====================================================================== http://site/mantis/view.php?id=26589 ====================================================================== Reported By: sshah Assigned To: cjordan ====================================================================== Project: Web Updates (Webwork) Issue ID: 26589 Category: Technical Reproducibility: unable to reproduce Severity: minor Priority: normal Status: assigned ====================================================================== Date Submitted: 2014-02-05 10:31 CST Last Modified: 2014-02-05 11:45 CST ====================================================================== Summary: Test ticket to test slowness Description: Testing ticket for slowness. ====================================================================== ---------------------------------------------------------------------- (0021012) sshah (administrator) - 2014-02-05 10:33 http://site/mantis/view.php?id=26589#c21012 ---------------------------------------------------------------------- test updating ---------------------------------------------------------------------- (0021014) (0021019) sshah (administrator) - 2014-02-05 11:45 http://site/mantis/view.php?id=26589#c21019 ---------------------------------------------------------------------- test from sheel 4 Issue History Date Modified Username Field Change ====================================================================== 2014-02-05 10:31 sshah New Issue 2014-02-05 10:31 sshah Status new => assigned 2014-02-05 10:31 sshah Assigned To => cjordan 2014-02-05 10:33 sshah Note Added: 0021012 2014-02-05 11:13 sshah Note Added: 0021014 2014-02-05 11:21 sshah Note Added: 0021015 2014-02-05 11:27 sshah Note Added: 0021016 2014-02-05 11:29 sshah Note Added: 0021017 2014-02-05 11:33 sshah Note Added: 0021018 2014-02-05 11:45 sshah Note Added: 0021019 ======================================================================', 1391622308, 'a:4:{s:7:"headers";a:2:{s:8:"keywords";s:33:"[Web Updates (Webwork)] Technical";s:11:"In-Reply-To";s:32:"b67b32f8b761c0976afda79ef907011a";}s:8:"priority";i:3;s:7:"charset";s:5:"utf-8";s:8:"hostname";s:15:"site";}' )
30 0.0000 project_api.php:466 project_get_local_user_access_level()
SELECT access_level FROM mantis_project_user_list_table WHERE user_id=55 AND project_id=10
31 0.0000 project_api.php:466 project_get_local_user_access_level()
SELECT access_level FROM mantis_project_user_list_table WHERE user_id=55 AND project_id=10
32 0.0000 history_api.php:151 history_get_raw_events_array()
SELECT * FROM mantis_bug_history_table WHERE bug_id=26589 ORDER BY date_modified ASC,id
33 0.0000 relationship_api.php:333 relationship_get_all_src()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.destination_bug_id = mantis_bug_table.id WHERE source_bug_id=26589 ORDER BY relationship_type, mantis_bug_relationship_table.id
34 0.0156 relationship_api.php:377 relationship_get_all_dest()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.source_bug_id = mantis_bug_table.id WHERE destination_bug_id=26589 ORDER BY relationship_type, mantis_bug_relationship_table.id
35 0.0000 email_queue_api.php:101 email_queue_add()
INSERT INTO mantis_email_table ( email, subject, body, submitted, metadata) VALUES ( 'cjordan@site.org', '[Web Updates (Webwork) 0026589]: Test ticket to test slowness', 'A NOTE has been added to this issue. ====================================================================== http://site/mantis/view.php?id=26589 ====================================================================== Reported By: sshah Assigned To: cjordan ====================================================================== Project: Web Updates (Webwork) Issue ID: 26589 Category: Technical Reproducibility: unable to reproduce Severity: minor Priority: normal Status: assigned ====================================================================== Date Submitted: 2014-02-05 10:31 CST Last Modified: 2014-02-05 11:45 CST ====================================================================== Summary: Test ticket to test slowness Description: Testing ticket for slowness. ====================================================================== ---------------------------------------------------------------------- (0021012) sshah (administrator) - 2014-02-05 10:33 http://site/mantis/view.php?id=26589#c21012 ---------------------------------------------------------------------- test updating ---------------------------------------------------------------------- (0021014) sshah (administrator) - 2014-02-05 11:13 http://site/mantis/view.php?id=26589#c21014 ---------------------------------------------------------------------- test ---------------------------------------------------------------------- (0021015) sshah (administrator) - (0021019) sshah (administrator) - 2014-02-05 11:45 http://site/mantis/view.php?id=26589#c21019 ---------------------------------------------------------------------- test from sheel 4 Issue History Date Modified Username Field Change ====================================================================== 2014-02-05 10:31 sshah New Issue 2014-02-05 10:31 sshah Status new => assigned 2014-02-05 10:31 sshah Assigned To => cjordan 2014-02-05 10:33 sshah Note Added: 0021012 2014-02-05 11:13 sshah Note Added: 0021014 2014-02-05 11:21 sshah Note Added: 0021015 2014-02-05 11:27 sshah Note Added: 0021016 2014-02-05 11:29 sshah Note Added: 0021017 2014-02-05 11:33 sshah Note Added: 0021018 2014-02-05 11:45 sshah Note Added: 0021019 ======================================================================', 1391622308, 'a:4:{s:7:"headers";a:2:{s:8:"keywords";s:33:"[Web Updates (Webwork)] Technical";s:11:"In-Reply-To";s:32:"b67b32f8b761c0976afda79ef907011a";}s:8:"priority";i:3;s:7:"charset";s:5:"utf-8";s:8:"hostname";s:15:"site";}' )
36 0.0000 email_queue_api.php:176 email_queue_get_ids()
SELECT email_id FROM mantis_email_table ORDER BY email_id DESC
37 0.0000 email_queue_api.php:148 email_queue_get()
SELECT * FROM mantis_email_table WHERE email_id=134215
38 0.0000 project_hierarchy_api.php:157 project_hierarchy_cache()
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name
39 0.0000 project_api.php:123 project_cache_array_rows()
SELECT * FROM mantis_project_table WHERE id IN (26,16,19,17,7,14,22,25,15,20,27,18,21,4)
40 0.0000 user_api.php:948 user_get_accessible_subprojects()
SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name
41 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=12
42 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=24
43 0.0000 user_api.php:1148 user_update_last_visit()
UPDATE mantis_user_table SET last_visit= 1391622369 WHERE id=112
0.0624 SQL Queries Total Time
60.2203 Page Request Total Time
Thanks,
Sheel Shah
Slowness reporting issue or updating issue into bugbase
Moderators: Developer, Contributor
Re: Slowness reporting issue or updating issue into bugbase
There are 81 rows in the mantis_email_table table. Should these entries be cleared out?
Re: Slowness reporting issue or updating issue into bugbase
There is a reason that these 81 emails can't be sent.
Now Mantis tries to sent them again and again whenenver any email is triggered.
Have a look at the entries if there is something special, e.g. all sent to the same address, ...
I am quite sure that your issue is fixed after clearing the entries, but I am also quite sure that you will get the same issue again if there is a general problem with email sending.
Now Mantis tries to sent them again and again whenenver any email is triggered.
Have a look at the entries if there is something special, e.g. all sent to the same address, ...
I am quite sure that your issue is fixed after clearing the entries, but I am also quite sure that you will get the same issue again if there is a general problem with email sending.
Re: Slowness reporting issue or updating issue into bugbase
Unfortunately, even after clearing the entries from the mantis_email_table, the performance when updating a ticket or creating a new one is still very slow. Below is the SQL tracing output after creating a new ticket. I received the notification on the creation of this ticket as well.
Mantis Bug Tracker
Logged in as: sshah (Sheel Shah - administrator) 2014-02-06 08:48 CST
Project:
RSS
Main | My View | View Issues | Report Issue | Change Log | Roadmap | Summary | Manage | My Account | Logout
Operation successful.
[ View Submitted Issue 26604 ] [ View Issues ]
Copyright © 2000 - 2011 MantisBT Group
sshah@soa.org
41 total queries executed.
40 unique queries executed.
1 0.0000 database_api.php:105 db_connect()
SET NAMES UTF8
2 0.0000 plugin_api.php:771 plugin_register_installed()
SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC
3 0.0000 config_api.php:124 config_get()
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
4 0.0000 authentication_api.php:759 auth_is_cookie_valid()
SELECT * FROM mantis_user_table WHERE cookie_string='29c4acfe8ad42cd715ed2fd16812f89db6e378965b6f04c4039cf49089aa287d'
5 0.0000 user_pref_api.php:171 user_pref_cache_row()
SELECT * FROM mantis_user_pref_table WHERE user_id=112 AND project_id=0
6 0.0000 tokens_api.php:263 token_purge_expired()
DELETE FROM mantis_tokens_table WHERE 1391698062 > expiry
7 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=112
8 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=10
9 0.0000 custom_field_api.php:866 custom_field_get_linked_ids()
SELECT cft.id FROM mantis_custom_field_table cft, mantis_custom_field_project_table cfpt WHERE cfpt.project_id = 10 AND cft.id = cfpt.field_id ORDER BY sequence ASC, name ASC
10 0.0000 bug_api.php:317 create()
INSERT INTO mantis_bug_text_table ( description, steps_to_reproduce, additional_information ) VALUES ( 'To Sheel.','','')
11 0.0000 bug_api.php:369 create()
INSERT INTO mantis_bug_table ( project_id,reporter_id, handler_id,duplicate_id, priority,severity, reproducibility,status, resolution,projection, category_id,date_submitted, last_updated,eta, bug_text_id, os, os_build,platform, version,build, profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version, target_version, due_date ) VALUES ( 10,112,112,0, 30,50,70,50, 10,10,97,1391698062, 1391698062,10,'26604','', '','','','', 0,'To Sheel',10,0, 0,'','',1)
12 0.0000 history_api.php:94 history_log_event_special()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, type, old_value, new_value, field_name ) VALUES ( 112, 26604, 1391698062, 1, '','', '')
13 0.0000 history_api.php:55 history_log_event_direct()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, field_name, old_value, new_value, type ) VALUES ( 112, 26604, 1391698062, 'status', 10, 50, 0 )
14 0.0000 history_api.php:55 history_log_event_direct()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, field_name, old_value, new_value, type ) VALUES ( 112, 26604, 1391698062, 'handler_id', 0, 112, 0 )
15 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=3 AND owner=112
16 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=3 AND owner=112
17 0.0000 tokens_api.php:43 token_exists()
SELECT id FROM mantis_tokens_table WHERE id=13602
18 0.0156 tokens_api.php:224 token_update()
UPDATE mantis_tokens_table SET value='26604,26592,26589,26591', expiry=1391784462 WHERE id=13602
19 0.0000 bugnote_api.php:433 bugnote_get_all_bugnotes()
SELECT b.*, t.note FROM mantis_bugnote_table b LEFT JOIN mantis_bugnote_text_table t ON b.bugnote_text_id = t.id WHERE b.bug_id='26604' ORDER BY b.id ASC
20 0.0000 bug_api.php:596 bug_cache_row()
SELECT * FROM mantis_bug_table WHERE id=26604
21 0.0000 email_api.php:234 email_collect_recipients()
SELECT DISTINCT user_id FROM mantis_bug_monitor_table WHERE bug_id=26604
22 0.0000 bugnote_api.php:336 bugnote_get_latest_id()
SELECT id FROM mantis_bugnote_table WHERE bug_id=26604 ORDER by last_modified DESC
23 0.0000 bugnote_api.php:317 bugnote_get_field()
SELECT view_state FROM mantis_bugnote_table WHERE id=0
24 0.0000 bugnote_api.php:317 bugnote_get_field()
SELECT last_modified FROM mantis_bugnote_table WHERE id=0
25 0.0000 email_api.php:256 email_collect_recipients()
SELECT DISTINCT reporter_id FROM mantis_bugnote_table WHERE bug_id = 26604
26 0.0000 user_pref_api.php:221 user_pref_cache_array_rows()
SELECT * FROM mantis_user_pref_table WHERE user_id IN (112) AND project_id=10
27 0.0000 bug_api.php:708 bug_text_cache_row()
SELECT bt.* FROM mantis_bug_text_table bt, mantis_bug_table b WHERE b.id=26604 AND b.bug_text_id = bt.id
28 0.0000 category_api.php:292 category_get_row()
SELECT * FROM mantis_category_table WHERE id=97
29 0.0000 custom_field_api.php:1062 custom_field_get_all_linked_fields()
SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM mantis_custom_field_project_table p INNER JOIN mantis_custom_field_table f ON p.field_id = f.id LEFT JOIN mantis_custom_field_string_table s ON p.field_id=s.field_id AND s.bug_id='26604' WHERE p.project_id = '10' ORDER BY p.sequence ASC, f.name ASC
30 0.0156 history_api.php:151 history_get_raw_events_array()
SELECT * FROM mantis_bug_history_table WHERE bug_id=26604 ORDER BY date_modified ASC,id
31 0.0000 relationship_api.php:333 relationship_get_all_src()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.destination_bug_id = mantis_bug_table.id WHERE source_bug_id=26604 ORDER BY relationship_type, mantis_bug_relationship_table.id
32 0.0000 relationship_api.php:377 relationship_get_all_dest()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.source_bug_id = mantis_bug_table.id WHERE destination_bug_id=26604 ORDER BY relationship_type, mantis_bug_relationship_table.id
33 0.0000 email_queue_api.php:101 email_queue_add()
INSERT INTO mantis_email_table ( email, subject, body, submitted, metadata) VALUES ( 'sshah@soa.org', '[Web Updates (Webwork) 0026604]: To Sheel', 'The following issue has been SUBMITTED. ====================================================================== http://bugbase.soa.org/mantis/view.php?id=26604 ====================================================================== Reported By: sshah Assigned To: sshah ====================================================================== Project: Web Updates (Webwork) Issue ID: 26604 Category: Technical Reproducibility: have not tried Severity: minor Priority: normal Status: assigned ====================================================================== Date Submitted: 2014-02-06 08:47 CST Last Modified: 2014-02-06 08:47 CST ====================================================================== Summary: To Sheel Description: To Sheel. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 2014-02-06 08:47 sshah New Issue 2014-02-06 08:47 sshah Status new => assigned 2014-02-06 08:47 sshah Assigned To => sshah ======================================================================', 1391698062, 'a:4:{s:7:"headers";a:2:{s:8:"keywords";s:33:"[Web Updates (Webwork)] Technical";s:10:"Message-ID";s:32:"6d6d421940a16b33c654f5c981c942ab";}s:8:"priority";i:3;s:7:"charset";s:5:"utf-8";s:8:"hostname";s:15:"bugbase.soa.org";}' )
34 0.0000 email_queue_api.php:176 email_queue_get_ids()
SELECT email_id FROM mantis_email_table ORDER BY email_id DESC
35 0.0000 email_queue_api.php:148 email_queue_get()
SELECT * FROM mantis_email_table WHERE email_id=134256
36 0.0000 project_hierarchy_api.php:157 project_hierarchy_cache()
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name
37 0.0000 project_api.php:123 project_cache_array_rows()
SELECT * FROM mantis_project_table WHERE id IN (26,16,19,17,7,14,22,25,15,20,27,18,21,4)
38 0.0000 user_api.php:948 user_get_accessible_subprojects()
SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name
39 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=12
40 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=24
41 0.0000 user_api.php:1148 user_update_last_visit()
UPDATE mantis_user_table SET last_visit= 1391698122 WHERE id=112
0.0312 SQL Queries Total Time
60.189 Page Request Total Time
Powered by Mantis Bugtracker
Mantis Bug Tracker
Logged in as: sshah (Sheel Shah - administrator) 2014-02-06 08:48 CST
Project:
RSS
Main | My View | View Issues | Report Issue | Change Log | Roadmap | Summary | Manage | My Account | Logout
Operation successful.
[ View Submitted Issue 26604 ] [ View Issues ]
Copyright © 2000 - 2011 MantisBT Group
sshah@soa.org
41 total queries executed.
40 unique queries executed.
1 0.0000 database_api.php:105 db_connect()
SET NAMES UTF8
2 0.0000 plugin_api.php:771 plugin_register_installed()
SELECT basename, priority, protected FROM mantis_plugin_table WHERE enabled=1 ORDER BY priority DESC
3 0.0000 config_api.php:124 config_get()
SELECT config_id, user_id, project_id, type, value, access_reqd FROM mantis_config_table
4 0.0000 authentication_api.php:759 auth_is_cookie_valid()
SELECT * FROM mantis_user_table WHERE cookie_string='29c4acfe8ad42cd715ed2fd16812f89db6e378965b6f04c4039cf49089aa287d'
5 0.0000 user_pref_api.php:171 user_pref_cache_row()
SELECT * FROM mantis_user_pref_table WHERE user_id=112 AND project_id=0
6 0.0000 tokens_api.php:263 token_purge_expired()
DELETE FROM mantis_tokens_table WHERE 1391698062 > expiry
7 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=5 AND owner=112
8 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=10
9 0.0000 custom_field_api.php:866 custom_field_get_linked_ids()
SELECT cft.id FROM mantis_custom_field_table cft, mantis_custom_field_project_table cfpt WHERE cfpt.project_id = 10 AND cft.id = cfpt.field_id ORDER BY sequence ASC, name ASC
10 0.0000 bug_api.php:317 create()
INSERT INTO mantis_bug_text_table ( description, steps_to_reproduce, additional_information ) VALUES ( 'To Sheel.','','')
11 0.0000 bug_api.php:369 create()
INSERT INTO mantis_bug_table ( project_id,reporter_id, handler_id,duplicate_id, priority,severity, reproducibility,status, resolution,projection, category_id,date_submitted, last_updated,eta, bug_text_id, os, os_build,platform, version,build, profile_id, summary, view_state, sponsorship_total, sticky, fixed_in_version, target_version, due_date ) VALUES ( 10,112,112,0, 30,50,70,50, 10,10,97,1391698062, 1391698062,10,'26604','', '','','','', 0,'To Sheel',10,0, 0,'','',1)
12 0.0000 history_api.php:94 history_log_event_special()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, type, old_value, new_value, field_name ) VALUES ( 112, 26604, 1391698062, 1, '','', '')
13 0.0000 history_api.php:55 history_log_event_direct()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, field_name, old_value, new_value, type ) VALUES ( 112, 26604, 1391698062, 'status', 10, 50, 0 )
14 0.0000 history_api.php:55 history_log_event_direct()
INSERT INTO mantis_bug_history_table ( user_id, bug_id, date_modified, field_name, old_value, new_value, type ) VALUES ( 112, 26604, 1391698062, 'handler_id', 0, 112, 0 )
15 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=3 AND owner=112
16 0.0000 tokens_api.php:78 token_get()
SELECT * FROM mantis_tokens_table WHERE type=3 AND owner=112
17 0.0000 tokens_api.php:43 token_exists()
SELECT id FROM mantis_tokens_table WHERE id=13602
18 0.0156 tokens_api.php:224 token_update()
UPDATE mantis_tokens_table SET value='26604,26592,26589,26591', expiry=1391784462 WHERE id=13602
19 0.0000 bugnote_api.php:433 bugnote_get_all_bugnotes()
SELECT b.*, t.note FROM mantis_bugnote_table b LEFT JOIN mantis_bugnote_text_table t ON b.bugnote_text_id = t.id WHERE b.bug_id='26604' ORDER BY b.id ASC
20 0.0000 bug_api.php:596 bug_cache_row()
SELECT * FROM mantis_bug_table WHERE id=26604
21 0.0000 email_api.php:234 email_collect_recipients()
SELECT DISTINCT user_id FROM mantis_bug_monitor_table WHERE bug_id=26604
22 0.0000 bugnote_api.php:336 bugnote_get_latest_id()
SELECT id FROM mantis_bugnote_table WHERE bug_id=26604 ORDER by last_modified DESC
23 0.0000 bugnote_api.php:317 bugnote_get_field()
SELECT view_state FROM mantis_bugnote_table WHERE id=0
24 0.0000 bugnote_api.php:317 bugnote_get_field()
SELECT last_modified FROM mantis_bugnote_table WHERE id=0
25 0.0000 email_api.php:256 email_collect_recipients()
SELECT DISTINCT reporter_id FROM mantis_bugnote_table WHERE bug_id = 26604
26 0.0000 user_pref_api.php:221 user_pref_cache_array_rows()
SELECT * FROM mantis_user_pref_table WHERE user_id IN (112) AND project_id=10
27 0.0000 bug_api.php:708 bug_text_cache_row()
SELECT bt.* FROM mantis_bug_text_table bt, mantis_bug_table b WHERE b.id=26604 AND b.bug_text_id = bt.id
28 0.0000 category_api.php:292 category_get_row()
SELECT * FROM mantis_category_table WHERE id=97
29 0.0000 custom_field_api.php:1062 custom_field_get_all_linked_fields()
SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM mantis_custom_field_project_table p INNER JOIN mantis_custom_field_table f ON p.field_id = f.id LEFT JOIN mantis_custom_field_string_table s ON p.field_id=s.field_id AND s.bug_id='26604' WHERE p.project_id = '10' ORDER BY p.sequence ASC, f.name ASC
30 0.0156 history_api.php:151 history_get_raw_events_array()
SELECT * FROM mantis_bug_history_table WHERE bug_id=26604 ORDER BY date_modified ASC,id
31 0.0000 relationship_api.php:333 relationship_get_all_src()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.destination_bug_id = mantis_bug_table.id WHERE source_bug_id=26604 ORDER BY relationship_type, mantis_bug_relationship_table.id
32 0.0000 relationship_api.php:377 relationship_get_all_dest()
SELECT mantis_bug_relationship_table.id, mantis_bug_relationship_table.relationship_type, mantis_bug_relationship_table.source_bug_id, mantis_bug_relationship_table.destination_bug_id, mantis_bug_table.project_id FROM mantis_bug_relationship_table INNER JOIN mantis_bug_table ON mantis_bug_relationship_table.source_bug_id = mantis_bug_table.id WHERE destination_bug_id=26604 ORDER BY relationship_type, mantis_bug_relationship_table.id
33 0.0000 email_queue_api.php:101 email_queue_add()
INSERT INTO mantis_email_table ( email, subject, body, submitted, metadata) VALUES ( 'sshah@soa.org', '[Web Updates (Webwork) 0026604]: To Sheel', 'The following issue has been SUBMITTED. ====================================================================== http://bugbase.soa.org/mantis/view.php?id=26604 ====================================================================== Reported By: sshah Assigned To: sshah ====================================================================== Project: Web Updates (Webwork) Issue ID: 26604 Category: Technical Reproducibility: have not tried Severity: minor Priority: normal Status: assigned ====================================================================== Date Submitted: 2014-02-06 08:47 CST Last Modified: 2014-02-06 08:47 CST ====================================================================== Summary: To Sheel Description: To Sheel. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 2014-02-06 08:47 sshah New Issue 2014-02-06 08:47 sshah Status new => assigned 2014-02-06 08:47 sshah Assigned To => sshah ======================================================================', 1391698062, 'a:4:{s:7:"headers";a:2:{s:8:"keywords";s:33:"[Web Updates (Webwork)] Technical";s:10:"Message-ID";s:32:"6d6d421940a16b33c654f5c981c942ab";}s:8:"priority";i:3;s:7:"charset";s:5:"utf-8";s:8:"hostname";s:15:"bugbase.soa.org";}' )
34 0.0000 email_queue_api.php:176 email_queue_get_ids()
SELECT email_id FROM mantis_email_table ORDER BY email_id DESC
35 0.0000 email_queue_api.php:148 email_queue_get()
SELECT * FROM mantis_email_table WHERE email_id=134256
36 0.0000 project_hierarchy_api.php:157 project_hierarchy_cache()
SELECT DISTINCT p.id, ph.parent_id, p.name, p.inherit_global, ph.inherit_parent FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 ORDER BY p.name
37 0.0000 project_api.php:123 project_cache_array_rows()
SELECT * FROM mantis_project_table WHERE id IN (26,16,19,17,7,14,22,25,15,20,27,18,21,4)
38 0.0000 user_api.php:948 user_get_accessible_subprojects()
SELECT DISTINCT p.id, p.name, ph.parent_id FROM mantis_project_table p LEFT JOIN mantis_project_hierarchy_table ph ON ph.child_id = p.id WHERE p.enabled = 1 AND ph.parent_id IS NOT NULL ORDER BY p.name
39 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=12
40 0.0000 project_api.php:83 project_cache_row()
SELECT * FROM mantis_project_table WHERE id=24
41 0.0000 user_api.php:1148 user_update_last_visit()
UPDATE mantis_user_table SET last_visit= 1391698122 WHERE id=112
0.0312 SQL Queries Total Time
60.189 Page Request Total Time
Powered by Mantis Bugtracker
Re: Slowness reporting issue or updating issue into bugbase
You can disable the sql trace as it shows
Temporary add the following line to file config_inc.php
Is it still slow?
The database seems not to be the bottleneck.0.0312 SQL Queries Total Time
Temporary add the following line to file config_inc.php
Code: Select all
$g_enable_email_notification = OFF;Re: Slowness reporting issue or updating issue into bugbase
BTW, your version is quite outdated
Maybe this fixes also the issue.
I recommend to update to latest stable version (1.2.15 at the moment)1.2.5
Maybe this fixes also the issue.
Re: Slowness reporting issue or updating issue into bugbase
Disabling email notifications results in the response time being much faster. I don't understand why disabling the email notifications resolves the issue? We cannot leave the notifications disabled, as the notifications are critical for communication between our office as well as our external vendors.
Re: Slowness reporting issue or updating issue into bugbase
We had similar issues in combination with Exchange 2010 and external e-mail addresses.
Using the cron-job for sending the emails took care of that issue.
It must be something in that area.
Using the cron-job for sending the emails took care of that issue.
It must be something in that area.
Re: Slowness reporting issue or updating issue into bugbase
Hi everyone,
to give an update, I upgraded my system to 1.2.15 from 1.2.5 this morning, and the issue appears to have been resolved. The page response time even with email notifications turned on are back to expected levels. I'm still not exactly sure why email notifications was the culprit, but I'm glad to know it is resolved.
Thanks,
Sheel
to give an update, I upgraded my system to 1.2.15 from 1.2.5 this morning, and the issue appears to have been resolved. The page response time even with email notifications turned on are back to expected levels. I'm still not exactly sure why email notifications was the culprit, but I'm glad to know it is resolved.
Thanks,
Sheel