The following are from the InnoDB configuration page:
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is 2GB
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
memory usage too high. |
glibc| may allow the process heap
Mayuran,
It depends on a bunch of things. What else is running on this server?
Does the distro you use have the ability to take advantage of all 16 gig
(ie if you have apache running, will it be stuck in the same 4 gig as
MySQL, or can it use the memory above the 4 gig limit).
How big is your