GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Anyone using a 64 bit OS on their server?

rowan · 03-27-2008, 05:34 PM

I must confess to not really doing any sort of methodical stress or performance testing so far, but I can say that the server is quite happily handling a database with over half a billion rows of data. The only issue is that if I set mysql's key_buffer value larger than about 4985M it seems to "wrap" and drops down to 900MB size. I don't think it's a FreeBSD issue (eg a per-process limit) because increasing the size of other buffers increases the total memory that mysql uses. Anyway, it's not a big worry since I can't expand the RAM further with the current mainboard, but it's something to keep in mind for the future.

03-27-2008, 05:34 PM
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	I must confess to not really doing any sort of methodical stress or performance testing so far, but I can say that the server is quite happily handling a database with over half a billion rows of data. The only issue is that if I set mysql's key_buffer value larger than about 4985M it seems to "wrap" and drops down to 900MB size. I don't think it's a FreeBSD issue (eg a per-process limit) because increasing the size of other buffers increases the total memory that mysql uses. Anyway, it's not a big worry since I can't expand the RAM further with the current mainboard, but it's something to keep in mind for the future.