Re: deleting data from large fragmented InnoDB table
EXPLAIN PARTITIONS SELECT * FROM alpha_calls_new WHERE createdOn = '2014-03-01'
id: 1
select_type_ SIMPLE
table: alpha_calls_new
partitions: p201408
type: ref
possible_keys: idx_createdOn
key: idx_createdOn
key_len: 8
ref: const
rows: 1
Subject
Views
Written By
Posted
2436
February 25, 2014 04:35AM
1148
February 27, 2014 12:20AM
1215
February 27, 2014 02:26AM
944
March 01, 2014 11:06AM
1102
March 03, 2014 03:19AM
1370
March 05, 2014 05:10PM
935
March 06, 2014 03:05AM
757
March 06, 2014 11:19PM
Re: deleting data from large fragmented InnoDB table
936
March 07, 2014 04:03AM
924
March 08, 2014 12:14PM
842
March 11, 2014 02:36AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.