Re: file per table - innodb - high memory usage

[Markus Schindler]

Hi Phil,

unfortunately I was hoping that rc24 (used rc23 before) would fix it and at the time I needed to fix it, innodb plugin was not working with rc24 without building it from sources (I was to lazy to do so). So no results with innodb plugin. May check it on standby if time allows.

Below I copy a snipet of the create table statement:

CREATE TABLE `PM_VALUES_20080426` (
`PM_Sub3_id` int(10) unsigned DEFAULT NULL,
`PM_Sub2_id` int(10) unsigned DEFAULT NULL,
`PM_Sub1_id` int(10) unsigned NOT NULL DEFAULT '0',
`PM_Sub0_id` int(10) unsigned NOT NULL DEFAULT '0',
`PM_TIME_id` int(10) unsigned NOT NULL DEFAULT '0',
`VS.Column001` float DEFAULT NULL,
.
.
.
`VS.Column500` float DEFAULT NULL,
KEY `PM_VALUES_FKIndex1` (`PM_TIME_id`),
KEY `PM_VALUES_FKIndex2` (`PM_Sub0_id`),
KEY `PM_VALUES_FKIndex3` (`PM_Sub1_id`),
KEY `PM_VALUES_FKIndex4` (`PM_Sub2_id`),
KEY `PM_VALUES_FKIndex5` (`PM_Sub3_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY LIST (PM_Sub0_id)
SUBPARTITION BY HASH (PM_Sub1_id)
SUBPARTITIONS 10 (
PARTITION p0 VALUES IN (1) ENGINE = InnoDB
, PARTITION p1 VALUES IN (2) ENGINE = InnoDB
, PARTITION p2 VALUES IN (3) ENGINE = InnoDB
, PARTITION p3 VALUES IN (4) ENGINE = InnoDB
, PARTITION p4 VALUES IN (5) ENGINE = InnoDB
, PARTITION p5 VALUES IN (6) ENGINE = InnoDB
, PARTITION p6 VALUES IN (7) ENGINE = InnoDB
, PARTITION p7 VALUES IN (8) ENGINE = InnoDB
, PARTITION p8 VALUES IN (9) ENGINE = InnoDB
, PARTITION p9 VALUES IN (10) ENGINE = InnoDB
)
*/