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>> 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