Dave:

In this case, Dar is correct. Even in the little Coxes the rod is always under compression unless the engine is missing fire - for example running in a "Four stroke" condition.

The socket gets hammered due to lateral acceleration of the rod, when it's going side to side at TDC and BDC. If the rpm is kept below 20K or so the loads aren't enough to beat it loose.

Bill.