maria-discuss team mailing list archive

[<ngtech1ltd@xxxxxxxxx>]

Hey Gordan,

Got you..

I actually have a script that can translate the relevant tables for the benchmark test In mind but have yet to sit on it.
I really do not have any intention of replacing the DB but merely try to understand if this similar issue in the query optimizer
present in most of the popular DB systems.
I do assume that Oracle DB do not have an issue since I have seen it does a much more complex queries on a very large data sets
pretty easily, however there is a difference between what I believe to what I know when I am trying to state that  there is a bug in
any DB what so ever and whatever the depth of this bug.

Since MySQL and MaraiDB have the same roots and both have this exact same optimization bug I just wanted to verify.

Thanks,
Eliezer

* I will try to update here on whatever steps I will take in the near future

----
Eliezer Croitoru
NgTech, Tech Support
Mobile: +972-5-28704261
Email: ngtech1ltd@xxxxxxxxx
Web: https://ngtech.co.il/
My-Tube: https://tube.ngtech.co.il/

-----Original Message-----
From: Gordan Bobic <gordan.bobic@xxxxxxxxx> 
Sent: Tuesday, 26 July 2022 23:16
To: Eliezer Croitoru <ngtech1ltd@xxxxxxxxx>
Cc: Mailing-List mariadb <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Maria-discuss] Looking for advice where to start looking at a slow query case

On Tue, Jul 26, 2022 at 11:04 PM <ngtech1ltd@xxxxxxxxx> wrote:
>
> Hey Gordon,
>
> Before I am filing a jira bug report I would like to verify how the same queries are running on other DB ie:
> * MSSQL
> * PostgreSQL
> * Oracle DB

You are probably going to have to ask that question on forums where
the primary interest are those respective databases.

> Are there any recommended tools to migrate the data from MariaDB to PostgreSQL or MSSQL?

Migrating to completely different databases is not something you can
do without a non-trivial amount of effort, unless your application and
requirements are pretty trivial.
You are going to have to at the very least make changes to your
application to address various incompatibilities in the SQL dialects
and features.

> Specifically MSSQL has a migration tool but I have yet to use it so I am looking for whatever recommendations.
> Any MariaDB to PostgreSQL transferring tool known to anyone?

In theory, mysqldump has an option for formatting the output so that
it is more easy to ingest into other databases.
In reality, unless your data and structures are very trivial, you will
still have to thump the output to make the ingestion process work.

> I can try to re-create the scenario just with the relevant tables and it would be pretty simple to do eventually
> but time consuming if there is any automated tools for that.
>
> Any Recommendation is more then welcome!

The recommendation I can give you is that if you are looking at
migrating to a completely different database just to avoid using an
index hint, you probably haven't thought through the complexities of
migrating between databases.