Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

mysql version 5 maximum memory on linux 64 bit

Posted on 2010-11-23
4
376 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:andieje
  • 2
  • 2
4 Comments
 
LVL 8

Expert Comment

by:wolfgang_93
ID: 34200877
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
 

Author Comment

by:andieje
ID: 34201333
so there isn;t an upper limit then?
0
 
LVL 8

Accepted Solution

by:
wolfgang_93 earned 500 total points
ID: 34201377
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
 

Author Closing Comment

by:andieje
ID: 34201396
thanks a lot
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
mysql joining from the same table 6 47
configure dependency in POM for new database 3 34
PHP: Insert Data into MySQL 5 56
UPDATE query not working in mysqli php 8 61
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question