Do you happen to have a really bad uptime for PHP’s APC, and it seems to randomly restart after 2 hours or so? Well, chances are that you are running cPanel/WHM on this server as well? The problem is that you need to enable Piped Loggin for Apache. This can be found under Apache [...]
FantasySP, Building a Better Upgrade Flow
A few weeks ago I came to the realization that my current implementation of upgrading and billing users on FantasySP using Paypal was pretty terrible. It was a clunky process where the user left my site to go to paypal, then they could sign in and/or input their credit card information. After that, they get [...]
Fix the WordPress SQL_CALC_FOUND_ROWS Bug
Anyone who has a WordPress blog with a lot of posts will eventually encounter an extremely slow query. I refer to this as the SQL_CALC_FOUND_ROWS Bug. If you have slow-query-log enabled then a query similar to this might have shown up before: SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID NOT IN (44682, 44657, [...]
My Review of New Relic, with some Performance Numbers
When optimizing your web application or server, the process can be a bit daunting. In fact, its usually something that is never fully checked off your to-do-list. The reason being is that you’ll never really know how your application will scale until it starts to show its growing pains. Just when you thought that you’ve [...]
Web Developers, You’re Not Alone
Web developers who plan to work alone, or are already doing so have a lot of obstacles to overcome. One of which is being isolated and having no like-minded professionals to turn to for advice and feedback. I know this one all too well and have been working alone for the past 5+ years on various [...]
jQuery vs Prototype, a newbies perspective
When I first started to dabble with javascript and ajax, Prototype was the only game in town that was making any headlines. So of course I used prototype with script.aculo.us . I was able to make some simple stuff, but my coding with Prototype wasn’t very elegant and it certainly wasn’t the best way to code things. [...]
How to restart Apache with PHP
If you ever need to restart Apache via PHP, you’ll notice that the “passthru” command doesn’t quite work out like you thought it would. For those of you who have cpanel and WHM installed, this will be an easy solution. cpanelmatt at the cpanel forums created an XML-API PHP class to be able to handle [...]