The field_data_myfield and field_revision_myfield have the same row entries (D7 fields). All of my content types have the "Create new revision" unchecked. Is this how it's suppose to work? If yes, two questions 1) is this okay for scalability and 2) how do I stop drupal from renaming the files with _0 even when the original is deleted -- I read that this is because revision is on. If it's not suppose to work this way, how do I fix it.
I'm using mysql.
To clarify the end goal, I don't want the entire field deleted, I would like the fields not to track data revisions. Currently if field_body is updated, it also tracks it in field_revision body. Ideally, drupal would only save the update in field_body, and field_revision_body would be left empty. The content type is marked to not track revisions.