Is there a way to get data statistics (bytes in/out) per
thread/connection with the MySQL C API? I would be interested in
generating statistics for the amount of transmitted data (over the
network) in my program. Thanks.
-
Before
>Description:
Take a client that connects to a remote database via a network
connection. Next the client issues a LOCK TABLES command, some
write others read. Now the network connection becomes unavailable.
MySQL will never timeout the locks nor the clients and the t
is running on.
>Fix:
Implement a timer for network reads/writes, make the socket non
blockable.
>Submitter-Id:
>Originator:
>Organization:
EQU, programmer of oer+MySQL (a MySQL based IRC bot)
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis
>Description:
With the current series of MySQL RDBMS (tested with 3.23.49 on Debian
Linux 3.0 running a 2.4.19-pre10 kernel) connecting to a remote
database can be problematic since MySQL doesn't handle very well
situations where the remote database has become unavailable.
To be more precise, is