Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. This not only enhances performance but also enables you to make more efficient use of your hardware resources, potentially resulting in cost savings on infrastructure.

Tuning 52

Tuning Database Performance Hardware 52

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Microbenchmark os::javaTimeMillis() on both systems. Running this on the two systems saw similar results.

Speed 52

Speed Java AWS Virtualization 52

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance. current CPU frequency: 1.99

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

AUGUST 30, 2023

In general terms, here are potential trouble spots: Hardware failure: Manufacturing defects, wear and tear, physical damage, and other factors can cause hardware to fail. heat) can damage hardware components and prompt data loss. Without data backup mechanisms, there can be data loss or system downtime.

Database 87

Database Hardware Open Source Strategy 87

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. Firstly for system choice a 2 socket system is optimal for PostgreSQL OLTP performance at the time of writing. CPUs which run at the same hardware frequency: 0. CPU Configuration.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Scalegrid

JANUARY 25, 2024

Effective monitoring of key performance indicators plays a crucial role in maintaining this optimal speed of operation. These essential data points heavily influence both stability and efficiency within the system. Memory RSS (Resident Set Size) is the number of bytes that the operating system has allocated to Redis.

Metrics 130

Metrics Monitoring Latency Cache 130

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Microbenchmark os::javaTimeMillis() on both systems. Running this on the two systems saw similar results.

Speed 40

Speed Java AWS Virtualization 40

Dynatrace

AUGUST 30, 2019

She was speaking about how her team is providing Visibility as a Service (VaaS) in order to continuously monitor and optimize their systems running across private and public cloud environments. Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. Impressive results I have to say!

Cache 195

Cache Architecture Database Government 195

Percona

DECEMBER 27, 2023

Another significant issue within security concerns is the escalating complexity of modern systems, especially in platforms like Kubernetes, which highlights the need for unified threat models and scanning tools to address vulnerabilities. Creating repositories for memory-safe patterns in cloud systems to improve overall security.

Cloud 79

Cloud Open Source Strategy Best Practices 79

Percona

JUNE 22, 2023

Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution. There are multiple tables MySQL internal system manages that come in handy, identifying the inefficient indexes, to name a few: sys.schema_unused_indexes, and information_schema.index_statistics.

Performance 104

Performance Monitoring Traffic Database 104

Percona

MAY 1, 2023

It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

HammerDB

OCTOBER 18, 2019

Nevertheless in this blog sometimes we do publish performance data to highlight best practices or potential configuration pitfalls and although we’ve mentioned this one before it is worth dedicating an entire post to it as this issue seems to appear numerous times running database workloads on Linux. uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Dotcom-Montior

JUNE 15, 2020

The censorship and monitoring of internet have evolved from anti-virus-like and firewall software to hardware security patches for all devices that uses internet. Operating System Updates and Security Patches. Therefore, even foreigners inside China will also opt to use the local counterparts of banned apps and websites due to speed.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

SQL Performance

JUNE 21, 2019

I always check backups first when looking at a new system. Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. There are exceptions to every rule or best practice.

Servers 49

Servers Azure Hardware Database 49

Testsigma

JANUARY 30, 2021

As mobile phones are readily available, users try to open that particular application on a mobile web browser, instead of signing into their systems and hitting the URL. Each smartphone comes with various screen sizes and resolutions, operates on different network speeds, and has different hardware capabilities.

Mobile 52

Mobile Testing Website Internet 52

Dotcom-Montior

NOVEMBER 27, 2018

Additionally, end users can access your site or applications from anywhere in the world using different browsers, operating systems, and mobile devices, all with varying connection speeds. LoadView – Best Practices and Process. Finding upper limits of your current systems for capacity planning.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

Smashing Magazine

MAY 20, 2020

It also allows the project to be loaded faster, which is pretty important in regards to the growing mobile share and new markets with slow connection speeds and fragmented internet coverage. Let’s write a script that allows us to measure performance, a11y, best practices, and provide us with an SEO score. It’s up to you!

Performance 99

Performance Metrics Best Practices Code 99

Percona

JULY 26, 2023

It is best practice to have an odd number of replica set members to maintain voting quorum. To make this process work more efficiently and ensure a smooth failover, it is important to have the same hardware configuration on all the nodes of the replica set. A replica set can currently have up to 50 nodes.

Database 79

Database Servers Storage Strategy 79

All Things Distributed

APRIL 5, 2012

Werner Vogels weblog on building scalable and robust distributed systems. In addition to using Edmodo to engage students in classroom activities, teachers all over the world build profile pages on Edmodo, which they use to discover and share content, meet and stay in contact with other educators, and best practices and top resources.

Innovation 146

Innovation AWS Education Network 146

Smashing Magazine

JANUARY 11, 2021

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Note : If you use Page Speed Insights or Page Speed Insights API (no, it isn’t deprecated!),

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JANUARY 7, 2019

You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Note : If you use Page Speed Insights (no, it isn’t deprecated), you can get CrUX performance data for specific pages instead of just the aggregates.

Performance 104

Performance Cache Network Metrics 104

Smashing Magazine

JANUARY 6, 2020

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Start Render time, Speed Index ). Treo Sites provides competitive analysis based on real-world data.

Performance 145

Performance Cache Network Metrics 145

SQL Server According to Bob

JULY 13, 2016

desktop machine (I won’t tell you the hardware details. And the Operating System environment for Windows Server has become more robust but has introduced more features and complexity. Don’t worry about taking screenshots or speed reading. So the initial time to run this all depends on your network speed. Go install it”.

Servers 40

Servers Media Engineering Virtualization 40

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

AUGUST 22, 2021

A Primer on Speed. Discussing performance and “speed” can quickly get complex, because many underlying aspects contribute to a web-page loading “slowly”. It is physically limited by the speed of light or, practically, how fast signals can travel in wires or in the open air. Did You Know?

Performance 106

Performance Network Latency Servers 106