…, which database connection I should use: whether to use MYSQL_CONNECT(), or MYSQL_PCONNECT or MYSQLI_CONNECT. Please clarify all these connections with details and…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… script with prepared statements: < ?php $mysqli = new mysqli(“localhost”, “root”, “”, “test”); /* check connection */ if (mysqli_connect_errno()) { printf(“Connect failed: %s\n”, mysqli_connect_error()); exit(); } $query = ‘SELECT * FROM longf’; $time_start = microtime(true); if ($stmt = $mysqli->prepare($query…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
…(); # Establish connections foreach ($reader_hosts as $i) { $mysqli = new mysqli($i, ‘root’, ”, ‘test’); if ($mysqli->connect_error) { echo ‘Connect Error (‘ . $mysqli->connect_errno . ‘) ‘ . $mysqli->connect_error; }else{ $all_links[]=$mysqli; $mysqli->query… = $result->fetch_row(); # Handle returned result mysqli_free_result($result); } else die(sprintf(“MySQLi Error: %s”, mysqli_error($link))); $processed++; } } while ($processed < count…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of the… talk now about why Persistent connections were disabled in mysqli extension. Even though you could misuse persistent connections and get poor performance that…
Comment: Are PHP persistent connections evil ?
November 19, 2007 By 32 Comments
[...] will have again the possibility to use persistent connection (mysqli_connect(‘p:localhost’, …);). This is an interesting post about this [...]
Comment: Are PHP persistent connections evil ?
November 19, 2007 By 32 Comments
[...] will have again the possibility to use persistent connection (mysqli_connect(‘p:localhost’, …);). This is an interesting post about this [...]
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
September 4, 2011 By 48 Comments
…) Is there something existing like this already? I dumped the mysqli connection object in php, and I see nothing like that. Insert…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… rewriting. You also can use pretty much direct path to mysqli extension to performance critical queries if you need. I would… is not the main performance problem, also benefit from persistent connections can be much more modest. DVD Store was special type… which may do very little work and formating, so database connection may become the issue. Caching should be good help in…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… rewriting. You also can > use pretty much direct path to mysqli extension to performance > critical queries if you need. Nice but… is > not the main performance problem, also benefit from persistent > connections can be much more modest. DVD Store was special > type… which may do very little work and formating, so > database connection may become the issue. Caching should be > good help in…
Comment: HandlerSocket on SSD
April 6, 2011 By 9 Comments
… on db saturated) using 50 client threads when keeping the connection and opened index objects persistent… but this dropped to 10… doing MySQLi based PK lookups in Perl/PHP, I hit an almost identical limit (10,500), and then got failed connects… So using persistent connection objects for both MySQLi and HandlerSocket access methods I achieved 40…
