… in parallel with MySQL asynchronous calls [/caption] This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was raised as to whether we can measure latency to all… calls, and in following posts how to measure latency to all nodes. PHP does not provide a way for parallel execution, so…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… still waste resources and add latency. The other problem with persistent connections is using too many MySQL server connections. Some people simply… 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: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is… like to be able to run multiple queries for multiple MySQL connections at once. For scale out applications data to generate… page may be on many different servers and it is latency killer to be required to query all of them sequentially…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different… unless you’re running 500 Apache children with mod_P (php,perl,python) per box (which is probably bad idea anyway… very good idea. One more benefit of local access to MySQL is latency. This was problem many years ago with 10Mbit network…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…helped dealing with performance problems (part MySQL related and part related to LAMP in general)… set in DNS configuration. This obviously adds latency especially for “aggregate” pages which may require … enforced. Serving file by simply reading from PHP or any other heavy programming language and …
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… good start for a ways to generally optimize MySQL load on the system. Latency Goal is another breed. The system may not… at Latency it is also much more practical to look from the top of the stack. If you look at MySQL log… this case we could spend a lot of time optimizing PHP code but because it takes only 10% of response time…
Comment: Are PHP persistent connections evil ?
January 17, 2007 By 32 Comments
… is that they reduce latency on the connect/disconnect/reconnect which, for Oracle, is more expensive than with MySQL. The good news is that SQL Relay’s performance here is comparable to PHP‘s persistent connections… X number of Oracle (or MySQL) connections and strives to maintain that number continually. Then, your PHP app connects and disconnects from…
Comment: HandlerSocket on SSD
April 6, 2011 By 9 Comments
…10,000 qps limit when testing Handlersocket with both PHP and Perl, under certain conditions. i.e not …HandlerSocket access methods I achieved 40,000 qps via MySQL (avg but fluctuating between 20,000 and 40,000…pretty fantastic results. Also try executing through a low-latency link if available…. //…
Comment: HandlerSocket on SSD
November 2, 2010 By 9 Comments
…10,000 qps limit when testing Handlersocket with both PHP and Perl, under certain conditions. i.e not …HandlerSocket access methods I achieved 40,000 qps via MySQL (avg but fluctuating between 20,000 and 40,000…pretty fantastic results. Also try executing through a low-latency link if available…. //…
Comment: Falcon Storage Engine Design Review
February 28, 2008 By 19 Comments
… in mysql-server level, it’s internally referred to as BKA (batched key access) It’s implemented for cluster (to reduce latency, instead of ordering reads) I’m not sure exactly which mysql version this will appear in. References: http://forge.mysql.com/worklog/task.php?id=2771
