…. In many MySQL Projects there are not even dedicated MySQL people and Web developers simply use MySQL as they fit suitable and one of them assumes DBA roles and installs MySQL and chases developer… as well, such as lighttpd. In fact in this area MySQL Cluster, which was always best isolated of MySQL source leads the pack…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… Host “Apache” and Host “MySQL“: Port 3306 as connection in TCP/IP protocol is identified by pair of IP addresses and pair of… more expensive. Threads also take memory resources both on kernel and MySQL size but most problems seems to happen in case of… squid in front, use apache proxy module or even use lighttpd with FastCGI all can fix this problem. Lets talk now…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… not available and you’re not dealing with timeouts properly. Or may be you have several connections to MySQL server and right now… connection in question (this is lighttpd based system with fastcgi) Now you know the process and you can use your favorite tools… 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 which does… static content especially with many thousands of keep-alive connections. Lighttpd is often named as faster alternative. It is surely true… not work well. Lighttpd 1.4 is single threaded and that single threads is used to handle both network and IO which is…
Comment: Lighttpd as reverse proxy
June 18, 2008 By 28 Comments
To all. Regarding lighttpd vs ngnix. Lighttpd is used by youtube.com and wikipedia, so it is proven to be able to work in high load environment. When we started use lighttpd it… still begin active developed, while author of lighttpd is more interested in mysql-proxy development and lighttpd looks frozen, so I even agree that…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
… with that, and mk-query-digest is an excellent tool. I do not know of any comparable tool for mysql, but this… tell you how i tune, and what i’m missing. Mind you that i am new to mysql, so i just could…, the load balancer, the switch, the network, the connection pool, lighttpd configuration”. Regards, Willem
Comment: Nginx Powers Hulu.com ?
November 1, 2007 By 12 Comments
Thomas, Looking at project timeline http://trac.lighttpd.net/trac/timeline Jan is doing some work. Though I … before. I think MySQL Proxy is what excites Jan now and as this is also priority for Jan’s employer (MySQL AB) we…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
… 600 tracking events per second on our lighttpd tracking servers which currently works well and there is still some capacity available but… no MySQL bugs hitting us with this project so far. We use Innodb tables now because checking and repairing MyISAM is nightmare and PBXT which could be good for this work is just not ready. MySQL Performance is…
