Remove Availability Remove Cache Remove Definition Remove Servers
article thumbnail

Is ANALYZE TABLE Safe on a Busy MySQL Database Server?

Percona

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 101
article thumbnail

How to use Server Timing to get backend transparency from your CDN

Speed Curve

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

20X Faster Backup Preparation With Percona XtraBackup 8.0.33-28!

Percona

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. So, given a table_id, how do you get the table schema/definition? For that, we have to use undo logs.

Cache 88
article thumbnail

The road to observability with OpenTelemetry demo part 1: Identifying metrics and traces

Dynatrace

When software runs in a monolithic stack on on-site servers, observability is manageable enough. OpenTelemetry demo application: Distributed host/URL availability checker For our demo, we picked a web-based application whose core service is a distributed host/URL availability check.

Metrics 180
article thumbnail

Impact of Querying Table Information From information_schema

Percona

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache 107
article thumbnail

Book Review: PostgreSQL 14 Internals by Egor Rogov

Percona

The book PostgreSQL 14 Internals has been available in PDF format for quite a while, but recently, the ability to order a printed copy became available ( [link] ). This 548-page tome from PostgresPro covers the spectrum from data organization to details on the many available indexing options.

Cache 92
article thumbnail

Image Processing Insights

KeyCDN

Our solution doesn't require any change on the origin server. Properly size images: Scaled images will definitely reduce the overall website size. Even if a browser doesn't support WebP, our WebP caching feature will ensure that the correct image format is delivered. The available operations are listed in our documentation.