A lot of details are missing...
Engine: MyISAM? InnoDB? other?
Let's see the SELECT.
If InnoDB, let's see the transaction, if it is part of such.
If InnoDB, which (COMPACT, etc) are you using.
You are asking about a single row with the 500MB, correct?
In general, each reques
Engine: MyISAM? InnoDB? other?
InnoDB
Let's see the SELECT.
select bytes from table_name where id = %d
If InnoDB, let's see the transaction, if it is part of such.
It's a single query
If InnoDB, which (COMPACT, etc) are you using.
Not sure
You