3 ms·
It would be nice if this ad at least explained a little bit of the technical side of the solution.
by richwater 6mo ago
It would be nice if this ad at least explained a little bit of the technical side of the solution.
- sgarland 6mo agoIt sounds vaguely like InnoDB’s concurrency control solution which uses tokens [0] as a unit of maximum work a query can perform. 0: https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-thread_concurrency.html https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-t...
- sroussey 6mo agotickets, not tokens, but yeah
- dukepiki 6mo agoMySQL’s concurrency control is a limit on the total number of threads that can be active at once, across all queries. Traffic Control limits concurrency and resource use according to configurable metadata like the username, remote address, or the contents of any sqlcommenter tags included in the query. So you can say things like “the batch processing role can’t run more than four queries at a time.” The finer granularity is key.
- simeonGriggs 6mo agoWe’ve got a separate blog post all about how traffic control works: https://planetscale.com/blog/behind-the-scenes-how-traffic-control-works https://planetscale.com/blog/behind-the-scenes-how-traffic-c...
- deleted 6mo ago[deleted]