How good it'd be to have 64 bit MySQL on 64 bit Linux ofcouse? Presently I have 32bit Mysql / OS but 64bit hardware. Shall I consider upgrade? What advantages do I have?
A:
You will get the main advantage of 64bit software - you will be able to address more RAM
Svetlozar Angelov
2009-12-16 11:05:13
A:
What advantages do I have?
Potentially bigger in-memory caches. And big caches can really help database performance ... in some cases. However, I've also noticed evidence that suggests that there is a limit to which application caches help, and that in some situations a OS level file caches work better at reducing disc IO delays.
For some hints on how 64bit MySQL (with appropriate tuning) might help, read How MySQL Uses Memory from the MySQL manual.
Stephen C
2009-12-16 11:09:05
How much? any comparisons?
kv
2009-12-16 11:11:46
Answers to questions like that will be highly application specific.
Stephen C
2009-12-16 11:28:50