Mysql Help

[yesitsme]

For some reason mysql installer doesn't detect the installed Redistributables therefor terminating the installation process, simple solution download instedit and remove the launch contrition

[yesitsme]

For some reason mysql installer doesn't detect the installed Redistributables therefor terminating the installation process, simple solution download instedit and remove the launch contrition

Anyone?

issue still here, every time I try to update it deletes the current version and can't update till I remove the following from launch contrition.

Code: [Select]

Installed OR CPP_2015_REDISTRIBUTABLE_1 OR CPP_2015_REDISTRIBUTABLE_2 MySQL Workbench requires the Visual C++ 2015 Redistributable Package to be installed. Click the Download-Button on the next page to open a web page containing further instructions.

[yesitsme]

https://stackoverflow.com/questions/43172345/mysql-workbench-installer-requires-visual-c-2015-redistributable-package-to-be

[yesitsme]

I was scratching my head why I couldn't login to MySQL over ssh using workbench,
finally I got it working

the my.ini was messed up, the collation_server=utf8mb4_unicode_ci doesn't exist in 5.7, which didn't let MySQL start on my local machine
I needed to add a user on the remote server root@127.0.0.1, it only had localhost

BH we are past that

[yesitsme]

invisible indexes, something new to me, and what's the point
https://mysqlserverteam.com/mysql-8-0-invisible-indexes/

[Yisroel Tech]

invisible indexes, something new to me, and what's the point
https://mysqlserverteam.com/mysql-8-0-invisible-indexes/

As your link points out, use is good for when adding or removing an Index, you can have the Index but not have it make any impact on the queries. So you can add it when time is due for the change or completely remove after confirming everything is good (so no need to recreate the index if you miscalculated the ability of the system to function without the index.)

Talking about MySQL 8.0... Facebook published last week a nice blog on their migration from MySQL 5.6 to 8.0: https://engineering.fb.com/2021/07/22/data-infrastructure/mysql/

[yesitsme]

As your link points out, use is good for when adding or removing an Index, you can have the Index but not have it make any impact on the queries. So you can add it when time is due for the change or completely remove after confirming everything is good (so no need to recreate the index if you miscalculated the ability of the system to function without the index.)

Talking about MySQL 8.0... Facebook published last week a nice blog on their migration from MySQL 5.6 to 8.0: https://engineering.fb.com/2021/07/22/data-infrastructure/mysql/

I got what it does but what's the big deal of adding or dropping an index, I guess i'm not dealing with enough records it should make a difference to me
why would someone add an invisible index, its useless

[Yisroel Tech]

I got what it does but what's the big deal of adding or dropping an index, I guess i'm not dealing with enough records it should make a difference to me
why would someone add an invisible index, its useless

Not sure what's not clear. When there is an index it makes a difference in the execution (most of the time to the better, but sometimes to worse if things are not done well), in a normal production environments with release cycles etc. you wouldn't want to change anything just because. Everything needs to be tested and benchmarked.

So someone can create an invisible index which doesn't affect query execution (except when specified) and do the testing, then switch in a sec to a visible index when ready. (The other way, when sunsetting an index, is even more simple.)

[yesitsme]

tip, wanna import from csv? never attempt to use import wizard, instead use load infile, make sure the zip has the right encoding the difference in speed is a few ms vs a few hours.

[yesitsme]

https://dev.mysql.com/blog-archive/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes/

this is a great add on

[yesitsme]

Functional Index Key Parts
Starting with version 8.0.13, MySQL supports function key parts that index expression values rather than column values or column prefixes. Using parts of a function key allows you to index values that are not directly stored in the table:

Interesting concept