Skip to content

Instantly share code, notes, and snippets.

@manuke

manuke/mysql

Last active December 17, 2019 07:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save manuke/702390654d7de0a4ee5b5ee961c4cc8d to your computer and use it in GitHub Desktop.
Save manuke/702390654d7de0a4ee5b5ee961c4cc8d to your computer and use it in GitHub Desktop.
Download ZIP
mysql
Raw
mysql
# デフォルトは大文字小文字の区別をしない
http://daybydaypg.com/2017/08/12/post-227/
# delete後の不要領域回収
https://aws.amazon.com/jp/premiumsupport/knowledge-center/rds-mysql-storage-optimization/
# tablechecksum
pt-table-checksum h=192.168.10.9,u=percona,p='',P=3306 --no-check-binlog-format --no-check-replication-filter --databases ch,twilio
# slaveをmasterから発見する
pt-slave-find --host localhost
# table sync
pt-table-sync --verbose --dry-run --replicate d.t h=192.168.10.9,u=percona,p='',P=3306,D=d,t=table
# disk io realtime check
pt-diskstats
# system summary
pt-summary
# check optimize repair
mysqlcheck -c|-o|-r --all-databases
# tuner
mysqltuner.pl --user root
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment