Jump to content

Edit History

El Patron

El Patron

This may help:

Review your MySQL settings in phpMyAdmin—look for any values in red and address them.

  • Adjust key variables like innodb_buffer_pool_size, query_cache_size, and max_connections to recommended levels.
  • Enable the slow query log temporarily to find slow queries, then disable it once finished.
  • Monitor and adjust settings regularly as your traffic and database grow.
  • Consider upgrading to faster storage (NVMe SSD), stronger hosting, or newer software.
  • For intensive tasks (like combinations generation), have a developer review and update these processes to run from the command line (CLI) instead of the web interface. This avoids PHP limits and dramatically improves performance.

How to Check MySQL Database Settings Using phpMyAdmin

  1. Log in to phpMyAdmin from your hosting control panel.
  2. Select your database in the sidebar.
  3. Click the “Variables” tab at the top to see MySQL settings.
  4. Look for values in red—these highlight settings below recommended levels.
  • innodb_buffer_pool_size: Should be 60–80% of server RAM for dedicated databases.
  • query_cache_size: 32–128MB for MySQL 5.7 or lower; zero for MySQL 8.0+.
  • max_connections: 100–300, depending on traffic and available RAM.
  • slow_query_log: Enable temporarily to find slow queries, then turn off.

Monitor these values regularly and adjust as needed.

Depending on your hosting (shared, VPS, or dedicated), you may need to request changes from your provider.

 

PrestaShop 1.7.6.x has known issues with slow combination generation—especially with products having many attributes/values. This is mostly due to inefficient PHP logic, lack of batching, and sometimes database design.

  • Later PrestaShop versions (1.7.7.x, 1.7.8.x, and 8.x) introduced several performance fixes for the combination generator:
  • More efficient algorithms to generate combinations.
  • Improved JavaScript handling for large attribute sets in the admin.
  • Reduction in redundant database calls during generation.
  • Better handling of saving/updating combinations in bulk.
  • PrestaShop 8.x continues these improvements, and the new combination generator is significantly faster and more reliable for catalogs with thousands of combinations.

Additional Tips

  • Use NVMe SSD hosting for faster database performance.
  • Upgrade your application to the latest version for improved efficiency.
  • Have a developer review performance issues—especially combination generation or imports—and move heavy tasks to CLI scripts.
  • Running these from the command line avoids PHP web server limits and ensures faster, more reliable processing.
El Patron

El Patron

This may help:

Review your MySQL settings in phpMyAdmin—look for any values in red and address them.

  • Adjust key variables like innodb_buffer_pool_size, query_cache_size, and max_connections to recommended levels.
  • Enable the slow query log temporarily to find slow queries, then disable it once finished.
  • Monitor and adjust settings regularly as your traffic and database grow.
  • Consider upgrading to faster storage (NVMe SSD), stronger hosting, or newer software.
  • For intensive tasks (like combinations generation), have a developer review and update these processes to run from the command line (CLI) instead of the web interface. This avoids PHP limits and dramatically improves performance.

How to Check MySQL Database Settings Using phpMyAdmin

  1. Log in to phpMyAdmin from your hosting control panel.
  2. Select your database in the sidebar.
  3. Click the “Variables” tab at the top to see MySQL settings.
  4. Look for values in red—these highlight settings below recommended levels.
  • innodb_buffer_pool_size: Should be 60–80% of server RAM for dedicated databases.
  • query_cache_size: 32–128MB for MySQL 5.7 or lower; zero for MySQL 8.0+.
  • max_connections: 100–300, depending on traffic and available RAM.
  • slow_query_log: Enable temporarily to find slow queries, then turn off.

Monitor these values regularly and adjust as needed.

Depending on your hosting (shared, VPS, or dedicated), you may need to request changes from your provider.

Additional Tips

  • Use NVMe SSD hosting for faster database performance.
  • Upgrade your application to the latest version for improved efficiency.
  • Have a developer review performance issues—especially combination generation or imports—and move heavy tasks to CLI scripts.
  • Running these from the command line avoids PHP web server limits and ensures faster, more reliable processing.
El Patron

El Patron 

<h2>Summary of Recommendations</h2>
<ul>
  <li>Review your MySQL settings in phpMyAdmin—look for any values in <strong>red</strong> and address them.</li>
  <li>Adjust key variables like <code>innodb_buffer_pool_size</code>, <code>query_cache_size</code>, and <code>max_connections</code> to recommended levels.</li>
  <li>Enable the slow query log temporarily to find slow queries, then disable it once finished.</li>
  <li>Monitor and adjust settings regularly as your traffic and database grow.</li>
  <li>Consider upgrading to faster storage (NVMe SSD), stronger hosting, or newer software.</li>
  <li><strong>For intensive tasks (like combinations generation), have a developer review and update these processes to run from the command line (CLI) instead of the web interface. This avoids PHP limits and dramatically improves performance.</strong></li>
</ul>

<h2>How to Check MySQL Database Settings Using phpMyAdmin</h2>
<ol>
  <li><strong>Log in to phpMyAdmin</strong> from your hosting control panel.</li>
  <li><strong>Select your database</strong> in the sidebar.</li>
  <li><strong>Click the “Variables” tab</strong> at the top to see MySQL settings.</li>
  <li><strong>Look for values in red</strong>—these highlight settings below recommended levels.
    <ul>
      <li><strong>innodb_buffer_pool_size:</strong> Should be 60–80% of server RAM for dedicated databases.</li>
      <li><strong>query_cache_size:</strong> 32–128MB for MySQL 5.7 or lower; zero for MySQL 8.0+.</li>
      <li><strong>max_connections:</strong> 100–300, depending on traffic and available RAM.</li>
      <li><strong>slow_query_log:</strong> Enable temporarily to find slow queries, then turn off.</li>
    </ul>
  </li>
  <li><strong>Monitor these values regularly and adjust as needed.</strong></li>
</ol>
<p><em>Depending on your hosting (shared, VPS, or dedicated), you may need to request changes from your provider.</em></p>

<h2>Additional Tips</h2>
<ul>
  <li><strong>Use NVMe SSD hosting</strong> for faster database performance.</li>
  <li><strong>Upgrade your application</strong> to the latest version for improved efficiency.</li>
  <li><strong>Have a developer review performance issues—especially combination generation or imports—and move heavy tasks to CLI scripts.</strong> Running these from the command line avoids PHP web server limits and ensures faster, more reliable processing.</li>
</ul>

 

×
×
  • Create New...