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 …
[Read more]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.
- Multi-Valued Indexing in MySQL 8.0
- Understanding Multi-Valued Indexes and their benefits
- 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!
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.
MySQL HeatWave on AWS is now available in AWS Asia Pacific (Mumbai) region Last month, we announced the availability of MySQL HeatWave on AWS in AWS Japan (Tokyo) region. We have now extended the availability to AWS India (Mumbai) region. The new region enables customers with applications deployed in AWS Asia Pacific (Mumbai) region to: […]