Author: paul
Date: 2008-06-04 15:24:05 +0200 (Wed, 04 Jun 2008)
New Revision: 10889
Log:
r31846@frost: paul | 2008-06-04 15:24:10 +0200
More UUID_SHORT() information
Modified:
trunk/it/refman-5.1/functions-core.xml
trunk/it/refman-5.1/replication-configuration.xml
trunk/pt/refman-5.1/functions-core.xml
trunk/pt/refman-5.1/replication-configuration.xml
trunk/refman-5.1/functions-core.xml
trunk/refman-5.1/replication-configuration.xml
trunk/refman-6.0/functions-core.xml
trunk/refman-6.0/replication-configuration.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:31845
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31539
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:31846
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31539
Modified: trunk/it/refman-5.1/functions-core.xml
===================================================================
--- trunk/it/refman-5.1/functions-core.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/it/refman-5.1/functions-core.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 2, Lines Added: 50, Lines Deleted: 1; 2606 bytes
@@ -10992,7 +10992,7 @@
-> <userinput>('MySQL Tutorial','DBMS stands for DataBase ...'),</userinput>
-> <userinput>('How To Use MySQL Well','After you went through a ...'),</userinput>
-> <userinput>('Optimizing MySQL','In this tutorial we will show ...'),</userinput>
- -> <userinput>('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),</userinput>
+ -> <userinput>('1001 MySQL Tricks','1. Never run ysqld as root. 2. ...'),</userinput>
-> <userinput>('MySQL vs. YourSQL','In the following database comparison ...'),</userinput>
-> <userinput>('MySQL Security','When configured properly, MySQL ...');</userinput>
Query OK, 6 rows affected (0.00 sec)
@@ -17425,6 +17425,55 @@
<function role="sql">UUID()</function> function).
</para>
+ <para>
+ The value of <function role="sql">UUID_SHORT()</function> is
+ guaranteed to be unique if the following conditions hold:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>server_id</literal> of the current host is
+ unique among your set of master and slave servers
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>server_id</literal> is between 0 and 255
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You don't set back your system time for your server
+ between <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You do not invoke
+ <function role="sql">UUID_SHORT()</function> on average
+ more than 16 million times per second between
+ <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The <function role="sql">UUID_SHORT()</function> return
+ value is constructed this way:
+ </para>
+
+<programlisting>
+ (server_id & 255) << 56
++ (server_startup_time_in_seconds << 24)
++ incremented_variable++;
+</programlisting>
+
<remark role="help-description-end"/>
<remark role="help-example"/>
Modified: trunk/it/refman-5.1/replication-configuration.xml
===================================================================
--- trunk/it/refman-5.1/replication-configuration.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/it/refman-5.1/replication-configuration.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 589 bytes
@@ -1562,7 +1562,8 @@
<listitem>
<para>
- <function role="sql">UUID()</function>
+ <function role="sql">UUID()</function>,
+ <function role="sql">UUID_SHORT()</function>
</para>
</listitem>
Modified: trunk/pt/refman-5.1/functions-core.xml
===================================================================
--- trunk/pt/refman-5.1/functions-core.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/pt/refman-5.1/functions-core.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 2, Lines Added: 50, Lines Deleted: 1; 2606 bytes
@@ -10992,7 +10992,7 @@
-> <userinput>('MySQL Tutorial','DBMS stands for DataBase ...'),</userinput>
-> <userinput>('How To Use MySQL Well','After you went through a ...'),</userinput>
-> <userinput>('Optimizing MySQL','In this tutorial we will show ...'),</userinput>
- -> <userinput>('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),</userinput>
+ -> <userinput>('1001 MySQL Tricks','1. Never run ysqld as root. 2. ...'),</userinput>
-> <userinput>('MySQL vs. YourSQL','In the following database comparison ...'),</userinput>
-> <userinput>('MySQL Security','When configured properly, MySQL ...');</userinput>
Query OK, 6 rows affected (0.00 sec)
@@ -17425,6 +17425,55 @@
<function role="sql">UUID()</function> function).
</para>
+ <para>
+ The value of <function role="sql">UUID_SHORT()</function> is
+ guaranteed to be unique if the following conditions hold:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>server_id</literal> of the current host is
+ unique among your set of master and slave servers
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>server_id</literal> is between 0 and 255
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You don't set back your system time for your server
+ between <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You do not invoke
+ <function role="sql">UUID_SHORT()</function> on average
+ more than 16 million times per second between
+ <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The <function role="sql">UUID_SHORT()</function> return
+ value is constructed this way:
+ </para>
+
+<programlisting>
+ (server_id & 255) << 56
++ (server_startup_time_in_seconds << 24)
++ incremented_variable++;
+</programlisting>
+
<remark role="help-description-end"/>
<remark role="help-example"/>
Modified: trunk/pt/refman-5.1/replication-configuration.xml
===================================================================
--- trunk/pt/refman-5.1/replication-configuration.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/pt/refman-5.1/replication-configuration.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 589 bytes
@@ -1562,7 +1562,8 @@
<listitem>
<para>
- <function role="sql">UUID()</function>
+ <function role="sql">UUID()</function>,
+ <function role="sql">UUID_SHORT()</function>
</para>
</listitem>
Modified: trunk/refman-5.1/functions-core.xml
===================================================================
--- trunk/refman-5.1/functions-core.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/refman-5.1/functions-core.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 2, Lines Added: 50, Lines Deleted: 1; 2597 bytes
@@ -10992,7 +10992,7 @@
-> <userinput>('MySQL Tutorial','DBMS stands for DataBase ...'),</userinput>
-> <userinput>('How To Use MySQL Well','After you went through a ...'),</userinput>
-> <userinput>('Optimizing MySQL','In this tutorial we will show ...'),</userinput>
- -> <userinput>('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),</userinput>
+ -> <userinput>('1001 MySQL Tricks','1. Never run ysqld as root. 2. ...'),</userinput>
-> <userinput>('MySQL vs. YourSQL','In the following database comparison ...'),</userinput>
-> <userinput>('MySQL Security','When configured properly, MySQL ...');</userinput>
Query OK, 6 rows affected (0.00 sec)
@@ -17425,6 +17425,55 @@
<function role="sql">UUID()</function> function).
</para>
+ <para>
+ The value of <function role="sql">UUID_SHORT()</function> is
+ guaranteed to be unique if the following conditions hold:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>server_id</literal> of the current host is
+ unique among your set of master and slave servers
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>server_id</literal> is between 0 and 255
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You don't set back your system time for your server
+ between <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You do not invoke
+ <function role="sql">UUID_SHORT()</function> on average
+ more than 16 million times per second between
+ <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The <function role="sql">UUID_SHORT()</function> return
+ value is constructed this way:
+ </para>
+
+<programlisting>
+ (server_id & 255) << 56
++ (server_startup_time_in_seconds << 24)
++ incremented_variable++;
+</programlisting>
+
<remark role="help-description-end"/>
<remark role="help-example"/>
Modified: trunk/refman-5.1/replication-configuration.xml
===================================================================
--- trunk/refman-5.1/replication-configuration.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/refman-5.1/replication-configuration.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 580 bytes
@@ -1562,7 +1562,8 @@
<listitem>
<para>
- <function role="sql">UUID()</function>
+ <function role="sql">UUID()</function>,
+ <function role="sql">UUID_SHORT()</function>
</para>
</listitem>
Modified: trunk/refman-6.0/functions-core.xml
===================================================================
--- trunk/refman-6.0/functions-core.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/refman-6.0/functions-core.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 2, Lines Added: 50, Lines Deleted: 1; 2597 bytes
@@ -11410,7 +11410,7 @@
-> <userinput>('MySQL Tutorial','DBMS stands for DataBase ...'),</userinput>
-> <userinput>('How To Use MySQL Well','After you went through a ...'),</userinput>
-> <userinput>('Optimizing MySQL','In this tutorial we will show ...'),</userinput>
- -> <userinput>('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),</userinput>
+ -> <userinput>('1001 MySQL Tricks','1. Never run ysqld as root. 2. ...'),</userinput>
-> <userinput>('MySQL vs. YourSQL','In the following database comparison ...'),</userinput>
-> <userinput>('MySQL Security','When configured properly, MySQL ...');</userinput>
Query OK, 6 rows affected (0.00 sec)
@@ -17864,6 +17864,55 @@
<function role="sql">UUID()</function> function).
</para>
+ <para>
+ The value of <function role="sql">UUID_SHORT()</function> is
+ guaranteed to be unique if the following conditions hold:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The <literal>server_id</literal> of the current host is
+ unique among your set of master and slave servers
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>server_id</literal> is between 0 and 255
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You don't set back your system time for your server
+ between <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ You do not invoke
+ <function role="sql">UUID_SHORT()</function> on average
+ more than 16 million times per second between
+ <command>mysqld</command> restarts
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <para>
+ The <function role="sql">UUID_SHORT()</function> return
+ value is constructed this way:
+ </para>
+
+<programlisting>
+ (server_id & 255) << 56
++ (server_startup_time_in_seconds << 24)
++ incremented_variable++;
+</programlisting>
+
<remark role="help-description-end"/>
<remark role="help-example"/>
Modified: trunk/refman-6.0/replication-configuration.xml
===================================================================
--- trunk/refman-6.0/replication-configuration.xml 2008-06-04 13:24:01 UTC (rev 10888)
+++ trunk/refman-6.0/replication-configuration.xml 2008-06-04 13:24:05 UTC (rev 10889)
Changed blocks: 1, Lines Added: 2, Lines Deleted: 1; 580 bytes
@@ -1554,7 +1554,8 @@
<listitem>
<para>
- <function role="sql">UUID()</function>
+ <function role="sql">UUID()</function>,
+ <function role="sql">UUID_SHORT()</function>
</para>
</listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10889 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-5.1 refman-6.0 | paul | 4 Jun |
