Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 110

Availability Database Open Source Hardware 110

Percona

MARCH 17, 2023

PMM2 uses VictoriaMetrics (VM) as its metrics storage engine. Planning for resources of a PMM Server host instance can be tricky because the numbers can change depending on the DB instances being monitored by PMM. Virtual Memory utilization was averaging 48 GB of RAM.

Monitoring 101

Monitoring Scalability Cache Database 101

Percona

DECEMBER 23, 2022

I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. Conclusion.

Storage 56

Storage Cache C++ Virtualization 56

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 126

Speed Java AWS Virtualization 126

Adrian Cockcroft

JUNE 21, 2022

So in 1988 I joined the Sun sales force and became a Systems Engineer (nowadays we would say Solutions Architect). I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems.

Tuning 52

Tuning Benchmarking Engineering C++ 52

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. SQL Server DELAYED_DURABILITY. Logging Waits.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

HammerDB

DECEMBER 5, 2020

From an engineering perspective this may be all that you need to know. The HammerDB TPROC-C workload by design intended as CPU and memory intensive workload derived from TPC-C – so that we get to benchmark at maximum CPU performance at a much smaller database footprint. I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

HammerDB

DECEMBER 14, 2022

my.cnf --user=hammerdb 2022-12-14 12:14:05 0 [Note] bin/mysqld (server 10.10.2-MariaDB) and the test will run with the number of Virtual Users equivalent to the number of CPUs. Benchmark set to TPC-C for MariaDB. Building 20 Warehouses with 5 Virtual Users, 4 active + 1 Monitor VU(dict value maria_num_vu is set to 4).

C++ 62

C++ Virtualization Database Benchmarking 62

Brendan Gregg

MARCH 16, 2024

It was also a virtual machine that lacked low-level hardware profiling capabilities, so I wasn't able to do cycle analysis to confirm that the 10% was entirely frame pointer-based. Back-end servers. The actual overhead depends on your workload. I made that up, AFAIK they don't run Linux, but I may be wrong!)

Java 145

Java Cache Google Hardware 145

HammerDB

DECEMBER 1, 2022

For querying a build, the status command will show whether all Virtual Users started and finished successfully, allowing a quick way to check the status of a build. . Use a different Browser. hammerdb>jobs [ "6388A0385EEC03E263531353", "6388A1585EEC03E243839333" ]. Use a different Browser. Use a different Browser.

Virtualization 57

Virtualization C++ Storage Database 57

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 52

Speed Java AWS Virtualization 52

SQL Server According to Bob

JANUARY 11, 2020

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

Servers Cache Database Media 40

Percona

DECEMBER 20, 2018

In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. A Look at MyRocks Performance. Installing MySQL 8.0

Database 40

Database Tuning Performance AWS 40

Brendan Gregg

SEPTEMBER 25, 2021

CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. This server is spending about a third of its CPU cycles just checking the time! Note that Ubuntu also has a frame to show entry into vDSO (virtual dynamic shared object). A quick check of basic performance statistics showed over 30% higher CPU consumption.

Speed 40

Speed Java AWS Virtualization 40

Enprowess

SEPTEMBER 20, 2021

Like React, Vue features two-way binding, uses components and a virtual DOM. They use lazy loading to extend performance rates and reduce loading times and code refreshes via virtual DOMs. With React being the foremost well-liked front-end library, there are skilled engineers accessible for hire. Server-Side Rendering.

Open Source 52

Open Source Mobile Scalability Google 52

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . Error in Virtual User 1: mysqlexec/db server: Table 'mysql.proc' doesn't exist.

Best Practices 40

Best Practices Scalability Performance C++ 40

Brendan Gregg

FEBRUARY 9, 2018

Many thanks to the engineers working hard to develop workarounds to these processor bugs. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Linux 4.14.12-virtual

Performance 75

Performance Benchmarking Cache Tuning 75

Alex Russell

MAY 9, 2022

Engineers and managers on these teams universally want to deliver great experiences and have many questions about how to approach common challenges. Thankfully, much of what once needed hand-debugging by browser engineers has become automated and self-serve thanks to those collaborations.

Performance 86

Performance Latency Metrics Engineering 86

Brendan Gregg

FEBRUARY 8, 2018

Many thanks to the engineers working hard to develop workarounds to these processor bugs. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Linux 4.14.12-virtual

Performance 40

Performance Benchmarking Cache Tuning 40

Smashing Magazine

JANUARY 11, 2021

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. It used to provide an insight into how quickly the server outputs any data. What does it mean?

Performance 145

Performance Cache Media Metrics 145