Differences
This shows you the differences between two versions of the page.
| — | mysql [2015/06/02 03:42] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== MySQL ====== | ||
| + | * [[MySQL Character Sets]] | ||
| + | * [[MySQL Configuration]] | ||
| + | * [[MySQL Optimization]] | ||
| + | * [[MySQL OS X]] | ||
| + | * [[MySQL Logs]] | ||
| + | * [[MySQL Privileges]] | ||
| + | * [[MySQL Maintenance and Repair]] | ||
| + | * [[MySQL Security]] | ||
| + | * [[MySQL Source Installation]] | ||
| + | * [[MySQL SSL]] | ||
| + | * [[MySQL Statistics]] | ||
| + | * [[MySQL Views]] | ||
| + | * [[mysql prompt]] | ||
| + | * [[mysqladmin]] | ||
| + | * [[mysqldump]] | ||
| + | * [[mysqlreport]] | ||
| + | * [[InnoDB]] | ||
| + | * [[Percona]] | ||
| + | * [[phpMyAdmin]] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | === Howtos === | ||
| + | |||
| + | == Change update_date timestamp automatically == | ||
| + | |||
| + | < | ||
| + | |||
| + | == Show database sizes == | ||
| + | |||
| + | < | ||
| + | SELECT table_schema AS db, (SUM(data_length + index_length) / 1024 / 1024) AS mb FROM information_schema.tables GROUP BY table_schema; | ||
| + | </ | ||
