• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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
$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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.