Thread:Project:Support desk/Gigabytes of data taken up by MySQL database for mediawiki installation/reply (2)

Note that, while you can even delete every table on the database or even the database itself, the file where all InnoDB tables are stored won't be shrunk (InnoDB storage options suck), but I guess that won't be the problem since you seem to run it on a shared web host.

You can also run SQL queries against the database to get what tables eat most of the space: or if you have access to phpMyAdmin it can display that information.

Note that every page edit stores the text of that revision of the page on the database, so if you do several edits to one page that is very large, the contents of the entire page will be saved on the database for every edit. If you have a bot editing userpages for inserting text ads you should try another system to inject the ads directly on the page when it's rendered instead of storing them in the page history.