List:General Discussion« Previous MessageNext Message »
From:REIBENSCHUH Alfred Date:May 12 1999 2:40pm
Subject:RE: Performance Problem under AIX ?
View as plain text  
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   |
> +---------------------------------------------------------------------+
Thread
Performance Problem under AIX ?REIBENSCHUH Alfred12 May
  • Re: Performance Problem under AIX ?Terrence W. Zellers12 May
  • Performance Problem under AIX ?Jani Tolonen12 May
RE: Performance Problem under AIX ?REIBENSCHUH Alfred12 May