article thumbnail

How to Assess MySQL Performance

HammerDB

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. For storage, FIO is generally used. TB)) for storage of database tablespaces and logging.

article thumbnail

Carving an AWS certification path

Dynatrace

Hosted and moderated by Amazon, AWS GameDay is a hands-on, collaborative, gamified learning exercise for applying AWS services and cloud skills to real-world scenarios. As an AWS Advanced Technology Partner , this was a great opportunity for Dynatrace developers to sharpen their AWS skills and pursue or up-level their Amazon certifications.

AWS 202
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

Fun with (columnstore) compression on a very large table – part 1

SQL Performance

Note that I am not focusing on reporting workload or other read query performance at this time – I merely want to see what impact I can have on storage (and memory) footprint of this data. ALTER DATABASE OCopy ADD FILE ( name = N'CCI_8' , size = 250000 , filename = 'K:Datao_cci_8.mdf' Here is the original table.

article thumbnail

Fundamentals of table expressions, Part 3 – Derived tables, optimization considerations

SQL Performance

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 109
article thumbnail

Fundamentals of table expressions, Part 3 ? Derived tables, optimization considerations

SQL Performance

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 93
article thumbnail

The top 5 reasons to run your own database benchmarks

HammerDB

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

article thumbnail

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

All Things Distributed

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 128