Re: Index analyser

2010-02-25 Thread Baron Schwartz
Bryan, On Tue, Feb 23, 2010 at 6:09 PM, Cantwell, Bryan wrote: > > Ya, that one is helpful... just trying to land on a solution like I've seen > in other DB's that have index-advisor that listens and creates what it thinks > is the perfect indexes ... but thx... I know exactly what you are thi

RE: Index analyser

2010-02-24 Thread Andrew Braithwaite
February 2010 17:44 To: Cantwell, Bryan; mysql@lists.mysql.com Subject: RE: Index analyser There's also the Query Analyser http://www.mysql.com/products/enterprise/query.html which is part of MySQL Enterprise - I've never used it and it is very expensive but I believe it will advise on optima

RE: Index analyser

2010-02-24 Thread Andrew Braithwaite
lto:bcantw...@firescope.com] Sent: 23 February 2010 23:09 To: mysql@lists.mysql.com Subject: RE: Index analyser Ya, that one is helpful... just trying to land on a solution like I've seen in other DB's that have index-advisor that listens and creates what it thinks is the perfect

RE: Index analyser

2010-02-23 Thread Cantwell, Bryan
ebruary 23, 2010 4:33 PM To: mysql@lists.mysql.com Subject: Re: Index analyser At 03:28 PM 2/23/2010, you wrote: >Is there still no such thing anywhere for Mysql as an index analyser? >Many others have such a thing that will sit and monitor db activity over a >poeriod of time and suggest the ex

Re: Index analyser

2010-02-23 Thread mos
At 03:28 PM 2/23/2010, you wrote: Is there still no such thing anywhere for Mysql as an index analyser? Many others have such a thing that will sit and monitor db activity over a poeriod of time and suggest the exact indexes on each table based on what it has seen to improve performance

Re: Index analyser

2010-02-23 Thread edberg
On Tue, February 23, 2010 1:28 pm, Cantwell, Bryan wrote: > Is there still no such thing anywhere for Mysql as an index analyser? > Many others have such a thing that will sit and monitor db activity over a > poeriod of time and suggest the exact indexes on each table based on what >

Index analyser

2010-02-23 Thread Cantwell, Bryan
Is there still no such thing anywhere for Mysql as an index analyser? Many others have such a thing that will sit and monitor db activity over a poeriod of time and suggest the exact indexes on each table based on what it has seen to improve performance Anyone got that for MySQL?