article thumbnail

A thorough introduction to bpftrace

Brendan Gregg

For example, iostat(1), or a monitoring agent, may tell you your average disk latency, but not the distribution of this latency. For smaller environments, it can be of more use helping eliminate latency outliers. Block I/O latency as a histogram. This traces block I/O, and shows latency as a power-of-2 histogram.

Latency 68
article thumbnail

Comparisons of Proxies for MySQL

Percona

When designing an architecture, many components need to be considered before deciding on the best solution. MySQL router, after the 2048 connection, could not serve anything more. Let us take a look also the latency: Here the situation starts to be a little bit more complicated. That allows it to go a bit further.

Games 119
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

​​ With new ​​ innovations ​​ come ​​ new terms, designs, ​​ and ​​ algorithms. This is different from ​​ the reference count design ​​ that was ​​ used in SQL Server 7.0 and ​​ 2000.

Servers 40