Menu
Community /Pin to ProfileBookmark
@NogDogFeb 07.2006 — #100 requests per second = 100 new rows in the database per second?
So, after 10 hours you've added 3,600,000 rows to your database table???
I'm not sure what the overhead is for each row, but it's going to be quite a bit more than 1 bit. Other than looking at upgrading the hardware solution (faster server, more servers, faster disks, etc.), you can look athttp://dev.mysql.com/doc/refman/5.0/en/optimization.html for lots of info on MySQL optimization.@NogDogFeb 07.2006 — #You might want to try using mysql_pconnect() instead of mysql_connect(), but read http://www.php.net/manual/en/features.persistent-connections.php first for the various issues to consider.@NogDogFeb 07.2006 — #
Can you find out if PHP was installed as an Apache module (SAPI mode) or as a CGI install? If it was installed in CGI mode, then every script run has to launch its own instance of PHP, whereas in module mode Apache launches it once and then keeps it running.
Server slowing down…
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.
Sign in
to post a comment12 Comments(s) ↴
0
@NogDogFeb 07.2006 — #100 requests per second = 100 new rows in the database per second?So, after 10 hours you've added 3,600,000 rows to your database table???
I'm not sure what the overhead is for each row, but it's going to be quite a bit more than 1 bit. Other than looking at upgrading the hardware solution (faster server, more servers, faster disks, etc.), you can look at
0
@NogDogFeb 07.2006 — #You might want to try using mysql_pconnect() instead of mysql_connect(), but read 0
@NogDogFeb 07.2006 — #OMG!
Just by adding:
<?php ?>
to the page will slow down the server dramatically! Its eating the CPU and there is no code....???!!! I found this on 2 different servers with 2 different setups of PHP!
How can this be?[/QUOTE]
Can you find out if PHP was installed as an Apache module (SAPI mode) or as a CGI install? If it was installed in CGI mode, then every script run has to launch its own instance of PHP, whereas in module mode Apache launches it once and then keeps it running.