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 |
Specializing in big data deployments using MySQL / NoSQL Solutions. Topics: [mysql tutorial] [database design] [mysql data types] [mysql commands] [mysql dump] [database development] [mysql training] [mysql scalability] [mysql sharding] [mysql performance tuning]
| Aborted_connects | 0 |
| Connections | 186 |
| Max_used_connections | 0 |
| Threads_connected | -31 |
| Aborted_connects | 0 |
1 comment:
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..
Post a Comment