Problems with mysql indexing

problem description

take over a new database, today found table data 50G, and then various indexes 75G, of which three large indexes are each around 23g, and most of the large indexes are bound to timestamps.

what result do you expect? What is the error message actually seen?

so now you need to optimize this table. How can I reduce the index size? In general, how to solve this kind of problem, and what are the steps

Menu