Different MySQL connections have different benefits whilst others are legacy methods. So i have listed recommend setting for the following web software.
- Joomla - Don't use MySQL, use MySQLi
- Prestashop - use innoDB, Link to original Article
Published in
MySQL