Re: Partitionierung bringt keine Performanceverbesserung
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
Subject
Views
Written By
Posted
1203
May 31, 2016 06:32AM
Re: Partitionierung bringt keine Performanceverbesserung
577
May 31, 2016 06: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.