scrap pad

mysql question: something big and nowhere to be found?

what would balloon to 700 mb while building a 70 mb mysql database? are there error logs recording every warning somewhere? (because there were a lot of warnings: I used IGNORE and inserted a lot of duplicates.) this space was very clearly being used up on my hd as I built the db (with a scrappy little script)

also, what are the files "ib_logfile0", "ib_logfile1", and "ibdata1" in /usr/local/mysql/data? (I suspect they're related to InnoDB tables, but how can I tell if I have any innoDB databases? - I might have played with them in the past, but not enough that I remember what/where/when). those three files are 5mb, 5mb, and 18mb (!) respectively.

Archives

who I am