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? I'm using MyISAM tables . mysql> select version(); +----------------+ | version() | +----------------+ | 4.1.8-standard | +----------------+ -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
