Showing entries 1 to 10 of 17
7 Older Entries »
Displaying posts with tag: component (reset)
MySQL Vector Datatype: create your operations (part 2)

We saw in the previous post how we can deal with data stored in the new VECTOR datatype that was released with MySQL 9.0. We implemented the 4 basic mathematical operations between two vectors. To do so we created JavaScript functions. MySQL JavaScript functions are available in MySQL HeatWave and MySQL Enterprise Edition (you can […]

Build MySQL 8 from the source rpm in OL9

After discussing with Simon about some issues when trying to recompile MySQL 8.0.34 on CentOS 9 (see #111159), I also tried it and indeed some dependencies are not listed when compiling via the source RPM.

Let’s see how to recompile the two latest versions of MySQL (8.0.34 and 8.1.0) using the source RPMs.

I use Oracle Linux 9 as build machine.

Getting the source RPM

To get the source RPM, you need first to install the MySQL Community’s repo:

$ sudo dnf install …
[Read more]
MySQL & UUIDs

More and more people are using UUID’s to identify records in their database.

As you already know, for MySQL’s storage engine (InnoDB) the primary key is very important ! (for performance, memory and disk space).

See the following links:

Problems

There are 2 major problems having a UUID as Primary Key in InnoDB:

  1. generally they are random and cause clustered index to be rebalanced
  2. they are included in each secondary indexes (consuming disk and memory)

Let’s have a look at …

[Read more]
Extending MySQL using the Component Infrastructure – part 13: FAQ

This post is the final one of a series of articles on extending MySQL with the Component Infrastructure:

[Read more]
Extending MySQL using the Component Infrastructure – part 12: instrument your code

This post is the twelfth one of a series of articles on extending MySQL with the Component Infrastructure:

[Read more]
Extending MySQL using the Component Infrastructure – part 11: performance_schema table

This post is the eleven one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:

[Read more]
Extending MySQL using the Component Infrastructure – part 10: status variables

Today we are already at the post number ten of the series of articles related to extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:

[Read more]
Extending MySQL using the Component Infrastructure – part 9: adding a new function

This post is the nine one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:

[Read more]
Extending MySQL using the Component Infrastructure – part 8: linking a third party library

This post is the eight one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:

[Read more]
Extending MySQL using the Component Infrastructure – part 7: messages to users

This post is the seventh post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:

[Read more]
Showing entries 1 to 10 of 17
7 Older Entries »