So I have a pretty large MySQL DB... 7 Gigs in Total size, 35 million URLs.
I was querying it (using SELECT queries only) quite fast the other day. My ubuntu froze/shutdown (that's a first!) and said something online the lines of "panic, reverting to text console" - but she was frozen solid.
Upon rebooting my computer. Every MySQL table in the DB was fine, except for the one I was reading from. It said "in use".
Any idea what could have caused this? Surely MySQL is smart enough to know when a SELECTion has finished?
EDIT: Could it be that I need to start running a standalone MySQL server? I mean... this one's at 100%cpu almost constantly between running my PHP script to access it and MySQL having to dig through such a large DB...