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
IP Address Change - Notes take longer to submit
Moderators: Developer, Contributor
Re: IP Address Change - Notes take longer to submit
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?
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?