When developing a Lean factory layout, many people assume that the layout must be a “U”. In order to begin database optimizations, a key requirement is to measure the query throughput that the database processes.Tim McLean – Managing Director will talk about the different Factory Layout Examples. ConclusionĪ Database Administrator can learn a lot from the world of business and manufacturing when considering database performance. What was happening yesterday compared to the day before? Or last week?įor these type of questions, you will need an external system to collect query information to understand query performance over time.Unfortunately, these native tools cannot answer questions like: This query data is helpful for answering many workload questions, such as: Using these tools, you can find a way to observe query throughput. The primary options are the slow query log, and in more recent versions, the Performance Schema. MySQL provides several options for finding your query data. Therefore, you must measure the queries going into the database to improve the product of your database.Īfter all, if it isn’t measured, it can’t be improved. Well, database performance is all about database workload production.Īnd the workload of databases result from queries asked from it. So what does this have to do with database performance? The point to be made, though, is that I need to have visibility into the inputs going into the pastures and the product output before I can begin to optimize production.īy the way, the product output is also called throughput.Īnd the game easily provides the visibility needed into product throughput to pinpoint bottlenecks. If you watched the video, you can clearly see there are bottlenecks to shipping the chicken and eggs, while the beef is being produced too slowly. While I could provide one farm to one grain mill to one pasture, that would not be an efficient use of resources. Now, each pasture requires animal feed to produce its assigned item.Īnimal feed is produced from grain mills, which in turn requires grain from a farm!Īdditionally, each building requires workers to produce the items. My goal is to make as much of these products as possible. In the game, I have a complex setup of pastures that will make various animal products such as milk, eggs, chicken, and beef. The game Factory Town is all about making improvements to production pipelines to maximize output and profits. The video above uses a game called Factory Town to highlight these concepts. When that bottleneck is fixed, you can move on to the next one. In a nutshell, the Theory of Constraints says that to improve the performance of a system you must focus on improving the single bottleneck holding up the system. This theory is another important concept for any activity related to database performance tuning. The Goal also introduced the Theory of Constraints. The golden rule for performance improvement comes from famous Management Consultant Peter Drucker: “What isn’t measured, can’t be improved.”Ī business book called The Goal highlights the importance of that rule. Database Performance: Measure the Queries! Important rules for Database Performance
0 Comments
Leave a Reply. |