Re: youtube video on pgsql integrity
От | Zdeněk Bělehrádek |
---|---|
Тема | Re: youtube video on pgsql integrity |
Дата | |
Msg-id | op.wojmvzcpgvy402@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: youtube video on pgsql integrity (Ray Stell <stellr@vt.edu>) |
Список | pgsql-general |
Dne Thu, 29 Nov 2012 16:00:55 +0100 Ray Stell <stellr@vt.edu> napsal(a): > > On Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote: >> is everything shown there really >> the behavior of the MySQL database itself? > > Good question. I intend to install mysql one day to explore, but just > can't find the time. The particular engine is not disclosed and I've > read some are better than others.... > It is behaviour of SQL parser, independent of storage engine. I tried it with MySQL in default settings, results are at http://pastebin.com/mbavfdj9 As you can see, your data will be changed on both mainstream engines. There is some "funny" effects created by this architecture (SQL parser and multiple storage engines), my favourite are the ones when InnoDB refuses to start (e. g. when you change innodb_log_file_size and forget to erase old innodb logs). Rest of MySQL starts happily, and even lets you drop tables belonging to unknown engine (InnoDB). When you realize your mistake and restart MySQL with functional InnoDB, you won't see the table (because SQL metadata are gone), but you can't create it either (because table metadata are still stored in InnoDB tablespace). -- Zdeněk Bělehrádek
В списке pgsql-general по дате отправления: