Percona

MAY 1, 2023

Recently I was engaged in a MySQL Performance Audit for a customer to help troubleshoot performance issues that led to downtime during periods of high traffic on their AWS RDS MySQL instances. This message is normally a side effect of a storage subsystem that is not capable of keeping up with the number of writes (e.g.,

AWS 115

AWS Hardware Storage Tuning 115

Percona

JANUARY 5, 2023

To speed up the above query we need to create an appropriate index so that the query can be executed in minimal time and have less impact on server performance. If we are using binlog_format as ROW, a huge number of bin logs would be created which could choke I/O of servers and require extra cleanup. What is partitioning?

Traffic 58

Traffic Engineering Speed Storage 58

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

MAY 15, 2023

This operation is quite expensive but our database can run it in a few milliseconds or less, thanks to several optimizations that allow the node to execute most of them in memory with no or little access to mass storage. It will also allow us to redirect read/write traffic to the primary and read-only traffic to all secondaries.

Traffic 121

Traffic Scalability Database Servers 121

Testsigma

JUNE 5, 2021

As the number of websites has increased with time, so has the source of traffic leading to that website. In 2015, 35% of the internet traffic came from mobile devices, 6 years later, the number is 54.8%. There are two main reasons why people keep mobile browsers installed in their system even after storage issues.

Mobile 52

Mobile Testing Website Testing Tools 52