What is the maximum memory a process (MySQL) can consume on a 32-bit OS?

Posted by mmattax on Server Fault See other posts from Server Fault or by mmattax
Published on 2010-03-30T17:43:05Z Indexed on 2010/03/30 17:53 UTC
Read the original article Hit count: 353

Filed under:

mysql

|

32-bit

|

32bit-64bit

|

memory

|

memory-usage

I have MySQL running on a 32-bit RHEL box. The server itself has 4GB total memory with 2GB allocated to MySQL.

I would like to know the max amount of memory I can put in the box and how much of that I can allocate to MySQL.

I have heard both 2GB and 4GB as the per-process-limit on a 32-bit OS...

Ultimately I'd like to know if I can increase the memory for MySQL without upgrading to a 64-bit OS.

© Server Fault or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about 32-bit

Enabling 32-Bit Applications on IIS7 (also affects 32-bit oledb or odbc drivers) [Solved]

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
We just bought a new Web Server, after installing Windows 2008 R2(which is a 64bit OS and IIS7), SQL Server Standard 2008 R2 and IBM Client Access for V5R3 with its Dot Net Data Providers, I tried deploying our new project which is fully functional on an IIS6 Based Web Server, I encountered this Error The… >>> More
I'm confuse about these 2 statements about performance of 32 bit application on 64 bit Windows 7....

as seen on Super User - Search for 'Super User'
Running some 32 bit applications on a 64 bit OS could actually be slower. The additional overheads in running 32 bit software in 64 bit mode could cause a slight degradation in performance. It will take some time for 64 bit software to become the norm. Source: http://www.w7forums.com/windows-7-64-bit-vs-32-bit-t484… >>> More
Map a 32 bit float to a 32 bit integer

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to map floats to ints or unsigned ints so that with the exception of NaN, order is preserved? So if a and b are floats, and F is the mapping function, a < b implies F(a) < F(b) and a == b implies F(a) == F(b) >>> More
PAE, 60 GB of Memory, 32 bit Windows Server OS vs 64 bit OS

as seen on Server Fault - Search for 'Server Fault'
I have 60 Gb of RAM on server. Windows 2008, 32bit with PAE. One Sql Server 2008 Express Instance can use 1 Gb of RAM. So if I install 60 instances, each can use 1 Gb of RAM, right? And the second question, what will be if I install 64bit system and use many Express instances? >>> More
Windows Server Certified as Secure Global Desktop Clients with EBS 12

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Secure Global Desktop provides secure access to centralized applications—Microsoft Windows, UNIX, mainframe, and midrange—from a wide variety of popular client devices, including Windows PCs, Oracle Solaris workstations, Linux PCs, and thin clients. Secure Global Desktop is certified… >>> More