Overview Modern cloud applications (like microservice or serverless apps) are distributed systems composed of many interconnected services and service instances. Without observability in place, it is often difficult to troubleshoot issues within such complex systems. The OCI Application Performance Monitoring (APM) service provides observability for end-to-end visibility and diagnosis across the entire IT environment. Using distributed transaction […]

One of the hidden gems in the MySQL documentation is this note in section 8.3.6: As an alternative to a composite index, you can introduce a column that is “hashed” based on information from other columns. If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. We will build on this idea by creating generated hash columns for indexed lookups on large values and enforcing uniqueness across many columns. Instead of creating huge composite indexes, we'll index the compact generated hashes for fast lookups. Before diving into generated hash columns, let's look at generated columns in general. Generated columns in MySQL A generated column can be considered a calculated, computed, or derived column. It is a column whose value results from an expression rather than direct data input. The expression can contain literal values, built-in functions, or references to other columns. The result of …

Creating generated hash columns in MySQL for faster strict equality lookups.

Learn how Multi-Valued Indexing in MySQL 8.0 can enhance query performance by efficiently indexing and querying JSON arrays. Discover the benefits, implementation steps, and considerations for optimizing your MySQL database.

1. Multi-Valued Indexing in MySQL 8.0
2. Understanding Multi-Valued Indexes and their benefits
3. Creating Multi-Valued Indexes in MySQL …

Thanks so much for reading OpenLampTech. Here is this week’s newsletter, full of great content all about PHP, MySQL, and the LAMP stack. Several WordPress and WooCommerce reads too.

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #82, we have articles covering:

• WordPress …

MySQL Heatwave, a fully managed database service, not only provides customers with one database service for OLTP, OLAP, and ML, but it also supports centralized access management for these databases via integration with OCI IAM. Using Oracle Cloud Infrastructure Identity and Access Management (OCI IAM) customers can protect themselves against security threats, streamline access management, and […]

MySQL Heatwave, a fully managed database service, not only provides customers with one database service for OLTP, OLAP, and ML, but it also supports centralized access management for these databases via integration with OCI IAM. Using Oracle Cloud Infrastructure Identity and Access Management (OCI IAM) customers can protect themselves against security threats, streamline access management, and achieve governance and compliance with industry standards.

TarnovoConf, Jun 17, 2023, Veliko Tarnovo, Bulgaria We are happy to announce the participation of MySQL in the small regional technical conference TarnovoConf. TaranovoConf is part of the IT Tour-travel conferences in Bulgaria initiated by a group of local enthusiasts and includes a series of technical conferences in major Bulgarian cities. At this one, scheduled […]

MySQL at TaranovoConf, Bulgaria

MySQL Shell is a powerful utility for managing MySQL Instances. One feature is the ability to perform multithreaded data dumps and loads. In this post we will discuss hows to dump data to, and read data from, a Storage Bucket in Oracle Cloud Infrastructure.