| List: | Commits | « Previous MessageNext Message » | |
| From: | paul.dubois | Date: | October 17 2008 8:34pm |
| Subject: | svn commit - mysqldoc@docsrva: r12088 - in trunk: . dynamic-docs/changelog refman-5.1 refman-6.0 | ||
| View as plain text | |||
Author: paul Date: 2008-10-17 20:34:19 +0200 (Fri, 17 Oct 2008) New Revision: 12088 Log: r34822@dhcp-100: paul | 2008-10-17 13:27:32 -0500 Add versions to changelog entries Modified: trunk/dynamic-docs/changelog/mysqld-1.xml trunk/dynamic-docs/changelog/mysqld.xml trunk/refman-5.1/dba-core.xml trunk/refman-5.1/installing-core.xml trunk/refman-6.0/dba-core.xml trunk/refman-6.0/installing-core.xml Property changes on: trunk ___________________________________________________________________ Name: svk:merge - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34797 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33695 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34822 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33695 Modified: trunk/dynamic-docs/changelog/mysqld-1.xml =================================================================== --- trunk/dynamic-docs/changelog/mysqld-1.xml 2008-10-17 16:08:37 UTC (rev 12087) +++ trunk/dynamic-docs/changelog/mysqld-1.xml 2008-10-17 18:34:19 UTC (rev 12088) Changed blocks: 39, Lines Added: 113, Lines Deleted: 2; 7710 bytes @@ -469,6 +469,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -28979,6 +28980,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29005,6 +29007,7 @@ <versions> <version ver="5.0.70"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29035,6 +29038,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29062,6 +29066,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29115,6 +29120,7 @@ <versions> <version ver="5.0.70"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29141,6 +29147,7 @@ <versions> <version ver="5.0.70"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29170,6 +29177,7 @@ <versions> <version ver="5.0.70"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29814,6 +29822,7 @@ <versions> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29870,6 +29879,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29896,6 +29906,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29924,6 +29935,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29951,6 +29963,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -29980,6 +29993,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30007,6 +30021,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30036,6 +30051,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30062,6 +30078,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30088,6 +30105,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30113,6 +30131,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30139,6 +30158,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30165,6 +30185,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30192,6 +30213,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30220,6 +30242,7 @@ <versions> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30251,6 +30274,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30278,6 +30302,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30304,6 +30329,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30332,6 +30358,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30357,6 +30384,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30384,6 +30412,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30499,9 +30528,10 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> - <message> + <message ver="5.1.29"> <para> In connection with view creation, the server created @@ -30536,7 +30566,7 @@ <listitem> <para> - Downgrade to an older 5.1.X server and run + Downgrade to an older 5.1.x server and run <command>mysql_upgrade</command>. </para> </listitem> @@ -30575,6 +30605,80 @@ </message> + <message ver="6.0.8"> + + <para> + In connection with view creation, the server created + <filename>arc</filename> directories inside database directories + and maintained useless copies of <filename>.frm</filename> files + there. Creation and renaming procedures of those copies as well + as creation of <filename>arc</filename> directories has been + discontinued. + </para> + + <para> + This change does cause a problem when downgrading to older + server versions which manifests itself under these + circumstances: + </para> + + <orderedlist> + + <listitem> + <para> + Create a view <literal>v_orig</literal> in MySQL 6.0.8 or + higher. + </para> + </listitem> + + <listitem> + <para> + Rename the view to <literal>v_new</literal> and then back to + <literal>v_orig</literal>. + </para> + </listitem> + + <listitem> + <para> + Downgrade to an older 6.0.x server and run + <command>mysql_upgrade</command>. + </para> + </listitem> + + <listitem> + <para> + Try to rename <literal>v_orig</literal> to + <literal>v_new</literal> again. This operation fails. + </para> + </listitem> + + </orderedlist> + + <para> + As a workaround to avoid this problem, use either of these + approaches: + </para> + + <itemizedlist> + + <listitem> + <para> + Dump your data using <command>mysqldump</command> before + downgrading and reload the dump file after downgrading. + </para> + </listitem> + + <listitem> + <para> + Instead of renaming a view after the downgrade, drop it and + recreate it. + </para> + </listitem> + + </itemizedlist> + + </message> + </logentry> <logentry entrytype="bug"> @@ -30593,6 +30697,7 @@ <versions> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30622,6 +30727,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30650,6 +30756,7 @@ <versions> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30675,6 +30782,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30729,6 +30837,7 @@ <versions> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30754,6 +30863,7 @@ <versions> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> @@ -30817,6 +30927,7 @@ <versions> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> Modified: trunk/dynamic-docs/changelog/mysqld.xml =================================================================== --- trunk/dynamic-docs/changelog/mysqld.xml 2008-10-17 16:08:37 UTC (rev 12087) +++ trunk/dynamic-docs/changelog/mysqld.xml 2008-10-17 18:34:19 UTC (rev 12088) Changed blocks: 1, Lines Added: 1, Lines Deleted: 0; 447 bytes @@ -39798,6 +39798,7 @@ <version ver="4.1.13"/> <version ver="5.0.72"/> <version ver="5.1.29"/> + <version ver="6.0.8"/> </versions> <message> Modified: trunk/refman-5.1/dba-core.xml =================================================================== --- trunk/refman-5.1/dba-core.xml 2008-10-17 16:08:37 UTC (rev 12087) +++ trunk/refman-5.1/dba-core.xml 2008-10-17 18:34:19 UTC (rev 12088) Changed blocks: 4, Lines Added: 12, Lines Deleted: 9; 2609 bytes @@ -458,8 +458,9 @@ <para> Specify whether to use row-based, statement-based, or mixed replication (statement-based was the default prior to MySQL - 5.1.12; beginning with MySQL 5.1.12, mixed replication is - the default). See <xref linkend="replication-formats"/>. + 5.1.12; in 5.1.12, the default was changed to mixed + replication; in 5.1.29, the default was changed back to + statement-based). See <xref linkend="replication-formats"/>. This option was added in MySQL 5.1.5. </para> </listitem> @@ -3966,8 +3967,9 @@ <para> <literal>STATEMENT</literal> was used by default prior to - MySQL 5.1.12; beginning with MySQL 5.1.12, - <literal>MIXED</literal> is the default. When + MySQL 5.1.12; in 5.1.12, the default was changed to mixed + <literal>MIXED</literal>; in 5.1.29, the default was changed + back to <literal>STATEMENT</literal>. When <literal>MIXED</literal> is specified, statement-based replication is used, except for cases where only row-based replication is guaranteed to lead to proper results. For @@ -13948,9 +13950,10 @@ </para> <para> - Mixed logging is available beginning with MySQL 5.1.8. - Beginning with MySQL 5.1.12, it is the default logging - mode. + Mixed logging is available beginning with MySQL 5.1.8. In + MySQL 5.1.12, it become the default logging mode; in + 5.1.29, the default was changed back to + <literal>STATEMENT</literal>. </para> <para> @@ -14015,14 +14018,14 @@ <para> <literal>STATEMENT</literal> causes replication to be statement-based. This is the default for MySQL 5.1.11 - and earlier. + and earlier, and MySQL 5.1.29 and later. </para> </listitem> <listitem> <para> <literal>MIXED</literal> causes replication to use mixed - format. This is the default for MySQL 5.1.12 and later. + format. This is the default for MySQL 5.1.12 to 5.1.28. </para> </listitem> Modified: trunk/refman-5.1/installing-core.xml =================================================================== --- trunk/refman-5.1/installing-core.xml 2008-10-17 16:08:37 UTC (rev 12087) +++ trunk/refman-5.1/installing-core.xml 2008-10-17 18:34:19 UTC (rev 12088) Changed blocks: 1, Lines Added: 1, Lines Deleted: 1; 547 bytes @@ -12772,7 +12772,7 @@ <listitem> <para> - Downgrade to an older 5.1.X server and run + Downgrade to an older 5.1.x server and run <command>mysql_upgrade</command>. </para> </listitem> Modified: trunk/refman-6.0/dba-core.xml =================================================================== --- trunk/refman-6.0/dba-core.xml 2008-10-17 16:08:37 UTC (rev 12087) +++ trunk/refman-6.0/dba-core.xml 2008-10-17 18:34:19 UTC (rev 12088) Changed blocks: 3, Lines Added: 6, Lines Deleted: 3; 1367 bytes @@ -486,7 +486,8 @@ <para> Specify whether to use row-based, statement-based, or mixed - replication (mixed is the default). See + replication (mixed is the default before MySQL 6.0.8 and + statement-based as of 6.0.8). See <xref linkend="replication-formats"/>. </para> </listitem> @@ -3938,7 +3939,8 @@ </para> <para> - <literal>MIXED</literal> is used by default. If + <literal>MIXED</literal> is used by default. before MySQL + 6.0.8 and <literal>STATEMENT</literal> as of 6.0.8. If <literal>MIXED</literal> is specified, statement-based replication is used, too, except for cases where only row-based replication is guaranteed to lead to proper @@ -13850,7 +13852,8 @@ <title>Setting The Binary Log Format</title> <para> - The default binary logging format is mixed-based. + The default binary logging format is mixed-based before MySQL + 6.0.8 and statement-based as of 6.0.8. </para> <para> Modified: trunk/refman-6.0/installing-core.xml =================================================================== --- trunk/refman-6.0/installing-core.xml 2008-10-17 16:08:37 UTC (rev 12087) +++ trunk/refman-6.0/installing-core.xml 2008-10-17 18:34:19 UTC (rev 12088) Changed blocks: 1, Lines Added: 73, Lines Deleted: 0; 2708 bytes @@ -12703,6 +12703,79 @@ <listitem> <para> + In connection with view creation, the server created + <filename>arc</filename> directories inside database + directories and maintained useless copies of + <filename>.frm</filename> files there. Creation and renaming + procedures of those copies as well as creation of + <filename>arc</filename> directories has been discontinued + in MySQL 6.0.8. + </para> + + <para> + This change does cause a problem when downgrading to older + server versions which manifests itself under these + circumstances: + </para> + + <orderedlist> + + <listitem> + <para> + Create a view <literal>v_orig</literal> in MySQL 6.0.8 + or higher. + </para> + </listitem> + + <listitem> + <para> + Rename the view to <literal>v_new</literal> and then + back to <literal>v_orig</literal>. + </para> + </listitem> + + <listitem> + <para> + Downgrade to an older 6.0.x server and run + <command>mysql_upgrade</command>. + </para> + </listitem> + + <listitem> + <para> + Try to rename <literal>v_orig</literal> to + <literal>v_new</literal> again. This operation fails. + </para> + </listitem> + + </orderedlist> + + <para> + As a workaround to avoid this problem, use either of these + approaches: + </para> + + <itemizedlist> + + <listitem> + <para> + Dump your data using <command>mysqldump</command> before + downgrading and reload the dump file after downgrading. + </para> + </listitem> + + <listitem> + <para> + Instead of renaming a view after the downgrade, drop it + and recreate it. + </para> + </listitem> + + </itemizedlist> + </listitem> + + <listitem> + <para> <emphasis role="bold">Incompatible change</emphasis>: In MySQL 6.0.6, a change was made to the way that the server handles prepared statements. This affects prepared
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r12088 - in trunk: . dynamic-docs/changelog refman-5.1 refman-6.0 | paul.dubois | 17 Oct |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.459 sec. using MySQL 5.1.14-beta-log