收录日期:2021/02/27 03:25:59 时间:2009-03-14 03:18:31 标签:mysql,database,performance,runtime,query-optimization

I'm wondering if there's some sort of runtime mechanism that would observe the queries that are running against my database server; record how many queries of each "type" are running; look at the performance of these queries; then, based on this runtime data, suggest what indexes need to be added/removed.

I'm working against MySQL at the moment; if you know of similar tools for other DB vendors, I'd be interested to know, too. Thanks!!

I'd suggest giving Jet Profiler a try. The free version is a bit limited but i still found it useful. It will do most of what you have asked, but you may struggle to find a tool that will suggest indexes for you though.

how about the New MySQL Query Profiler (since 5.0.37)? google has some more.