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.rei...@thelounge.net <mailto:h.rei...@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.l...@grassvalley.com <mailto:andy.l...@grassvalley.com> > <mailto:andy.l...@grassvalley.com > <mailto:andy.l...@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_ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
