You don't mention CPU type but do mention RedHat 9. Is this on 32-bit x86
hardware or something 64-bit? How do you set innodb_buffer_pool_size to anything
> 2GB on a 32-bit box if it is? I've got it set to 7GB on a dual Opteron box
with 8GB RAM with great results so far (in testing, go live next we
Hi,
> innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
> innodb_buffer_pool_size = 6G
it looks like your InnoDB tablespace is less than 2G.
If it is true then IMHO it doesn't make any sense to allocate 6G for
innodb_buffer_pool.
InnoDB won't use it.
Best regards,
Mikhail.
- Ori
I'd up your buffer sizes - the mysql manual has some clues as to setting
these values? You might want to increase the query cache size.
I'd then run it and watch the stats.
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
