As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is probably one of… it. Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could… but they need some MySQL support to be properly implemented. Now with new “mysqlnd” driver for PHP effort by MySQL team I hope…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… asynchronous call to send a query to MySQL using a new MySQLnd driver for PHP. In this post I’ll only show… driver has been available since PHP 5.3, and in most part it mimics the standard MySQLi driver and functions it provides… die(sprintf(“MySQLi Error: %s”, mysqli_error($link))); $processed++; } } while ($processed < count($all_links)); As conclusion, we see that using PHP with MySQLnd…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… beat MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would go for using mysqli object… direct path to mysqli extension to performance critical queries if you need. I would also note for many PHP applications abstraction layer… growth it will however start to crawl. So developing you PHP applications use test database with reasonable amount of data in…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… small tables… but not for larger ones. First problem was PHP script generating the table took 10GB of RAM and was… apply to MySQL result set. OK there is “easy” fix for this problem, you can use mysql_unbuffered_query instead and mysqli and PDO have their own way to reach similar behavior. This call users underlying mysql_use…
Comment: Pitfalls of converting to InnoDB
February 26, 2007 By 16 Comments
… this is other story. No there is no option on MySQL level to solve this problem because only application knows what… actually can handle it on mysql wrapper you’re using or even for example in php extend mysqli class so it masks such…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…mysqli_query with MYSQLI_STORE_RESULT (used by default) is equal mysql_query, and with MYSQLI_USE_RESULT – is equal to mysql_unbuffered_query. Results: MYSQLI…
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
… PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10, so pretty recent + standard. I’m using the PHP mysqli API and doing a basic insert into an InnoDB table. My database class starts a transaction with a “$mysqli->autocommit(false)”, then executes an insert SQL statement, and completes with a “$mysqli->commit()”. It works fine…….. …… until PHP bombs mid…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would go for using mysqli object… rewriting. You also can > use pretty much direct path to mysqli extension to performance > critical queries if you need. Nice but… growth it will however start > to crawl. > So developing you PHP applications use test database with reasonable > amount of data in…
Comment: HandlerSocket on SSD
April 6, 2011 By 9 Comments
… the 10,000 qps limit when testing Handlersocket with both PHP and Perl, under certain conditions. i.e not persisting the… in every loop. Indeed… if I tried doing MySQLi based PK lookups in Perl/PHP, I hit an almost identical limit (10… persistent connection objects for both MySQLi and HandlerSocket access methods I achieved 40,000 qps via MySQL (avg but fluctuating between 20…
Comment: HandlerSocket on SSD
November 2, 2010 By 9 Comments
… the 10,000 qps limit when testing Handlersocket with both PHP and Perl, under certain conditions. i.e not persisting the… in every loop. Indeed… if I tried doing MySQLi based PK lookups in Perl/PHP, I hit an almost identical limit (10… persistent connection objects for both MySQLi and HandlerSocket access methods I achieved 40,000 qps via MySQL (avg but fluctuating between 20…
