Michael Fernández M. wrote:
Remember that you have to stay under 2GB total memory allocation! I
think you hit that limit.
Sorry, but why do you say that?, because of the 32 bits kernel?
Yes exactly. Depending on kernel version you can allocate something
between 2 or 2.7GB. Until 2GB it's safe, over 2GB there be dragons. If
you have lots of MyISAM tables the remaining memory can still be used
for the OS file cache.
which is the recommended value for: innodb_buffer_pool_size? in my case?
It's difficult to suggest a value here as I'd have to know full table
schemas and queries. I have a server with a mixed InnoDB/MyISAM setup
and 4GB RAM and set the buffer pool to 512M. You can fine-tune that with
SHOW ENGINE INNODB STATUS; which will tell you how much of the buffer
pool is in use.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
