Bug #45311 System variable pseudo_thread_id not documented
Submitted: 3 Jun 2009 20:58 Modified: 5 Jun 2009 0:15
Reporter: Sveta Smirnova Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[3 Jun 2009 20:58] Sveta Smirnova 
Description:
System variable pseudo_thread_id exists, but not documented.

How to repeat:
mysql> select @@pseudo_thread_id;
+--------------------+
| @@pseudo_thread_id |
+--------------------+
|                 10 | 
+--------------------+
1 row in set (0.00 sec)
[5 Jun 2009 0:15] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.
[5 Sep 2010 11:14] Baron Schwartz 
The documentation isn't very helpful:

"This variable is for internal server use."

I would appreciate if even internals are documented for users.  It looks like this is how the SQL thread in replication is able to replay statements such as SELECT CONNECTION_ID(), and is also useful for mysqlbinlog.  Users can benefit from knowing that.
[5 Sep 2010 17:26] Paul DuBois 
This variable's purpose is not documented deliberately. There is no commitment that the current use today will be the same tomorrow.