Moving images causing server overload

[tintin74]

Hello,

I've imported my smartor gallery into Vbgallery. After several hours of hard work (the gallery has 12.000 photos) , now I've solve most of the problems but one big problem is still there.

When a user (admin, mod or simple user) move an image from a category to another, it take 30-45 seconds to finish the process. I'm running a dual xeon dedicated server with 2 gb of ram.

If I get into a shell, using the command "top", I see mysql running and "eat" 70% of cpu during this process. When the moving process finish, mysql come back to 4% - 6%.

I'va made a test:

Moving at the same time 2 images, mysql goes to 140% cpu , and all my board begin unreachable : the server is overloaded.
So, if 2 users decided to move 2 images at the same time, probably , this action block my server.

I'm not an mysql expert, but I think could be something wrong in the database index, ut I don't know how rebuild these index.

Any idea about this issue?

Thank you

[Zachariah]

Investigating

[tintin74]

This evening the board was very slow, someone on the gallery was moving some images.

Now, I've removed the file "editimage.php" the risk is too high.

This is a big problem for my site.

Zachariah, have you got any news, please?

Thank you

Tintin

[Zachariah]

Theres a few things we can do, got a sec hit me on IM.
- look @ PM's