List:Commits« Previous MessageNext Message »
From:mcbrown Date:July 30 2008 1:48pm
Subject:svn commit - mysqldoc@docsrva: r11437 - trunk/refman-6.0
View as plain text  
Author: mcbrown
Date: 2008-07-30 15:48:39 +0200 (Wed, 30 Jul 2008)
New Revision: 11437

Log:
Some updates to the Falcon I_S tables



Modified:
   trunk/refman-6.0/se-falcon-core.xml


Modified: trunk/refman-6.0/se-falcon-core.xml
===================================================================
--- trunk/refman-6.0/se-falcon-core.xml	2008-07-30 13:28:08 UTC (rev 11436)
+++ trunk/refman-6.0/se-falcon-core.xml	2008-07-30 13:48:39 UTC (rev 11437)
Changed blocks: 3, Lines Added: 40, Lines Deleted: 21; 4611 bytes

@@ -969,15 +969,19 @@
 <programlisting>+---------------------------------------+
 | Tables_in_information_schema          |
 +---------------------------------------+
-| FALCON_RECORD_CACHE_SUMMARY           |
-| FALCON_SYSTEM_MEMORY_DETAIL           |
-| FALCON_SYSTEM_MEMORY_SUMMARY          |
-| FALCON_SYNCOBJECTS                    |
-| FALCON_RECORD_CACHE_DETAIL            |
-| FALCON_TRANSACTION_SUMMARY            |
-| FALCON_DATABASE_IO                    |
-| FALCON_TRANSACTIONS                   |
-| FALCON_SERIAL_LOG                     |
+| FALCON_TABLES                         | 
+| FALCON_SERIAL_LOG_INFO                | 
+| FALCON_SYSTEM_MEMORY_DETAIL           | 
+| FALCON_SYSTEM_MEMORY_SUMMARY          | 
+| FALCON_VERSION                        | 
+| FALCON_TRANSACTION_SUMMARY            | 
+| FALCON_TABLESPACES                    | 
+| FALCON_SYNCOBJECTS                    | 
+| FALCON_TRANSACTIONS                   | 
+| FALCON_RECORD_CACHE_DETAIL            | 
+| FALCON_TABLESPACE_IO                  | 
+| FALCON_RECORD_CACHE_SUMMARY           | 
+| FALCON_TABLESPACE_FILES               | 
 +---------------------------------------+</programlisting>
 
     <table>

@@ -1034,18 +1038,31 @@
               get duplicate rows of information in the generated table.</entry>
           </row>
           <row>
-            <entry><literal>FALCON_SERIAL_LOG</literal></entry>
+            <entry><literal>FALCON_SERIAL_LOG_INFO</literal></entry>
             <entry>Serial log status information. Shows transactions and serial log object
-              usage per database.</entry>
+              usage per database. This table was known as
+              <literal>FALCON_SERIAL_LOG</literal> in MySQL 6.0.3 and
+              earlier.</entry>
           </row>
           <row>
-            <entry><literal>FALCON_DATABASE_IO</literal></entry>
+            <entry><literal>FALCON_TABLES</literal></entry>
+            <entry>Lists all <literal>Falcon</literal> tables.</entry>
+          </row>
+          <row>
+            <entry><literal>FALCON_TABLESPACE_FILES</literal></entry>
+            <entry>Shows the list of <literal>Falcon</literal> tablespaces, including the
+              system tablespaces <literal>FALCON_USER</literal> and
+              <literal>FALCON_TEMPORARY</literal>.</entry>
+          </row>
+          <row>
+            <entry><literal>FALCON_TABLESPACE_IO</literal></entry>
             <entry>I/O statistics showing page size, buffer size, and reads/writes on a per
               tablespace basis.</entry>
           </row>
           <row>
-            <entry><literal>FALCON_TABLES</literal></entry>
-            <entry>Lists all <literal>Falcon</literal> tables.</entry>
+            <entry><literal>FALCON_VERSION</literal></entry>
+            <entry>Shows the internal <literal>Falcon</literal> version number and release
+              date.</entry>
           </row>
         </tbody>
       </tgroup>

@@ -1072,13 +1089,15 @@
       <literal>falcon_database_io</literal> table:
     </para>
 
-<programlisting>mysql&gt; select * from information_schema.falcon_database_io;
-+----------+-----------+---------+-------+--------+---------+-------+
-| DATABASE | PAGE_SIZE | BUFFERS | READS | WRITES | FETCHES | FAKES |
-+----------+-----------+---------+-------+--------+---------+-------+
-| RMS      |      4096 |    2560 |     0 |    109 |   98687 |   615 |
-| GIMF     |      4096 |    2560 |   565 |     28 |   56870 |     3 |
-+----------+-----------+---------+-------+--------+---------+-------+</programlisting>
+<programlisting>mysql&gt; SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLESPACE_IO;
++------------------+-----------+---------+----------------+--------+---------------+-------+
+| TABLESPACE       | PAGE_SIZE | BUFFERS | PHYSICAL_READS | WRITES | LOGICAL_READS | FAKES |
++------------------+-----------+---------+----------------+--------+---------------+-------+
+| FALCON_MASTER    |      4096 |    1024 |             59 |      0 |          1186 |     3 | 
+| FALCON_TEMPORARY |      4096 |    1024 |              1 |      0 |             0 |     1 | 
+| FALCON_USER      |      4096 |    1024 |              2 |      0 |             4 |     3 | 
++------------------+-----------+---------+----------------+--------+---------------+-------+
+</programlisting>
 
     <para>
       You can also <literal>JOIN</literal> information between tables to
Thread
• svn commit - mysqldoc@docsrva: r11437 - trunk/refman-6.0mcbrown30 Jul