How to find out if you are running 32-bit or 64-bit version of MySQL

I neeeded to update MySQL, installed using an automatic installer, so having passed a lot of time after I did the installation, I needed to know which version of MySQL I was running.

I found two was:

Inside MySQL console:

mysql>show global variables like "version_compile%";

The answer was:

+-------------------------+-------+
| Variable_name | Value |
+-------------------------+-------+
| version_compile_machine | x86 |
| version_compile_os | Win64 |
+-------------------------+-------+

As I understand this means that I am runnig x86 version of MySQL on a Windows 64 machine, so the answer for me is that I am running the 32 bit version.

x86 32 bits
i686 32 bits
x86-64 - 64 bits

The other way to get this information is using the command prompt, in your mysqld.exe location run:

mysqld --version

and you will get mostly the same information. As I understand Win64 refers to the machine I am running, and the other value to the mysql version.

Comments

vmware.exe - No Disk

I was trying to run vmware last nigh, and started receiving an error message, trying to open vmware, the moment I tried to opened, it a received the error. Vmware player was working OK, but I wanted to create a new virtual machine so I had to find a solution. The error message was: wmware.exe - No Disk There is no disk in the drive. Please insert a disk into drive \Device\Harddisk3\DR2. I looked everywhere, including the registry, trying to find a configuration option or something that could be wrong, and nothing helped. Then I discovered a couple of entries on vmware site that helped solving it. Apparently there is something wrong with the preferences file, locate in %APPDATA%\VMware\ preferences .ini for Windows ~/.vmware/ preferences for Linux Not wanting to spend all night trying to solve it, I first deleted de preferences.ini file without looking into it much with no luck. The solution: I deleted the directory VMWare, first I typed cd %APPDATA% in a command wi

com.pivotmobile.android.metrics file on my Android phone

I recently ran an scan on my phone using MVISION, the scan indicated that com.pivotmobile.android.metrics was sideloaded and that it should be deleted. I could not find any valuable information of its origin on the web, but looking at the application tab on my phone setting, I could find out that it was installed by Claro, my mobile service provider. So I went ahead and deleted, without a problem Take this with a little caution (backup before deleting, bla, bla, bla), but it looks to be a mobile service provider tracking file.

Ubuntu does not recognize windows partitions

Trying to install Ubuntu 12.10, the Ubuntu installer does not recognize that a Windows partition exists. Looking around, it seems kind an usual problem, but with not many real solutions. Browsing around I found an utility to "fix"my partition table. My partition table was working great in Windows, so "fix" is more appropriate than fix. http://www.rodsbooks.com/fixparts/ Being myself I Windows person, I selected the Windows version of the program: to run it I used fixparts 0: The first thing I got was: NOTICE: GPT signatures detected on the disk, but no 0xEE protective partition! The GPT signatures are probably left over from a previous partition table. Do you want to delete them (if you answer 'Y', this will happen immediately)? (Y/N): Now I understood the problem. I used this disk to install MacOS, and the leftovers made the problem. I selected, Y (for yes) and then w to save and exit. Booted Windows again to see everything was OK, and th

Poncho´s Blog

Search This Blog