Alpha
Share and Organize Code
login register
HotNewTop
F.A.Q.
1. To begin adding code first register.
2. Create your own tags for code that you add.
3. To see your own code click Me, to see all code click Everyone, or filter by people rob.
4. To follow a user, click on their username, rob and hit follow.
5. Add other code to your library by clicking the
button near the code titles (note that you can not edit these codes).
6. To create a copy of a code that you can edit use fork.
7. If you can't find your code, double check your filter settings as you can filter by Category, User and Tag simultaneously.
8. Add comments to a code by clicking on it's title or the comments link underneath it.

Generate OPTIMIZE statements for any Fragmented tables (plain)

1
2
3
SELECT CONCAT('optimize table ', table_schema, '.', table_name, ';')
FROM information_schema.tables WHERE table_schema
NOT IN ('information_schema','mysql') AND data_free > 0 ORDER BY table_schema, data_free DESC;
comments (1) flag fork
This query will find fragmented tables, and spit out OPTIMIZE statements for you. - prdgreene 5 Years ago