熱 MySQL 的方法…

看到 jnlin 寫的「利用 Percona Playback warm-up MySQL 資料庫…」,把之前用到的「用 pt-find 加熱 (暖機) InnoDB table」改良讓他可以平行跑,儘可能吃完 I/O capacity:

pt-find --charset=utf8 --print -h $1 -u USER -p PASSWORD | xargs -t -P8 -I% -n1 sh -c "echo 'SELECT COUNT(*) FROM %;' | mysql -h $1 > /dev/null"

Related Posts:

This entry was posted in Computer, Database, Murmuring, MySQL, Network, Software and tagged , , , , , , . Bookmark the permalink.