|
|
Posted by seaside on 12/22/06 04:17
Jørn Dahl-Stamnes schrieb:
> Hello,
>
> I have been using mysql_connect in a script that display a lot of thumbnails
> for an album. Each thumbnail is displayed using the code:
>
> <IMG SRC="thm.php?id=some_id" ALT="some title">
>
> thm.php use a mysql_connect to the database to access the info about the
> picture based on the id.
>
> This worked fine. However, the SQL server is located on a different network
> than the web-server with a firewall between. When I looked into the
> firewalls log I saw that there was large amount of new connections when
> someone accessed the page where all the thumbnails was displayed.
>
> I then changed mysql_connect to mysql_pconnect on the scripts and viola...
> the amount of new connections to the SQL server dropped to only two.
>
> Good, I thought. But later I discovered that the SQL server had a large
> amount of childs running. I had 50-60 mysqld running on the system. This
> number was constant to below 10 before I changed to persistent mode.
>
> Any settings in the config file for the sql-server I need to be aware of?
>From the docs:
>>>
This means that for every child that opened a persistent connection
will have its own open persistent connection to the server. For
example, if you had 20 different child processes that ran a script that
made a persistent connection to your SQL server, you'd have 20
different connections to the SQL server, one from each child.
<<<
Do you always connect using identical hostname, userid and password? If
not, you'll get new persistent connections too.
Navigation:
[Reply to this message]
|