Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. ChatGPT: The InnoDB buffer pool is used by MySQL to cache frequently accessed data in memory.

Social Media 122

Social Media Database Servers Cache 122

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 106

Performance Monitoring Traffic Database 106

Percona

JULY 25, 2023

In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again.

Cache 87

Cache Benchmarking Servers Design 87

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 101

Monitoring Scalability Cache Database 101

Dynatrace

JANUARY 23, 2023

As our CTO Bernd Greifeneder shared in his blog post , what was a relatively small software release resulted in a large number of our customers b eing una ble to access their Dynatrace environments. Two weeks ago, we experienced a service interruption with our SSO service. Hopefully never.) This has been completed.

Social Media 130

Social Media Cache Traffic Media 130

Percona

AUGUST 31, 2018

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 57

Tuning Database Performance Benchmarking 57

Scalegrid

FEBRUARY 11, 2019

With such strong interest in this installation, we decided to write up the steps to configure your MySQL database on the ScaleGrid side to get you up and running ever faster with WordPress on Now. You can setup fully managed MySQL on Azure for as little as $8/month for management-only, or $18/month with hosting included on dedicated servers.

Serverless 138

Serverless Azure Database Cache 138

SQL Server According to Bob

NOVEMBER 8, 2016

Note: We received feedback that there was some confusion on us calling this functionality “tail of the log caching” because our documentation and prior history has referred to the tail of the log as the portion of the hardened log that has not been backed up. Create / Alter Database … LOG ON. Tail Of Log Caching.

Cache 40

Cache Servers Media Storage 40

Percona

NOVEMBER 9, 2023

In this blog post, we will discuss how to extend Percona Monitoring and Management (PMM) to get PostgreSQL metrics on checkpointing activity, internal buffers, and WAL usage. With this data, we’ll be able to better understand and tune our Postgres servers. You can search the blog for more information on this if needed.

Monitoring 92

Monitoring Tuning Metrics Servers 92

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Official Blog - World Web Technology

AUGUST 27, 2023

It is a server-side scripting language that is highly secure, open-source, and versatile. Mostly, web servers are created with PHP. In PHP, code is directly executed on the server and generates HTML to send to the client. You can integrate PHP with many technologies, such as databases, web servers, CMS, etc.

Development 98

Development Ecommerce Open Source Website 98

Percona

FEBRUARY 16, 2023

key id, key user, key type, together with keys themselves) into the cache, unless MySQL is restarted, or you want to rotate the master key (you won’t though, as you know you have removed the keyring_file), it will not need the keyring file anymore. row Database: test Create Database: CREATE DATABASE `test` /*!40100

Database 119

Database Servers Engineering Testing 119

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

All Things Distributed

AUGUST 17, 2011

No Server Required - Jekyll & Amazon S3. The increasing sophistication of client-side JavaScript has redefined what dynamic means; where in the past dynamic content would be mainly server generated, today much content is served statically with JavaScript on the client side doing the dynamic modifications. All Things Distributed.

Servers 126

Servers Social Media AWS Website 126

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 2023. Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. docker-entrypoint."

Scalability 60

Scalability Best Practices Servers Database 60

Official Blog - World Web Technology

NOVEMBER 9, 2023

PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. Regarding command-line and server-side scripts, PHP is easy for users to understand and use. PHP can work perfectly on shared hosting and private servers, making it an excellent choice for building websites.

Website 59

Website Development Open Source Database 59

High Scalability

SEPTEMBER 3, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.

Open Source 55

Open Source Cache C++ Database 55

Dotcom-Montior

JUNE 25, 2020

Email servers tend to blacklist certain IDs as spam based on their content. And if the mail server for the user is attached to the DNSBL database, then any emails coming from the list of blacklisted sites could be either flagged or rejected. It performs a check against all the databases that could have blacklisted the IP.

Monitoring 86

Monitoring Traffic Website Database 86

All Things Distributed

AUGUST 22, 2011

Today AWS has launched Amazon ElastiCache , a new service that makes it easy to add distributed in-memory caching to any application. Amazon ElastiCache handles the complexity of creating, scaling and managing an in-memory cache to free up brainpower for more differentiating activities. blog comments powered by Disqus.

Cloud 117

Cloud Cache AWS Storage 117

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). That is to ensure your database is encrypted at the file level.

Servers 40

Servers Database Azure Cache 40

Percona

MAY 6, 2024

Since Valkey (a fork of Redis) is around the corner, I thought to write a short blog post about some of the configuration parts, mainly discussing how to dynamically change certain settings and persist those inside the configuration file.Disk persistenceLet me start with a very important setting, which is “SAVE,” that helps in performing (..)

Performance 94

Performance Cache Hardware Storage 94

Percona

DECEMBER 20, 2023

The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it.

Monitoring 90

Monitoring Code Open Source Cache 90

Smashing Magazine

SEPTEMBER 20, 2021

Web scraping can be used to harvest marketing data, such as identifying good keywords for advertising campaigns, identifying trending topics for blog posts, or identifying influencers in important blogs and news sites. Search Engine And Web Archive Cached Results. Turning The Data Into Information. Large preview ).

Website 89

Website Analytics Google Cache 89

The Netflix TechBlog

MARCH 5, 2019

the order of the rows on your Netflix home page, issuing content licenses when you click play, finding the Open Connect cache closest to you with the content you requested, and many more). Other Relevant Readings More infrastructure-related post from the Netflix Tech Blog How Netflix Works?

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

MachMetrics

DECEMBER 14, 2019

How fast is the average time to first byte (server delay)? How long is the average server delay? It is typically reduced via server-side optimizations, such as enabling caching and database indexes. appeared first on MachMetrics Speed Blog. How fast is the average page load time in 2020?

Best Practices 105

Best Practices Speed Mobile Google 105

All Things Distributed

DECEMBER 5, 2010

The naming system that we are all most familiar with in the internet is the Domain Name System (DNS) that manages the naming of the many different entities in our global network; its most common use is to map a name to an IP address, but it also provides facilities for aliases, finding mail servers, managing security keys, and much more.

Cloud 117

Cloud Internet Internet AWS 117

SQL Server According to Bob

AUGUST 8, 2016

I was asked about these terms from a blog reader. As I thought about these terms and how to blog about them I became concerned that I might just be as clear as mud, but I will do my best. Let’s talk about these terms in light of a computer and more specifically SQL Server. If you talk about database pages HOT is a good thing.

Cache 40

Cache Energy Database Servers 40

Dynatrace

SEPTEMBER 17, 2019

REDIS for caching. Robert allowed me to take a couple of screenshots from their Dynatrace environment and with that, in this blog I try to explain how Dynatrace gives them MaaSS for Developers, Operators, DevOps as well as Business. The post AWS EKS Monitoring as a Self-Service with Dynatrace appeared first on Dynatrace blog.

AWS 127

AWS Monitoring Ecommerce Lambda 127

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. “. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. In this blog post, we’ll explain how PgBouncer works, the pros and cons of using it, and how to setup the connection pooler.

Cache 246

Cache Architecture Database Servers 246

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Dynatrace

AUGUST 12, 2019

With OneAgent installed on an application server, Davis, the Dynatrace AI causation engine, continuously analyzes all database statements within the context of your applications. Now, with Oracle database insights, we’re going even deeper, giving you visibility into what’s going on in the database layer.

Database 127

Database Metrics Cache Servers 127

MachMetrics

DECEMBER 27, 2019

It can also be described as server delay. TTFB is typically reduced via server-side optimizations, such as enabling caching and database indexes. The post Year in Web Performance: 2019 appeared first on MachMetrics Speed Blog. Time to first byte is a blocker for all other metrics that follow it.

Performance 52

Performance Speed Website Mobile 52

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. So, apart from powering servers with renewable energy, what else can web developers do about climate change? Server-Side Performance.

Website Performance 73

Website Performance Website Energy Performance 73

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. We have several YouTube Tutorials and blog posts available that show how you can use Dynatrace RUM data for Web Performance & User Experience Optimization. Digital Performance: 99% reduction in Response Time, from 18.2s Impressive results I have to say!

Cache 195

Cache Architecture Database Government 195

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. However, as the size of your database grows, it can become challenging to manage and optimize its performance. In this blog post, we will explore the benefits of using pgpool-II for PostgreSQL.

Cache 116

Cache Open Source Benchmarking Database 116

Scalegrid

AUGUST 30, 2019

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker. Redis Strings Use Cases.

Cache 232

Cache Ecommerce Social Media Database 232