maria-developers team mailing list archive

Thread
Date

WL#231 New (by Monty): Faster UNIQUE key generation with ALTER TABLE

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: worklog-noreply@xxxxxxxxxxxx
Date: Wed, 27 Jul 2011 16:49:50 +0000 (UTC)

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: Faster UNIQUE key generation with ALTER TABLE
CREATION DATE..: Wed, 27 Jul 2011, 16:49
SUPERVISOR.....: Monty
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-RawIdeaBin
TASK ID........: 231 (http://askmonty.org/worklog/?tid=231)
VERSION........: Server-5.5
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 30 (hours remain)
ORIG. ESTIMATE.: 30

PROGRESS NOTES:



DESCRIPTION:

Faster UNIQUE key generation with ALTER TABLE

Generate also unique keys by sorting (as we do with non unique keys) to speed up
alter tables with unique keys significantly.

This worklog is for doing this for MyISAM and Aria tables. 


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v4.0.0)