Monitoring
System Monitoring
sql
-- Check active devices
SELECT deviceId, protocol, lastUpdate
FROM devices
WHERE status = 'online';
-- Monitor positions
SELECT deviceId, latitude, longitude, speed
FROM positions
WHERE serverTime > NOW() - INTERVAL 1 HOUR;
Performance Metrics
bash
# Check server status
curl http://localhost:8082/api/server
# Monitor memory usage
jmap -heap PID
# Check thread status
jstack PID