Re: Major mysqli Problems
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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Major mysqli Problems
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" <[EMAIL PROTECTED]> 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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Major mysqli Problems
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" <[EMAIL PROTECTED]> 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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Re: Major mysqli Problems
Are you using persistent db connections? On Oct 30, 1:26 pm, "Luigi" <[EMAIL PROTECTED]> 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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---
Major mysqli Problems
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 cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~--~~~~--~~--~--~---