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 |

1 comment:

Anonymous said...

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