Greetings,

I have a lot of past experience with tuning and timing on Oracle (quite
simple), but I seem to have hit a hurdle with timing my sql statements in
MySQL. Getting these timings are _incredibly_ important to finding
bottlenecks in a web site's performance...

Now, first, is it possible to turn on profiling for ZSQL methods? I've
turned on my Zope's profiling, and I can see statistics on how many times
sqlvar was called, but not specific zsql methods. Second, anyone familiar
with any mysql settings that will dump a log displaying real-time sql
executions and the corresponding execute time?

I like to turn sql timing on, then run around the site for a while, send
some people to test it out, or throw up a http load tester script up, and
then check the timing logs to see how things worked out.

Regards,

Knight
[EMAIL PROTECTED]


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to