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:
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
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.