Hi,

I hope some one can help me.

I have tried so hard to minimize the time it takes comments to post on my site at http://metsmerizedonline.com.

They are taking a minute or longer to post and it's really starting to effect my readership on the site.

I tried a few fixes that were suggested here on this board like not automatically rebuilding my stylesheet and java script templates. It made no impact.

I am at wits end.

I disabled almost all of the plugins, and again it made no impact.

Is this just the way Movable Type is or is there something wrong?

Thank you for any help....

Nothing turned up in the server error logs when you enabled DebugMode?

At the moment you site is slow for me (main page) as it is waiting for photobucket, all I have is the header - main page took almost 2 minutes to load.

The problem could be the connection speed between the server and the database, something that you do not have any control over. It could be that you need to run CHECK TABLES on your database as something is wrong at the backend.

When I posted it took 50 seconds, which is a while, though as a comparison it took 70 seconds for the main page to load after clicking on the link from the post I commented on. Going from the main page to a post takes about 55 seconds for the page to finish loading.

You have two feeds building, an atom feed and an rss feed. One should be enough especially if they are large files.

Hi again Rob,

I think I did CHECK TABLES right and this is what I got...

Problems with indexes of table `mt_entry`
More than one INDEX key was created for column `entry_blog_id`
Problems with indexes of table `mt_ts_job`
UNIQUE and INDEX keys should not both be set for column `ts_job_funcid`

after I ran checktables, my site is no longer loading. I cant access my dashboard, or leave comments or anything...

Got an error: Connection error: Access denied for user 'admin'@'localhost' (using password: YES) at lib/MT/ObjectDriver/Driver/DBD/mysql.pm line 49
at lib/MT/ObjectDriver/Driver/DBD/mysql.pm line 49

fixed the sql problem. When I got in I changed the password because I did not know what the original one was. That error has been fixed.

The comments problem still exists.

Thanks

Well if it is a static site it would not need to access the database until you post.

The connection error points to the username / password in mt-config being incorrect. Though I can post on your site now so it looks like that is working.

CHECK TABLES only reports errors it does not fix them or do anything to your database, that is a different command.

the multiple index keys for entry_blog_id and the problem with ts_job_funid are problems that can be fixed. Though I will need to look at what SQL would need to be run.

Another problem seems to be the load on the server, not necessarily from your own site but maybe from others on the same server. Connecting this morning (04:30AM your time) the system was more responsive for me than when I connected last night (5PM your time), I addition to those speeds I posted I could not even get to your RSS feed (a 70KB file) because it kept timing out.

Hi Rob,

I am trying to do whatever I can to decrease the page load speed based on one of your previous posts.

I removed over 40 images, checked for dead links, and fixed a couple of errors. I ran a tool that had my site load speed at 32 seconds and after decreasing the size of the index page and fixing the errors I was able to cut it down to 8 seconds. Thanks for alerting me to that problem, it didn't do much for the comment problem, but you helped me immensely in this other area for putting me on that trail.

I am a complete novice with Sql, but I can follow instructions well and figure things out easily. Do you think those errors could be the source of the problem?

Thanks again.

When a comment is posted to an entry, in addition to updating the various database records, this triggers the rebuilding of the relevant archive pages (Individual, Category, Date-Based, where enabled) for that entry, and all index templates set to rebuild automatically. The number of entries in your weblog, the number and complexity of your templates, the archive types enabled, and any plugins in use will all contribute to the resources required to complete this task.

* How many of the index templates listed on the Design > Templates page for your weblog in Movable Type are configured to be published automatically when index templates are republished?

- If there are a large number of index templates being published automatically, review the types of index templates configured to be published automatically and see if there are any index templates which perhaps do not need to be republished automatically every time index templates are rebuilt.

- In addition, you may wish to consider disabling the "Archive Index" template from being automatically published with index templates, as this template publishes a page containing a link to every archive page in your weblog each time index templates are republished.

The Archive Index template currently appears to be publishing the page at http://metsmerizedonline.com/blog/, which contains a list of links to every individual entry archive page in the weblog (1,072 entries), as well as links to every monthly archive page (21 archives),

* What types of archive mappings are enabled for the Entry and Entry Listing archive templates?

* If there is not one already present, you may wish to try adding a LaunchBackgroundTasks[1] directive to the mt-config.cgi configuration file, and set it to a value of '1':

LaunchBackgroundTasks 1

I haven't seen any mention of upgrading or anything, but is this an upgraded installation? Was blitzed ever removed from Spamlookup? That can certainly cause delays of a minute or longer for comments to post.
http://www.movabletype.com/blog/2007/05/im...-your-spam.html

Thanks David...

I was able to turn off automatic rebuilding on the "Archive Index" template and it did shave off about 5 seconds.

I have no idea about the archive mapping and dont know whether it is enabled or not. I'm kind of a novice.

I'm hoping that if I can get those two sql errors fixed that it would help as well.

How many other index templates are still left that are set to be published automatically?


Archive mappings are what determine the types of archive pages that get published for a weblog. Browse to the Design > Templates > Archive Templates page for your weblog in Movable Type, click on each of the template names listed to edit the template, scroll down the the "Archive Mapping" section below the template editor window and see what archive types being published by that template.


Those errors look more like warnings and probably do not need to be fixed, nor would they cause posting comments to be really slow.

Main Index, RSD, RSS



Here is a screen shot of my Ind Arch Temp.

[img]http://i81.photobucket.com/albums/j225/metsmerized/MetsMerized%20Online/Untitled-1copy.jpg[/img]

The category and date based template only had one item in each archive map.

Thank you..

But what are they?

I'm sorry,

Date Based Archive - Monthly - yyyy/mm/index.html

Category Archive - Category - category/sub_category/index.html

Thanks for your help Dave...

Are there actual category archive pages being published for your weblog, and if so, could you provide the URL to a few of them?

If you are not intending to publish category archive pages, the category archive mapping should be removed by browsing to the Design > Templates > Archive Templates page for your weblog in Movable Type, click on the "Category Archive" template name to edit the template, scroll down to the Archive Mapping section below the template editor window, then click the trash can icon to the right of the "Category" archive mapping.

I actually deleted my categories last week because the were not working properly. When you clicked on a category name it took you to a page that was blank.

Since there is no reason for category archive pages to be published (because the weblog no longer has any categories), the category archive mapping should be deleted from the Category Archive template, as described in previous post.

I just wanted to say thanks to David and Rob and Su for helping me out. Those of you who administrate at this forum or just contribute your expertise should all be commended. Over the years I have always been able to rely on your incredible support whenever I had a problem at any of my sites.

Thanks so much!

hi!
I also have absolutely the same problem with mt-comments.cgi. Comments being posted for about a minute, and comment script probably have memory leaks (it usually consumes over ~50% RAM and if there are more than 3 scripts running at the same time they can hang the system for a while, until linux kernel would kill them and clear swap and ram).

Everything ( other MT scripts) except comments script work fine and fast, comments are moderated (so there are no automatic publishing processes).

MT 4.12, Linux 2.6, Apache 2.2.9 + mod_cgi, Mysql

ok, I've solved this problem. it was in Image::Magick, which had deep recursion at one of its scripts. recompilation if ImageMagick helped.

but now there is another problem: when I enabled comments (I had to turn them off to prevent visitors from hanging my server) - republished templates still show pages, where comments are disabled. the same happens with each new blog I create.

someone, please help...
now I really don't know what to do... I'm not new with linux, etc., but I'm new with movable...

ok, this is also solved.

i've forgotten to enable anonymous comments

thnx everyone, who had read this entries and thought whether he could help me or no

Try this,

If you have enabled E-mail Notification(under Comment Settings), Disable it. And try posting now ..