maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx <mailto:h.reindl@xxxxxxxxxxxxx>> 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@xxxxxxxxxxxxxxx <mailto:Andy.Ling@xxxxxxxxxxxxxxx>
>     <mailto:Andy.Ling@xxxxxxxxxxxxxxx
>     <mailto:Andy.Ling@xxxxxxxxxxxxxxx>>> 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_