Am 02.06.20 um 17:13 schrieb Roberto Spadim:
yeap, i'm just trying to help to reproduce the problem
i'm talking about the regression problem of speed between the same engine but different versions
tha focus on that when one comes up with numbers comparing exactly that and *additionally* provides numbers with Aria BTW: that below looks like after shot in the head because of using HTML mails previosuly
Em ter., 2 de jun. de 2020 às 12:07, Reindl Harald <h.reindl@thelounge.net <mailto:h.reindl@thelounge.net>> escreveu:
Am 02.06.20 um 17:03 schrieb Roberto Spadim: > Try to avoid compare aria/myisam cause it have a journal
how does that matter for selects and the point is "but MariaDB 10 MyISAM is still a long way behind 5.5"
it's complety normal to also compare the same operations with different engines and the point is still MyISAM without anything else touched got way slower
> Em ter., 2 de jun. de 2020 às 11:48, Ling, Andy > <Andy.Ling@grassvalley.com <mailto:Andy.Ling@grassvalley.com> <mailto:Andy.Ling@grassvalley.com <mailto:Andy.Ling@grassvalley.com>>> escreveu: > > Well I’ve had a go. Using MariaDB 5.5.68 and MyISAM tables I get > times very similar to MySQL____ > > __ __ > > Some more definitive timings all on the same hardware…____ > > __ __ > > MySQL 5.5 MyISAM____ > > __ __ > > mysql> SELECT r.rushid FROM rushes r LEFT JOIN browse b ON r.rushID > = b.rushID WHERE b.rushID IS NULL AND r.updated < NOW() - INTERVAL 1 > DAY;____ > > +----------------------------------+____ > > | rushid |____ > > +----------------------------------+____ > > | 4de1e340d664dd87c4afda2c27f700a8 |____ > > | 455166dd2cefff65f578aa333f7a5581 |____ > > | 44f02723e901d2e958c58b9813ebaeae |____ > > +----------------------------------+____ > > 3 rows in set (3.63 sec)____ > > __ __ > > __ __ > > MariaDB 5.5.68 MyISAM____ > > __ __ > > MariaDB [quentin_v3]> SELECT r.rushid FROM rushes r LEFT JOIN browse > b ON r.rushID = b.rushID WHERE b.rushID IS NULL AND r.updated < > NOW() - INTERVAL 1 DAY;____ > > +----------------------------------+____ > > | rushid |____ > > +----------------------------------+____ > > | 4de1e340d664dd87c4afda2c27f700a8 |____ > > | 455166dd2cefff65f578aa333f7a5581 |____ > > | 44f02723e901d2e958c58b9813ebaeae |____ > > +----------------------------------+____ > > 3 rows in set (3.01 sec)____ > > __ __ > > MariaDB 10.4.2 MyISAM____ > > __ __ > > MariaDB [quentin_v3]> SELECT r.rushid FROM rushes r LEFT JOIN browse > b ON r.rushID = b.rushID WHERE b.rushID IS NULL AND r.updated < > NOW() - INTERVAL 1 DAY;____ > > +----------------------------------+____ > > | rushid |____ > > +----------------------------------+____ > > | 4de1e340d664dd87c4afda2c27f700a8 |____ > > | 455166dd2cefff65f578aa333f7a5581 |____ > > | 44f02723e901d2e958c58b9813ebaeae |____ > > +----------------------------------+____ > > 3 rows in set (12.890 sec)____ > > __ __ > > MariaDB 10.4.2 Aria____ > > __ __ > > MariaDB [quentin_v3]> SELECT r.rushid FROM rushes r LEFT JOIN browse > b ON r.rushID = b.rushID WHERE b.rushID IS NULL AND r.updated < > NOW() - INTERVAL 1 DAY;____ > > +----------------------------------+____ > > | rushid |____ > > +----------------------------------+____ > > | 4de1e340d664dd87c4afda2c27f700a8 |____ > > | 455166dd2cefff65f578aa333f7a5581 |____ > > | 44f02723e901d2e958c58b9813ebaeae |____ > > +----------------------------------+____ > > 3 rows in set (16.268 sec)____ > > __ __ > > So Aria is the slowest, but MariaDB 10 MyISAM is still a long way > behind 5.5_