Ignacio_Romaguera answered on October 8th 19 at 02:03
9гб even for mysql is a small value. Look for a problem in another. For example, when data were few, it was noticeable the lack of an index on some more or less frequently used query.
Jordane_Douglas answered on October 8th 19 at 02:05
Not quite clear the original data. In addition to querying more importantly, are the PRIMARY indices.
To reduce the occupied disk space when clubsarahjean CPU, you can use the packaging text on the fly using COMPRESS/UNCOMPRESS.
aniya.Kertzmann65 answered on October 8th 19 at 02:07
Makes sense sometimes to make the text field in a separate plate if twitch data from this table without this field.
eloise_Hahn answered on October 8th 19 at 02:09
To store text articles in a database is silly — better to keep the link or to communicate directly with the room key. This approach you'll reduce the load on the database and increase the responsiveness of the server, because you can organize casiraya at the server level and PS. To search you need to use Sphinx.
Florine.Luettgen answered on October 8th 19 at 02:11
So maybe just base has grown so much that the indices did not fit in key_buffer and indexes now muscle just stopped usfsa?