Re: Partitionierung bringt keine Performanceverbesserung

[Haribert Schnoeckel]

Entschuldigt bitte, diesen Post wollte ich noch gar nicht abschicken.

Ergänzungen:

DB-Version: 5.5.47-MariaDB-1~wheezy-log

SHOW CREATE TABLE ptest;

CREATE TABLE `ptest` (
`Date` date DEFAULT NULL,
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`text` varchar(32) NOT NULL,
UNIQUE KEY `Date` (`Date`,`id`),
KEY `in_key` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18944437 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (to_days(Date))
(PARTITION p0 VALUES LESS THAN (736336) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (736343) ENGINE = InnoDB,
[...]
PARTITION p49 VALUES LESS THAN (736679) ENGINE = InnoDB,
PARTITION p50 VALUES LESS THAN MAXVALUE ENGINE = InnoDB)

SHOW CREATE TABLE ptest_no_partitions;

CREATE TABLE `ptest_no_partitions` (
`Date` date DEFAULT NULL,
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`text` varchar(32) NOT NULL,
UNIQUE KEY `Date` (`Date`,`id`),
KEY `in_key` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18944434 DEFAULT CHARSET=latin1