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 -~--~~~~--~~--~--~---
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 -~--~~~~--~~--~--~---
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 -~--~~~~--~~--~--~---
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
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 -~--~~~~--~~--~--~---