If you have the right level of logging turned on, you will see evidence in your query log.
Generally you see command sequences like Connect, Query, Query, Query, Quit. With prepared statements you would see Connect, Prepare, Execute, Execute, Execute, Quit. I don't know off hand if there is a good way to check if you don't have everything being logged. Nor do I know of a more quantitative measure. I'm pretty new to mysql. Richard On Thu, Jan 22, 2004 at 08:42:56AM -0500, Sid Lane wrote: > on a related note how can you verify that you're actually using a prepared > statement (re: not reparsing)? > > in Oracle you can watch ratio of executions/parse_calls in v$sqlarea but how can > you measure their effectiveness in mysql? > > obviously you can infer it with comparative tests of execution time/CPU load but > is there a definitive/quantitative way to tell/measure? > > just curious (though I freely admit I've yet to even download 4.1; still proof > of concepting on 4.0 so sorry if this is a RTM ?)... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
