news <[EMAIL PROTECTED]> wrote on 07/25/2005 10:41:46 AM:
> 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
>
The time it takes to process any statement includes but is not limited to:
client encoding time (bundles your statement for transport)
network lag (the time it takes to get the bundled statement to the server)
statement parsing time (the processing required for the server to both
validate and understand the syntax of your request)
statement processing time:
wait for locks to clear (concurrent processes may be getting in
your way)
set locks
read/write data on disk (how slow are your disks?)
updating indexes, if necessary (again, how slow are your disks?)
clearing locks
network lag (the time it takes for the server to respond with the
completion status of your statement)
client decoding time (to unbundle the results from the networking
protocols)
Any or all of those may be causing your delay. You will have to provide us
more details about your setup before we could make a more educated guess.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
