WordPress page_rewrite_rules many URL rewrite mysql slow

There are use cases that Wordpress core isn’t well optimized for. The end result is poor page load and sub optimal performance. One of these use cases is the too-many-URLs or menu links issue. WP is then forced to break down these requests into smaller chunks to process them. Except that smaller chunks almost always amount to significant overhead especially with a high number of URLs. Here’s the fix.

Running mysql-proxy with cPanel remote mysql and proxy for localhost

Tweet 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 instead of the widely used localhost.