[Bug 539243] New: MySQL changes
http://bugzilla.novell.com/show_bug.cgi?id=539243 Summary: MySQL changes Classification: openSUSE Product: openSUSE 11.2 Version: Milestone 7 Platform: Other OS/Version: All Status: NEW Severity: Normal Priority: P5 - None Component: Release Notes AssignedTo: ke@novell.com ReportedBy: suse-beta@cboltz.de QAContact: coolo@novell.com CC: mhrusecky@novell.com Found By: Beta-Customer Bug 539148 pointed out one of several important changes in MySQL. Basically the whole file /usr/share/doc/packages/mysql/README.SuSE should be copied to the release notes. I'll paste it here for reference and include some comments with recommended text changes marked with ### Note: Even if Michal adds a %post script to remove skip-federated, I'd keep the paragraph about it in the release notes. Notes about MySQL 5.1 package: ============================== With MySQL 5.1 package we introduced some changes you may like to know. Most of them will affect you only if you are upgrading from previous version and you did some changes to your configuration, but I'll try to explain most notable changes. ### ", but I'll [...] notable changes" should be deleted 1) Plugins: =========== One of the new features in MySQL 5.1 is support for plugins. So some of the storage engines are now shipped like that. You can use following plugins: - archive - blackhole - federated - example ### "As you see," should be seleted As you see, InnoDB is still compiled as internal part of MySQL. If you are upgrading from version 5.0 or if this is your first installation of MySQL 5.1, all plugins will be enabled by default and you can disable them manually later (see http://dev.mysql.com/doc/refman/5.1/en/uninstall-plugin.html). With this change you need to remove skip-federated option from your my.cnf file if you have changed it manually. This option was there by default in previous versions of MySQL. 2) File locations: ================== There were some changes in files locations. Most of them was made in default ### _were_ made in _the_ configuration file so if you are experiencing problems and you have made some manual adjustments to your /etc/my.cnf, try to merge this file with /etc/my.cnf.rpmnew. First of them is that MySQL socket file and pid file were moved from /var/lib/mysql to more reasonable location ( /var/run/mysql ) by default. Second change is that MySQL log files are in /var/log/mysql. ### make this paragraph a bullet list: ### - MySQL socket file and pid file were moved from /var/lib/mysql to more ### reasonable location ( /var/run/mysql ) by default ### - MySQL log files are in /var/log/mysql 3) BerkeleyDB: ============== Other important change is that MySQL no longer contains BerkeleyDB as storage ### Remove "Other important change is that" engine. There is no fix for that and if you used it before, you have to migrate your data to different storage engine BEFORE updating. This can be done for example using following command: ALTER TABLE foo ENGINE = INNODB; 4) MySQL Upgrade Log ==================== Last thing you may find useful is that if you missed messages displayed during ### Delete "Last thing ... useful is that" automatic MySQL database upgrade, you can find them from now on in /var/log/mysql/mysql_upgrade.log -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=539243
User mhrusecky@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c1
--- Comment #1 from Michal Hrusecky
http://bugzilla.novell.com/show_bug.cgi?id=539243
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c2
--- Comment #2 from Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c3
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c4
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User suse-beta@cboltz.de added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c5
Christian Boltz
http://bugzilla.novell.com/show_bug.cgi?id=539243
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c6
--- Comment #6 from Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c7
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User support@microtechniques.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c8
Don Hughes
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c9
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
Karl Eichwalder
http://bugzilla.novell.com/show_bug.cgi?id=539243
User mhrusecky@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c10
--- Comment #10 from Michal Hrusecky
http://bugzilla.novell.com/show_bug.cgi?id=539243
User ke@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=539243#c11
Karl Eichwalder
Well there are also other changes in behavior, I added link to the official upgrade documentation which lists possible incompatibilities to the mentioned wiki page.
In this case it is probably better to avoid adding more entries. 3 entries are enough and the users will continue reading the online info. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=539243
http://bugzilla.novell.com/show_bug.cgi?id=539243#c12
--- Comment #12 from Bernhard Wiedemann
participants (1)
-
bugzilla_noreply@novell.com