mysql 4 & EE Backup

[seanspeng]

I have just upgraded my database to version 4. And after the upgrade, I got the following error when run EE backup:


lock ee_backup WRITE: Access denied for user: 'myusername@localhost' to database 'mydatabasename' lock ....

This same message repeats itself for pages. But by looking at the resulted backup file size, it looks like it is still backed up.

Pekka, any idea what caused this and how to fix it?

Thank you very much!!!

Sean

[Pekka]

Please see http://photography-on-the.net/forum/showthread.php?t=24311&highlight=mysql+lock

[seanspeng]

Sorry, I should've run a search on it. Yes, granting the Global Lock solved the problem.

Thanks!

[Pekka]

While you're with MySQL 4, don't forget to activate query cache - it makes a big difference - list page query takes about 2ms with cache on. Also reduces server load.

query-cache-size = 10M
query-cache-type = 1

[seanspeng]

That is the main reason that I upgrade to version 4. I will double check them as you suggested.

Thanks, Pekka!