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 <discuss@lists.mariadb.org> wrote:
В Tue, 31 Oct 2023 11:45:52 +0200 Vassilis Virvilis <vasvir@iit.demokritos.gr> пишет:
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 -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org