Link to home
Start Free TrialLog in
Avatar of andieje
andieje

asked on

mysql version 5 maximum memory on linux 64 bit

Hi

Are there any upper limits on how much memory mysqlcan use on 64 bit linux. I want to give it as much as possible!

Thanks
Avatar of wolfgang_93
wolfgang_93
Flag of Canada image

Should you use the InnoDB engine for your tables -- a highly recommended
feature to ensure ACID compliance, robustness etc. -- you will want to set certain
configuration parameters in your my.cnf file to take advantage of the high speed
RAM memory which is 1000 times faster than disk -- to achieve a high hit-cache
ratio.

A rule of thumb I use is to take amount of RAM for the server, subtract 1
gig for operating system, subtract 1 or 2 gig for other stuff in MySQL and
other applications on the server. So if RAM is 8 gig, I would make sure
to have a line like this in my my.cnf config file:

#
# Set buffer pool size to 50-80% of your computer's memory
innodb_buffer_pool_size=5G

There of course other config parameters that could be bumped up to get
better performance, but this is by far the most significant one for tables
set up for InnoDB.

After changing any config parameters in my.cnf file, you should reboot
the server to ensure the changes are applied.
Avatar of andieje
andieje

ASKER

so there isn;t an upper limit then?
ASKER CERTIFIED SOLUTION
Avatar of wolfgang_93
wolfgang_93
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of andieje

ASKER

thanks a lot