Welcome Guest, Not a member yet? Register   Sign In
CI_DB_driver Bug?
#16

Y
(02-11-2015, 07:14 AM)Narf Wrote: Again, quoting that same manual:

Quote: You are using a Windows client and the server had dropped the connection (probably because wait_timeout expired) before the command was issued.

The problem on Windows is that in some cases MySQL does not get an error from the OS when writing to the TCP/IP connection to the server, but instead gets the error when trying to read the answer from the connection.

... you should've really read it yourself.

A persistent connection may decrease your page load time on your local setup, but that's because it's only you using the application. When deployed on production, with pconnect set to TRUE, each time you have more than 1 visitor at a time, the second (and third, fourth, etc.) will have to wait for the first person's request to be fulfilled before they can load a page.

pconnect is not a magic "improve my performance" switch. It has a specific purpose and comes with certain implications that are now the reason for your issue. Just turn it off.

You still just explained alternatives to the solution, the thing is, OK on production i'll disable pconnect and there wont be any queuing for visitor's queries. but on local i do need the speed for my work to be fast and i want to keep pconnect true, but i just don't want to see this damn warning, coz it does nothing and has no implications on my code, its a codeigniter behavior and there should be a way to suppress only this warning and not all the warning level notices. its like telling this warning that "Thanks for notifying but don't remind me again, because you are damn irritating. :\"
Reply


Messages In This Thread
CI_DB_driver Bug? - by Gavin - 11-03-2014, 08:29 AM
RE: CI_DB_driver Bug? - by kenji - 11-03-2014, 08:46 AM
RE: CI_DB_driver Bug? - by Rufnex - 11-03-2014, 09:29 AM
RE: CI_DB_driver Bug? - by Narf - 11-04-2014, 01:14 AM
RE: CI_DB_driver Bug? - by kilishan - 11-03-2014, 10:00 AM
RE: CI_DB_driver Bug? - by InsiteFX - 11-03-2014, 03:47 PM
RE: CI_DB_driver Bug? - by Gavin - 11-04-2014, 12:28 AM
RE: CI_DB_driver Bug? - by Rufnex - 11-04-2014, 02:05 AM
RE: CI_DB_driver Bug? - by summer - 02-10-2015, 12:19 PM
RE: CI_DB_driver Bug? - by InsiteFX - 02-10-2015, 09:03 PM
RE: CI_DB_driver Bug? - by summer - 02-10-2015, 11:47 PM
RE: CI_DB_driver Bug? - by summer - 02-11-2015, 06:26 AM
RE: CI_DB_driver Bug? - by Narf - 02-11-2015, 06:36 AM
RE: CI_DB_driver Bug? - by summer - 02-11-2015, 06:57 AM
RE: CI_DB_driver Bug? - by Narf - 02-11-2015, 07:14 AM
RE: CI_DB_driver Bug? - by summer - 02-11-2015, 11:33 AM
RE: CI_DB_driver Bug? - by Narf - 02-11-2015, 11:41 AM
RE: CI_DB_driver Bug? - by Narf - 02-11-2015, 11:45 AM
RE: CI_DB_driver Bug? - by summer - 02-11-2015, 01:49 PM
RE: CI_DB_driver Bug? - by Narf - 02-11-2015, 03:58 PM
RE: CI_DB_driver Bug? - by khoggatt - 02-11-2015, 10:21 PM
RE: CI_DB_driver Bug? - by summer - 02-11-2015, 11:19 PM
RE: CI_DB_driver Bug? - by Narf - 02-12-2015, 03:21 AM
RE: CI_DB_driver Bug? - by summer - 02-12-2015, 05:36 AM
RE: CI_DB_driver Bug? - by Narf - 02-12-2015, 06:32 AM
RE: CI_DB_driver Bug? - by khoggatt - 02-12-2015, 09:51 AM



Theme © iAndrew 2016 - Forum software by © MyBB