Saturday, May 19, 2007

Negative number of threads connected?

Today, I noticed that one of my machines was giving a negative number for threads connected.

Anyone care to share why the threads would be displayed as a negative number in mysqladmin ex output:

| Aborted_connects           | 0          |
| Connections                | 186        |
| Max_used_connections       | 0          |
| Threads_connected          | -31        |
| Aborted_connects           | 0          |
at

1 comment:

  1. Anonymous5:44 AM

    It looks to me like you are using -r/--relative with mysqladmin - which actually reports the *difference* (delta) between the last snapshot and this one that is currently being reported on (along with -i and -c).

    So Threads_connected actually went down from the last snapshot..

    ReplyDelete