CODEWITHSUNDEEP
mysql
user605334
user605334

Reputation:

How to check whether system has x86 or x64 MySQL

I want to check that which type of MySQL my system has (as in x86 or x64 [32 or 64 bit]).

Any way to check that this in MySQL?

Upvotes: 3

Views: 2098

Answers (1)

Billy Samuel
Billy Samuel

Reputation: 672

The way to find is using mysql to find it

MYSQL on 32 Bit System

mysql> SHOW GLOBAL VARIABLES LIKE 'version_compile_machine';
+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| version_compile_machine | i686 |
+-------------------------+-------+
1 row in set (0.00 sec)

MYSQL on 64 Bit System

mysql> show variables like 'version_compile_machine';
+-------------------------+--------+
| Variable_name | Value |
+-------------------------+--------+
| version_compile_machine | x86_64 |
+-------------------------+--------+

Upvotes: 2

Related Questions