Server slowing down...

deep

Hello!

Im currently running a php script that gets about 100 requests from internet users every second. The script is simple and only adds very little data to the mysql db.
The script only uses one INSERT command inserting only one bit to the DB and is very simple.

But its slowing down the server dramatically... Does anyone know how a problem like this can be solved?

I was thinking editing apache httpd.conf maybe?? But im new to running server alone so I need all the help I can get.

frost110

Are you using persistant connections to the DB. If so don't. Other than that we need code to tell why it is slowing down.

--FrosT

deep

Here is the code beeing called by 100s users every second:


   $db = mysql_connect($host, $user, $pass);
   mysql_select_db($dbname, $db) or exit;

   if(isset($_COOKIE[$_GET['a']]) == false){

  setcookie ($_GET['a'], "b", time() + 5000, "/");
  $ip  = getenv('REMOTE_ADDR');

  $sql = "INSERT INTO table (ip, count) VALUES ('$ip', '1')";
  $query = mysql_query($sql);

   }

   mysql_close($db);
   exit;

I use it to collect banner views and the 'table' is a Memory table to store fast... dont understand why its making the server go slow....?

frost110

If you are not inserting that data for every user why not just instantiate the connection inside the if statement? That way the database connection is only opened when it needs to be.

Other than that I am not sure. It should not make it slow at all. Check with your server administrator and ask if something is going on.

--FrosT

deep

I did do some testing and found that the delay starts when I use the mysql_connect function and then builds up when I use the INSERT query....

Im not sure what to do... tried changing values in httpd.conf but thats not helping...

frost110

Is the mysql server hosted locally or remotely?

--FrosT

deep

locally. I tested to comment out all the connect and query functions and the delay was still there... but its not a bandwidth problem because i tested it by replacing the current script with a webpage and that went smooth...

Maybe PHP is taking to long to "get started" on the page?

deep

Its confirmed!! Just by adding:

<?php ?>

Will slow down the server dramatically!!!??? .... help

frost110

Sounds like an issue with your php.ini file.

Try <? ?>

maybe? I do not see how it will help, but if that is the problem it is beyond my knowledge. Best of luck.

--FrosT

deep

didnt do it 🙁

Im looking into optimizing php now... if that dont help, ill have to change to another language... O_O (for this particular job, not the whole site ;-))

sf_dave

Is PHP installed as an Apache Module or run as a CGI binary? You can see by checking the Module lines of your httpd.conf, you should see something like:
... Some Modules...
LoadModule php4_module <path_to_module>

... Some Modules...
AddModule mod_php4.c

if it is configured as a cgi binary the OS must launch and kill a process for every php page.
-dave

deep

I found this in /etc/apache2/modules.d/70_mod_php.conf

<IfModule !sapi_apache2.c>
LoadModule php4_module modules/libphp4.so
</IfModule>

The file 70_mod_php.conf is included into httpd.conf

justsomeone

If the intialisation of PHP is a problem:

Try checking how many libraries you have included in your PHP install - removing any you don't need should increase the speed.
investigate using a PHP accelerator. These can work from bytecode representations of your HTML rather than text, and so don't have to encode each page, as it's already encoded.