Migs, the high priest of Linux and server administration, whom I always look to for advice on such things, told me to write about my latest hosting issues and so I shall. I suppose this is a good way to talk and archive the recent problems I’d been having with the sites and what I do to fix it, and how I’m starting to realize that whatever ‘fix’ I do seems temporary since the site’s traffic increase again anyway that as soon as I enhance / improve performance, traffic increases again. I am therefore plagued, within days, by either mysql inefficiencies or run out of RAM. Anyway here’s a rundown:

Here’s a screenshot of Aug. 30’s mysql issues. WordPress serves that up when it can’t connect to the db. I emailed Rimuhosting about it and they figured out I was having issues with one of my favorite WordPress plugins called Counterize, which allowed me to produce those interesting stats at the footer of KikayEx which says ‘x number of visitors visited today, xx number the past 7 days. xxx number total since forever, and so on…‘. We activated an option on mysql to produce a ‘mysql-slow.log‘ which lists down all the mysql queries that take more than 2 seconds to complete. The results were stunning, as Counterize apparently had queries that take as long as 20 seconds, and at a given morning (not even a whole day), there were 40 queries already. Here’s how it looked:
If there’s any type of movie I’d say that best reflects my idea of Hollywood, it’s the big grand musical. Now I’m fairly aware that saying that sounds very gay, which I’m sure makes my homophobic girlfriend cringe. But hey, I’m not gonna lie. Big grand musicals are the epitome, to me, of what a ‘spectacular performance’ is. There’s great music, terrific melodies, and basically actors interpreting what they feel through feats of song and dance. Any story of great romance, deep despair, hate, fear, or anything for that matter, is made more meaningful and dramatic via moving performances filled with music and dancing.
Whatever’s the latest Harry Potter movie, it’s almost always the best one. Some people will argue, but in this case, I’m quite positive that a lot would agree that it is.