httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Burden" <...@burden.ca>
Subject Re: [users@httpd] Apache service at 100% cpu usage
Date Fri, 28 Jan 2005 01:23:08 GMT
Simply put, you want to make sure there is an index on any field used in the WHERE or ON clause
of a query. There's more to it than that, but that's what I mean.
  ----- Original Message ----- 
  From: Pedro 
  To: users@httpd.apache.org 
  Sent: Thursday, January 27, 2005 8:17 PM
  Subject: Re: [users@httpd] Apache service at 100% cpu usage


  "Try better use of indexes."

  what you are talking about ??(sory if this is a stupid question...)

  thanks
    ----- Original Message ----- 
    From: Tim Burden 
    To: users@httpd.apache.org 
    Sent: Friday, January 28, 2005 1:17 AM
    Subject: Re: [users@httpd] Apache service at 100% cpu usage


    300 kb is not a big database. Try better use of indexes.

      ----- Original Message ----- 
      From: Pedro 
      To: users@httpd.apache.org 
      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 = 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... 
      Sory for the bad description, anyone can help me ?

      Thanks
Mime
View raw message