Provided we are talking music wire, the ideal string tension is where it works the best, whatever "best" means to you, which I expect to be somewhere between rattling and breaking. I'd be happy, if a string simply feels and sounds right.
If you want to get more serious, you might refer to the D'Addario tension chart: In a mandolin medium set, the e-strings (0.011) have a tension of 23.1 lbs, the d-strings have 23.3 lbs. The a-strings, however, of the same medium set (0.015) have only 19.7 lbs. To my experience, on some mandolins, a thicker 0.016 a-string - 21.9 lbs - (as in the GHS medium set) sounds and feels just right, which is what you would expect, since the tension is closer to both the e-strings and the d-strings. But surprisingly, on some instruments, the thinner 0.015 a-string sounds and feels better.
Now if that's still not serious enough - refer to Roger Siminoff's findings, it's fun.
Bookmarks