[Imc-web] Re: [Imc-(tech|web)] Dada upgrade
Daniel S. Lewart
lewart at uiuc.edu
Sat Jan 3 23:19:49 CST 2004
Clint,
> Ok, it's done. I didn't end up having to do the database piecemeal,
> because I found a workaround to mysql's braindead index-updating
> algorithm.(*)
Excellent!!!
> www.ucimc.org is /var/www/ucimc with database ucimc, version .98.1
> old.ucimc.org is /var/www/old-ucimc with database ucimc-dada, version .94
> I have made no modifications to the site code, and I discourage it
> immensely, given my experience updating the site this time. The
> newest code has a pretty sophisticated stylesheet structure, and if
> you can't do what you want with that, then you need to do diffs and
> submit them to dada's maintainer, IMHO.
Sounds perfectly reasonable.
> (*) The trick was to delete the non-primary indices on the articles
> table before letting the various update.php scripts do their UPDATE
> statements, and then recreate them afterwards. Otherwise MYSQL
> updates EACH INDEX after EACH ROW. Ugh. And there is no way (in our
> version of mysql) to turn this off, AFAICT. It's so bad that even
> "delete from X where Y" will be O(N^2).
Perhaps the update.php scripts should drop and add indexes?
Imsahp appears to have a mixture of MySQL 3.23.49-8.5 and 3.23.51-1woody.
I figure you would have liked the following MySQL 4.0.0 commands:
ALTER TABLE ... DISABLE KEYS
ALTER TABLE ... ENABLE KEYS
Should we ask Zach about installing mysql-nonfree 4.0.17?
Thanks!
Dan
More information about the IMC-Web
mailing list