[Pdns-users] transaction support in my db?

Steve Sobol sjsobol at JustThe.net
Thu May 13 01:50:48 UTC 2004


Bob Lockie wrote:
>> No, it wasn't. MySQL can use different storage engines, the default 
>> (MyISAM) doesn't support transactions, but InnoDB does. However, 
>> because it isn't the default, you have to specify "type=InnoDB" in 
>> your "CREATE TABLE" command for your transaction-enabled table.

Or BDB - the only difference is the type of locking each table type
does. And I've foudn that with non-transaction table types, the
transaction commands will just be ignored and inserts, etc will
proceed as normal - but of course it's safer to specify the right
type of table in the first place.


-- 
JustThe.net Internet & New Media Services, Apple Valley, CA   PGP: 0xE3AE35ED
Steven J. Sobol, Geek In Charge / 888.480.4NET (4638) / sjsobol at JustThe.net
Domain Names, $9.95/yr, 24x7 service: http://DomainNames.JustThe.net/
"someone once called me a sofa, but i didn't feel compelled to rush out and buy
slip covers." -adam brower * Hiroshima '45, Chernobyl '86, Windows 98/2000/2003



More information about the Pdns-users mailing list