PHP has a function called phpinfo() that lets you see it's internal
settings.
It's reporting the mySQL client API as 3.23.22-beta... I'm using 3.23.36...
That's compiling PHP with it's internal client libraries for mySQL...
Maybe that's part of the problem?
I tried to compile PHP against the new mySQL libraries, but that won't even
build (I have a help request in on their mailing list...).
Are there enough differences between 3.23.23 and 3.23.36 that might be
causing connections to not drop?
Hunter
> From: "Andrew Schmidt" <[EMAIL PROTECTED]>
> Date: Wed, 25 Apr 2001 15:13:24 -0400
> To: "Hunter Hillegas" <[EMAIL PROTECTED]>, "mySQL List"
> <[EMAIL PROTECTED]>
> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>
> Who are web users logging in as? Take away their process_priv if they have
> it (unless they need it).
>
> Also, what version of php are you running? As old versions contained leaks
> in connections
>
> In the change log for php 4.0.4
> <cut>
> Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - they
> weren't properly closing the SQL connections (Zeev)
> <cut>
>
> regards,
>
> -- Andrew
>
> ----- Original Message -----
> From: "Hunter Hillegas" <[EMAIL PROTECTED]>
> To: "Andrew Schmidt" <[EMAIL PROTECTED]>; "mySQL List"
> <[EMAIL PROTECTED]>
> Sent: Wednesday, April 25, 2001 3:04 PM
> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>
>
>> Running mysqladmin -p proc reports:
>>
>> too many connections...
>>
>> That's why I can't diagnose it.
>>
>> I'm logging in as root. How else would I get process_priv? I haven't
> changed
>> any parameters so I should be able to get in but I cannot.
>>
>> What am I doing wrong?
>>
>> Hunter
>>
>>> From: "Andrew Schmidt" <[EMAIL PROTECTED]>
>>> Date: Wed, 25 Apr 2001 14:46:48 -0400
>>> To: "Hunter Hillegas" <[EMAIL PROTECTED]>, "mySQL List"
>>> <[EMAIL PROTECTED]>
>>> Subject: Re: MySQL 3.23.36 STILL Having Major Problems
>>>
>>> taken from the manual:
>>>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
>>> W_PROCESSLIST
>>>
>>> ----
>>> SHOW PROCESSLIST shows you which threads are running. You can also get
> this
>>> information using the mysqladmin processlist command. If you have the
>>> process privilege, you can see all threads. Otherwise, you can see only
> your
>>> own threads. See section 7.27 KILL Syntax. If you don't use the FULL
> option,
>>> then only the first 100 characters of each query will be shown.
>>>
>>> This command is very useful if you get the 'too many connections' error
>>> message and want to find out what's going on. MySQL reserves one extra
>>> connection for a client with the Process_priv privilege to ensure that
> you
>>> should always be able to login and check the system (assuming you are
> not
>>> giving this privilege to all your users).
>>> ----
>>>
>>> I believe you will want to do the second paragraph.
>>>
>>> regards,
>>>
>>> -- Andrew
>>>
>>> ----- Original Message -----
>>> From: "Hunter Hillegas" <[EMAIL PROTECTED]>
>>> To: "mySQL List" <[EMAIL PROTECTED]>
>>> Sent: Wednesday, April 25, 2001 11:21 AM
>>> Subject: MySQL 3.23.36 STILL Having Major Problems
>>>
>>>
>>>> OS: Red Hat Linux 6.0 / Intel
>>>> 1GB RAM
>>>>
>>>> MySQL 3.23.36
>>>> PHP4.0.4PL1
>>>> Linux kernel 2.4.3
>>>> Using the my.cnf for medium sized sites
>>>>
>>>> mySQL starts with safe_mysqld and there are three threads running.
> Queries
>>>> come in and out and it's quite fast. Using mysqladmin proc status shows
> no
>>>> queries running.
>>>>
>>>> After about 12 hours, the number of mySQL threads visible in ps have
> shot
>>> to
>>>> about 75. At this point the server reports "No More Connections", both
>>>> through PHP and from mysqladmin.
>>>>
>>>> What's going on here? I can't figure it out. I can't even get in to
>>> diagnose
>>>> the problem, since the server is out of connections. 99% of my queries
> are
>>>> SELECT's.
>>>>
>>>> It sounds like something is hanging on to connections and not returning
>>>> them... I'm using mysql_connect() in the PHP scripts.
>>>>
>>>> Any ideas? This has taken my Web site out about 5 or 6 times in the
> last
>>> two
>>>> weeks. It's no fun. Anything anyone could do to help would be great.
>>>>
>>>> Hunter
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> Before posting, please check:
>>>> http://www.mysql.com/manual.php (the manual)
>>>> http://lists.mysql.com/ (the list archive)
>>>>
>>>> To request this thread, e-mail <[EMAIL PROTECTED]>
>>>> To unsubscribe, e-mail
>>> <[EMAIL PROTECTED]>
>>>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>>>
>>>>
>>>
>>
>>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php