Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Need help managing complex database environments? This structure makes for faster data access. So, what to do then?

Virtualization 76

Virtualization Speed Database Efficiency 76

Dynatrace

OCTOBER 11, 2021

The headlining feature of GCP is Google’s Compute Engine , a service for creating and running virtual machines in the Google infrastructure—a direct analog to AWS’ EC2 instances and Azure’s VMs. These functions can connect with supported cloud databases, such as Cloud SQL and Bigtable. GCF use cases.

Google 226

Google Cloud Serverless Azure 226

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. The Linux default is usually 60 , which is not ideal for database usage. Without further ado, let’s start with the OS settings.

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. IT professionals are familiar with scoping the size of VMs with regards to vCPU, memory, and storage capacity. Microsoft has helped simplify things by creating multiple types of virtual machines. Generation.

Azure 76

Azure Benchmarking Storage Virtualization 76

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. Gen4 is still described in the documentation , but this option is mostly unavailable now. Each service tier supports anywhere from 4 to 80 logical CPUs — also known as virtual cores, or vCores. Memory is allocated at approximately 5.1

Azure 63

Azure Performance Storage Latency 63

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Also, in the case of multi-Primary, the writes will be distributed by transaction. The POC Why this POC?

Traffic 121

Traffic Scalability Database Servers 121

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently.

Servers 90

Servers Media Cache Storage 90

HammerDB

DECEMBER 5, 2020

First of all it has always been clear in the HammerDB documentation that the TPROC-C/TPC-C and TPROC-H/TPC-H workloads have not been ‘real’ audited and published TPC results instead providing a tool to run workloads based on these specifications.

C++ 40

C++ Benchmarking Virtualization Open Source 40

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. in the directory storage/innobase/ut the following section has UT_RELAX_CPU defined to call the PAUSE instruction on x86.

Testing 48

Testing Tuning Latency Storage 48

Abhishek Tiwari

DECEMBER 22, 2017

Cheap storage and on-demand compute in the cloud coupled with the emergence of new big data frameworks and tools are forcing us to rethink the whole ETL and data warehousing architecture. In classic Extract, transform, and load (ETL) model, we store entities in their corresponding application databases i.e. as rows in the relational tables.

Big Data 40

Big Data Retail Storage Google 40

Abhishek Tiwari

JANUARY 6, 2018

auto-completion of commands, auto-suggestions, in-line documentation. Telepresence is an open source tool that lets you debug a service locally while keeping the connection with its dependency services hosted in a remote Kubernetes cluster and remote cloud resources like a database. It has some really nifty features such as.

Open Source 111

Open Source DevOps Storage Engineering 111

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Dynatrace

AUGUST 5, 2019

Database & functional migration. Lift & Shift is where you basically just move physical or virtual hosts to the cloud – essentially you just run your host on somebody else’s hardware. Step 4: Smart Database Migration. Which applications and services are depending on a database that might be impacted by a migration?

Cloud 31

Cloud Traffic Database Network 31

SQL Server According to Bob

JANUARY 11, 2020

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

Servers Cache Media Hardware 40

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. Consider an example where a company is running multiple virtual machines (VMs) on a cloud provider. This level of granularity is not found in UI-managed systems.Â

Open Source 52

Open Source DevOps AWS Azure 52

Smashing Magazine

SEPTEMBER 20, 2021

Another kind of content publishing tool is a service that fetches a web page, checks it against databases for any potential copyright violation or plagiarism , and displays the page with markup to identify any potentially offending content. These are page views loaded from a previously-viewed web page that was saved to device local storage.

Website 89

Website Analytics Google Cache 89

Percona

AUGUST 27, 2018

Essentially, you can assign a thread to a specific virtual CPU. MySQL 8 introduced a feature that is explained only in a single documentation page. assigning to a specific CPU) is a manageable resource, represented by the concept of “virtual CPU” as a term that includes CPU cores, hyperthreads, hardware threads, and so forth.

Tuning 44

Tuning Virtualization Testing Servers 44

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. Terraform's declarative nature makes this adaptation straightforward.‍Consider an example where a company is running multiple virtual machines (VMs) on a cloud provider.

Open Source 40

Open Source DevOps AWS Azure 40

SQL Server According to Bob

FEBRUARY 13, 2020

​​​​ Another example would be backup to Azure Storage using the rest interface to read and ​​ write data to/from Azure Blob Storage. ​​​​ A utility would issue the dbcc freeze to stop the I/O activity for the database.

Servers 40

Servers Availability Transportation Database 40

Smashing Magazine

SEPTEMBER 26, 2019

Technically, we have to split our existing application into microservices virtually. By “virtually” I mean that in general, you don’t need to change your existing application physically: it’s enough to have structure settled in any form even if only on paper. So we should dive more in-depth here. Allow Host-to-Alien Access.

Architecture 73

Architecture Virtualization Servers Technology 73

All Things Distributed

JANUARY 18, 2012

a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Today is a very exciting day as we release Amazon DynamoDB , a fast, highly reliable and cost-effective NoSQL database service designed for internet scale applications. Werner Vogels weblog on building scalable and robust distributed systems.

Scalability 167

Scalability Database Ecommerce Latency 167

Alex Russell

APRIL 29, 2021

Chrome has missed several APIs for 3+ years: Storage Access API. Now in development in WebKit after years of radio silence, WebXR APIs provide Augmented Reality and Virtual Reality input and scene information to web applications. Where Chrome Has Lagged. During the drafting of this post, iOS 14.5 was released and with it, Safari 14.1.

Media 145

Media Games Education Engineering 145