Wednesday, October 3. 2012MySQL 5.6-RC: GTID vs. MyISAMTrackbacks
Trackback specific URI for this entry
No Trackbacks
Comments
Display comments as
(Linear | Threaded)
Out of curiosity, how would you expect Global _Transaction_ Identifier to work for a storage engine that does not transactions?
I don't think he expects it to work with MyISAM. I think he thinks the system tables should be InnoDB and personally I agree. Since the default storage engine is innodb, no_engine_substitution is now the default, etc, the system tables should be innodb. this should have been a high priority for oracle, including getting rid of .frm madness
I think I have to install a comment voting plugin just so that i can +1 what Justin just wrote.
Sorry, it wasn't clear given that none of this is actually mentioned.
> Now guess what mysql-install-db and friends are using?
It is worth noting that when mysql_install_db is to be used, mysqld is invoked with --skip-grant-tables. Hence, these tools use regular statements because the System Tables are not setup yet, and as a consequence, the privilege system is not working yet.
Loading of help tables also fails
http://bugs.mysql.com/bug.php?id=67073 Loading of time zone information is also bound to fail # mysql_tzinfo_to_sql /usr/share/zoneinfo/ | head -10 ... INSERT INTO time_zone_name (Name, Time_zone_id) VALUES ('Africa/Abidjan', @time_zone_id); [mysql]> show create table time_zone\G Table: time_zone Create Table: CREATE TABLE `time_zone` ( `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`Time_zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones' 1 row in set (0.00 sec) MyISAM in mysql.* has to go before GTID can be sucessfully deployed.
> MyISAM in mysql.* has to go before GTID can be sucessfully deployed.
I think you meant to say before it can be successfully deployed in your environment as it depends on how one bootstraps/manages the database. Getting rid of MyISAM system tables is a much larger problem scope (and something that I believe is in Oracle's plans).
It is quite a bit worse than that: Right now, the default RPM as distributed by Oracle will fail to install if it finds an otherwise valid /etc/my.cnf in place, because the installation process is subject to additional restrictions that normal operations have not.
In fact, I am pretty certain that this also breaks mysql_upgrade or has the potential to do so.
|
QuicksearchComments
about Wed, 31.10.2012 13:46
My friendly Offtopic Channel
in IRC has horror stories
about this, it is Halloween,
after all.
"Well, I do
have [...]
about Mon, 15.10.2012 09:41
What if we use SSDs. Can we
then assume memory limits
are not as significant
because SSDs can handle
random access [...]
about Fri, 05.10.2012 07:46
In fact, I am pretty certain
that this also breaks
mysql_upgrade or has the
potential to do so.
about Fri, 05.10.2012 06:44
It is quite a bit worse than
that: Right now, the default
RPM as distributed by Oracle
will fail to install if it
[...]
about Thu, 04.10.2012 18:52
> MyISAM in mysql.* has to go
before GTID can be
sucessfully deployed.
I
think you meant to say
before it can b [...]
about Thu, 04.10.2012 18:36
Sorry, it wasn't clear given
that none of this is
actually mentioned.
about Thu, 04.10.2012 13:47
You can turn it on with FLUSH
PRIVILEGES once the tables
exist.
about Thu, 04.10.2012 11:34
I think I have to install a
comment voting plugin just
so that i can +1 what Justin
just wrote.
Categories
Blog AdministrationDisclaimerAll examples, code-snippets, advice, trivia, etc. are supplied in the hope that they are useful, but no warranty of any kind is given. Use of trademarks is not intended as a challenge to them.
ImpressumCopyright 2005-2012 bei den jeweiligen Autorinnen der Beiträge. Die Infrastruktur von MySQL-dump wird betrieben von:
Azundris, Immanuelkirchstraße 18, 10405 Berlin, Germany
|