← Back to team overview

maria-discuss team mailing list archive

Re: Poor performance compared to MySQL

 


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


Follow ups

References