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
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
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 General Mailing
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 happening
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]
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 archives:
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
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