Mysql-proxy is a neat tool that is badly needed to make remote MySQL server installations seem as if they were local (as in localhost). It is a convenience more than anything else. For example, if you are multi-tenant provider (a.k.a shared hosting provider), you would rather not ask your clients to set the db host to db.example.net [...]
Howdy! The above error can come up quite often on a busy database-driven website or it could happen at one time or the other for different reasons. Today, we are going to cover the main two reasons for it happening. I shall break this down by architecture. Linux x86_64 (64-bit) The Out of memory error [...]
This error is not specific to Litespeed but can be encountered while building PHP with MySQL support on 64-bit systems. The fix is to tell the build that the MySQL client is indeed installed, but in a different directory, by adding the following flag to the configure line in Litespeed: –with-libdir=lib64 The reason being the [...]
In this post, we shall go through the steps required to optimize a WordPress blog. If you are a current customer of UNIXy (http://www.unixy.net), do know that we are happy to implement these changes for your blog free of charge. We are a fully managed provider so do take advantage of it. Contact us today! [...]
Update (2011-02-16): If you’re interested in running Varnish with cPanel, UNIXY has created a cPanel Varnish plugin. Our Varnish VCL configuration performs much better than Litespeed. Read more about it here: http://www.unixy.net/varnish Update (2010-10-09): Should you be interested in a managed vBulletin dedicated server know that UNIXy has built a system that is ideal for [...]
The MySQL query cache is used to store data retrieved using SELECT statements. The advantage of the query cache is that subsequent and identical SELECT statement results are retrieved directly from the query cache, which resides in memory. So instead of executing the SELECT statements again and again, the stream of data is pulled from [...]
