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
andiejeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wolfgang_93Commented:
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.
0
andiejeAuthor Commented:
so there isn;t an upper limit then?
0
wolfgang_93Commented:
There was an upper limit for 32 bit of 2 gig or so because of the limitations of
32 bit. For 64 bit, the memory limit is not an issue. Use as much as is available
on the server and that makes sense in the context of what you are running
on the server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
andiejeAuthor Commented:
thanks a lot
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.