View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0017240 | mantisbt | db mysql | public | 2014-04-23 02:05 | 2014-05-20 00:39 |
Reporter | chandoo | Assigned To | dregad | ||
Priority | urgent | Severity | major | Reproducibility | have not tried |
Status | closed | Resolution | no change required | ||
Platform | windows | OS | windows7 | ||
Summary | 0017240: mantisBT very slow | ||||
Description | when i am reporting the issue ,site became very slow and showing blank screen. even responding also very slow. i am using MantisBT Version 1.2.15 using phpmysql using | ||||
Steps To Reproduce | please let know how to archive the data projectwice | ||||
Tags | No tags attached. | ||||
Attached Files | db_stats.php (1,764 bytes)
<?php # MantisBT - a php based bugtracking system # MantisBT is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 2 of the License, or # (at your option) any later version. # # MantisBT is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with MantisBT. If not, see <http://www.gnu.org/licenses/>. /** * @package MantisBT * @copyright Copyright (C) 2000 - 2002 Kenzaburo Ito - kenito@300baud.org * @copyright Copyright (C) 2002 - 2013 MantisBT Team - mantisbt-dev@lists.sourceforge.net * @link http://www.mantisbt.org */ /** * MantisBT Core API's */ require_once( dirname( dirname( __FILE__ ) ) . DIRECTORY_SEPARATOR . 'core.php' ); access_ensure_global_level( config_get_global( 'admin_site_threshold' ) ); # -------------------- function helper_table_row_count( $p_table ) { $t_table = $p_table; $query = "SELECT COUNT(*) FROM $t_table"; $result = db_query_bound( $query ); $t_users = db_result( $result ); return $t_users; } # -------------------- function print_table_stats( $p_table_name ) { $t_count = helper_table_row_count( $p_table_name ); echo "$p_table_name = $t_count records<br />"; } echo '<html><head><title>MantisBT Database Statistics</title></head><body>'; echo '<h1>MantisBT Database Statistics</h1>'; foreach( db_get_table_list() as $t_table ) { if( db_table_exists( $t_table ) ) { print_table_stats( $t_table ); } } echo '</body></html>'; | ||||
Hi Chandoo, Is this a new installation / new issue or an issue you have been experiencing for a while ? To see if we can assist... First off, I'd be interested to see the output of the database statistics script - which shows number of rows in various tables. This can be found at /admin/db_stats.php on your installation Secondly, what value do you have set for $g_email_send_using_cronjob in your config. Could you try setting this to: $g_email_send_using_cronjob = ON; [Note: this will queue any emails up and not send them until you add a scheduled task] Thirdly, If you go to /admin/email_queue.php, does this show the message "Email Queue Empty" or are there entries in the list ? And finally... Do you make use of LDAP authentication with Mantis? Paul |
|
I have upload the admin\db file i am not using cronjob for mail No there is no queue in entry. No LDAP using here. please tell me how to take backup and restore |
|
We're not interested in seeing the contents of the php script, but rather its output Furthermore, you have not provided a clear answer to
In most cases, performance issues like you reported are caused by having $g_email_send_using_cronjob = OFF and e-mails queuing up without being sent. |
|
chandoo, You did not provide any feedback; I am therefore resolving this issue as "no change required". Feel free to reopen the issue at a later time and provide the requested information. |
|