Man, giving a talk remote is always hard. Is my mic too soft? Can they hear me? Did some poor guy with a hearing aid just have it blown out ’cause I had my mic too loud? Am I pacing ok? What about handling questions?
Well, thanks to the expert help of Susie and Clint, I didn’t have to worry about any of this while giving my talk on Tuning Sugar Databases to SDUG. Everything functioned smoothly and the only thing I had to worry about was pacing myself, which seemed to work out good. Hopefully those who attended picked up a few new tricks. For those who didn’t get to attend live, we’ll have a recording of the webinar online soon. I’ll update when we do.
I promised some links during the presentation, so here you go. Our wiki is online @ http://www.sugarcrm.com/wiki/. There’s excellent info throughout the wiki, but the settings I touched on specifically are all outlined in Performance Tweaks for Large Systems, except one. Someone mentioned that there was no reference to
$calculate_response_time on the wiki, that is correct and will be fixed. In meantime, here’s a quick intro to it. Adding the following line to your config.php:
"calculate_response_time" = true,
Will get you output like:
The other links I mentioned where, in no particular order:
Also, for anyone who’s interested, the MySQL AB tool for automating many of the processes I outlined is MySQL Enterprise. If you’re short on people or expertise, outsourcing your DBA duties to the company that created MySQL is a great option.
Hope that helps get you started on tuning your SugarCRM installs on MySQL. If you have any questions that we didn’t get covered in the presentation or Q & A, post them here and we’ll get you answers.