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 database? The innodb_buffer_pool_size holds data from
your database in memory; if you run a query, and the data is in the
buffer_pool, the query returns very quickly. If it is not in the
buffer_pool, then MySQL/InnoDB has to go to disk to get the data. If
your database is 100 megabytes, there is not much sense in setting a
buffer_pool of 1 gigabyte. If your database is 10 gigabytes, then you
will probably encounter some slowness as the disk is being accessed.
How many users will connect? Each user requires some memory for the
connection, for sorting, etc, etc.
The following equation gives you an idea of how much memory MySQL will
consume, based on various parameters:
innodb_buffer_pool_size + key_buffer + max_connections * (sort_buffer +
record_buffer) + max_connections * 2 MB
If you try to grab too much, mysql will crash. Check your distribution
to figure out what the max process size is.
David
Mayuran Yogarajah wrote:
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 to grow over thread stacks, which
crashes your server.
Can someone please explain what this means. We have a 32bit Linux x86
server with 16gigs of
ram. Because it is 32bit and not 64bit we cant really make much use
of all the ram. I am wondering
which values I can safely increase without crashing the server. Here
are some of the parameters we are
using in our conf file:
thread_concurrency = 16
table_cache = 512
innodb_buffer_pool_size = 1000M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
From SHOW INNODB STATUS:
BUFFER POOL AND MEMORY
--
Total memory allocated 462835472; in additional pool allocated 3569664
Buffer pool size 24576
Free buffers 0
Database pages 23956
Modified db pages 11531
Free buffers is 0.
Someone mentioned that because its a quad xeon each CPU would have
2gigs of ram to work with. Does this
mean that I can set the innodb buffer pool much higher ?
any feedback is welcome.
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
