Couple of months ago there was a post by FreshBooks on getting great performance improvements by lowering table_cache variable. So I decided to investigate what is really happening here. The “common sense” approach to tuning caches is to get them as large as you can if you have enough resources (such as memory). With MySQL [...]
For those who use Amazon EC2 service and were anxious about having XtraDB ready to launch there is a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How to use it. First make sure it is avaiable.
$ ec2-describe-images ami-4701e22e
IMAGEÂ Â ami-4701e22eÂ Â Â xtradb/centos-5.3-x86_64.fs.manifest.xmlÂ Â Â Â Â Â Â 834362721059Â Â Â availableÂ Â Â Â Â Â publicÂ Â Â Â Â Â Â Â Â x86_64Â machine
Run it. It is built for x86_64 [...]