Ok, smacking it hard into my face had worked !
for everyone interested onto the solution, i have set the
following options in /etc/my.cnf:
----------------------------------
[mysqld]
port=3306
socket=/tmp/mysql.sock
set-variable = key_buffer=16M
set-variable = max_allowed_packet=16M
set-variable = connect_timeout=20
set-variable = join_buffer=1M
set-variable = record_buffer=16M
set-variable = sort_buffer=4M
set-variable = table_cache=256
set-variable = wait_timeout=28800
----------------------------------
mfg. Alfred Reibenschuh
INFORMATIONSTECHNOLOGIE AUSTRIA GMBH
Telekommunikation - LAN/WAN-Services - Netzwerkmanagement
A-1020 Wien, Lassallestrasse 5
T: ++43-1-21717-58947
F: ++43-1-21717-58979
E: alfred.reibenschuh@stripped
> -----Original Message-----
> From: Jani Tolonen [SMTP:jktolone@stripped]
> Sent: Wednesday, May 12, 1999 2:56 PM
> To: REIBENSCHUH Alfred
> Cc: mysql@stripped
> Subject: Performance Problem under AIX ?
>
> REIBENSCHUH Alfred writes:
> > Hi !
> >
> > the machine is a ibm/rs6000 with 4x 323mhz, 2gb ram/4gb swap
> > i'm using AIX-4.2.1 at maintenance level 4.
> > i compiled mysql with egcs-1.1.1
> > i use perl-5.005_2 with dbi-1.0.6 and dbd-mysql-1.20.15
> >
> > sometimes during a huge number of inserts into the same
> > database/table the scripts gets the following errors:
> >
> > > DBD::mysql::st execute failed: Lost connection to MySQL server during
> > query at /opt/planet/scripts/proc.trap2db.pl line 73.
> > > DBD::mysql::st execute failed: MySQL server has gone away at
> > /opt/planet/scripts/proc.trap2db.pl line 73.
> >
> > if the php3 pages access the server/database at the same time
> > they abort with a similar error
> >
> > am i running into some timeouts, or is the huge amount of data
> > a problem (> 75mb) ?
> >
> >
>
> Hello!
>
> You might need to increase the value max_allowed_packet
> by starting your MySQL server with: mysqld -O max_allowed_packet=N
> where N should be at least as big as the biggest field you have
> in your table. For example, if you have any mediumtext or mediumblob
> fields, the max_allowed_packet should be at least 16777215.
> Please see section '7.2 Column types' from the manual.
>
> Can you print the $DBI::errstr ?
>
> If the above doesn't help, can you please provide more information
> about the problem? A some kind of test-program which will reproduce
> the failure. Please see section 'How to report bugs or problems'
> from the manual for more information.
>
> Regards,
>
> - Jani
>
> --
> +---------------------------------------------------------------------+
> | TcX ____ __ _____ _____ ___ == mysql@stripped |
> | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Jani Tolonen |
> | /*/ /*/ /*/ \*\_ |*| |*||*| mailto: jani@stripped |
> | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Helsinki |
> | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Finland |
> | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
> | /*/ \*\ Developers Team |
> +---------------------------------------------------------------------+
