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

There definitely seems to be some sort of issue with the mysqli driver on v3. I've been using 1.x and 2.x for years on the same server and development environment. This morning, I upgraded to 3.0 RC2, and I've been getting the same intermittent messages that others are reporting: "Message: mysqli::real_connect() [mysqli.real-connect]: MySQL server has gone away". The page takes forever to load, as it's waiting for some sort of timeout. This issue happens about 30% of the page loads.
For me, I turned off compression in the db config, and I haven't seen it since.
I'm connecting to mysql server 5.0.77 and have client api library 5.0.11. Also, PHP 5.6.5.

$db[$group]['dbdriver'] = 'mysqli';
$db[$group]['dbprefix'] = '';
$db[$group]['pconnect'] = TRUE;
$db[$group]['db_debug'] = FALSE;
$db[$group]['cache_on'] = FALSE;
$db[$group]['cachedir'] = '';
$db[$group]['char_set'] = 'utf8';
$db[$group]['dbcollat'] = 'utf8_general_ci';
$db[$group]['swap_pre'] = '';
$db[$group]['autoinit'] = TRUE;
$db[$group]['encrypt'] = FALSE;
$db[$group]['compress'] = FALSE; // Setting sompress to TRUE starts the intermittent connection issues
$db[$group]['stricton'] = FALSE;
$db[$group]['failover'] = array();
$db[$group]['save_queries'] = FALSE;
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