patternsqlMinor
MySQL version confusion
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
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
Now this:
and:
and this:
How can this be: 32 bit architecture after (obviously) downloading and installing 32 bit?
I am feeling lost.
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.1and 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.
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.