Bug #25607 mysqladmin version does not show enough info for OS X
Submitted: 13 Jan 2007 8:54 Modified: 14 Jan 2007 13:27
Reporter: Jon Koerber Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.0.27 OS:MacOS (OS X Server 10.4)
Assigned to: CPU Architecture:Any

[13 Jan 2007 8:54] Jon Koerber
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.
[14 Jan 2007 13:27] Valeriy Kravchuk
Thank you for a problem report. Yes, looks like in case of PowerPC we need to provide more exact information about 32-bit vs. 64-bit version of mysqladmin. In case of Windows we have "for Win32 on ia32", for example.

So, I think this is a reasonable feature request. You may try to use file command to check what kind of binary it is. See man file (or http://www.hmug.org/man/1/file.php) for details.