: 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 actually make any
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 an idea of size, TableA has
Hi,
This is a bit of a long mail, so apologies in advance, I've tried to
five as much information as possible that I think might be useful
regarding my problem.
I have 3 tables where I keep cache records, the structures are something
like
TableA TableB TableC
Id
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
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