MySQL Forums
Forum List  »  Partitioning

Re: file per table - innodb - high memory usage
Posted by: Markus Schindler
Date: May 06, 2008 07:20PM

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
)
*/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: file per table - innodb - high memory usage
3465
May 06, 2008 07:20PM


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.