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:
