MySQL 5 x64 flies
- Published March 11th, 2008 in MySQL
I’ve just installed MySQL 5.0.51a x64 on my development machine (Mac OS X Leopard) and on my test machine (Ubuntu x64) and this is damn fast. No, really, you can notice the speed improvements over the x86 version even without having to run one single benchmark.
If you’re not upgrading from heavily different architectures (like *nix to Windows Windows to *nix) copying the entire data/ folder might pull the trick. Migrating from x86 to x64 works because MySQL doesn’t store any pointer or other architecture-dependent in the data files, otherwise you’d have to do a full dump and proceed with a restore of all the tables.
64 bits registers in database environments is definitely a blessing. Oh, and making use of more than 4GB of addressing space is also useful.




No Responses to “MySQL 5 x64 flies”