MySQL Forums
Forum List  »  InnoDB

Re: Ease My Pain: InnoDB in a Memory-Constrained Environment
Posted by: Peter Brawley
Date: September 09, 2021 03:39PM

InnoDB does so much more than MyISAM, comparing them is like comparing a car with a bicycle.

The InnoDB errors you cite look like results of design and coding errors. MariaDB tried their best, for years, to mount a viable ACID-compliant alternative to InnoDB. They gave up. If Monty couldn't materially improve upon it, furious criticism of the sort you posted looks misdirected. So I suggest your frustration with InnoDB looks less about InnoDB, more about how you're using it.

There may be tables and operations in your system that don't need the overhead of ACID compliance. There are probably design issues with your InnoDB tables, and/or with queries on them.

So your solution, I suspect, will be a mixture of optimising your DDL and code, and buying enough server hardware to give InnoDB what it needs. If it's me, I start with a representative DB, analyse it for bottlenecks and possible optimisations (a possible starting point would be the optimisation cheatsheet described at https://www.artfulsoftware.com/infotree/mysqltips.php, but there are advanced tools out here too), and go from there.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.