Moving images causing server overload
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?