V
V
Vladislav2020-11-13 15:37:20
MySQL
Vladislav, 2020-11-13 15:37:20

A 500 row table weighs 47 gigabytes! How to find the reason?

Good afternoon.
wp_options (utf8) is 47 gigs and has 500 lines in total. According to my calculations, these lines cannot weigh that much.
Autoincrement is already about 160,000.

Are there any hidden fields in the database? Caching or something like that? Where are these gigabytes of data stored? Count shows all the same 500 lines +/-
Who faced such a problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vladimir, 2020-11-13
@MechanID

Your table is too fragmented.
login to the server via sssh and do mysqlcheck -o "base name" "table name"

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question