|
|
| Applications |
| Mailing Lists |
| Miscellaneous |
| Operating Systems |
| Programming |
svn commit - mysqldoc@docsrva: r8287 - in trunk: dynamic-docs/changelog dynamic-docs/command-optvars refman-5.1 refman-5.2
From: <jon(at)mysql.com>
Date: Wed Oct 24 2007 - 08:30:18 EDT
-
- <tags>
+
</option>
+
-<!-- is this correct? -->
+ <!-- is this correct? -->
+
+
+
+
+
</option>
</option>
</option>
<option command="mysqld" section="server" id="Uptime_since_flush_status"> -<!-- This one is Community only! -->
-<!-- <xrefto id="option_mysqld_Uptime_since_flush_status"/> --> + <!-- This one is Community only! -->
+ <!-- <xrefto id="option_mysqld_Uptime_since_flush_status"/> -->
+
+
+
+
+
+
+
-
+
+
</option>
<option command="mysqld" section="binlog" id="binlog-ignore-db"> -<!-- checked-->
+ <!-- checked-->
+
+
-
+
+
+
+
-
+
+
+
-
+
+
+
</option>
<option command="mysqld" section="innodb" id="crash_binlog_innodb"> -<!-- <xrefto id="option_mysqld_crash_binlog_innodb"/> --> + <!-- <xrefto id="option_mysqld_crash_binlog_innodb"/> -->
+
</option>
<option command="mysqld" section="server" id="defaults-extra-file"> -<!-- this is actually a general option --> + <!-- this is actually a general option -->
</option>
<option command="mysqld" section="server" id="defaults-group-suffix"> -<!-- this is actually a general option --> + <!-- this is actually a general option -->
</option>
<option command="mysqld" section="server" id="defaults-file"> -<!-- this is actually a general option --> + <!-- this is actually a general option -->
+
-
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
+
+
+
+
</option>
<option command="mysqld" section="server" id="identity"> -<!--xrefto id="option_mysqld_last_insert_id"/--> + <!--xrefto id="option_mysqld_last_insert_id"/-->
</option>
Date: Wed Oct 24 2007 - 08:30:18 EDT
Author: jstephens
Date: 2007-10-24 14:30:17 +0200 (Wed, 24 Oct 2007)
New Revision: 8287
Log:
Documentation for WL#432 (Replication Beartbeats):
- CHANGE MASTER TO ... MASTER_HEARTBEAT_PERIOD = interval
- Server status variables:
- Slave_heartbeat_period
- Slave_received_heartbeats
- Fixes for Replication bugs:
- Bug #20435
- Bug #29309
- Bug #30932
- MCCGE feature listing update
Modified:
trunk/dynamic-docs/changelog/mysqld.xml trunk/dynamic-docs/command-optvars/mysqld.xml trunk/refman-5.1/dba-core.xml trunk/refman-5.1/mysql-cluster-cge.xml trunk/refman-5.1/sql-syntax.xml trunk/refman-5.2/dba-core.xml trunk/refman-5.2/sql-syntax.xml
Modified: trunk/dynamic-docs/changelog/mysqld.xml
- trunk/dynamic-docs/changelog/mysqld.xml 2007-10-24 10:59:02 UTC (rev 8286) +++ trunk/dynamic-docs/changelog/mysqld.xml 2007-10-24 12:30:17 UTC (rev 8287) Changed blocks: 3, Lines Added: 82, Lines Deleted: 30; 3789 bytes
@@ -6,6 +6,85 @@
]>
<changelog>
++ + ++ + ++ + + + + + + + + + ++ + + + + ++ + + + ++ A replication heartbeat mechanism has been added to facilitate + monitoring. This provides an alternative to checking log files, + making it possible to detect in real time when a slave has + failed. + + ++ Configuration of heartbeats is done via a new + + +MASTER_HEARTBEAT_PERIOD = + interval clause for the +CHANGE MASTER TO statement (see +); monitoring can be done by + checking the values of the status variables + Slave_heartbeat_period and +Slave_received_heartbeats (see +). + + The addition of replication heartbeats addresses a number of + issues: + + ++ + ++ ++ Relay logs were rotated every + +slave_net_timeout seconds even if no + statements were being replicated. (Bug #24035) ++ ++ +SHOW SLAVE STATUS displayed an + incorrect value for +seconds_behind_master following a +FLUSH LOGS statement. (Bug #29309) ++ + ++ Replication master-slave connections used + +slave_net_timeout for connection + timeouts. (Bug #30932) +
<logentry entrytype="bug">
<tags>
@@ -78629,8 +78708,9 @@
<message>
- mysqld processes did not always detect cluster shutdown, leading
- to issues with CLuster replication and schema distribution.
+ mysqld processes did not always detect
+ cluster shutdown, leading to issues with Cluster replication and
+ schema distribution.
@@ -78640,34 +78720,6 @@
<logentry entrytype="bug">
-
-
-
-
-
-
-
-
-
-
-
- Relay logs were rotated every
- slave_net_timeout seconds even if no
- statements were being replicated.
-
-
-
-
-
-
-
-
- <tags>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
- trunk/dynamic-docs/command-optvars/mysqld.xml 2007-10-24 10:59:02 UTC (rev 8286) +++ trunk/dynamic-docs/command-optvars/mysqld.xml 2007-10-24 12:30:17 UTC (rev 8287) Changed blocks: 375, Lines Added: 930, Lines Deleted: 896; 178442 bytes
@@ -1,7 +1,5 @@
<!DOCTYPE options SYSTEM "options.dtd">
-- -
+
</option>
+
<option command="mysqld" section="binlog" id="Binlog_cache_disk_use">
Binlog_cache_disk_use
The number of transactions that used a temporary file instead of the
- temporary binary log cache
+ temporary binary log cache
@@ -34,6 +34,7 @@
</option>
+
<option command="mysqld" section="replication" id="have_row_based_replication">
have_row_based_replication
@@ -409,7 +410,7 @@
<option command="mysqld" section="server" id="Com_delete_multi">
Com_delete_multi
-<!-- is this correct? -->
+ <!-- is this correct? -->
Count of multiple table DELETE statements
@@ -1739,7 +1740,7 @@
Compression
Whether the client connection uses compression in the client/server
- protocol
+ protocol
@@ -1769,7 +1770,7 @@
Created_tmp_disk_tables
The number of temporary tables on disk created automatically by the
- server while executing statements
+ server while executing statements
@@ -1815,7 +1816,7 @@
Delayed_errors
The number of rows written with INSERT DELAYED for which some error
- occurred
+ occurred
@@ -2022,7 +2023,7 @@
Handler_rollback
The number of requests for a storage engine to perform a rollback
- operation
+ operation
@@ -2053,7 +2054,7 @@
Handler_savepoint_rollback
The number of requests for a storage engine to roll back to a
- savepoint
+ savepoint
@@ -2099,7 +2100,7 @@
Key_blocks_not_flushed
The number of key blocks in the key cache that have changed but have
- not yet been flushed to disk
+ not yet been flushed to disk
@@ -2207,20 +2208,20 @@
Last_query_cost
The total cost of the last compiled query as computed by the query
- optimizer
+ optimizer
-
+
<value default="-1"/>
-
+
-
+
<value default="0"/>
-
+
@@ -2233,7 +2234,7 @@
Max_used_connections
The maximum number of connections that have been in use
- simultaneously since the server started
+ simultaneously since the server started
@@ -2249,14 +2250,14 @@
Ndb_number_of_data_nodes
If the server is part of a MySQL Cluster, the value of this variable
- is the number of data nodes in the cluster
+ is the number of data nodes in the cluster
-
+
<value default="0"/>
-
+
@@ -2268,16 +2269,16 @@
Ndb_conflict_fn_max
If the server is part of a MySQL Cluster
- involved in cluster replication, the value of this variable
- indicates the number of times that conflict resolution based on
- "greater timestamp wins" has been applied
+ involved in cluster replication, the value of this variable
+ indicates the number of times that conflict resolution based on
+ "greater timestamp wins" has been applied
-
+
<value default="0"/>
-
+
@@ -2289,16 +2290,16 @@
Ndb_conflict_fn_old
If the server is part of a MySQL Cluster
- involved in cluster replication, the value of this variable
- indicates the number of times that "same timestamp wins" conflict
- resolution has been applied
+ involved in cluster replication, the value of this variable
+ indicates the number of times that "same timestamp wins" conflict
+ resolution has been applied
-
+
<value default="0"/>
-
+
@@ -2459,7 +2460,7 @@
Qcache_lowmem_prunes
The number of queries that were deleted from the query cache because
- of low memory
+ of low memory
@@ -2475,7 +2476,7 @@
Qcache_not_cached
The number of non-cached queries (not cacheable, or not cached due
- to the query_cache_type setting)
+ to the query_cache_type setting)
@@ -2549,7 +2550,7 @@
Select_full_join
The number of joins that perform table scans because they do not use
- indexes
+ indexes
@@ -2595,7 +2596,7 @@
Select_range_check
The number of joins without keys that check for key usage after each
- row
+ row
@@ -2622,11 +2623,26 @@
</option>
+
</option>
+
</option>
<option command="mysqld" section="server" id="Uptime_since_flush_status"> -<!-- This one is Community only! -->
-<!-- <xrefto id="option_mysqld_Uptime_since_flush_status"/> --> + <!-- This one is Community only! -->
+ <!-- <xrefto id="option_mysqld_Uptime_since_flush_status"/> -->
Uptime_since_flush_status
The number of seconds since the most recent FLUSH STATUS
@@ -2940,9 +2972,9 @@
-
+
<value default="0"/>
-
+
@@ -2955,15 +2987,15 @@
allow-suspicious-udfs
Allows use of UDFs consisting of only one symbol xxx() without
- corresponding xxx_init() or xxx_deinit()
+ corresponding xxx_init() or xxx_deinit()
-
+
<value default="FALSE"/>
-
+
@@ -2998,14 +3030,14 @@
-
+
<value default="1"/>
-
+
@@ -3025,9 +3057,9 @@
-
+
<value default="1"/>
-
+
@@ -3064,9 +3096,9 @@
-
+
<value default="TRUE"/>
-
+
@@ -3096,7 +3128,7 @@
basedir
Path to installation directory. All paths are usually resolved
- relative to this
+ relative to this
@@ -3121,9 +3153,9 @@
-
+
<value default="FALSE"/>
-
+
@@ -3155,12 +3187,12 @@
-
+
-
+
@@ -3215,10 +3247,10 @@
@@ -3247,10 +3279,10 @@
@@ -3268,9 +3300,9 @@
-
+
<value default="10000"/>
-
+
@@ -3283,7 +3315,7 @@
The buffer that is allocated to cache index and rows for BDB tables
@@ -3344,11 +3376,11 @@
</option>
<option command="mysqld" section="binlog" id="binlog-ignore-db"> -<!-- checked-->
+ <!-- checked-->
binlog-ignore-db
Tells the master that updates to the given database should not be
- logged to the binary log
+ logged to the binary log
@@ -3380,16 +3412,16 @@
binlog_cache_size
The size of the cache to hold the SQL statements for the binary log
- during a transaction
+ during a transaction
-
+
<value default="32768"/>
-
+
@@ -3410,12 +3442,12 @@
-
+
-
+
@@ -3448,9 +3480,9 @@
-
+
<value default="8388608"/>
-
+
@@ -3466,12 +3498,12 @@
-
+
<value default="TRUE"/>
-
+
@@ -3487,7 +3519,7 @@
Set the filesystem character set
@@ -3504,7 +3536,7 @@
character-set-server
Set the default collation (deprecated option, use instead).
- --default-collation=name
+ --default-collation=name
@@ -3702,12 +3734,12 @@
-
+
-
+
@@ -3727,17 +3759,17 @@
-
+
<value default="TRUE"/>
-
+
-
+
-
+
@@ -3750,16 +3782,16 @@
connect_timeout
The number of seconds the mysqld server waits for a connect packet
- before responding with 'Bad handshake'
+ before responding with 'Bad handshake'
-
+
<value default="5"/>
-
+
@@ -3772,7 +3804,7 @@
console
Write error output on screen; do not remove the console window on
- Windows
+ Windows
@@ -3794,9 +3826,9 @@
-
+
<value default="TRUE"/>
-
+
@@ -3806,7 +3838,7 @@
</option>
<option command="mysqld" section="innodb" id="crash_binlog_innodb"> -<!-- <xrefto id="option_mysqld_crash_binlog_innodb"/> --> + <!-- <xrefto id="option_mysqld_crash_binlog_innodb"/> -->
crash_binlog_innodb
Used only for testing, to crash when writing Nth event to binlog
@@ -3896,7 +3928,7 @@
@@ -3980,9 +4012,9 @@
-
+
<value default="0"/>
-
+
@@ -3992,7 +4024,7 @@
</option>
<option command="mysqld" section="server" id="defaults-extra-file"> -<!-- this is actually a general option --> + <!-- this is actually a general option -->
defaults-extra-file
Load additional options from file
@@ -4008,7 +4040,7 @@
</option>
<option command="mysqld" section="server" id="defaults-group-suffix"> -<!-- this is actually a general option --> + <!-- this is actually a general option -->
defaults-group-suffix
Option group suffix value
@@ -4024,7 +4056,7 @@
</option>
<option command="mysqld" section="server" id="defaults-file"> -<!-- this is actually a general option --> + <!-- this is actually a general option -->
defaults-file
Loads defaults from specific file
@@ -4049,12 +4081,12 @@
-
+
-
+
@@ -4076,17 +4108,17 @@
delayed_insert_limit
After inserting delayed_insert_limit rows, the INSERT DELAYED
- handler will check if there are any SELECT statements pending. If so, it allows these to
- execute before continuing
+ handler will check if there are any SELECT statements pending. If so, it allows these to
+ execute before continuing
-
+
<value default="100"/>
-
+
@@ -4099,16 +4131,16 @@
delayed_insert_timeout
How many seconds an INSERT DELAYED thread should wait for INSERT
- statements before terminating
+ statements before terminating
-
+
<value default="300"/>
-
+
@@ -4121,16 +4153,16 @@
delayed_queue_size
What size queue (in rows) should be allocated for handling INSERT
- DELAYED
+ DELAYED
-
+
<value default="1000"/>
-
+
@@ -4161,13 +4193,13 @@
Option used by mysql-test for debugging and testing of replication
-
+
<value default="0"/>
-
+
@@ -4180,16 +4212,16 @@
div_precision_increment
Scale of the result of '/' operator will be
-increased by this many digits</shortdescription>
+ increased by this many digits</shortdescription>
-
+
<value default="4"/>
-
+
@@ -4209,9 +4241,9 @@
-
+
<value default="FALSE"/>
-
+
@@ -4229,9 +4261,9 @@
-
+
<value default="FALSE"/>
-
+
@@ -4245,14 +4277,14 @@
Push supported query conditions to the storage engine
-
+
<value default="OFF"/>
-
+
@@ -4279,20 +4311,20 @@
event-scheduler
Enable/disable and start/stop the event scheduler. Note that this
- variable underwent significant changes in behavior and permitted values in MySQL 5.1.11 and
- 5.1.12
+ variable underwent significant changes in behavior and permitted values in MySQL 5.1.11 and
+ 5.1.12
-
+
-
+
@@ -4321,16 +4353,16 @@
expire_logs_days
If non-zero, binary logs will be purged after expire_logs_days days;
- possible purges happen at startup and at binary log rotation
+ possible purges happen at startup and at binary log rotation
-
+
<value default="0"/>
-
+
@@ -4351,9 +4383,9 @@
-
+
<value default="FALSE"/>
-
+
@@ -4372,9 +4404,9 @@
-
+
<value default="OFF"/>
-
+
@@ -4387,16 +4419,16 @@
flush_time
A dedicated thread is created to flush all tables at the given
- interval
+ interval
-
+
<value default="0"/>
-
+
@@ -4408,15 +4440,15 @@
<option command="mysqld" section="innodb" id="foreign_key_checks">
foreign_key_checks
If set to 1 (the default), foreign key constraints for InnoDB tables
- are checked.
+ are checked.
-
+
<value default="1"/>
-
+
@@ -4435,9 +4467,9 @@
-
+
<value default="+-><()~*:""&"/>
-
+
@@ -4450,7 +4482,7 @@
ft_max_word_len
The maximum length of the word to be included in a FULLTEXT index.
- Note: FULLTEXT indexes must be rebuilt after changing this variable
+ Note: FULLTEXT indexes must be rebuilt after changing this variable
@@ -4468,16 +4500,16 @@
ft_min_word_len
The minimum length of the word to be included in a FULLTEXT index.
- Note: FULLTEXT indexes must be rebuilt after changing this variable
+ Note: FULLTEXT indexes must be rebuilt after changing this variable
-
+
<value default="4"/>
-
+
@@ -4492,14 +4524,14 @@
Number of best matches to use for query expansion
-
+
<value default="20"/>
-
+
@@ -4536,9 +4568,9 @@
-
+
<value default="FALSE"/>
-
+
@@ -4570,9 +4602,9 @@
-
+
<value default="host_name.log"/>
-
+
@@ -4590,9 +4622,9 @@
-
+
<value default="1024"/>
-
+
@@ -4621,10 +4653,10 @@
</option>
<option command="mysqld" section="server" id="identity"> -<!--xrefto id="option_mysqld_last_insert_id"/--> + <!--xrefto id="option_mysqld_last_insert_id"/-->
identity
This variable is a synonym for the LAST_INSERT_ID variable. It
- exists for compatibility with other database systems
+ exists for compatibility with other database systems
@@ -4689,22 +4721,22 @@
</option>
-