Partitioning and performance

[Per Andersson]

Hi,

I've just started testing partitioning, but I can't get any good results out of it. The more partitions I add, the worse performance I get (INSERTS). What am I doing wrong?

CREATE TABLE `tmp_table`
(
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1
PARTITION BY RANGE (id)
(
PARTITION p0 VALUES LESS THAN (100001) ENGINE = MyISAM,
PARTITION p1 VALUES LESS THAN (200001) ENGINE = MyISAM,
PARTITION p2 VALUES LESS THAN (300001) ENGINE = MyISAM,
PARTITION p3 VALUES LESS THAN (400001) ENGINE = MyISAM,
PARTITION p4 VALUES LESS THAN (500001) ENGINE = MyISAM
)

I'm inserting 500000 rows from 5 concurrent clients. The clients are generating unique values for id (client 1 -> 1-100000, client 2 -> 100001-200000 etc.). As I stated above; the more partitions I add, the longer it takes. Creating the table without any partitioning at all is the fastest.