Description:
When executing "mysqladmin -u user -p version" on OS X client (PPC dual G4 32-bit, running 10.4, mysql-standard-5.0.27-osx10.4-powerpc) and OS X Server on a dual G5 64-bit Xserve (PPC Dual G5 64-bit, 10.4 Server, mysql-standard-5.0.27-osx10.4-powerpc-64bit) I get the same information. I have multiple versions of MySQL installed on OS X Server but am unable to identify which version, either 32 bit or 64 bit, is running from using "mysqladmin". The output from both is:
mysqladmin Ver 8.41 Distrib 5.0.27, for apple-darwin8.6.0 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 19 min 17 sec
Threads: 1 Questions: 1793 Slow queries: 0 Opens: 47 Flush tables: 1 Open tables: 41 Queries per second avg: 1.550
How to repeat:
Execute "mysqladmin -u user -p version" on the command line of OS X client PPC 32-bit
Execute "mysqladmin -u user -p version" on the command line of OS X Server PPC 64-bit
Compare results to find information is exactly the same.
Suggested fix:
Adding an additional line of information for processor and bit size would help quickly identify which version is running. While I understand you dont differentiate between server and client versions, the information on 32 or 64 bit is important. For environments that test using multiple versions, it is tedious to manually verify the version and the output from a "mysqladmin" cannot be scripted to check against the full version (PPC 32bit vs. PPC 64bit) as we switch from version to version during testing.
This may become even more important as additional Xserves and desktops ship from Apple with different Intel Core Duo and Xeon processors and MySQL AB begins providing even more source and binaries variations for Mac OS X.