Skip to main content

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

Post a Comment

Popular posts from this blog

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.
Post a Comment
Read more

http://localhost/sys/en/classic/login/login page not found installing ProcessMaker

I have been trying to install ProcessMaker using Wamp to avoid having several installations of MySQL, Apache and PHP. After serveral attemps I kept getting errors and could not make it work. My goal was to setup ProcessMaker in the following way. I tried using an alias instead of a Virtual Host. http://localhost/ProcessMaker As it turns out, it cannot be done that way. Whatever you do, you will not make it work (I guess there is a way, but yet have to find one, and would be not supported). The correct way would be something like http://ProcessMaker.localhost This would requiere changes in my hosts file and I guess I will have to go that way. The reference I found was this: http://forum.processmaker.com/viewtopic.php?f=5&t=249 Hopes to save you some time.
Post a Comment
Read more

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 ...
5 comments
Read more