mysql中table限制_mysql表行限制？(mysql table rows limit?)

It's very unlikely that you will approach the limitations of a MySQL table with two columns that are only integers.

If you're really concerned about query performance, you can just go ahead and throw an index on both columns. It's likely that the cost of inserting / updating your table will be negligible even with an index on the device ID. If your database gets huge, it can speed up queries such as "which users prefer this device". Your queries that ask "what devices do this user prefer" will also be fast with an index on user.

I would just say to make this table a simple two column table with a two-part composite key (indexed). This way, it will be as atomic as possible and won't require any of the tom-foolery that some may suggest to "increase performance."

Keep it atomic and normal -- your performance will be fine and you won't exceed any limitations of your DBMS