very slow inserts on InnoDB

2005-07-25 Thread Catalin Trifu
Hi, I have the following table : CREATE TABLE `raw_outgoing_sms` ( `id` bigint(20) NOT NULL auto_increment, `id_gsm_operator` bigint(20) NOT NULL default '0', `id_shortcode` bigint(20) NOT NULL default '0', `msisdn` varchar(20) NOT NULL default '', `sender`

Re: very slow inserts on InnoDB

2005-07-25 Thread Catalin Trifu
Hi, Thanks for the reply. The setup is the following: Dual Processor SuSE 9.0 (kernel 2.4.21 SMP), apache 2.0.54, php 5.0.4, mysql-4.1.12 (RPM), 2GB RAM, 80GB scsi RAID 5 The database config file is this one: [mysqld] port= 3306 socket =