Is disclosing a user's IP legal?

Question

MySQL

Can I disclose the ip of users to other users?

Is it somehow punishable, is the user's permission needed, or is there no problem at all?

Answer 1

If:
>About 100k records are added to the table every day, and therefore the table is very large.
and there is a problem with 5k elements - your site will not work.
Solution to the problem:
1 - index fields
2 - InnoDB
3 - base scaling
4 - ...

Answer 2

count itself is a simple operation. Most likely chooses for a long time. Is there an index?
What does EXPLAIN say?

Answer 3

> but the query itself, which returns 5000 elements, takes a long time to complete.
this cannot be. or non-indexed fields are used in the condition

Answer 4

Static IP - is PD.
Dynamic - no.
Most likely, some of your users will have a static IP. Thus, if you have not yet come up with a privacy policy for your service, then in theory it will be easy to win a case against you.