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.

Find MyISAM tables larger than 4 Gigs (plain)

1
2
3
4
5
SELECT table_schema,table_name,table_type,engine,table_rows,data_length/1024/1024/1024 as "size - Gigs"
FROM information_schema.tables
WHERE engine='MyISAM'
AND data_length > 536870912
ORDER BY table_schema,table_rows DESC;
[+] (1) more...
comments (1) flag fork
Typically tables should be converted to INNODB if they are 4 Gigs in size or larger - prdgreene 5 Years ago