Catalin,
I was able to create the table with the CREATE statement you pasted, and
insert a row with some simple data.
mysql> insert into raw_outgoing_sms
(id_gsm_operator,id_shortcode,msisdn,sender,text,dlr_url) values
(10,20,'19284720','deva','hello world','yahoo.com');
Query OK, 1 row affected (0.02 sec)
As SGreen pointed out, there are lots of possible contributing factors.
Leaving out network, application, or disk latency, I wonder if the
slowness is caused by the InnoDB configuration on your server...
Could you send a copy of your server's my.cnf file, and some information
about the servers themselves (CPU, RAM, etc)? Seeing the configuration
parameters would help us to understand where your problem may be coming
from.
Regards,
Devananda vdv
Catalin Trifu wrote:
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` varchar(20) NOT NULL default '',
`ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`text` text,
`udh` text,
`data` text NOT NULL,
`dlr_status` varchar(20) default NULL,
`dlr_url` text,
PRIMARY KEY (`id`),
KEY `idx_outgoing_gsm_op` (`id_gsm_operator`),
KEY `idx_outgoing_shortcode` (`id_shortcode`)
) ENGINE=InnoDB
When i insert data into it it takes around 11 seconds. Why ?
Thanks,
Catalin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
