Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqlcheck -uroot -p --optimize --databases myDatabase
- SELECT Concat('OPTIMIZE TABLE ',TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES
- WHERE table_schema='yourdb';
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- MYSQL_DATA=mydb
- TBLLIST=""
- COMMA=""
- SQL="SELECT table_name FROM information_schema.tables WHERE table_schema=DATABASE()"
- for TBL in `mysql ${MYSQL_CONN} -D${MYSQL_DATA} -ANe"${SQL}"`
- do
- TBLLIST="${TBLLIST}${COMMA}${TBL}"
- COMMA=","
- done
- SQL="OPTIMIZE TABLE ${TBLLIST};"
- mysql ${MYSQL_CONN} -D${MYSQL_DATA} -ANe"${SQL}"
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- TBLLIST=""
- COMMA=""
- SQL="SELECT CONCAT(table_schema,'.',table_name) FROM information_schema.tables WHERE"
- SQL="${SQL} table_schema NOT IN ('information_schema','mysql','performance_schema')"
- for DBTB in `mysql ${MYSQL_CONN} -ANe"${SQL}"`
- do
- TBLLIST="${TBLLIST}${COMMA}${DBTB}"
- COMMA=","
- done
- SQL="OPTIMIZE TABLE ${TBLLIST};"
- set -x
- mysql ${MYSQL_CONN} -ANe"${SQL}"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement