Correct place to put very large text field for mysql/mariadb
I'd suggest you split this large column off into its own table.  While you're there take out any other columns which are only used once in a blue moon.  (The smaller your row the faster your queries will run.)

I'll take your current table as MyData.  Rename it to, say, MyData_Crucial.  Let's call the new table MyData_Sometimes.  Create this view:

create view MyData
select
    &lt;all the columns&gt;
from MyData_Crucial
inner join MyData_Sometimes
    on &lt;primary key&gt; = &lt;primary key&gt;


Now, assuming your optimizer is at least a little bit clever, you will not need to change your application code at all.