InnoDB/XtraDB Configuration for optimum performance (MySQL 5.1 to MariaDB 10.1)

Hello, we were using MySQL 5.1 with MyISAM till now and now moving to MariaDB10.1. Instead of taking a Hop of MariaDB5.5, we will be removing MySQL after taking backup of data and then install MariaDB 10.1 & import the Data dump.

We will also be changing our engine to InnoDB/XtrDB. May I know what are the configuration we need to take care of with regard to InnoDB/XTraDB for better/faster responses.

Answer Answered by Harald Reindl in this comment.

don't you realize how stupid a question "how can i make something faster for something unnown" is?

if you don't know wehat you are dong stay at the defaults if you have special needs mention them

otherwise: if a generic configuration for mostly everything would be faster as the current dfaults don#t you think THAT would be the defaults?

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.