MySQL_GetStats

What a handle did since it connected.

native bool:MySQL_GetStats(MySQL:handle, &sent, &failed, &Float:average, &Float:longest);

Parameters

Parameter	Description
MySQL:handle	Handle to check.
&sent	Queries sent.
&failed	Queries that failed.
&Float:average	Milliseconds a query took to run, on average.
&Float:longest	Milliseconds the longest query took to run.

Returns

• true when the numbers were written.
• false when the handle does not exist.

Example

stock PrintDatabaseStats(MySQL:handle) {
    new
        sent,
        failed,
        Float:average,
        Float:longest
    ;

    MySQL_GetStats(handle, sent, failed, average, longest);
    printf("%i queries, %i failed, %.2f ms on average, %.2f ms the longest, %i waiting", sent, failed, average, longest, MySQL_GetPendingCount(handle));
}

Related

• MySQL_GetPendingCount: How many queries of a handle wait or run.
• MySQL_GetQueryTime: Milliseconds the query read took to run, without the time it waited.