{"id":3268,"date":"2013-03-15T15:01:15","date_gmt":"2013-03-15T05:01:15","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=3268"},"modified":"2013-03-15T15:01:15","modified_gmt":"2013-03-15T05:01:15","slug":"innodb_sys_fields-vs-innodb_sys_columns","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2013\/03\/15\/innodb_sys_fields-vs-innodb_sys_columns\/","title":{"rendered":"INNODB_SYS_FIELDS vs INNODB_SYS_COLUMNS"},"content":{"rendered":"<p>In MySQL 5.6 we have two new INFORMATION_SCHEMA tables for InnoDB that are likely going to cause confusion: INNODB_SYS_FIELDS and INNODB_SYS_COLUMNS. You may think these are likely to just be aliases of each other in order to make your life easier. However&#8230;<\/p>\n<p>These are not the same thing. The INNODB_SYS_FIELDS table is all about key columns (fields) of InnoDB indexes, while INNODB_SYS_COLUMNS is about actual columns. This is even more confusing as within the MySQL source code, there is the Field set of objects that manipulate fields (columns) in a row.<\/p>\n<p>Blegh. I&#8217;m glad it&#8217;s Friday.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In MySQL 5.6 we have two new INFORMATION_SCHEMA tables for InnoDB that are likely going to cause confusion: INNODB_SYS_FIELDS and INNODB_SYS_COLUMNS. You may think these are likely to just be aliases of each other in order to make your life &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2013\/03\/15\/innodb_sys_fields-vs-innodb_sys_columns\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[14],"tags":[257,628],"class_list":["post-3268","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-innodb","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-QI","jetpack-related-posts":[{"id":2353,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/04\/12\/innodb-and-memcached\/","url_meta":{"origin":3268,"position":0},"title":"innodb and memcached","author":"Stewart Smith","date":"2011-04-12","format":false,"excerpt":"I had a quick look at the source tree (I haven't compiled it, just read the source - that's what I do. I challenge any C\/C++ compiler to keep up with my brain!) that's got a tarball up on labs.mysql.com for the memcached interface to innodb. A few quick thoughts:\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2147,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/09\/30\/what-was-innodb\/","url_meta":{"origin":3268,"position":1},"title":"What was InnoDB+?","author":"Stewart Smith","date":"2010-09-30","format":false,"excerpt":"Yes, I said InnoDB+ with a plus sign at the end (also see the first comment here). Please note that this blog post is only based on public information. It has absolutely nothing in it that I only could have learned from back when I worked at Sun or MySQL\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3312,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/04\/26\/a-few-notes-on-innodb-in-mysql-5-7-1\/","url_meta":{"origin":3268,"position":2},"title":"A few notes on InnoDB in MySQL 5.7.1","author":"Stewart Smith","date":"2013-04-26","format":false,"excerpt":"I've started poking around the MySQL 5.7.1 source tree (although just from tarball as I don't see a BZR tree yet). I thought I'd share a few thoughts: InnoDB temporary tables. Not REDO logged. What does this mean? It's a huge step in removing the dependency on MEMORY and MyISAM\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3801,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/09\/19\/mysql-architecture\/","url_meta":{"origin":3268,"position":3},"title":"Some current MySQL Architecture writings","author":"Stewart Smith","date":"2014-09-19","format":false,"excerpt":"So, I've been looking around for a while (and a few times now) for any good resources that cover a bunch of MySQL architecture and technical details aimed towards the technically proficient but not MySQL literate audience. I haven't really found anything. I mean, there's the (huge and very detailed)\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3338,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/05\/22\/some-storage-engine-features-you-only-get-if-youre-innodb\/","url_meta":{"origin":3268,"position":4},"title":"Some storage engine features you only get if you&#8217;re InnoDB","author":"Stewart Smith","date":"2013-05-22","format":false,"excerpt":"I had reason to look into the extended secondary index code in MariaDB and MySQL recently, and there was one bit that I really didn't like. MariaDB: share->set_use_ext_keys_flag(legacy_db_type == DB_TYPE_INNODB); MySQL: use_extended_sk= (legacy_db_type == DB_TYPE_INNODB); In case you were wondering what \"legacy_db_type\" actually does, let me tell you: it's not\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3685,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/02\/25\/ghosts-of-mysql-past-part-7-pbxt\/","url_meta":{"origin":3268,"position":5},"title":"Ghosts of MySQL Past, Part 7: PBXT","author":"Stewart Smith","date":"2014-02-25","format":false,"excerpt":"Recently, I\u00e2\u20ac\u2122ve been writing based on my linux.conf.au 2014 talk, which you can watch the recording of. Also see Part 1, Part 2, Part 3, Part 4, Part 5 and Part 6. My feed feel off Planet MySQL for a bit so you may have missed those posts - so\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=3268"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3268\/revisions"}],"predecessor-version":[{"id":3269,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3268\/revisions\/3269"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=3268"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=3268"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=3268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}