MySQL Lists: internals: bk commit - mysqldoc@docsrva tree (stefan:1.2815)

List:	Internals	« Previous Message Next Message »
From:	stefan	Date:	June 17 2005 7:07pm
Subject:	bk commit - mysqldoc@docsrva tree (stefan:1.2815)
View as plain text
Below is the list of changes that have just been committed into a local
mysqldoc repository of stefan. When stefan does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.2815 05/06/17 19:07:17 stefan@stripped +2 -0
  mysql-database-administration.xml:
    Applied comments on first
draft[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[DKonstantin's
comments on first draft
  news.xml:
    compresed -> compressed
  mysql-database-administration.xml:
    Shortened output from SHOW STATUS
     to make it more clear that this is just an example.
    Added Konstantin's new Com_ statement counter vars.

  refman/mysql-database-administration.xml
    1.4 05/06/17 19:06:36 stefan@stripped +15 -9
    Applied comments on first
draft[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[D[DKonstantin's
comments on first draft

  refman/news.xml
    1.7 05/06/17 18:54:12 stefan@stripped +3 -55
    compresed -> compressed

  refman/mysql-database-administration.xml
    1.3 05/06/17 18:15:20 stefan@stripped +62 -69
    Shortened output from SHOW STATUS
     to make it more clear that this is just an example.
    Added Konstantin's new Com_ statement counter vars.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	stefan
# Host:	apollon.site
# Root:	/home/stefan/bk/mysqldoc

--- 1.2/refman/mysql-database-administration.xml	2005-06-17 04:55:33 +02:00
+++ 1.4/refman/mysql-database-administration.xml	2005-06-17 19:06:36 +02:00
@@ -9176,64 +9176,7 @@
 | Bytes_received           | 155372598  |
 | Bytes_sent               | 1176560426 |
 | Connections              | 30023      |
-| Created_tmp_disk_tables  | 0          |
-| Created_tmp_files        | 60         |
-| Created_tmp_tables       | 8340       |
-| Delayed_errors           | 0          |
-| Delayed_insert_threads   | 0          |
-| Delayed_writes           | 0          |
-| Flush_commands           | 1          |
-| Handler_delete           | 462604     |
-| Handler_read_first       | 105881     |
-| Handler_read_key         | 27820558   |
-| Handler_read_next        | 390681754  |
-| Handler_read_prev        | 6022500    |
-| Handler_read_rnd         | 30546748   |
-| Handler_read_rnd_next    | 246216530  |
-| Handler_update           | 16945404   |
-| Handler_write            | 60356676   |
-| Key_blocks_used          | 14955      |
-| Key_read_requests        | 96854827   |
-| Key_reads                | 162040     |
-| Key_write_requests       | 7589728    |
-| Key_writes               | 3813196    |
-| Max_used_connections     | 0          |
-| Not_flushed_delayed_rows | 0          |
-| Not_flushed_key_blocks   | 0          |
-| Open_files               | 2          |
-| Open_streams             | 0          |
-| Open_tables              | 1          |
-| Opened_tables            | 44600      |
-| Qcache_free_blocks       | 36         |
-| Qcache_free_memory       | 138488     |
-| Qcache_hits              | 79570      |
-| Qcache_inserts           | 27087      |
-| Qcache_lowmem_prunes     | 3114       |
-| Qcache_not_cached        | 22989      |
-| Qcache_queries_in_cache  | 415        |
-| Qcache_total_blocks      | 912        |
-| Questions                | 2026873    |
-| Select_full_join         | 0          |
-| Select_full_range_join   | 0          |
-| Select_range             | 99646      |
-| Select_range_check       | 0          |
-| Select_scan              | 30802      |
-| Slave_open_temp_tables   | 0          |
-| Slave_running            | OFF        |
-| Slow_launch_threads      | 0          |
-| Slow_queries             | 0          |
-| Sort_merge_passes        | 30         |
-| Sort_range               | 500        |
-| Sort_rows                | 30296250   |
-| Sort_scan                | 4650       |
-| Table_locks_immediate    | 1920382    |
-| Table_locks_waited       | 0          |
-| Threads_cached           | 0          |
-| Threads_connected        | 1          |
-| Threads_created          | 30022      |
-| Threads_running          | 1          |
-| Uptime                   | 80380      |
-+--------------------------+------------+
+&hellip;
 </programlisting>
 
    <para>
@@ -9310,17 +9253,73 @@
      MySQL 3.23.7.
     </para></listitem>
 
-    <listitem><para>
-     <literal>Com_<replaceable>xxx</replaceable></literal>
-    </para>
-
-    <para>
-     The number of times each <replaceable>xxx</replaceable> statement
-     has been executed. There is one status variable for each type of
-     statement. For example, <literal>Com_delete</literal> and
-     <literal>Com_insert</literal> count
<literal>DELETE</literal> and
-     <literal>INSERT</literal> statements.
-    </para></listitem>
+    <listitem>
+     <para>
+      <literal>Com_<replaceable>xxx</replaceable></literal>
+     </para>
+     <para>
+      The <literal>Com_<replaceable>xxx</replaceable></literal>
statement
+      counter variables were added beginning with MySQL 3.23.47.
+      They indicate the number of times each <replaceable>xxx</replaceable> 
+      statement has been executed. There is one status variable for each type of
+      statement. For example, <literal>Com_delete</literal> and
+      <literal>Com_insert</literal> count
<literal>DELETE</literal> and
+      <literal>INSERT</literal> statements.
+     </para>
+     <para>
+      New
<literal>Com_stmt_<replaceable>xxx</replaceable></literal> status
variables 
+      have been added in MySQL 4.1.13 or 5.0.8, respectively.
+      <itemizedlist>
+       <listitem><para>
+        <literal>Com_stmt_prepare</literal>
+       </para></listitem>
+       <listitem><para>
+        <literal>Com_stmt_execute</literal>
+       </para></listitem>
+       <listitem><para>
+        <literal>Com_stmt_fetch</literal> (not available in versions before
5.0)
+       </para></listitem>
+       <listitem><para>
+        <literal>Com_stmt_send_long_data</literal>
+       </para></listitem>
+       <listitem><para>
+        <literal>Com_stmt_reset</literal>
+       </para></listitem>
+       <listitem><para>
+        <literal>Com_stmt_close</literal>
+       </para></listitem>
+      </itemizedlist>
+      Those variables stand for prepared statements commands. Their names 
+      refer to the
<literal>COM_<replaceable>xxx</replaceable></literal> command 
+      set used in the network layer; in other words: Their values are being
+      increased whenever prepared statements API calls such as 
+      <command>mysql_stmt_prepare()</command>,
+      <command>mysql_stmt_execute()</command>, and so forth are executed.
+      However, <literal>Com_stmt_prepare</literal>, 
+      <literal>Com_stmt_execute</literal> and 
+      <literal>Com_stmt_close</literal> are also increased when one issues 
+      the following SQL statements: <literal>PREPARE</literal>, 
+      <literal>EXECUTE</literal>, or
<literal>DEALLOCATE</literal>
+      respectively.
+      <!--
+      Additionally, the values of the older (available since MySQL 4.1.3) 
+      statement counter variables <literal>Com_prepare_sql</literal>, 
+      <literal>Com_execute_sql</literal>, and
+      <literal>Com_deallocate_sql</literal> are increased for
+      the <literal>PREPARE</literal>, <literal>EXECUTE</literal>,
and
+      <literal>DEALLOCATE</literal> statements.
+      -->
+      <literal>Com_stmt_fetch</literal> stands for the total number of
network 
+      round-trips issued when fetching from cursors.
+     </para>
+     <para>
+      All of the
<literal>Com_stmt_<replaceable>xxx</replaceable></literal>
+      variables are increased even if their argument (a prepared statement) is 
+      unknown or an error occurred during execution; in other words: Their 
+      values correspond to the number of requests issued, not to the number of
+      requests successfully completed.
+     </para>
+    </listitem>
 
     <listitem><para>
      <literal>Connections</literal>

--- 1.6/refman/news.xml	2005-06-17 15:21:47 +02:00
+++ 1.7/refman/news.xml	2005-06-17 18:54:12 +02:00
@@ -232,21 +232,6 @@
    <itemizedlist>
 
     <listitem><para>
-     Fixed a problem where a stored procedure caused a server crash if
-     the query cache was enabled. (Bug #9715)
-    </para></listitem>
-
-    <listitem><para>
-     <literal>SHOW CREATE DATABASE INFORMATION_SCHEMA</literal> returned
-     an <quote>unknown database</quote> error. (Bug #9434)
-    </para></listitem>
-
-    <listitem><para>
-     Corrected a problem with <literal>IFNULL()</literal> returning an
-     incorrect result on 64-bit systems. (Bug #11235)
-    </para></listitem>
-
-    <listitem><para>
      Fixed a problem resolving table names with
      <literal>lower_case_table_names=2</literal> when the table name
      lettercase differed in the <literal>FROM</literal> and
@@ -425,14 +410,6 @@
      before).
     </para></listitem>
 
-    <listitem><para>
-     <literal>InnoDB</literal>: In stored procedures and functions,
-     <literal>InnoDB</literal> no longer takes full explicit table locks
-     for every involved table. Only `intention' locks are taken, similar
-     to those in the execution of an ordinary SQL statement. This
-     greatly reduces the number of deadlocks.
-    </para></listitem>
-
    </itemizedlist>
 
    <para>
@@ -442,12 +419,6 @@
    <itemizedlist>
 
     <listitem><para>
-     Corrected a problem where an incorrect column type was returned in
-     the result set metadata when using a prepared <literal>SELECT
-     DISTINCT</literal> statement to select from a view. (Bug #11111)
-    </para></listitem>
-
-    <listitem><para>
      Fixed bug in the MySQL Instance manager that caused the version to
      always be <literal>unknown</literal> when <literal>SHOW INSTANCE
      STATUS</literal> was issued. (Bug #10229)
@@ -624,20 +595,6 @@
     </para></listitem>
 
     <listitem><para>
-     <literal>InnoDB</literal>: Fixed a duplicate key error that
-     occurred with <literal>REPLACE</literal> in a table with an
-     <literal>AUTO-INC</literal> column. (Bug #11005)
-    </para></listitem>
-
-    <listitem><para>
-     Fixed that MySQL would pass a wrong key length to storage engines
-     in <literal>MIN()</literal>. This could cause warnings
-     <literal>InnoDB: Warning: using a partial-field key prefix in
-     search.</literal> in the <filename>.err</filename> log. (Bug
-     #11039)
-    </para></listitem>
-
-    <listitem><para>
      Fixed a server crash for <literal>INSERT</literal> or
      <literal>UPDATE</literal> when the <literal>WHERE</literal>
clause
      contained a correlated subquery that referred to a column of the
@@ -751,7 +708,7 @@
 
     <listitem><para>
      <literal>SHOW VARIABLES</literal> now shows the
-     <literal>slave_compresed_protocol</literal>,
+     <literal>slave_compressed_protocol</literal>,
      <literal>slave_load_tmpdir</literal> and
      <literal>slave_skip_errors</literal> system variables. (Bug #7800)
     </para></listitem>
@@ -1059,8 +1016,8 @@
     </para></listitem>
 
     <listitem><para>
-     Fixed server crash resulting from multiple calls to a stored
-     procedure that assigned the result of a subquery to a variable or
+     Fixed server crash resulting from multiple calls to stored
+     procedure that assigned result of subquery to a variable or
      compared it to a value with <literal>IN</literal>. (Bug #5963)
     </para></listitem>
 
@@ -4087,15 +4044,6 @@
    </para>
 
    <itemizedlist>
-
-    <listitem><para>
-     Added the <option>--log-slow-admin-statements</option> server
-     option to request logging of slow administrative statements such as
-     <literal>OPTIMIZE TABLE</literal>, <literal>ANALYZE
-     TABLE</literal>, and <literal>ALTER TABLE</literal> to the slow
-     query log. These statements were logged in MySQL 4.0, but not in
-     4.1. (Bug #9141)
-    </para></listitem>
 
     <listitem><para>
      <literal>SHOW BINARY LOGS</literal> now displays a
Thread
• bk commit - mysqldoc@docsrva tree (stefan:1.2815)	stefan	17 Jun