… while still keeping MySQL connection open, others will serve static content such as images which also does not need MySQL connection open. In optimal… module or even use lighttpd with FastCGI all can fix this problem. Lets talk now about why Persistent connections were disabled in…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… case we can find php-cgi is holding connection in question (this is lighttpd based system with fastcgi) Now you know the… can find which connections does this process have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same host, which if usually bad idea) and connection to some external web…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general) of system … serving static content especially with many thousands of keep-alive connections. Lighttpd is often named as faster alternative. It is surely true… serving many millions of thumbnails it may not work well. Lighttpd 1.4 is single threaded and that single threads is…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… components in the system : (1) the RDBMS (in this case, Mysql) – think about memory settings, parameters, locking contention etc (2) The…€ to memcached, the load balancer, the switch, the network, the connection pool, lighttpd configuration”. Regards, Willem
