HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

MySQL version confusion

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
versionmysqlconfusion

Problem

How is this possible:

I installed mysql-5.6.11-osx10.7-x86.dmg which is supposed to be version Mac OS X ver. 10.7 (x86, 32-bit), DMG Archive (32 bit!)

But upon SHOW VARIABLES LIKE "%version%"; I get the following:

mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name           | Value                        |
+-------------------------+------------------------------+
| innodb_version          | 5.6.11                       |
| protocol_version        | 10                           |
| slave_type_conversions  |                              |
| version                 | 5.6.11                       |
| version_comment         | MySQL Community Server (GPL) |
| version_compile_machine | x86_64                       |
| version_compile_os      | osx10.7                      |
+-------------------------+------------------------------+
7 rows in set (0,00 sec)


Why x86_64 ?

Amendment:

Now it becomes weird:
I uninstalled MySQL with the help of https://stackoverflow.com/questions/1436425/how-do-you-uninstall-mysql-from-mac-os-x

Then I installed mysql-5.5.31-osx10.6-x86_64 from http://dev.mysql.com/downloads/mysql/5.5.html#downloads
It is clearly sitting in /usr/bin/local/mysql-5.5.31-osx10.6-x86_64/ (note the 64 at the end).

Now this:

mysqld  Ver 5.5.31 for osx10.6 on i386 (MySQL Community Server (GPL))


and:

mysql  Ver 14.14 Distrib 5.5.31, for osx10.6 (i386) using readline 5.1


and this:

mysql> SHOW VARIABLES LIKE "%version_compile%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| version_compile_machine | i386    |
| version_compile_os      | osx10.6 |
+-------------------------+---------+
2 rows in set (0.00 sec)


How can this be: 32 bit architecture after (obviously) downloading and installing 32 bit?
I am feeling lost.

Solution

Let's analyze the string '5.6.11-osx10.7-x86'.
5.6.11 is the MySQL version.
osx is the platform.
10.7 is the version of the MacOS X package for the 5.6.11 MySQL version.

That package was compiled on a x86_64 machine.

Context

StackExchange Database Administrators Q#42813, answer score: 2

Revisions (0)

No revisions yet.