8:00 – SR
- Backups
- Add code to MySQLif that does the following to a table stored in visibility_dev2:
- Get a hash of the query string
- start a timer
- run the query
- stop the timer
- SELECT the row with a matching hash or make a new one.
- Add the time to the running total
- increment the count of calls
- This will allow us to find the queries that are being run the most often and the ones that take the most time. We should focus our efforts on the longest queries that are called the most.
- Build a query (per Lenny’s instruction) that shows who’s late and who’s under. Include names, project info and contacts.
