Remove 2000 Remove Cache Remove Hardware Remove Tuning
article thumbnail

Impact of Querying Table Information From information_schema

Percona

The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. having to open each table.frm (and in which my test runs, I have purposely read a very high number of tables compared to “Table-open-cache” variable). Results for Percona Server for MySQL 8.0

Cache 104
article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Books Online (BOL) References: ​​ All BOL references cited in this paper are taken from the Microsoft SQL Server 2000 Books Online site (updated to include SP3 functionality), which can be found at: [link] Click the Product Documentation link. This cache is often supported by a battery-powered backup facility.

Servers 40
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

The ​​ SQL Server 2000 I/O Basics ​​ document is a prerequisite to ​​ the information contained in this ​​ document. and ​​ 2000. DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk.

Servers 40