Hi,
I am currently running a large database (around 20Gb) on a 32bit x86
Linux platform. Many of my larger data-crunching queries are disk-bound
due to the limitation described in the innodb configuration documentation:
*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. It is a risk if the value of
the following expression is close to or exceeds 2GB:
Being a responsible citizen, I have my innodb_buffer_pool_size set below
2Gb. But the time has come to scale the application, so I need an
alternative solution that will allow me to set innodb_buffer_pool_size
as high as my heart desires (or at least well beyond 2Gb).
Do any of you have battle-tested recommendations?
How about FreeBSD? From what I can gather, it is a good idea to build
MySQL on FreeBSD linked with the Linux Thread Library. Would doing so
re- invoke the 2Gb limit?
I look foward to your collective responses. Thanks!
Brady
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
