If you are frequently deleting many records, then that can cause
fragmentation. But if you are deleting that many records, you usually
are deleting "old" records. To work around this overhead, I usually
use MERGE tables. On a periodic basis you create a new table, add it
to the MERGE list w
I don't think this is indicative of a design issue. Some tables need
data removed more often than others, however Moon's Father brings up an
excellent point. If you CAN resolve this with a change in design, that
would be the best solution of course.
-Micah
On 11/17/2008 06:50 PM, Moon's Father wr
There is little performance hit due to this. It would only start to
affect performance when the overhead started to increase to the point
that it was a significant percentage of the total table size. Perhaps
someone else can ring in here with real numbers but I'd say it'd have to
be 10-20% of your
Maybe your tables were not properly designed.
On Tue, Nov 18, 2008 at 10:35 AM, sangprabv <[EMAIL PROTECTED]> wrote:
> Thanks for the reply, does this overhead reduce performance? And is
> there any tips to avoid this overhead? TIA.
>
>
> WM
>
>
> --
> MySQL General Mailing List
> For list archiv
Thanks for the reply, does this overhead reduce performance? And is
there any tips to avoid this overhead? TIA.
WM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, Nov 17, 2008 at 7:56 PM, sangprabv <[EMAIL PROTECTED]> wrote:
> Hi,
> I just want to know what things that cause table/db overhead? Because I
> have my tables always get overhead problem. And must run OPTIMIZE query
> every morning. Is there any other solution? TIA.
>
>
> Willy
What is hap
Deleted rows.
On 11/17/2008 04:56 PM, sangprabv wrote:
> Hi,
> I just want to know what things that cause table/db overhead? Because I
> have my tables always get overhead problem. And must run OPTIMIZE query
> every morning. Is there any other solution? TIA.
>
>
> Willy
>
>
>
--
MySQL Genera
Hi,
I just want to know what things that cause table/db overhead? Because I
have my tables always get overhead problem. And must run OPTIMIZE query
every morning. Is there any other solution? TIA.
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
