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.

phpMyAdmin - Error Incorrect format parameter restoring sql database on phpAdmin using Mamp

When I tried to restore a mysql database on phpAdmin, I got the following error: phpMyAdmin - Error Incorrect format parameter after a small search found the following article https://sitenetic.com/techie/mamp-error-phpmyadmin-error-incorrect-format-parameter/ The problem for me was that the database dump file was bigger than 32MB, and php was limited to 8/32 MB The fast solution for me, on MAMP console, selected Languages>PHP> and Open the default template There I changed the following parameter post_max_size = 128 M and the following parameter upload_max_filesize = 128 M MAMP offered to restart the servers, and I did, and then, I was able to restore my database!

Poncho´s Blog

Search This Blog