JSON Storage Size Issue

[Preetham KV]

Hello.

We are using the json column to store some data in the table. For a particular row when we checked the JSON_STORAGE_SIZE( table.json_colum) the size used is 280KB. But the plain text json data size is just 1kb and also when we checked the SELECT JSON_STORAGE_SIZE('JSON_data'), the size required was 1.5kb.

Can someone explain why the table consumes a lot of storage size? What can we do to fix this?

Please let me know if needed any more information.

Thanks