MySQL: check what version : 32 bit or 64 bit?

Question

Can I tell what version (32 bit or 64 bit) of MySQL I am running by using Terminal?

Answer 1

$ mysql --version mysql  Ver 14.14 Distrib 5.1.45, for apple-darwin10.2.0 (i386) using readline 6.2   $ echo '\s' | mysql -------------- mysql  Ver 14.14 Distrib 5.1.45, for apple-darwin10.2.0 (i386) using readline 6.2  Connection id:      105730 [...] Server version:     5.1.41 MySQL Community Server (GPL) [...] Uptime:         11 days 4 hours 2 min 6 sec  Threads: 2  Questions: 1141270  Slow queries: 0  Opens: 6137  Flush tables: 1  Open tables: 56  Queries per second avg: 1.182 -------------- 

Answer 2

run this command in command line:

mysql> show variables like 'version_compile_machine'; 

then you get something like this:

+-------------------------+-------+ | Variable_name           | Value | +-------------------------+-------+ | version_compile_machine | i386  | +-------------------------+-------+ 1 row in set (0.00 sec) 

and then please check this: http://www.redhat.com/archives/rhl-list/2006-October/msg03684.html

you'll see that i386/i686 are 32 bit, and x86_64 is 64 bit.

Hope this helps.