… I should use: whether to use MYSQL_CONNECT(), or MYSQL_PCONNECT or MYSQLI_CONNECT. Please clarify all these connections with details…
Post: Nginx Powers Hulu.com ?
November 1, 2007 By 12 Comments
…, but what is interesting is the server line which shows nginx 0.5.32 I have checked and indeed images served… first site of this (planned) scale to run Nginx. So far even though Nginx was used by many major companies in Russia…
Comment: mysql-proxy, urgh performance and scalability ?
February 11, 2013 By 44 Comments
If Ha proxy or mysql proxy is no good for you then please look into f5 load balancers for load balancing. Read/write can be done at application level aswell. Nginx can also be used for load balancing and is quite efficient and lightweight.
Post: Dot-Org Pavilion at the Percona Live MySQL Conference
February 8, 2012 By Leave a Comment
…-source project that’s interesting to MySQL users, such as Nginx, PHPMyAdmin, Drupal, Jenkins, PHP, and so on? Percona just published…
Comment: Innodb Performance Optimization Basics
November 1, 2011 By 75 Comments
Could you please indicate some values for 512 mb ram that runs nginx, php-fpm, mysql?
Comment: Impact of the number of idle connections in MySQL
January 24, 2011 By 21 Comments
I have same issue with idle connection on mysql. But my case, i’m using php to connect to mysql and i’m using mysql_pconnect(). with p as persisted connection. when the problem hit i simply replace function mysql_pconnect() with mysql_connect()
Comment: Caching could be the last thing you want to do
July 25, 2010 By 14 Comments
@Twirrim – similar experience here. We did experiment with varnish fronting things and did see a nice speedup. However some code changes are needed. Here’s a site we did some work for a hosting provider. http://nginx.openstream.ch/ But you are right, out the box performance is abysmal.
Comment: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… take advantage of all optimisations possible. 3) Ditch Apache, use nginx & FastCGI. Hard to understate how much of a performance drag…
Comment: APC or Memcached
January 11, 2010 By 23 Comments
… as costly connections to database. Use both, use it with nginx instead of Apache, and be prepared to be blown off…
Comment: Are PHP persistent connections evil ?
December 28, 2009 By 32 Comments
… they succumb to the gotchas. And the potential gotchas of pconnect are all symptoms of bad design themselves: having far too…
