Buenas tardes tengo un problema casa tanto el sitio actual se cae entro a la bd y tiene el imite de conexiones aceptadas
Anteriormente teniamos el sitio en Acquia pero er muy lento y también tenia problemas, ahora migramos a google cloud pero se cae no regularmente
Alguna idea de como podría ver el problema
Anexo el bat de show processlist no esta completo pero se repite mucho
Cita: +--------+------+------------------+----------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+-----------+----
-----------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+--------+------+------------------+----------------------+---------+------+---------------------+------------------------------------------------------------------------------------------------------+-----------+---------------+
| 1052 | root | 10.158.0.5:58260 | NULL | Sleep | 4 | | NULL | 413 | 413 |
| 548739 | root | 10.158.0.3:55298 | dm_drupal_produccion | Query | 520 | Creating sort index | SELECT field_data_field_type_order0.entity_type AS entity_type, field_data_field_type_order0.entity_ | 2 | 0 |
| 548789 | root | 10.158.0.3:55412 | dm_drupal_produccion | Query | 526 | Creating sort index | SELECT field_data_field_type_order0.entity_type AS entity_type, field_data_field_type_order0.entity_ | 0 | 0 |
| 548806 | root | 10.158.0.3:55468 | dm_drupal_produccion | Query | 520 | Creating sort index | SELECT field_data_field_type_order0.entity_type AS entity_type, field_data_field_type_order0.entity_ | 0 | 0 |
Anexo errores de drupal salen varios pero con el mismo error
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Cita: Aug 16 14:04:33 contentserver-1 dm:
https://www.url.com.ar|1534428273|ph...|PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT commerce_product.product_id AS entity_id, commerce_product.revision_id AS revision_id, commerce_product.type AS bundle, :entity_type AS entity_type#012FROM #012{commerce_product} commerce_product#012WHERE (commerce_product.status = :db_condition_placeholder_0) AND (commerce_product.product_id IN (:db_condition_placeholder_1)) ; Array#012(#012 [:db_condition_placeholder_0] => 1#012 [:db_condition_placeholder_1] => 1231179#012 [:entity_type] => commerce_product#012)#012 in EntityCacheControllerHelper::entityCacheLoad() (line 92 of /var/www/drupal-commerce/sites/all/modules/entitycache/includes/entitycache.entitycachecontrollerhelper.inc).