Percona

MAY 2, 2023

Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. Since your dataset is 100 GB and you have 500 GB of RAM, you can allocate a significant portion of the available memory to the InnoDB buffer pool. A commonly recommended value for the buffer pool size is between 50% to 75% of the available memory.

Social Media 124

Social Media Database Servers Cache 124

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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

Percona

FEBRUARY 24, 2023

Let’s take a look at how to get the benefits you need while spending less, based on the recommendations presented by Dani Guzmán Burgos, our Percona Monitoring and Management (PMM) Tech Lead, on this webinar (now available on demand) hosted in November last year. Marked in red in Figure 1 is a server with less than 30% of CPU usage.

Cloud 123

Cloud Serverless AWS Storage 123

Dynatrace

AUGUST 10, 2019

Having the ability to monitor the performance and availability of your organization’s internal applications—in addition to your organization’s customer-facing applications—from within your corporate network is an important benefit of synthetic monitoring. Windows 2016 Server (or a supported Linux distribution ).

Monitoring 103

Monitoring Hardware Tuning Mobile 103

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

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. The product is not released yet, at least at the time of writing, but they have started to shape which features (and there are a lot of them ) will be available in which editions.

Servers 40

Servers Hardware Database Availability 40

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. It provides redundancy and data availability for your data. Replication provides redundancy, and having multiple copies of the same data increases data availability. MongoDB is popular with developers as it is easy to get started with.

Database 83

Database Servers Storage Strategy 83

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. MySQL itself does not provide the capability for taking file system snapshots but it is available using third-party solutions such as LVM or ZFS. Why Do MySQL Backups Matter?

Best Practices 80

Best Practices Storage Strategy Database 80

Brendan Gregg

MARCH 16, 2024

The x86-64 ABI documentation shows how a CPU register, %rbp, can be used as a "base pointer" to a stack frame, aka the "frame pointer." This technique saves two instructions in the prologue and epilogue and makes one additional general-purpose register (%rbp) available." Back-end servers.

Java 145

Java Cache Google Hardware 145

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. There is an issue with this, which causes the OS to swap even with memory available. Spoiler alert: This post focuses on MongoDB 3.6.X 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

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

Randon ASCII

OCTOBER 4, 2020

The behavior of the Windows scheduler changed significantly in Windows 10 2004, in a way that will break a few applications, and there appears to have been no announcement, and the documentation has not been updated. I think the new behavior is an improvement, but it’s weird, and it deserves to be documented.

Programming 145

Programming Games Hardware Operating System 145

ACM Sigarch

JULY 17, 2023

An example of a specification is the correct operation of the hardware of a microprocessor. An SDC is the worst possible outcome of a fault, as it can have an arbitrary impact on the correctness of software running on the hardware. Background A fault is a condition that causes the inability to meet a specification. core lock-stepping).

Energy 52

Energy Hardware Best Practices Architecture 52

SQL Performance

JANUARY 23, 2020

Tom Davidson, Opening Microsoft's Performance-Tuning Toolbox SQL Server Pro Magazine, December 2003. Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006.

Tuning 115

Tuning Servers Monitoring Hardware 115

HammerDB

OCTOBER 23, 2023

Note that for all tests, we used the local loopback address and port to provide the lowest possible network latency between client and server and also so we don’t have any concerns about bandwidth limitations. Use the performance metrics available in the database first before looking at data further down in the stack.

Benchmarking 62

Benchmarking Database Network C++ 62

HammerDB

JUNE 27, 2022

It enables the user to measure database performance and make comparative judgements about database hardware and software. These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. What is HammerDB? Supported Databases.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Smashing Magazine

JUNE 18, 2020

That’s because they are meant for user preferences, as mentioned here in the case of iOS and here in the Android documentation when talking about the Security library which is designed to provide wrappers to the SharedPreferences specifically to encrypt the data before storing it. Secure Storage On Mobile. No, not at all. Solving Both.

Storage 93

Storage Mobile Website Java 93

SQL Performance

JULY 3, 2019

A recent consulting engagement was focused on blocking issues inside of SQL Server that were causing delays in processing user requests from the application. Depending on which DMV you look at for SQL Server, a session can have a few different statuses. So, we had to dig in further. Understanding Session Status.

Servers 64

Servers Hardware Code Virtualization 64

Percona

JANUARY 19, 2023

You can refer to the documentation for further details. Sharding: Sharding is the concept of splitting data horizontally, i.e. by distributing data into multiple servers (shards), meaning that the different portions of data for a given table, may be stored on many different servers. It is available under a paid subscription.

Open Source 92

Open Source Storage Database Big Data 92

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. Both are well documented and standardized, but most of the discussion occurs around attributional accounting. The first thing to understand is that doing things consumes time and energy and has a carbon footprint of its own.

Energy 52

Energy Cloud Traffic Transportation 52

The Morning Paper

MARCH 3, 2020

Over the decade since [the introduction of Availability Zones], our thinking on failure and availability has continued to evolve, and we paid increasing attention to blast radius and correlation of failure. EBS uses chain replication for availability, with data flowing from client to primary to replica.

Database 106

Database AWS Network Design 106

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 desktop machine (I won’t tell you the hardware details. There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use.

Servers 40

Servers Media Engineering Virtualization 40

Percona

DECEMBER 14, 2022

The key goals of OLTP applications are availability, speed, concurrency, and recoverability. BAD-NEWS: At the time of writing this blog, the only publicly available packages on the Postgres repositories that I could find were the cstore foreign data wrappers which cover only version 12 and older versions of Postgres. drill-down.

Database 93

Database Analytics Storage Processing 93

All Things Distributed

JUNE 28, 2017

The body and hardware still reflect HARTING's standard of perfection. If the requirements change or better software technologies become available, each microservice can be thrown out and a new one created. The web servers reported timeouts. Why were the web servers overloaded? Why don't we have enough web servers?

Innovation 113

Innovation Website Servers Technology 113

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

Smashing Magazine

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. In the end, it’s not the load events or server response times that define the experience, but the perception of how snappy the interface feels. It used to provide an insight into how quickly the server outputs any data. Large preview ).

Performance 145

Performance Cache Media Metrics 145

CSS - Tricks

AUGUST 18, 2020

Even if you render components on the server and hydrate them on the client, it still churns because component hydration is computationally expensive. When even a bit of React can be a problem on devices slow and fast alike, using it is an intentional choice that effectively excludes people with low-end hardware. I think JSX is great.

Performance 101

Performance Mobile Servers Code 101

Percona

AUGUST 5, 2023

KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. Documentation : Always be documenting! ” This can lead to uneven resource utilization and slower performance for certain partitions.

Strategy 40

Strategy Storage Database Best Practices 40

Testsigma

FEBRUARY 3, 2021

Mobiles have different models, screen resolutions, operating systems, network types, hardware configurations, etc. Also, how to test the hardware of the mobile phone itself, is it supporting all the software as it should? Let us have a look at the most popular types of mobile testing for applications and hardware.

Mobile 82

Mobile Testing Hardware C++ 82

HammerDB

FEBRUARY 25, 2021

When we have multiple CPU cores on both the benchmark client and database server it is crucial that these database sessions run independently of each other at the same time, in parallel. The following is an example from TPROC-C from SQL Server. and the following from TPROC-H. select top 100. where p_partkey = ps_partkey. Glue language.

Programming 67

Programming Benchmarking Virtualization C++ 67

VoltDB

MAY 2, 2017

We recently received a question from a customer who was looking for a quick way to repurpose some VoltDB production servers to create a disaster recovery site. Say you have five VoltDB servers in production, with k-factor=2, and no disaster site. You want to shift some of these servers to create a disaster recovery site.

Hardware 40

Hardware Database Servers Tuning 40

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It used to provide an insight into how quickly the server outputs any data. What does it mean?

Performance 145

Performance Cache Network Metrics 145

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . CPUs which run at the same hardware frequency: 0. cpupower idle-info.

Best Practices 40

Best Practices Scalability Performance Hardware 40

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented. TheYear , CA.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

APRIL 29, 2021

If an image is called donut.jpg and it exists in the same path as your HTML document, it can be embedded as follows: <img src="donut.jpg"> To ensure our image is accessible, we add the alt attribute. This approach ensures that the browser can allocate the correct amount of space in the document while the image is loading.

Media 145

Media Network Metrics Mobile 145

Alex Russell

OCTOBER 22, 2017

This isn’t true (more on that in a follow-up post), and sites which are built this way implicitly require more script in each document (e.g., Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. Main-document scrolling (assuming no active touch listeners). Parsing CSS.

Performance 68

Performance Benchmarking Network Mobile 68