Elasticsearch

Count the number of documents

Elasticsearch: Count API | Elasticsearch Guide [8.15 Elastic]

GET /MY_INXEX/_count

MySQL MySQL :: MySQL 8.4 Reference Manual :: 5.3.4.8 Counting Rows

SELECT COUNT(*) FROM MY_TABLE

Truncate the index

Elasticsearch: Delete API | Elasticsearch Guide [8.15 | Elastic]

DELETE /MY_INXEX/

MySQL MySQL :: MySQL 8.4 Reference Manual :: 15.1.37 TRUNCATE TABLE Statement

TRUNCATE MY_TABLE

Create the index

Elasticsearch: Create index API | Elasticsearch Guide [8.15 | Elastic]

PUT /MY_INXEX
{
  "mappings": {
    "properties": {
      "field1": { "type": "text" }
    }
  }
}

MySQL MySQL :: MySQL 8.4 Reference Manual :: 15.1.20 CREATE TABLE Statement

CREATE TABLE MY_TABLE (
  id INT AUTO_INCREMENT PRIMARY KEY,
  field1 TEXT
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;