I am having an issue that when images are imported the site hangs and even locks up.

I am importing 300 images using imagefield_import and assigning a taxonomy term during upload. The site currently has about 60,000 images. During import the site becomes unresponsive and even hangs after the images have been imported. The images appear to import fine. The site is a photo gallery built with views 3 and using AJAX for page requests.

My current setup is an xServe dedicated to the site with 128MB assigned to PHP. The site functions fine but immediately hangs when the image import process starts.

Is there something I can set in my configuration that can make the import process be less resource intensive during imports?

Comments

vordude’s picture

vordude commented
Status: Active » Closed (works as designed)

I've seen this issue, so firstly, here's confirmation that you're not crazy.

I had no real confirmation, but my educated guess was there were tables that were being locked during the import process. Regardless, I did track it down to an issue with the database.

In an effort to fix this problem and others with my site, I changed all of my tables to InnoDB (with big enough buffer pool, and log files) from MyISAM and seem to be avoiding issues.

The DB tuner module can help with database configuration tweaks. http://drupal.org/project/dbtuner

As always, please make a good backup before you go futzing with settings.

hedac’s picture

hedac commented

maybe it would be considerable to do the import at cron runs.. by steps of x images each time...