I will install and optimize mysql and mariadb

Optimize MySQL For High-Traffic Websites

When tasked with the need to implement optimizations to MySQL systems, we have some focus areas that may achieve some immediate effects. Configuration changes made to the /etc/my.cnf file can help the performance of databases that are experiencing a higher than anticipated number of users.

One strategy that can help is to keep the maximum amount of data and indexes cached in RAM. If InnoDB is your stage vehicle, the innodb_buffer_pool_size variable needs to be set appropriately. After determining how much data is being used by InnoDB, you have a guideline as to the size of your buffer pool. You should aim to accommodate the full-size requirements of InnoDB without using more than 50% of available memory. If this cannot be accomplished, it may be time to consider more memory. Using too much memory for InnoDB will negatively affect the systems performance in other ways.

Similar changes can be made if MyISAM is used as the storage vehicle for your database. In this case, key_buffer_size is the variable that needs to be addressed. It should be set to less than 30% of the total RAM available.