Re: Delete from mysql table is there a way to....
| From: | Frank Flynn | Date: | Tue, 16 Apr 2002 21:09:36 +0000 |
| Subject: | Re: Delete from mysql table is there a way to.... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18570@lists.php.net to get a copy of this message | ||
On 4/16/02 2:34 PM, "Lisi" <lists@shemeshdirectory.co.il> wrote:
> Thanks for the explanation! Very clear.
>
> How do you know how fragmented your DB is? I apologize if this is covered
> somewhere, like I said I was very confused buy this whole topic.
>
> Thanks,
>
> -Lisi
>
Oh, sorry each database is different but for MySQL it's:
SHOW TABLE STATUS FROM ... LIKE ...
In MS SQL it's:
sp_spaceused ...
In Informix it's:
onstat (-something I forget which but there help in onstat)
I forget Oracle but it's somewhere in the Enterprise manager...
Good Luck,
Frank
--
Frank Flynn
Poet, Artist & Mystic