Author: jstephens
Date: 2006-10-20 18:25:43 +0200 (Fri, 20 Oct 2006)
New Revision: 3691
Log:
Finished marking up and correcting worst errors.
Modified:
trunk/refman-5.0/old-faq.xml
Modified: trunk/refman-5.0/old-faq.xml
===================================================================
--- trunk/refman-5.0/old-faq.xml 2006-10-20 16:13:31 UTC (rev 3690)
+++ trunk/refman-5.0/old-faq.xml 2006-10-20 16:25:43 UTC (rev 3691)
Changed blocks: 29, Lines Added: 270, Lines Deleted: 179; 24772 bytes
@@ -13,122 +13,6 @@
<title>MySQL ¤t-series; Technical FAQ</title>
-<programlisting>
-MySQL ¤t-series; - Technical FAQ
-Last updated September 9, 2005
-
- General
- * When did MySQL ¤t-series; become Production/GA?
- * Can MySQL ¤t-series; do subqueries?
- * Can MySQL ¤t-series; do multi-table inserts and updates?
- * Does MySQL ¤t-series; have a Query Cache? Does it work on Server, Instance or Database?
- * Does MySQL ¤t-series; have Sequences?
- * Does MySQL ¤t-series; have a NOW() with fractions of seconds?
- * Does MySQL ¤t-series; work with Dual Core Opterons?
- * Is there a "MyISAM Hot-Backup" like the "InnoDB Hot-Backup".?
- * Is there any improvement in error reporting when Foreign Key fails (i.e. currently does not report which column and reference failed)?
- * Can MySQL ¤t-series; do ACID Transactions?
-
- Storage Engines
- * What are the new Storage Engines in MySQL ¤t-series;?
- * What are the unique benefits of the ARCHIVE Storage Engine?
- * Do the new features in MySQL ¤t-series; apply to all the Storage Engines?
-
- Server SQL Mode
- * What is "Server SQL Mode"?
- * How many modes are there in "Server SQL Mode"?
- * How do you configure "Server SQL Mode"?
- * Is the mode dependent on the Database or the Connection?
- * Can "Strict Mode" rules be extended?
- * Does "Strict Mode" impact performance?
- * What is the default mode when MySQL ¤t-series; is installed?
-
- Stored Procedures
- * Where can I find documentation for MySQL Stored Procedures?
- * Where is the discussion forum for MySQL Stored Procedures?
- * Where can I find the ANSI SQL 2003 specification for Stored Procedures?
- * How do you manage Stored Procedures?
- * Is there a way to view all Stored Procedures in a database?
- * Where are Stored Procedures stored?
- * Is it possible to group SPs into a package (e.g. like Oracle)?
- * Can a SP call another SP?
- * Can a SP call a Trigger?
- * Can SPs access a single Table? Multiple Tables?
- * Do SPs have a "raise" statement to "raise application errors"?
- * Do SPs have Exception Handling?
- * Can SPs return result sets (as do MS SQL and Sybase)?
- * Can I do a "WITH RECOMPILE" for SPs?
- * Oracle uses mod_plsql as a gateway on Apache to talk directly to a SP in the database. What is the MySQL equivalent?
- * Can I pass an array as input to a SP?
- * Can I pass a cursor as an IN parameter to a SP?
- * Can I return a cursor as an OUT parameter from a SP?
- * Can I print out a variable value in a SP for debugging?
- * Can I do a Transaction inside a SP (i.e. committing or rolling back a set of SQL statements in a batch)?
-
- Triggers
- * Where can I find documentation for MySQL Triggers?
- * Where is the discussion forum for MySQL Triggers?
- * Do you have Statement-level Triggers or Row-level Triggers?
- * Are there any default Triggers?
- * How do you manage Triggers?
- * Is there a way to view all Triggers in a Database?
- * Where are Triggers stored?
- * Can a Trigger call a Stored Procedure?
- * Can Triggers access a single Table? Multiple Tables?
- * Can Triggers call an external application (through a UDF)?
- * Is there an example of a Trigger updating Tables on remote servers?
-
- Views
- * Where can I find documentation for MySQL Views?
- * Where is the discussion forum for MySQL Views?
- * What happens if an underlying Table is dropped, renamed, etc.?
- * Does MySQL ¤t-series; have Table Snapshots?
- * Does MySQL ¤t-series; have Materialized Views?
- * Can you insert into Views based on Joins?
- * Can updating a View affect multiple tables or single table?
-
- INFORMATION_SCHEMA
- * Where can I find documentation for MySQL INFORMATION_SCHEMA?
- * Where is the discussion forum for MySQL INFORMATION_SCHEMA?
- * Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA?
- * What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA?
- * Can I organize groups of Tables in MySQL (e.g. PostgreSQL does this with SCHEMA)?
- * Can I add or modify the Tables in the INFORMATION_SCHEMA?
-
- Connectors
- * Does MySQL Connector/J work with the new features in MySQL ¤t-series;?
- * Does MySQL Connector/NET work with the new features in MySQL ¤t-series;?
- * Does MySQL Connector/ODBC work with the new features in MySQL ¤t-series;?
- * Does DBD::MySQL (the Perl MySQL driver) work with the new features in MySQL ¤t-series;?
- * Do the mysql and mysqli extensions (the PHP MySQL APIs) work with the new features in MySQL ¤t-series;?
-
- Tools
- * Can Instance Manager enable management of remote MySQL servers?
- * Can you run Instance Manager on a Windows machine to manage MySQL on remote Linux machines?
- * Are GUI (Graphical User Interface) Tools available on Linux?
- * Can MySQL Administrator work with the new features in MySQL ¤t-series;?
- * Can MySQL Query Browser work with the new features in MySQL ¤t-series;?
- * Can you use MySQL GUI Tools to build Stored Procedures and Views?
- * When will Backup/Restore and mysqldump work with SPs?
- * When will mysqldump actually dump the definitions of SPs, Triggers, and Functions?
-
- Cluster
- * Does MySQL ¤t-series; work with MySQL Cluster?
- * Does MySQL ¤t-series; provide any new features/capabilities for MySQL Cluster?
- * Does MySQL ¤t-series; include a disk-based MySQL Cluster?
-
- Migration
- * How do you migrate from MySQL 4.x to 5.0?
- * Have the Table Types changed from MySQL 4.x to 5.0?
-
- Security
- * Does MySQL ¤t-series; have native support for SSL?
- * Will the SSL Support be built into the MySQL Binaries or will it require a recompile?
- * Does MySQL ¤t-series; have built-in Authentication against LDAP directories?
- * Does MySQL ¤t-series; have built-in Roles Based Access Control (RBAC)?
-
- </programlisting>
-
<section id="faqs-general">
<title>MySQL ¤t-series; FAQ — General</title>
@@ -140,7 +24,8 @@
<question>
<para>
- When did MySQL ¤t-series; become Production/GA?
+ When did MySQL ¤t-series; become production-ready
+ (GA)?
</para>
</question>
@@ -148,9 +33,9 @@
<answer>
<para>
- MySQL ¤t-series; a Production release on 19th October
- 2005. We are now working on MySQL 5.1, which is in the beta
- stages.
+ MySQL 5.0.15 was released for production use on 19 October
+ 2005. We are now working on MySQL 5.1, which is currently in
+ beta.
</para>
</answer>
@@ -196,7 +81,7 @@
<literal>DELETE</literal> were actually implemented in MySQL
4.0, with enhancements added in MySQL 4.1. See
<xref
- linkend="update"/>, and
+ linkend="update"/>, and
<xref linkend="delete"/>.
</para>
@@ -209,8 +94,8 @@
<question>
<para>
- Does MySQL ¤t-series; have a Query Cache? Does it
- work on Server, Instance or Database?
+ Does MySQL ¤t-series; have a Query Cache? Does it work
+ on Server, Instance or Database?
</para>
</question>
@@ -260,8 +145,7 @@
</qandaentry>
- <qandaentry
- id="faqs-general-now-fractional-seconds">
+ <qandaentry id="faqs-general-now-fractional-seconds">
<question>
@@ -412,7 +296,8 @@
The <literal>FEDERATED</literal> storage engine, new in My
SQL ¤t-series;, allows the server to access tables in
other (remote) servers. See
- <xref linkend="federated-storage-engine"/>.
+ <xref
+ linkend="federated-storage-engine"/>.
</para>
<para>
@@ -442,7 +327,9 @@
MySQL 4.1, is ideally suited for storing large amounts of
data (without indexes) in a very small footprint, and
selects using table scans. See
- <xref linkend="archive-storage-engine"/>, for details.
+ <xref
+ linkend="archive-storage-engine"/>, for
+ details.
</para>
</answer>
@@ -504,7 +391,8 @@
and to use MySQL together with other database servers. The
MySQL Server apply these modes individually to different
clients. For more information, see
- <xref linkend="server-sql-mode"/>.
+ <xref
+ linkend="server-sql-mode"/>.
</para>
</answer>
@@ -654,8 +542,9 @@
<para>
By default, no special modes are enabled. See
<xref
- linkend="server-sql-mode"/>, for information
- about all available modes and the default behaviour.
+ linkend="server-sql-mode"/>, for
+ information about all available modes and the default
+ behaviour.
</para>
</answer>
@@ -728,7 +617,9 @@
<para>
Yes. See
- <ulink url="http://forums.mysql.com/list.php?98">http://forums.mysql.com/list.php?98</ulink>.
+ <ulink
+ url="http://forums.mysql.com/list.php?98"
+ >http://forums.mysql.com/list.php?98</ulink>.
</para>
</answer>
@@ -783,7 +674,8 @@
about existing stored procedures using the
<literal>ROUTINES</literal> table in the
<literal>INFORMATION_SCHEMA</literal> database (see
- <xref linkend="routines-table"/>).
+ <xref
+ linkend="routines-table"/>).
</para>
</answer>
@@ -816,7 +708,9 @@
</programlisting>
<para>
- For more information, see <xref linkend="routines-table"/>.
+ For more information, see
+ <xref
+ linkend="routines-table"/>.
</para>
<para>
@@ -824,8 +718,9 @@
<literal>SHOW CREATE FUNCTION</literal> (for a stored
function) or <literal>SHOW CREATE PROCEDURE</literal> (for a
stored procedure). See
- <xref linkend="show-create-procedure"/>, for more
- information.
+ <xref linkend="show-create-procedure"
+ />, for
+ more information.
</para>
</answer>
@@ -852,8 +747,9 @@
FUNCTION</literal> to obtain information about stored
functions, and <literal>SHOW CREATE PROCEDURE</literal> to
obtain information about stored procedures. See
- <xref linkend="show-create-procedure"/>, for more
- information about these statements.
+ <xref
+ linkend="show-create-procedure"/>, for
+ more information about these statements.
</para>
<para>
@@ -989,7 +885,8 @@
MySQL implements <literal>HANDLER</literal> definitions
according to the SQL standard. See
<xref
- linkend="declare-handlers"/>, for details.
+ linkend="declare-handlers"/>, for
+ details.
</para>
</answer>
@@ -1231,7 +1128,8 @@
<para>
Yes. It is available at
<ulink
- url="http://forums.mysql.com/list.php?99">http://forums.mysql.com/list.php?99</ulink>.
+ url="http://forums.mysql.com/list.php?99"
+ >http://forums.mysql.com/list.php?99</ulink>.
</para>
</answer>
@@ -1303,16 +1201,16 @@
<literal>CREATE TRIGGER</literal> statement, and dropped
using <literal>DROP TRIGGER</literal>. See
<xref
- linkend="create-trigger"/>, and
- <xref linkend="drop-trigger"/>, for more about these
- statements.
+ linkend="create-trigger"/>, and
+ <xref
+ linkend="drop-trigger"/>, for more about
+ these statements.
</para>
<para>
Information about triggers can be obtained by querying the
<literal>INFORMATION_SCHEMA.TRIGGERS</literal> table. See
- <xref
- linkend="triggers-table"/>.
+ <xref linkend="triggers-table"/>.
</para>
</answer>
@@ -1346,13 +1244,15 @@
<para>
For more information about this table, see
- <xref linkend="triggers-table"/>.
+ <xref
+ linkend="triggers-table"/>.
</para>
<para>
You can also use the <literal>SHOW TRIGGERS</literal>
statement, which is specific to MySQL. See
- <xref linkend="show-triggers"/>.
+ <xref
+ linkend="show-triggers"/>.
</para>
</answer>
@@ -1469,7 +1369,8 @@
<para>
Yes. A table on a remote server could be updated using the
<literal>FEDERATED</literal> storage engine. (See
- <xref linkend="federated-storage-engine"/>).
+ <xref
+ linkend="federated-storage-engine"/>).
</para>
</answer>
@@ -1499,8 +1400,7 @@
<answer>
<para>
- See <xref
- linkend="views"/>.
+ See <xref linkend="views"/>.
</para>
</answer>
@@ -1521,7 +1421,9 @@
<para>
Yes. See
- <ulink url="http://forums.mysql.com/list.php?100">http://forums.mysql.com/list.php?100</ulink>
+ <ulink
+ url="http://forums.mysql.com/list.php?100"
+ >http://forums.mysql.com/list.php?100</ulink>
</para>
</answer>
@@ -1546,7 +1448,8 @@
alter a table or view to which the definition refers. To
check a view definition for problems of this kind, use the
<literal>CHECK TABLE</literal> statement. (See
- <xref linkend="check-table"/>.)
+ <xref
+ linkend="check-table"/>.)
</para>
</answer>
@@ -1630,7 +1533,7 @@
<qandaset>
- <qandaentry>
+ <qandaentry id="faqs-information-schema-docs">
<question>
@@ -1651,7 +1554,7 @@
</qandaentry>
- <qandaentry>
+ <qandaentry id="faqs-information-schema-forum">
<question>
@@ -1666,14 +1569,15 @@
<para>
See
- <ulink url="http://forums.mysql.com/list.php?101">http://forums.mysql.com/list.php?101</ulink>.
+ <ulink url="http://forums.mysql.com/list.php?101"
+ >http://forums.mysql.com/list.php?101</ulink>.
</para>
</answer>
</qandaentry>
- <qandaentry>
+ <qandaentry id="faqs-information-schema-spec">
<question>
@@ -1700,7 +1604,7 @@
</qandaentry>
- <qandaentry>
+ <qandaentry id="faqs-information-schema-data-dictionary">
<question>
@@ -1726,7 +1630,7 @@
</qandaentry>
- <qandaentry>
+ <qandaentry id="faqs-information-schema-modify-tables">
<question>
@@ -1755,37 +1659,224 @@
</section>
- <section>
+ <section id="faqs-migration">
- <title></title>
+ <title>MySQL ¤t-series; FAQ — Migration</title>
-<programlisting>
+ <qandaset>
+ <qandaentry id="faqs-migration-docs">
-Migration
-MIG 1. How do you migrate from MySQL 4.x to 5.0?
- Detailed upgrade information for each version can be found at http://dev.mysql.com/doc/mysql/en/upgrade.html. We recommend that you do not skip a major version when upgrading, but rather upgrade in steps (for instance, if you are still using MySQL 4.0 but wish to upgrade to 5.0, upgrade your (test) system to 4.1 first, and verify that everything is as it should be. Then proceed with the 4.1 to 5.0 upgrade step). This may seem more complicated, but it will probably save you time and hassle - if you find any problems along the way, their origin will be easier to identify (either by you or MySQL support, if you have a MySQL Network subscription).
-MIG 2. Have the Table Types changed from MySQL 4.x to 5.0?
- Support for the old ISAM tables (used until MySQL 3.22) was removed in MySQL ¤t-series;. To convert a table from ISAM to MyISAM, simply issue a statement like ALTER TABLE tblname ENGINE=MYISAM.
+ <question>
- The "internal RAID" support in MyISAM tables was also removed. This was an old feature used to allow large tables with file systems that did not support large (>2GB) files. All modern file systems allow for larger tables, and there are also other solutions such as MERGE tables and VIEWs.
+ <para>
+ Where can I find information on how to migrate from MySQL
+ &previous-series; to MySQL ¤t-series;?
+ </para>
- The VARCHAR column type now retains any trailing spaces (all storage engines).
+ </question>
- MEMORY tables (called HEAP, prior to MySQL version 4.1) can now also contain VARCHAR columns.
-Security
-SEC 1. Does MySQL ¤t-series; have native support for SSL?
- Yes, most 5.0 binaries have support for SSL secured and/or authenticated connections between the client and server. We can't currently build with the new YaSSL library everywhere, as it's still quite new and does not compile on all platforms yet. See http://dev.mysql.com/doc/mysql/en/secure-connections.html
+ <answer>
- You could also tunnel the connection via SSH, for instance if the client application doesn't support SSL connections. For an example of this, see http://dev.mysql.com/doc/mysql/en/windows-and-ssh.html
-SEC 2. Will the SSL Support be built into the MySQL Binaries or will it require a recompile?
- Most 5.0 binaries have SSL enabled for secured and/or authenticated connections between the client and server. We can't currently build with the new YaSSL library everywhere, as it's still quite new and does not compile on all platforms yet. See http://dev.mysql.com/doc/mysql/en/secure-connections.html
-SEC 3. Does MySQL ¤t-series; have built-in Authentication against LDAP directories?
- No. Support for external authentication methods is on the MySQL roadmap as a "rolling feature". This means that it is not a flagship feature, but will be implemented, development time permitting. Specific customer demand may change this scheduling.
-SEC 4. Does MySQL ¤t-series; have built-in Roles Based Access Control (RBAC)?
- No. Roles are on the MySQL roadmap as a "rolling feature". This means that it is not a flagship feature, but will be implemented, development time permitting. Specific customer demand may change this scheduling.
-</programlisting>
+ <para>
+ For detailed upgrade information, see
+ <xref linkend="upgrade"/>. We recommend that you do not skip
+ a major version when upgrading, but rather complete the
+ process in steps, upgrading from one major version to the
+ next in each step. This may seem more complicated, but it
+ will you save time and trouble — if you encounter
+ problems during the upgrade, their origin will be easier to
+ identify, either by you or — if you have a MySQL
+ Network subscription — by MySQL support.
+ </para>
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry id="faqs-migration-storage-engines">
+
+ <question>
+
+ <para>
+ How has storage engine (table type) support changed in MySQL
+ ¤t-series; from previous versions?
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ Storage engine support has changed as follows:
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ Support for <literal>ISAM</literal> tables was removed
+ in MySQL 5.0 and you should now use the
+ <literal>MyISAM</literal> storage engine in place of
+ <literal>ISAM</literal>. To convert a table
+ <replaceable>tblname</replaceable> from
+ <literal>ISAM</literal> to <literal>MyISAM</literal>,
+ simply issue a statement such as this one:
+ </para>
+
+<programlisting>ALTER TABLE <replaceable>tblname</replaceable> ENGINE=MYISAM;</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ Internal <literal>RAID</literal> for
+ <literal>MyISAM</literal> tables was also removed in
+ MySQL 5.0. This was formerly used to allow large
+ tables in filesystems that did not support filesizes
+ greater than 2GB. All modern filesystems allow for
+ larger tables; in addition, there are now other
+ solutions such as <literal>MERGE</literal> tables and
+ views.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The <literal>VARCHAR</literal> column type now retains
+ trailing spaces in all storage engines.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <literal>MEMORY</literal> tables (formerly known as
+ <literal>HEAP</literal> tables) can also contain
+ <literal>VARCHAR</literal> columns.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ </qandaset>
+
</section>
+ <section id="faq-security">
+
+ <title>MySQL ¤t-series; FAQ - Security</title>
+
+ <qandaset>
+
+ <qandaentry id="faq-security-ssl-support">
+
+ <question>
+
+ <para>
+ Does MySQL ¤t-series; have native support for SSL?
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ Most ¤t-series; binaries have support for SSL
+ connections between the client and server. We can't
+ currently build with the new YaSSL library everywhere, as
+ it's still quite new and does not compile on all platforms
+ yet. See <xref linkend="secure-connections"/>.
+ </para>
+
+ <para>
+ You can also tunnel a connection via SSH, if (for instance)
+ if the client application doesn't support SSL connections.
+ For an example, see <xref linkend="windows-and-ssh"/>.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry id="faq-security-built-in-ssl">
+
+ <question>
+
+ <para>
+ Is SSL support be built into MySQL binaries, or must I
+ recompile the binary myself to enable it?
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ Most ¤t-series; binaries have SSL enabled for
+ client-server connections thsat are secured, authenticated,
+ or both. However, the YaSSL library currently does not
+ compile on all platforms. See
+ <xref linkend="secure-connections"/>, for a complete listing
+ of supported and unsupported platforms.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry id="faq-security-ldap">
+
+ <question>
+
+ <para>
+ Does MySQL ¤t-series; have built-in authentication
+ against LDAP directories?
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ No. Support for external authentication methods is on the
+ MySQL roadmap as a <quote>rolling feature</quote>, which
+ means that we plan to implement it in the future, but we
+ have not yet determined when this will be done.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ <qandaentry id="faq-security-roles">
+
+ <question>
+
+ <para>
+ Does MySQL ¤t-series; include support for Roles Based
+ Access Control (RBAC)?
+ </para>
+
+ </question>
+
+ <answer>
+
+ <para>
+ No. Support for roles is on the MySQL roadmap as a
+ <quote>rolling feature</quote>, which means that we plan to
+ implement it in the future, but we have not yet determined
+ when this will be done.
+ </para>
+
+ </answer>
+
+ </qandaentry>
+
+ </qandaset>
+
+ </section>
+
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r3691 - trunk/refman-5.0 | jon | 20 Oct |
