Return-Path: Delivered-To: apmail-httpd-users-archive@www.apache.org Received: (qmail 90886 invoked from network); 28 Jan 2005 01:16:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 28 Jan 2005 01:16:14 -0000 Received: (qmail 11407 invoked by uid 500); 28 Jan 2005 01:16:05 -0000 Delivered-To: apmail-httpd-users-archive@httpd.apache.org Received: (qmail 11301 invoked by uid 500); 28 Jan 2005 01:16:05 -0000 Mailing-List: contact users-help@httpd.apache.org; run by ezmlm Precedence: bulk Reply-To: users@httpd.apache.org list-help: list-unsubscribe: list-post: Delivered-To: mailing list users@httpd.apache.org Received: (qmail 11285 invoked by uid 99); 28 Jan 2005 01:16:04 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_60_70,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from tomts10.bellnexxia.net (HELO tomts10-srv.bellnexxia.net) (209.226.175.54) by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 27 Jan 2005 17:16:03 -0800 Received: from tim ([69.158.168.150]) by tomts10-srv.bellnexxia.net (InterMail vM.5.01.06.10 201-253-122-130-110-20040306) with SMTP id <20050128011559.EXLT19622.tomts10-srv.bellnexxia.net@tim> for ; Thu, 27 Jan 2005 20:15:59 -0500 Message-ID: <001e01c504d7$1fb59200$020aa8c0@parrysound.com> From: "Tim Burden" To: References: <001f01c504d6$65258f80$a601a8c0@mondego> Date: Thu, 27 Jan 2005 20:17:24 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01C504AD.36A407A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Checked: Checked Subject: Re: [users@httpd] Apache service at 100% cpu usage X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N ------=_NextPart_000_001B_01C504AD.36A407A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 300 kb is not a big database. Try better use of indexes. ----- Original Message -----=20 From: Pedro=20 To: users@httpd.apache.org=20 Sent: Thursday, January 27, 2005 8:12 PM Subject: [users@httpd] Apache service at 100% cpu usage hie, i need some help... i have the last version of apache V2, Mysql 4.1.9 and php 5.0.3... = and the last version of phpmyadmin. The problem is, when i try to execute one "sql comand" via phpmyadmin = and the sql file is "big" (big =3D 300kb +/-) the apache service go to = 100% CPU usage for some minutes... internet explorer some times show = time-out, some times the "sql comand" is finished but the cpu load is = very hight and is for some minutes...=20 Sory for the bad description, anyone can help me ? Thanks ------=_NextPart_000_001B_01C504AD.36A407A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
300 kb is not a big database. Try = better use of=20 indexes.
 
----- Original Message -----
From:=20 Pedro
Sent: Thursday, January 27, = 2005 8:12=20 PM
Subject: [users@httpd] Apache = service at=20 100% cpu usage

hie,
 
i need some help...
i have the last version of apache = V2,  Mysql=20 4.1.9 and php 5.0.3... and the last version of = phpmyadmin.
The problem is, when i try to execute = one "sql=20 comand" via phpmyadmin and the sql file is "big" (big =3D 300kb +/-) = the apache=20 service go to 100% CPU usage for some minutes... internet = explorer some=20 times show time-out, some times the "sql comand" is finished but = the cpu=20 load is very hight and is for some minutes...
Sory for the bad description, anyone = can help me=20 ?
 
Thanks
------=_NextPart_000_001B_01C504AD.36A407A0--