We can improve the performance of our Prestashop by changing the database engine. To do this, we just have to follow these simple steps:
1. Open a text editor
2. Create a new document called, for example, myisam.php
3. Insert the following code into the document.
$host = "localhost"; //Host of the server, leave it by default as localhost$user = "user"; //Database user$pass = "password"; //Database password$db = "database"; //Database name// Do not touch anything beyond this pointini_set('display_errors', 'On');error_reporting(E_ALL);$link = mysql_connect($host, $user, $pass) or die("Could not connect to server: " . msql_error());mysql_select_db($db, $link) or die("Could not select database: " .msql_error());$result = mysql_query("show tables");if (!$result) { die('Query failed: ');}while ($row = mysql_fetch_array($result)){ mysql_query("ALTER TABLE ".$row[0]." ENGINE=MyISAM; ");}?>4. Replace the fields user, password, and database with the data of the database that you have installed for Prestashop (if you do not know this information, you can find it in the file /config/settings.inc.php).
5. Upload the file to the httpdocs folder of your server.
6. Execute the file through the browser by running the URL nombredesudominio.com/nombredelarchivo.php
Let it finish, and with this, all the tables would already be passed to MyISAM.