Most efficient way to log user login IPs

Question

I am looking for ideas on how to log user's login IPs without compromising on performance in MySQL.

There are few primary tasks which the log would be used for:

Finding list of other users who have similar IPs (almost every time a user logs in)
Finding names of users with same IP
Finding all IPs used by the user and showing side by side other users who have similar IPs. (mainly to track ban-evaders) (by similar, I require at least 2 bytes of the IP to match)
Finding most recently used IP by a user when he is offline (was thinking if it would be better to add an IP column in the users table for each user)

Every user has a unqiue id known as database-id which is a number.

I need ideas on how to implement before I begin with the main focus on maximizing performance of the tasks mentioned above.

score 1 · Answer 1 · edited Apr 13 '17 at 12:42

1

Create an init_connect script that writes the user's session info to a table.

A better way would be to configure MySQL to log user activity to a table, as in Rolando's answer to this question: Audit logins on MySQL database

edited Apr 13 '17 at 12:42

Community

answered Jul 19 '16 at 13:19

Andrew Brennan

1 Answers1