what can this be ?

what can this be ?
Warning: mysql_pconnect() [function.mysql-pconnect]: Too many
connections in conn.php on line 28

Fatal error: Too many connections in conn.php on line 28

and the other day my table had crashed

and i dont have flush rights
the server tech support at manashosting is pathetic

finally i did a repair table which solved the problem
and the data was intact

what could have caused these problems

i am freeying the recordset appropriately
so that cant be the problem

On 7 Sep, 12:34, Hemanth <mvhema...@gmail.com> wrote:
> what can this be ?
> Warning: mysql_pconnect() [function.mysql-pconnect]: Too many
> connections in conn.php on line 28
>
> Fatal error: Too many connections in conn.php on line 28
>
> and the other day my table had crashed
>
> and i dont have flush rights
> the server tech support at manashosting is pathetic
>
> finally i did a repair table which solved the problem
> and the data was intact
>
> what could have caused these problems
>
> i am freeying the recordset appropriately
> so that cant be the problem

Do you really have a need to use permanent connections?

By the way:

Do not multi-post. Cross-post if you must but don't multi post
It wastes people's time.
http://www.blakjak.demon.co.uk/mul_crss.htm

Hemanth wrote:
> what can this be ?
> Warning: mysql_pconnect() [function.mysql-pconnect]: Too many
> connections in conn.php on line 28
>
> Fatal error: Too many connections in conn.php on line 28
>
> and the other day my table had crashed
>
> and i dont have flush rights
> the server tech support at manashosting is pathetic
>
> finally i did a repair table which solved the problem
> and the data was intact
>
> what could have caused these problems
>
> i am freeying the recordset appropriately
> so that cant be the problem
>

Why are you using pconnect()? Unless you're getting 100K hits/minute or
more, you'll be much better off with non-persistent connections.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

>
> Why are you using pconnect()? Unless you're getting 100K hits/minute or
> more, you'll be much better off with non-persistent connections.
>


hi
does pconnect cause any problem if the traffic is not very high ?

"Hemanth" <mvhemanth@gmail.com> wrote in message
news:1189407137.390922.66050@19g2000hsx.googlegrou ps.com...
> >
>> Why are you using pconnect()? Unless you're getting 100K hits/minute or
>> more, you'll be much better off with non-persistent connections.
>>
>
>
> hi
> does pconnect cause any problem if the traffic is not very high ?
>
not that i know much
but every time you run the page it's adding another connection

try

SHOW PROCESSLIST

it should show 1 connection, they one you are using currently

i thought normal connect created a connection every time its called
and pconnect only made a new connection if there wasnt an existing
connection...

am i mistaken here

Hemanth wrote:
>> Why are you using pconnect()? Unless you're getting 100K hits/minute or
>> more, you'll be much better off with non-persistent connections.
>>
>
>
> hi
> does pconnect cause any problem if the traffic is not very high ?
>

You're wasting system resources, among other things. When using
persistent connections, you must always have the maximum number of
connections ever needed allocated. So if you peak at 100 simultaneous
connections even once in the next year, you need at least 100
connections allocated all the time.

Non-persistent connections just have whatever is needed at the time. If
you need 100 connections, you will have 100 connections. But if you
only need 1 connection, you'll only have one connection.

Unless you're doing hundreds of thousands of connections per minute, you
shouldn't be using persistent connections. You're wasting system resources.

You're trying to optimize something which isn't a problem. Such
"optimizations" almost always lead to trouble.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================