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?