log2sql-examples.sql #1

  • //
  • guest/
  • robert_cowham/
  • perforce/
  • utils/
  • log_analysis/
  • log2sql-examples.sql
  • View
  • Commits
  • Open Download .zip Download (765 B)
Locks Held for 10 seconds

SELECT startTime, endTime, computedLapse, running, 
  cmd, pid, tablename, maxReadHeld, 
  maxWriteHeld,totalReadWait,totalWriteWait 
FROM tableUse JOIN process USING (processKey)
WHERE (( totalReadHeld > 10000 or totalWriteHeld > 10000 )) 
ORDER BY startTime, endTime;


Commands waiting fo rlocks for over 30 seconds

SELECT startTime, endTime, computedLapse, running, 
  cmd, pid, tablename, maxReadHeld,
  maxWriteHeld,totalReadWait,totalWriteWait 
FROM tableUse JOIN process USING (processKey)
WHERE (( totalReadWait > 30000 or totalWriteWait > 30000 )) 
ORDER BY startTime,endTime;

Commands running per second (look for boottlnecks)

SELECT SUBSTRING(startTime,1,19),MAX(running) 
FROM process 
GROUP BY SUBSTRING(startTime,1,19);
# Change User Description Committed
#6 22907 Robert Cowham Updated examples and notes for SQLlite3
#5 22906 Robert Cowham Check for log file not existing.
#4 21695 Robert Cowham Sundry examples from Karl.
Tweaked to use Sqlite syntax (e.g. SUBSTR not SUBSTRING).
Also performance related ones.
#3 10406 Robert Cowham Tweaked formatting slightly - no content changes.
#2 10405 Robert Cowham Updated fuller set of reporting statements
#1 10404 Robert Cowham Renamed
//guest/robert_cowham/perforce/utils/log_analysis/lg2sql-examples.sql
#1 10403 Robert Cowham Examples - just getting started