Comments on: Personal observation: more migrations from MyISAM to InnoDB https://shlomi-noach.github.io/blog/mysql/personal-observation-more-migrations-from-myisam-to-innodb Blog by Shlomi Noach Mon, 21 Jun 2010 00:03:24 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Arjen Lentz https://shlomi-noach.github.io/blog/mysql/personal-observation-more-migrations-from-myisam-to-innodb/comment-page-1#comment-15004 Mon, 21 Jun 2010 00:03:24 +0000 https://shlomi-noach.github.io/blog/?p=2517#comment-15004 Gwen: the INFORMATION_SCHEMA db does not contain any physical tables. They’re materialised as memory or disk temporary tables if you run queries on them. There’s other hideous inefficiencies related to the current implementation, but that’s another matter.See sql_show.cc if you want to peruse the source code on this.

]]> By: Arjen Lentz https://shlomi-noach.github.io/blog/mysql/personal-observation-more-migrations-from-myisam-to-innodb/comment-page-1#comment-15003 Mon, 21 Jun 2010 00:01:07 +0000 https://shlomi-noach.github.io/blog/?p=2517#comment-15003 Hi Shlomi

I don’t believe there’s been a significant shift in the existing trend, which was that people either deploy on or move to InnoDB.

Somewhat relevant is that non-Windows storage engine default becomes InnoDB from 5.5, but that’s something that others had already dealt with in my.cnf anyway. Nevertheless, good.

In terms of development, we have not yet seen any releases from the new Oracle+Sun. What we’ve seen so far was the earlier work led by Ken Jacobs at Oracle for the InnoDB 1.1 plugin, and Sun’s existing work on 5.5. Ken is no longer at Oracle. So we’ll have to see what the next release looks like, when it comes.

Regards,
Arjen.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/personal-observation-more-migrations-from-myisam-to-innodb/comment-page-1#comment-14872 Thu, 17 Jun 2010 03:32:03 +0000 https://shlomi-noach.github.io/blog/?p=2517#comment-14872 Hi,
I’m not an authority here, but here’s what I believe:
1. The mysql database will not transition to InnoDB in the near future: it’s just too much of a change for everyone.
2. Oracle owns MySQL & InnoDB. They have owned InnoDB for the past 4 years, and they have developed the InnoDB plugin.
Please see my earlier post on InnoDB plugin.

Regards

]]> By: Gwen Shapira https://shlomi-noach.github.io/blog/mysql/personal-observation-more-migrations-from-myisam-to-innodb/comment-page-1#comment-14858 Wed, 16 Jun 2010 18:49:56 +0000 https://shlomi-noach.github.io/blog/?p=2517#comment-14858 Do you think that the mysql and information_schema databases will ever transition to InnoDB?

As someone who recently started on MySQL, I’m a bit confused on the InnoDB plugin topic:
Does Oracle own the plugin? Will they merge it with the default distribution of MySQL? Will there always be an innoDB plugin as a separate entity with slightly more advanced features?

]]>