wait_timeout / mysql_pconnect

[csousley]

I've built a rather busy site that is having some memory issues due to mysql_pconnect. The machine has over a GIG of mem so it does ok for awhile, but it does end up slowing things down. So I wanted to change my wait_timeout variable and am having some issues. Here is what I get:

csousley% mysqld -O wait_timeout=3600
021009 12:26:53 Can't start server: Bind on TCP/IP port: Address already in use
021009 12:26:53 Do you already have another mysqld server running on port: 3306 ?
021009 12:26:53 Aborting

021009 12:26:53 ./bin/mysqld: Shutdown Complete

csousley%

Anyone have any thoughts, or is there a better way to do this. I have tried creating a my.cnf file and had no success with that either.

Thanks

-Cy

[gid]

sounds like mysqld is already running:

try using mysqladmin to change the wait_timeout variable like so:

mysql_admin -uuser -p --set-variabable wait_timeout=3600

As an experiment, have you tried change to just mysql_connect, if the database is running on localhost or even if it's not, then this might save valueable ram speeding things up tremendously, when the connect time might be negligible anyway. I'm just theorizing tho, I've never run a site that busy before. You might also want to look into other settings in you /etc/my.cnf file.

[tha_mink]

You may consider using mysql_free_result() in your code to free results that get buffered.

and as gid says...use mysql_connect instead of mysql_pconnect.