In one of my previous posts I stated that in
Oracle's MySQL server some old enough features remain
half-backed, not well tested, not properly integrated with each
other, and not documented properly. It's time to prove
I should highlight from the very beginning that most of the features I am going to list are not that much improved by other vendors. But they at least have an option of providing other, fully supported storage engines that may overcome the problems in these features, while Oracle's trend to get rid of most engines but InnoDB makes MySQL users more seriously affected by any problems related to InnoDB.