Re: MyISAM table size vs actual data, and performance

2013-02-22 Thread Johan De Meersman
- Original Message - > From: "Rick James" Hey Rick, Thanks for your thoughts. > * Smells like some huge LONGTEXTs were INSERTed, then DELETEd. > Perhaps just a single one of nearly 500M. I considered that, too; but I can see the on-disk size grow over a period of a few months - it's

RE: MyISAM table size vs actual data, and performance

2013-02-21 Thread Rick James
InnoDB, the LONGTEXT will usually be stored separately, thereby making a full table scan relatively efficient. > -Original Message- > From: Johan De Meersman [mailto:vegiv...@tuxera.be] > Sent: Friday, February 15, 2013 4:21 AM > To: mysql. > Subject: MyISAM table size vs a

MyISAM table size vs actual data, and performance

2013-02-15 Thread Johan De Meersman
Hey list, I've got another peculiar thing going on :-) Let me give you a quick summary of the situation first: we host a number of Drupal sites, each site and it's db on separate VMs for reasons that are not important to this scenario. MySQL is 5.0.51a-24+lenny4-log (Debian); I don't have th