List:General Discussion« Previous MessageNext Message »
From:Jani Tolonen Date:May 12 1999 12:55pm
Subject:Performance Problem under AIX ?
View as plain text  
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