006 00:02
To: Marvin Wright
Cc: mysql@lists.mysql.com
Subject: Re: Deletes on big tables
Marvin Wright wrote:
>I have 3 tables where I keep cache records, the structures are
>something like
>
>
>TableA is a 1 to many on TableB which is a 1 to many on TableC
>
>To give you
: Deletes on big tables
> 2.If I could split the tables up into smaller tables would this
> help ? My dilemma here is that I can split the data, the data would
> be in different tables but on the same hardware, the same number of
> deletes would still have to happen so would it actua
Marvin Wright wrote:
I have 3 tables where I keep cache records, the structures are something
like
TableA is a 1 to many on TableB which is a 1 to many on TableC
To give you an idea of size, TableA has 8,686,769 rows, TableB has
5,6322,236 rows and TableC has 1,089,635,551 rows.
My expir
2. If I could split the tables up into smaller tables would this
help ? My dilemma here is that I can split the data, the data would be
in different tables but on the same hardware, the same number of deletes
would still have to happen so would it actually make any difference ?
No idea a
