Week 06 - DevopsGroupC/Minitwit GitHub Wiki

week 06 prep questions

Can you figure out the following properties of your ITU-MiniTwit with your group fellows?

  • CPU load during the last hour/the last day.
  • response: image
  • Average response time of your application's front page.
  • response: load: 1,14s, DOMContentLoaded: 495 ms

What are DOMContentLoaded and load events? DOMContentLoaded and load are two events that fire when the browser parses and renders the HTML document. The DOMContentLoaded event occurs when the document has been completely loaded and parsed, without waiting for stylesheets, images, and subframes to finish loading. The load event occurs when the entire page, including its resources, has been loaded. You can see these values under inspect > network tab at google chrome

  • Amount of users registered in your system.
  • query asked:
    select count(*) from user;
  • response: approx 9450;
  • Average amount of followers a user has.
  • query asked:
    SELECT AVG(follower_count) AS average_followers FROM ( SELECT whom_id, COUNT(*) AS follower_count FROM follower GROUP BY whom_id ) AS follower_counts;
  • response: 1.89

status for group c

image