From: stefan Date: March 16 2006 8:45am Subject: svn commit - mysqldoc@docsrva: r1599 - in trunk: refman-4.1 refman-5.0 refman-5.1 List-Archive: http://lists.mysql.com/commits/3878 Message-Id: <200603160845.k2G8j1hG005960@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: shinz Date: 2006-03-16 09:45:00 +0100 (Thu, 16 Mar 2006) New Revision: 1599 Log: Clarify that PACK_KEYS is a MyISAM-only option Modified: trunk/refman-4.1/sql-syntax.xml trunk/refman-5.0/sql-syntax.xml trunk/refman-5.1/sql-syntax.xml Modified: trunk/refman-4.1/sql-syntax.xml =================================================================== --- trunk/refman-4.1/sql-syntax.xml 2006-03-16 08:29:57 UTC (rev 1598) +++ trunk/refman-4.1/sql-syntax.xml 2006-03-16 08:45:00 UTC (rev 1599) @@ -2201,16 +2201,16 @@ + PACK_KEYS takes effect only with + MyISAM tables. Set this option to 1 if you want to have smaller indexes. This usually makes updates slower and reads faster. Setting the option to 0 disables all packing of keys. Setting it to - DEFAULT (MySQL 4.0) tells the storage - engine to pack only long CHAR or + DEFAULT tells the storage engine to pack + only long CHAR or VARCHAR columns. - (MyISAM and ISAM - only.) - + If you do not use PACK_KEYS, the default is to pack only strings, but not numbers. If you use Modified: trunk/refman-5.0/sql-syntax.xml =================================================================== --- trunk/refman-5.0/sql-syntax.xml 2006-03-16 08:29:57 UTC (rev 1598) +++ trunk/refman-5.0/sql-syntax.xml 2006-03-16 08:45:00 UTC (rev 1599) @@ -2235,15 +2235,16 @@ + PACK_KEYS takes effect only with + MyISAM tables. Set this option to 1 if you want to have smaller indexes. This usually makes updates slower and reads faster. Setting the option to 0 disables all packing of keys. Setting it to DEFAULT tells the storage engine to pack only long CHAR or VARCHAR columns. - (MyISAM only.) - + If you do not use PACK_KEYS, the default is to pack strings, but not numbers. If you use Modified: trunk/refman-5.1/sql-syntax.xml =================================================================== --- trunk/refman-5.1/sql-syntax.xml 2006-03-16 08:29:57 UTC (rev 1598) +++ trunk/refman-5.1/sql-syntax.xml 2006-03-16 08:45:00 UTC (rev 1599) @@ -2719,13 +2719,14 @@ + PACK_KEYS takes effect only with + MyISAM tables. Set this option to 1 if you want to have smaller indexes. This usually makes updates slower and reads faster. Setting the option to 0 disables all packing of keys. Setting it to DEFAULT tells the storage engine to pack only long CHAR or VARCHAR columns. - (MyISAM only.)