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

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.

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.

Workout pauses while running with Nikeplus on the iphone

This weekend I had my first real run with my Iphone and Nikeplus sensor. Usually I use my iphone only when running in a treadmill, and my ipod nano for running outside, buy since this was a 21K run and had the need for a phone, just in case, I decided to use my iphone. After 6 miles, things got weird, my iphone paused the workout for no apparent reason, so I began receiving the message, pausing workout, sometimes it came back on it´s own, sometimes I had to press play again, with my wet hands to continue. I tried moving it to another pocket to avoid any contact, but, it was locked, so there was no way that I could pause it by contact. The solution As always, easer that you may imagine. I took the earplugs out, and voila, the problem apparently was that there was a false contact in the earplugs, I was using the earplugs included with the ipod, with them, you cand do two things while running, turn the volume up and down, and ..... PAUSE THE WORKOUT so, my advice to you, use conve...