- 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
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
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