… (search results, recent users, recent posts, etc) Full page output (relatively static pages) Full objects (user or cart object built from several… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort… Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL module Zend…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 5.6 a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list. Foreground threads can….mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php… bad, as Percona has a fix for it – http://bugs.mysql.com/bug.php?id=45892
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… 5.6 a background thread, buf_flush_page_cleaner_thread, should be moving all pages to the free list. Foreground threads can….mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php… bad, as Percona has a fix for it – http://bugs.mysql.com/bug.php?id=45892
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
One more bug that explains why LRU page flushing rate is much less than innodb_lru_scan_depth even if innodb_lru_scan_depth is large enough. Apparently fixed in 5.6.12 — http://bugs.mysql.com/bug.php?id=69170
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… for simple applications which may run query several times per page. I however would like to go further and have TTL… run multiple queries for multiple MySQL connections at once. For scale out applications data to generate the page may be on many…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… query you can get your PHP script running too long, well after user stopped waiting for the page to render and went… unfortunately very serious limitation in practice when you’re using MySQL with PHP as you can have single runaway query which takes… open another MySQL connection to kill the query which was running (otherwise query may well continue to run even if PHP script…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “… it. Persistent connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough so you could…. Many applications are fine – ie if you have read-only page and everything on your site uses same charset and does…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… be the code simply gets into the tight loop and page never gets generated) it also could mean some of external… stack trace originated from php stream functions not from libmysql or memcache.so, which means it is not MySQL or memcache connections… process are not only helpful to debug sleeping connections with MySQL but many other cases when you see web application locking…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1… files in directory or because random updates to 10000 distinct pages for index header updates not to mention modification time update… 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, you can still… solutions with MySQL Proxy I see have stern disclaimers against using it in production. Even the official manual page for MySQL Proxy 0.8.2 still says: “MySQL Proxy is currently an Alpha release and…
