So as you’ve probably heard, if your doing decent volume with anything your going to need MySQL 5.1 on your server. All good right? WRONG! MySQL is hard to upgrade to from an older installation or can just go wrong completely. Theres no commands you can drop in or something in cPanel you can click to do it either (not that I’ve found anyway).
So what Wes from P202 says is if your doing 5,000 clicks a day or so (not hard with social traffic) then your going to need it. MySQL has some horizontal partitioning or something like that (correct me if I’m wrong - I’m not sure lol) and that helps it bring the data up faster. The current version most of us are on is 5.0.* and most hosts won’t upgrade it for you unless you pay $75-150/hr for their time. That’s enough to get you spanking server right? Yep, and that’s what you should do.
Right now I’m with (more…)








