I have to say that surprises me. MyISAM became slower even on read-only workloads around MySQL 5. One of the reasons was that MyISAM uses the OS page cache for data caching and only caches index data internally. Which means that unless you have a covering index, you end up with more context switching to retrieve the row data. But maybe InnoDB has since been "enhanced" to the point where it is no longer outright faster on every workload.
On Wed, Nov 1, 2023 at 12:14 PM Ivan Krylov via discuss <[email protected]> wrote: > > В Tue, 31 Oct 2023 11:45:52 +0200 > Vassilis Virvilis <[email protected]> пишет: > > > If you change the table format to MyISAM do you get better > > performance? > > I almost missed your message, and that would have been a shame, because > if I change the table format to MyISAM, I get the query results in ~3.5 > seconds, which is faster than any other result I've been getting with > MariaDB. Many thanks! > > This is the largest table in our database, but it's also the easiest to > recreate, so we might just switch it to MyISAM with no apparent > downsides. > > -- > Best regards, > Ivan > _______________________________________________ > discuss mailing list -- [email protected] > To unsubscribe send an email to [email protected] _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
