Hi, The following diff fixes a bug in MySQL status output (both "SHOW STATUS;" and `mysqladmin status`).
See: http://bugs.mysql.com/bug.php?id=61205 Cheers! David Index: Makefile =================================================================== RCS file: /cvs/ports/databases/mysql/Makefile,v retrieving revision 1.189 diff -u -p -r1.189 Makefile --- Makefile 8 Mar 2011 10:46:31 -0000 1.189 +++ Makefile 18 May 2011 10:51:45 -0000 @@ -11,7 +11,7 @@ DISTNAME= mysql-${VERSION} PKGNAME-main= mysql-client-${VERSION} REVISION-main= 0 PKGNAME-server= mysql-server-${VERSION} -REVISION-server=5 +REVISION-server=6 PKGNAME-tests= mysql-tests-${VERSION} CATEGORIES= databases V= MySQL-5.1 Index: patches/patch-sql_sql_parse_cc =================================================================== RCS file: patches/patch-sql_sql_parse_cc diff -N patches/patch-sql_sql_parse_cc --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ patches/patch-sql_sql_parse_cc 18 May 2011 10:51:45 -0000 @@ -0,0 +1,16 @@ +$OpenBSD$ + +Fix floating point string printing in MySQL status output +(MySQL Bug #61205) + +--- sql/sql_parse.cc.orig Wed May 18 12:36:24 2011 ++++ sql/sql_parse.cc Wed May 18 12:37:14 2011 +@@ -1558,7 +1558,7 @@ bool dispatch_command(enum enum_server_command command + length= my_snprintf(buff, buff_len - 1, + "Uptime: %lu Threads: %d Questions: %lu " + "Slow queries: %lu Opens: %lu Flush tables: %lu " +- "Open tables: %u Queries per second avg: %u.%u", ++ "Open tables: %u Queries per second avg: %u.%03u", + uptime, + (int) thread_count, (ulong) thd->query_id, + current_global_status_var.long_query_count,
