article thumbnail

Comparisons of Proxies for MySQL

Percona

When designing an architecture, many components need to be considered before deciding on the best solution. In this scenario, it is also crucial to be efficient in resource utilization and scaling with frugality. MySQL router, after the 2048 connection, could not serve anything more. That allows it to go a bit further.

Games 119
article thumbnail

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting and other activities applications may require to gain improved I/O performance. On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048.

Servers 40
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