Closed
Bug 602622
Opened 14 years ago
Closed 13 years ago
weave tables are created with redundant indexes
Categories
(Cloud Services Graveyard :: Server: Sync, defect)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: jeff, Assigned: jeff)
Details
the key "usr_col_mod_pay" fully encompasses key "modified". Therefore, "modified" should be dropped. MariaDB [weave0]> show create table wbo74; +-------+-------------+ | Table | Create Table| +-------+-------------+ | wbo74 | CREATE TABLE `wbo74` ( `username` int(11) NOT NULL, `collection` smallint(6) NOT NULL DEFAULT '0', `id` varbinary(64) NOT NULL DEFAULT '', `parentid` varbinary(64) DEFAULT NULL, `predecessorid` varbinary(64) DEFAULT NULL, `sortindex` int(11) DEFAULT NULL, `modified` bigint(20) DEFAULT NULL, `payload` longtext, `payload_size` int(11) DEFAULT NULL, PRIMARY KEY (`username`,`collection`,`id`), KEY `modified` (`username`,`collection`,`modified`), KEY `usr_col_mod_pay` (`username`,`collection`,`modified`,`payload_size`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +-------+--------------+ 1 row in set (0.00 sec)
Assignee | ||
Comment 1•14 years ago
|
||
In fact, the decision was made with eng to drop usr_col_mod_pay instead. this is being done along with the alters in bug 604132
Assignee: nobody → jv
Assignee | ||
Comment 2•13 years ago
|
||
Done forever ago.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Updated•1 year ago
|
Product: Cloud Services → Cloud Services Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•