June 20, 2013

Post: 10+ Ways to Crash or Overload MySQL

MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional. The limits which exist are not

Post: Paul McCullagh answers your questions about PBXT

InnoDB style “gap locking”. Gap locking effectively involves locking rows that do not exist. This, in turn, means that PBXT transactions are nottables use different engine types. The API does not yet support incremental backup, but this is planned. Internally

Post: Innodb Double Write

internally consistent. It does not matter which page version it is – it could be “current” version in which case Innodbin the tablespace it is recovered from double write buffer. How much does double write buffer affect MySQL