+ Image credit: Johns Hopkins Dept. of Orthopedic Surgery
Real goal: fine‐grained, targeted fixes
UNIVERSITY OF TORONTO
DTrace: making systems transparent Instrument majority of OS and all user‐level functions
Trace events generated by domain‐specific “providers”
Domain‐specific language specifies probe actions
Zero disabled probe cost
Safe: designed for non‐wizard use with production systems
Two‐way OS/app communication via process memory
UNIVERSITY OF TORONTO
Disclaimer This talk is about a new way of looking at our tools, not about any one (use of a) tool. For concreteness, we’ll discuss a specific tool (DTrace) and problem class (scheduling) that I happen to be familiar with. Hopefully these examples inspire other/better uses for active observers within the DBMS.
UNIVERSITY OF TORONTO
Example: diagnosing contention Sample‐based profiling (OS service) Post‐processing identifies samples due to contention (lock waits, atomic ops, etc.) Work breakdown 100%
Contention Compute More client threads
UNIVERSITY OF TORONTO
Spinning and thread preemption
!
!
DBMS records lock acquire/release, DTrace does the rest
7
UNIVERSITY OF TORONTO
Priority inversion unmasked DTrace tracks locks held by pre‐empted threads, samples call stacks Worker threads record held/attempted locks in thread‐local storage
DTrace isolates samples where threads wait on pre‐empted locks
Work breakdown 100%
Prio‐invert Contention Compute
Post‐processing differentiates samples due to contention and priority inversion
Conclusions • Cooperation between DBMS and observability tools can be a powerful thing • Recurring theme: two‐way communication between OS/DBMS • What other active uses might be out there? • How to adapt our tools for these new uses?
probe cost. Instrument majority of OS and all user-level ... Two-way OS/app communication via process memory ... Work breakdown. Sample-based profiling.
Two-way OS/app communication via process memory. Safe: designed for non-wizard use ... samples call stacks. DTrace isolates samples where threads wait on.
Investigating. & Resolving. Justice. Center Issues ... Texas County, MO. Monroe County, TN Loudon County, TN ... Abuse, Mental Health. Page 4 of 23. TMA PPT ...
Page 2 of 16. Outline. Major Cause of Climate Change. Climate Change Impact. Solutions. General Condition of Indonesia. Potential of Solar Energy. Potential ...
Interoperate Spatial Data Stored in. SQL and NoSQL Databases. Cláudio de Souza Baptista,. Odilon Francisco de Lima Junior,. Maxwell Guimarães de Oliveira,.
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. TiDE(PPT).pdf.
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. jeje ppt titip.pdf.
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. PPT-MS-SMER.Missing:
ãåèã:MyBooks.jp :ããã°ãã¼ã¿ããæ¬ãä½æã§ãããµã¼ãã¹. ãå¼ç¨ã:http://mybooks.jp/. Page 4 of 79. (å ¨ç·¨)PPT to ePub_FUSEe Beta PPT to ePub.pdf. (å ¨ç·¨)PPT to ...
Page 3 of 21. Triad PPT Jan 2017.pdf. Triad PPT Jan 2017.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying Triad PPT Jan 2017.pdf. Page 1 of 21.
Whoops! There was a problem loading more pages. Retrying... Whoops! There was a problem previewing this document. Retrying... Download. Connect more ...
... y rejillas, incluidas las acometidas, de. la red de saneamiento en cualquiera de las poblaciones mencionadas. Page 3 of 18. PPT Zona 2.pdf. PPT Zona 2.pdf.
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Cougar Camp ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. GreenStar ...
Frame construction is used throughout. the aerospace industry in the creation of. welded steel-tube fuselages, piston- engine motor mounts, ribs, and landing.
Page 1 of 53. Page 1 of 53. Page 2 of 53. Page 2 of 53. Page 3 of 53. Page 3 of 53. Page 4 of 53. Page 4 of 53. Main menu. Displaying PPT on technicality of ...
8th / early 9th century â modern clocks make meaningful. appearances in the Middle East (Iraq). ⢠11th century â clock mechanisms are well in use, mostly ...
Download. Connect more apps... Try one of the apps below to open or edit this item. PPT-II Machine Maintenance.pdf. PPT-II Machine Maintenance.pdf. Open.
Page 1 of 7 . NANCY RODRIGUEZ POLO. Abogada & Administradora de Empresas. Especializada en. Gobierno y PolÃticas Públicas. Universidad de los Andes. Page 1 ...