Welcome Guest, Not a member yet? Register   Sign In
MySQL Codeigniter
#1

Hi all,

I meet the problem about MySQL "Too Many Connections" and i suspect this is causing by my MySQL script without close after run the query.

Actually, i'm using active record to do my query but all the time i didn't close mysql connection after run the query.

Does it will cause the issue too many connection?

some more, in config/database.php there is one option called $db['default']['pconnect']=TRUE, True value by default and the description said "Whether to use a persistent connection". what does it mean? will this causing too many connection too?

Any advise is appreciate!! Thanks !!
Reply
#2

(This post was last modified: 11-16-2015, 05:16 AM by InsiteFX.)

$db['default']['pconnect']=FALSE;

This should always be FALSE. even MySQL recommends it.

You can also check your MySQL my.ini settings file to make sure the connections are high enough.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply
#3

(11-16-2015, 05:15 AM)InsiteFX Wrote: $db['default']['pconnect']=FALSE;

This should always be FALSE. even MySQL recommends it.

You can also check your MySQL my.ini settings file to make sure the connections are high enough.

Thanks for advice~
Reply




Theme © iAndrew 2016 - Forum software by © MyBB