We now have hardware in our test lab that represents the next generation of commodity servers for databases. It’s aÂ Cisco UCS C250 server, powered by two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount of memory. It has 384GB of RAM, […]Read more
During my visit to Moscow, Russia next month I’m going to give a full day training/tutorial presentation on Diagnosing and Fixing MySQL Performance Problems . This even will be based on updated and expanded tutorial from MySQL Conference & Expo which was so popular it was sold out earlier this year. […]Read more
Percona Server version 5.1.50-rel11.4 is now available for download.
The changes in this release include:
The primary purpose of this release is to update to the latest version of MySQL 5.1.
Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50.
innodb_use_sys_stats_table – The
table is now used only for non-temporary tables.
The binary packages are […]Read more
I wrote couple of weeks ago on dangers of bad cache design. Today I’ve been troubleshooting the production down case which had fair amount of issues related to how cache was used.
The deal was as following. The update to the codebase was performed and it caused performance issues, so it was rolled back but […]
I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables.Â My standard response has always been: “it depends on how much of a tradeoff you are willing to make for performance. In some situations the cost can be considerable”.