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