Monitoring ALTER TABLE Progress for InnoDB Tables Using Performance Schema.
See: https://dev.mysql.com/doc/refman/8.0/en/monitor-alter-table-performance-schema.html
Add this line to your application's Gemfile:
gem 'mysql_alter_monitoring'
And then execute:
$ bundle install
Or install it yourself as:
$ gem install mysql_alter_monitoring
All commands require the specification of host, user name, password.
It can also be specified in URL format using the --url option.
$ mysql-alter-monitoring enable --url mysql2://root:pass@localhost:3306
# When specifying host, user, password, etc. separately
$ mysql-alter-monitoring enable --host localhost --port 3306 --user root --password pass
$ mysql-alter-monitoring disable --url mysql2://root:pass@localhost:3306
$ mysql-alter-monitoring run --url mysql2://root:pass@localhost:3306
$ mysql-alter-monitoring run-forever --url mysql2://root:pass@localhost:3306
$ mysql-alter-monitoring -h
To develop on docker, build first.
$ docker compose build
Enter docker container and run rake task etc.
$ docker compose run --rm gem bash
# Run all specs
$ bin/rake spec
# Run specs individually
$ bin/rspec spec/mysql_alter_monitoring/monitor_spec.rb
# Run lint
$ bin/rake rubocop
# Run rubocop autocorrect
$ bin/rake lint:fix
# Generate and Check code documents
# Output to doc/index.html
$ bin/rake doc
Bug reports and pull requests are welcome on GitHub at https://github.com/akito-fujisaki/mysql_alter_monitoring.
This project is intended to be a safe, welcoming space for collaboration, and contributors are expected to adhere to the code of conduct.
The gem is available as open source under the terms of the MIT License.
Everyone interacting in the MysqlAlterMonitoring project's codebases, issue trackers, chat rooms and mailing lists is expected to follow the code of conduct.