Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql8.0 support #41

Closed
longhaiqwe opened this issue Jan 16, 2019 · 3 comments
Closed

mysql8.0 support #41

longhaiqwe opened this issue Jan 16, 2019 · 3 comments

Comments

@longhaiqwe
Copy link

I use innodb_space for mysql8.0 ibdata1, the following errors occured:

$ innodb_space -s ~/install/mysql8.0/data/ibdata1 system-spaces
name                            pages       indexes
/home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/index.rb:33:in `page': undefined method `record_describer=' for #<Innodb::Page::FspHdrXdes:0x00000000ef85f8> (NoMethodError)
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/index.rb:13:in `initialize'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/space.rb:308:in `new'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/space.rb:308:in `index'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/data_dictionary.rb:282:in `data_dictionary_index'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/data_dictionary.rb:325:in `each_record_from_data_dictionary_index'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/data_dictionary.rb:364:in `each_index'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/data_dictionary.rb:448:in `each_index_by_space_id'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/space.rb:320:in `each_index_root_page_number'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/lib/innodb/space.rb:344:in `each_index'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/bin/innodb_space:207:in `each'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/bin/innodb_space:207:in `to_a'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/bin/innodb_space:207:in `block in system_spaces'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/bin/innodb_space:211:in `call'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/bin/innodb_space:211:in `system_spaces'
        from /home/longhai/.gem/ruby/gems/innodb_ruby-0.9.15/bin/innodb_space:1976:in `<top (required)>'
        from /home/longhai/bin/innodb_space:23:in `load'
        from /home/longhai/bin/innodb_space:23:in `<main>'

Does innodb_ruby is still not supported for mysql8.0?(I tested mysql5.7, it's ok)
If so, do we have a plan to support mysql8.0?

@sunbains
Copy link

sunbains commented Mar 1, 2019

8.0 support should be fairly easy (in theory). Dump the table space meta data using ibd2sdi and then parsing the output. ibd2sdi spits out the data in JSON format, there must be JSON parsers in Ruby that should make this task easier.

Any takers? :)

@junsionzhang
Copy link

8.0 support should be fairly easy (in theory). Dump the table space meta data using ibd2sdi and then parsing the output. ibd2sdi spits out the data in JSON format, there must be JSON parsers in Ruby that should make this task easier.

Any takers? :)

it would be awesome if someone can give the details or tools/

@jeremycole
Copy link
Owner

I created a blanket issue for MySQL 8.0 support, so I will consolidate the info and work there: #97.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants