IP Address Change - Notes take longer to submit

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
Coolpro21
Posts: 10
Joined: 12 Dec 2011, 21:23

IP Address Change - Notes take longer to submit

Post by Coolpro21 »

Hello,

I have searched all over the place for an answer to my conundrum. We recently moved our servers to an off-site location and in the process, changed the IP addresses. After the IP address change, Mantis 1.2.6 takes between 15 and 20 seconds to post any notes added to a ticket. I have looked at the following information and nothing here helps

http://www.mantisbt.org/bugs/view.php?id=6627 - not a viable solution as stated by reporter
http://www.mantisbt.org/bugs/view.php?id=11499 - changed mantis_email_table->metadata/body from longtext to medium text = did not resolve | Tried - changing the "$g_phpMailer_method" variable in "config_inc.php" from (2) to (0) back to (2) without success (Did succeed in sending a bunch of old emails that were still in queue somehow)
http://mantisbt.domainunion.de/forums/v ... =2&t=19653 - truncated the mantis_email_table at onset of problem months ago = reporting/updating ticket is still slow, current size is 175MB with an overhead of 19MB. Should I truncate again? I've read that the mantis_email_table isn't supposed to retain anything. If that is the case, how do I keep this table from filling up, and what is causing it to retain information?

The only work around was to use crontab and send the email on a schedule. This sped up adding a note, but delays email notification.

I would like to know what is causing the slowdown when updating or reporting issues. I only know enough about LAMP to be dangerous.

VMWare virtual machine - Operating system Ubuntu Linux 10.04.1

MySQL

Server: Localhost via UNIX socket
Server version: 5.1.73-0ubuntu0.10.04.1
Protocol version: 10
User: xxx@localhost
MySQL charset: UTF-8 Unicode (utf8)

Web server

Apache/2.2.14 (Ubuntu)
MySQL client version: 5.1.72
PHP extension: mysql
atrol
Site Admin
Posts: 8558
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: IP Address Change - Notes take longer to submit

Post by atrol »

I recommend to upgrade to latest stable version of MantisBT as a first step. (1.2.15 at the moment)
There is only a small chance that this will fix the issue, but will help as there are some improvements in email logging.

Which PHP version do you use?
Please use Search before posting and read the Manual
Post Reply