Comments on: Basic Housekeeping for MySQL Indexes https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/ Mon, 12 Feb 2024 23:39:55 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: doublemarket https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/#comment-10967081 Mon, 03 Oct 2016 08:06:33 +0000 https://www.percona.com/blog/?p=37861#comment-10967081 Hello and thanks for the nice post. The ways written here are good especially for DBAs who don’t know well about the app using a database.

I translated this post into Japanese https://yakst.com/ja/posts/4236

Please let me know if it’s a problem.

Thanks again!

P.S. I also translated Morgan’s comment as an additional note 🙂

]]> By: Morgan Tocker https://www.percona.com/blog/basic-housekeeping-for-mysql-indexes/#comment-10966903 Fri, 09 Sep 2016 19:45:38 +0000 https://www.percona.com/blog/?p=37861#comment-10966903 Hi Daniel,

Good balanced discussion on how often to do house keeping 🙂

I just wanted to mention one thing – be careful when dropping seemingly redundant indexes. If a hint is used on a query, you will get an error rather than an alternative index selected.

As mentioned in Manyi’s interview last week – in MySQL 8.0 we will support invisible indexes for this purpose (hide first, then delete after some time). This will also help for case #1 that you mention.

– Morgan

]]>