article thumbnail

Impact of Querying Table Information From information_schema

Percona

Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 98
article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

There are a couple of blog posts from Yves that describe and benchmark MySQL compression: Compression Options in MySQL (Part 1) Compression Options in MySQL (Part 2) Archive or purge old or non-used data: Some companies have to retain data for multiple years either for compliance or for business requirements. ibd -rw-r --. ibd -rw-r --.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Progress Delayed Is Progress Denied

Alex Russell

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. is access to hardware devices. This is as it should be. CSS color().

Media 145
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. SQL Server 2000/7.0 data pages are 8 KB in size.

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. SQL Server 2000, and SQL Server 2005. SQL Server 6. However, as explained above, the SQL Server 6.

Servers 40