When working in startup, don’t lose hope, keep slogging as once you reach scale help is on the way. So far I have been scaling Mysql by throwing more hardware and focusing only on performance issues detected by new relic or my custom report but there were some data driven anomalies where 99% calls to this query would take 1sec but one call to same query would take 10sec. I wasn’t focusing much on it because it was a blip in the graph and there were too many other issues to focus on. Now we got a full time Mysql engineer who is looking at these queries and hunting down suspects. Today he found this query select sum(points) from ( select g.all_versions_size as points from folders_trash f inner join groups g on f.folder_id = g.folder_id union all ...