Planet MySQL

Displaying posts with tag: optimization (reset)

Dec

2017

Posted by Lerxst on Mon 11 Dec 2017 01:28 UTC
Tags:

sql, optimization, buffers, MySQL, bases de données, informatique, 8.0, optimisateur, plan d'accès, query optimiser, requête

C’était attendu depuis longtemps : MySQL 8.0 aura un optimiseur de requête amélioré et encore plus intelligent! Les détails ici.

Aug

2016

Freewill in progress (2)

Posted by Lerxst on Wed 03 Aug 2016 12:56 UTC
Tags:

database, Programming, scaling, optimization, Statistics, Optimisation, crossover, Statistiques, Smalltalk, Pharo, MySQL, algorithmes, programmation, informatique, Ruzzle, algorithmes génétiques, 8 queens, Burma, Burma14, chromosome, De Jong, eight queens, Freewill, genetic, genetic algorithm, Griewank, immigration, mutation, ranking, sélection, termination, Traveling salesman problem, TSP, TSPLIB, xover

(Click to enlarge)

What’s up?

As you can see, Freewill now supports 17 different selection policies. At this point, all of them are coded but only half of them have been tested.

The 11 available termination policies are coded, half of them tested.

So far, only 2 mutation policies are available. Both of them are coded and tested. I will probably need a few extras for TSP type of problems as well as numerically parametrized problems (e.g. De Jong functions with a domain for each variable). I’ll probably add 3-4 other ones specific to the problem that started all this adventure!

Only one immigration policy (no immigration!) is available and it will stay that way …

[Lire plus]

Oracle MySQL Blogs

Liens MySQL