ramblings on PHP, SQL, the web, politics, ultimate frisbee and what else is on in my life
Follow up on hotspots
Admitedly I am not yet MySQL certified. So my last post was more based on knowledge of DBMS in general. A few people have noted that the issues described in my previous post might not apply to the InnoDB table handler. So I will need to research this a bit. Actually I am planning to become MySQL certified and so its quite handy that the new certification guide is to be released on august 19th.
Hotspots and how to avoid them
The other day a discussion in #mysql on freenode developed concering possible issues arising from using auto increment on primary key fields due to the danger of hotspots. Since I am currently preparing a new talk first to be held at php|works on SQL performance tuning I thought that the topic would make for a perfect warming up post on the general topic.
LiveUser realizes it has documentation
Well when ever people talk about integrating LiveUser into their project they usually at some point ask: "where is the documentation?" Or worse they say "I wasted hours to get this stuff working, it looks promising but I gave up".