Hi Catalin,
Here are some InnoDB performance tuning tips that may boost
your insert speed:
Catalin Trifu wrote:
...
innodb_buffer_pool_size = 256M
Higher is better, in fact pushing this up to 60%-80% on a
dedicated database would be good. If there are other things
running like a web server,
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 = /var/li
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 aff
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 defa
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` varcha
