Remove 2000 Remove Efficiency Remove Servers Remove Tuning
article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. Redundant indexes: It is known that accessing rows by fetching an index is more efficient than through a table scan in most cases. 1 mysql mysql 592K Dec 30 02:48 tb1.ibd ibd -rw-r --. 1 mysql mysql 464K Dec 30 02:48 tb2.ibd

article thumbnail

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

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

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40
article thumbnail

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

To learn bpftrace, I've created a couple of references: - [one-liners tutorial] - [reference guide] The one-liners tutorial is based on my [FreeBSD DTrace Tutorial], and I think is a time-efficient way to learn bpftrace (as well as DTrace on FreeBSD). Might bpftrace SIGSEGV and coredump? That's what I wrote seeksize.d But it isn't. ### 2.

C++ 110
article thumbnail

bpftrace (DTrace 2.0) for Linux 2018

Brendan Gregg

To learn bpftrace, I've created a couple of references: - [one-liners tutorial] - [reference guide] The one-liners tutorial is based on my [FreeBSD DTrace Tutorial], and I think is a time-efficient way to learn bpftrace (as well as DTrace on FreeBSD). Might bpftrace SIGSEGV and coredump? That's what I wrote seeksize.d But it isn't. ### 2.

C++ 40
article thumbnail

Using Modern Image Formats: AVIF And WebP

Smashing Magazine

Users appreciate high-quality visuals, but care needs to be taken to deliver those hero images, product photos and cat memes as efficiently and effectively as possible. The efficiency of a codec can be mainly measured by how much compression it can achieve. Images are the most popular resource type on the web and are often the largest.