Submitted by Dirk on 31 July, 2009 - 10:52
On one of my Typo3 installations I found an unusually large InnoDB file (Typo3's indexed_search being the culprit).
dev.mysql.com/doc/refman/5.1/en/adding-and-removing.html is a bit more complex. Instead of mysqldump (step 1 per documentation) I ran this SQL statement, following Nickolay Pelov's suggestion.
Here are the SQL statements I used to create the scripts to shrink this file:
use information_schema;
Submitted by Dirk on 19 May, 2009 - 10:10
Note to self: if you want to install Jaunty Jackalope (Ubuntu 9.04) on a Asus A8V-MX motherboard and you have SATA drives only, they will not be recognized unless you load the kernel with these options:
irqpoll noapic pci=nomsi
These options should be added to your grub boot configuration as well.
Pages
