user stats - looking for info/download

[bill....@serverside-ts.com]

Hi,

Today I was looking for something that could tell me about index utilization in mysql. I would like to find and remove unused indexes

on a database I just started working with. Apparently the user stats "patch" will allow this information.

We are running mysql v5.0.84 on FreeBSD 7.2-STABLE

• Can we use a version of user stats with the version of mysql we are using?
  
• Where is the download for this? I keep getting redirected to this Percona site which appears to be it's own version of mysql. I can't introduce a change like that right now.
• Is this just an isolated drop in for mysql? Like I said, I need to minimize change as I am the new guy on this project and can't bring in the shutgun this early in the game

Any info you can provide is appreciated.

Thanks

Bill

[Ian Gulliver]

Hi Bill. We don't have any maintained MySQL 5.0 patches left. We have a 5.1 user stats patch on a branch here: https://code.google.com/p/google-mysql/

It's pretty far up our branch tree, however, so it may be tricky to apply by itself.

--
You received this message because you are subscribed to the Google Groups "google-mysql-tools" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-mysql-to...@googlegroups.com.
To post to this group, send email to google-my...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-mysql-tools?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[MARK CALLAGHAN]

There isn't one patch that you could apply to get table_stats & user_stats from the Facebook or Google patches for MySQL. Your best options are to use either Percona Server or MariaDB. 

On Wed, Feb 27, 2013 at 1:44 PM, <bill....@serverside-ts.com> wrote:

--

You received this message because you are subscribed to the Google Groups "google-mysql-tools" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-mysql-to...@googlegroups.com.
To post to this group, send email to google-my...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-mysql-tools?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Mark Callaghan
mdca...@gmail.com

[bill....@serverside-ts.com]

Not sure I can justify a whole new version of mysql just for this. Does Percona offer something that works with an existing mysql installation?

Thanks

On Friday, March 1, 2013 10:07:55 AM UTC-6, MarkCallaghan wrote:

There isn't one patch that you could apply to get table_stats & user_stats from the Facebook or Google patches for MySQL. Your best options are to use either Percona Server or MariaDB. 

On Wed, Feb 27, 2013 at 1:44 PM, <bill....@serverside-ts.com> wrote:

Hi,

Today I was looking for something that could tell me about index utilization in mysql. I would like to find and remove unused indexes

on a database I just started working with. Apparently the user stats "patch" will allow this information.

We are running mysql v5.0.84 on FreeBSD 7.2-STABLE

• Can we use a version of user stats with the version of mysql we are using?
  
• Where is the download for this? I keep getting redirected to this Percona site which appears to be it's own version of mysql. I can't introduce a change like that right now.
• Is this just an isolated drop in for mysql? Like I said, I need to minimize change as I am the new guy on this project and can't bring in the shutgun this early in the game

Any info you can provide is appreciated.

Thanks

Bill

--
You received this message because you are subscribed to the Google Groups "google-mysql-tools" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-mysql-tools+unsub...@googlegroups.com.

To post to this group, send email to google-my...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-mysql-tools?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Mark Callaghan
mdca...@gmail.com

[bill....@serverside-ts.com]

I went to the kink. Where do I run these commands? i.e. what is git? Do I need to install something to use it?

Thanks

On Wednesday, February 27, 2013 4:38:45 PM UTC-6, Ian Gulliver wrote:

Hi Bill. We don't have any maintained MySQL 5.0 patches left. We have a 5.1 user stats patch on a branch here: https://code.google.com/p/google-mysql/

It's pretty far up our branch tree, however, so it may be tricky to apply by itself.

On Wed, Feb 27, 2013 at 1:44 PM, <bill....@serverside-ts.com> wrote:

Hi,

Today I was looking for something that could tell me about index utilization in mysql. I would like to find and remove unused indexes

on a database I just started working with. Apparently the user stats "patch" will allow this information.

We are running mysql v5.0.84 on FreeBSD 7.2-STABLE

• Can we use a version of user stats with the version of mysql we are using?
  
• Where is the download for this? I keep getting redirected to this Percona site which appears to be it's own version of mysql. I can't introduce a change like that right now.
• Is this just an isolated drop in for mysql? Like I said, I need to minimize change as I am the new guy on this project and can't bring in the shutgun this early in the game

Any info you can provide is appreciated.

Thanks

Bill

--
You received this message because you are subscribed to the Google Groups "google-mysql-tools" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-mysql-tools+unsub...@googlegroups.com.