PDA

View Full Version : 1.5 RC4: mySQL deadlock


schwanm
26th of May 2004 (Wed), 09:33
After I've done a fresh install of EE1.5RC4 and uploaded only 2 pictures.
I'm getting a deadlock in mySQL:


Kill 668440 web41 localhost usr_web41_3 Query 72 statistics SELECT ee_photo.ee_photo_id, ee_photo_eng.ee_photo_header, ee_photo.ee_photo_exif_datetime, ee_len

Kill 668450 web41 localhost usr_web41_3 Query 57 Locked UPDATE ee_counter SET ee_counter_value = ee_counter_value +1 WHERE ee_counter.ee_count

(I'm able to open the gallery mainpage but if I click on a thumb I get nothing but a proxy timeout.)

I tried an optimazation of the database already. But without success! :cry:

Any ideas!? :idea:

Thank you in advance!

Pekka
26th of May 2004 (Wed), 12:51
You will need at least 7 photos in database to gain full speed. Getting very slow performance or even timeout with 2 photo system is normal.

schwanm
27th of May 2004 (Thu), 07:45
Thank you! You were right! :P

Superb Gallery!!!! 8)