Do you know how to turn on the MySQL slow query log? In my experience, slow db queries are best debugged with this feature rather than SBS's sql logging. Among other things, the slow query log will tell you if a query is generating a Cartesian result set (http://www.rampant-books.com/t_hpsdba_77_cartesian_join_operations.htm). There have been Cartesian query bugs in SBS/SC in the past and the slow query log has uncovered them.
If you're using the "stock" mysql bundled with SBS, you'll need to make changes to my.tt. I think I'm going to try to enable this with a new SBS 7.5 embedded installation later today. I'll post the changes to my.tt necessary to do this. -- gharris999 ------------------------------------------------------------------------ gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115 View this thread: http://forums.slimdevices.com/showthread.php?t=73010 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
