deck7uk wrote:We use 64bit for everything and find it far outperforms 32bit - especially for Mysql. Don't forget with 32bit you have a max table size of 4GB - if you keep large log/leads tables this can quite quickly become a problem.[/img]
We do have clients running 64bit MySQL and 32bit MySQL and I would not say there is a significant increase in performance using one over the other for VICIDIAL purposes. We have run the numbers on the same hardware moving from one to the other when we expected to have an improvement and it just wasn't there.
As for the 4GB file issue, Not true, this is a common misconception that for some reason keeps getting perpetuated. If you have --big-tables and --large-files then 32bit MySQL has no problems with >4GB files. For example take a look at this call_log_archive table:
mysql 7057231000 2008-12-09 00:30 call_log_archive.MYD
mysql 2929159168 2008-12-09 00:31 call_log_archive.MYI
mysql 9114 2008-12-07 03:23 call_log_archive.frm
There is also no issue if you have more than 4GB RAM on the server(another misconception). We have 32bit systems running only MySQL that have 8GB RAM and MySQL has no problem using more than 4GB. The limit is per-process, not per application so this is not a problem for 32bit MySQL.