[bind10-dev] some suggested topics for the team call

[JINMEI Tatuya / 神明達哉]

At Tue, 2 Oct 2012 15:57:43 +0200,
Michal 'vorner' Vaner <michal.vaner at nic.cz> wrote:

> > - PostgreSQL vs MySQL
> 
> MySQL uses table engines that don't support transactions by default. That's the
> main reason mysql is faster in many situations. What engine did you measure
> against?

Of course InnoDB (the most common one that supports transactions in
mysql).

| zones | CREATE TABLE `zones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `class` int(11) NOT NULL DEFAULT '1',
  `rname` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `zones_byrname` (`rname`(32))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 |

---
JINMEI, Tatuya
Internet Systems Consortium, Inc.