Major mysqli Problems

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Major mysqli Problems

Luigi-6

Hi,

I just re-launched my organization's community blog using CakePHP:

http://www.blogforamerica.com

Unfortunately, the mysqli connection seems to be buckling under the
pressure. Every 45 minutes or so, the site just dies and gives me this:

Warning: mysqli_connect() [function.mysqli-connect]: (08004/1040): Too
many connections in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line
101

Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean
given in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 104

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 126


I have to restart Apache to get things going again. Any thoughts?
Should I switch away from mysqli? Thanks.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply | Threaded
Open this post in threaded view
|

Re: Major mysqli Problems

dkarlson

Are you using  persistent db connections?


On Oct 30, 1:26 pm, "Luigi" <[hidden email]> wrote:

> Hi,
>
> I just re-launched my organization's community blog using CakePHP:
>
> http://www.blogforamerica.com
>
> Unfortunately, the mysqli connection seems to be buckling under the
> pressure. Every 45 minutes or so, the site just dies and gives me this:
>
> Warning: mysqli_connect() [function.mysqli-connect]: (08004/1040): Too
> many connections in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line
> 101
>
> Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean
> given in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 104
>
> Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
> in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 126
>
> I have to restart Apache to get things going again. Any thoughts?
> Should I switch away from mysqli? Thanks.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply | Threaded
Open this post in threaded view
|

Re: Major mysqli Problems

Luigi-6

I'm using mysqli_connect. For some reason, trying out mysqli_pconnect
spits out errors.

Thanks!

dkarlson wrote:

> Are you using  persistent db connections?
>
>
> On Oct 30, 1:26 pm, "Luigi" <[hidden email]> wrote:
> > Hi,
> >
> > I just re-launched my organization's community blog using CakePHP:
> >
> > http://www.blogforamerica.com
> >
> > Unfortunately, the mysqli connection seems to be buckling under the
> > pressure. Every 45 minutes or so, the site just dies and gives me this:
> >
> > Warning: mysqli_connect() [function.mysqli-connect]: (08004/1040): Too
> > many connections in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line
> > 101
> >
> > Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean
> > given in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 104
> >
> > Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
> > in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 126
> >
> > I have to restart Apache to get things going again. Any thoughts?
> > Should I switch away from mysqli? Thanks.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply | Threaded
Open this post in threaded view
|

Re: Major mysqli Problems

Matt Adams

Luigi wrote:

> I'm using mysqli_connect. For some reason, trying out mysqli_pconnect
> spits out errors.
>
> Thanks!
>
> dkarlson wrote:
>> Are you using  persistent db connections?
>>
>>
>> On Oct 30, 1:26 pm, "Luigi" <[hidden email]> wrote:
>>> Hi,
>>>
>>> I just re-launched my organization's community blog using CakePHP:
>>>
>>> http://www.blogforamerica.com
>>>
>>> Unfortunately, the mysqli connection seems to be buckling under the
>>> pressure. Every 45 minutes or so, the site just dies and gives me this:
>>>
>>> Warning: mysqli_connect() [function.mysqli-connect]: (08004/1040): Too
>>> many connections in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line
>>> 101
>>>
>>> Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean
>>> given in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 104
>>>
>>> Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given
>>> in /path/to/cake/libs/model/dbo/dbo_mysqli.php on line 126
>>>
>>> I have to restart Apache to get things going again. Any thoughts?
>>> Should I switch away from mysqli? Thanks.

You need to increase your max_connections for MySQL.

General rule is one connection per-thread or process, I believe.


Cheers,

Matt
--
BASIC: A programming language.  Related to certain social diseases
in that those who have it will not admit it in polite company.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---

Reply | Threaded
Open this post in threaded view
|

Re: Major mysqli Problems

Luigi-6

Thank you Matt! Increased the max_connections to 500. Worked like a
charm I should've known better than to blame the CakePHP code. ;-)

For all those interested, here are two sites I've recently launched
built on CakePHP:

http://www.democracyforamerica.com/
http://www.blogforamerica.com/


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake PHP" group.
To post to this group, send email to [hidden email]
To unsubscribe from this group, send email to [hidden email]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---