Percona

JUNE 2, 2023

MySQL was founded in 1995 and went open source in 2000. MySQL was the database for phpWebLog, for example, way back in 2000. But, for a long time, you needed to be comfortable with mysqldump or other backup / restore methods to move servers or providers. But WordPress brought MySQL and open source to the masses.

Open Source 94

Open Source Traffic Tuning Database 94

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. The innodb_io_capacity_max parameter was set to 2000, so the hardware should be able to deliver that many IOPS without major issues.

AWS 118

AWS Hardware Storage Tuning 118

Dynatrace

APRIL 2, 2020

All-traffic monitoring, analysis on demand—network performance management started to grow as an independent engineering discipline. Real-time network performance analysis capabilities, including SSL decryption, enabled precise reconstruction of end user application states through the analysis of network traffic.

Network 166

Network Traffic Monitoring Java 166

Percona

MAY 15, 2023

In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. As illustrated above, ProxySQL allows us to set up a common entry point for the application and then redirect the traffic on the base of identified sharding keys. The POC Why this POC?

Traffic 123

Traffic Scalability Database Servers 123

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

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 59

Traffic Engineering Speed Storage 59

Smashing Magazine

MARCH 2, 2021

These days, with mobile traffic accounting for over 50% of web traffic , it’s fair to assume that the very first encounter of your prospect customers with your brand will happen on a mobile device. This goes way beyond basic optimizations such as color contrast and server response times.

Mobile 134

Mobile Testing Website Benchmarking 134