如何设计一个高性能的MySQL表结构来实现日志管理功能？

CREATE TABLE `login_log` (
  `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `user_id` INT(11) NOT NULL,
  `login_time` DATETIME NOT NULL,
  `login_ip` VARCHAR(50) NOT NULL,
  INDEX (`user_id`),
  INDEX (`login_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Timestamp;

public class LoginLogDAO {
    private Connection getConnection() throws SQLException {
        // TODO: 获取数据库连接
    }

    public void insert(LoginLog log) {
        String sql = "INSERT INTO login_log(user_id, login_time, login_ip) VALUES(?, ?, ?)";
        try (Connection conn = getConnection();
             PreparedStatement pstmt = conn.prepareStatement(sql)) {
            pstmt.setInt(1, log.getUserId());
            pstmt.setTimestamp(2, new Timestamp(log.getLoginTime().getTime()));
            pstmt.setString(3, log.getLoginIp());
            pstmt.executeUpdate();
        } catch (SQLException e) {
            // TODO: 异常处理
        }
    }
}

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class LoginLogDAO {
    // ...

    public List<LoginLog> getByUserId(int userId) {
        String sql = "SELECT * FROM login_log WHERE user_id = ?";
        List<LoginLog> result = new ArrayList<>();
        try (Connection conn = getConnection();
             PreparedStatement pstmt = conn.prepareStatement(sql)) {
            pstmt.setInt(1, userId);
            try (ResultSet rs = pstmt.executeQuery()) {
                while (rs.next()) {
                    LoginLog log = new LoginLog();
                    log.setId(rs.getInt("id"));
                    log.setUserId(rs.getInt("user_id"));
                    log.setLoginTime(rs.getTimestamp("login_time"));
                    log.setLoginIp(rs.getString("login_ip"));
                    result.add(log);
                }
            }
        } catch (SQLException e) {
            // TODO: 异常处理
        }
        return result;
    }
}