mysql_warmup

KO | EN

gitlite — search

#javascript #hacktoberfest #ai #typescript #llm #android #machine-learning #linux #docker #java #cli #kubernetes #openai #open-source

(★ 8)

Simple tool for warming up mysql server after create new/reboot

mysql_warmup Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# mysql_warmup
Simple mysql-wamup command tool for warming up mysql server after create/reboot <br/>
[Github](https://github.com/manhdaovan/mysql_warmup) <br/>
[RubyGems](https://rubygems.org/gems/mysql-warmup)

# Benchmark
[From 7.562 seconds to 2.132 seconds](./BENCHMARK.md)

# Background
With InnoDB storage engine, when you've just created new slave instance,
first requests to DB will be hit on disk instead of buffer poll. So, the requests will be slow down.
You can use this tool for warming up buffer poll before the first requests come.
[Detail](https://www.percona.com/blog/2008/05/01/quickly-preloading-innodb-tables-in-the-buffer-pool/)

# Usage
1. **When?**
  * You've set up new slave instance (base on Master-Slave model)
  * Your mysql version < 5.6, that not support [Saving and Restoring the Buffer Pool State](https://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html), and your mysql instance just reboot
  * Your mysql version >= 5.6, but you not config [Saving and Restoring the Buffer Pool State](https://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html), and your mysql just reboot
2. **How?**
  * Install this tool (please see `Install` section below)
  * Usage as below syntax

```
    Usage: mysql-warmup -u username <options>

Input options:
    -h host      : Host or ip of mysql instance
    -u username  : Username to access mysql instance
    -d database  : Database to warmup.
                   Default to all databases exclude information_schema, mysql, performance_schema, sys
    -p port      : Port to connect. Default to 3306
    --help       : Show help message
    --version    : Show mysql-warmup version
```

# Install
* Directly with command: `$gem install mysql-warmup`

* Or with `Gemfile` by adding line '`gem 'mysql-warmup`' to your `Gemfile` then `$bundle install`

# TODO
* RDoc

# Development
* All PR are welcome.
* Be sure all test cases are passed by command: `$rake test`

# Changelog
Please ref to [Changelog](./CHANGELOG.md)

# License
MIT

mysql_warmup

mysql_warmup Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

mysql_warmup

mysql_warmup Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README