I have been told by my shared webhost that my installation has a high resource usage and is probably due to longer running sql queries that seem to be coming from my gallery module:

| 4649713 | Sleep   |   24 |          | NULL
| 4649715 | Query   |   24 | updating | DELETE FROM gallery_SessionMap WHERE gallery_SessionMap.drupal_creationTimestamp < 1214364176|
| 4649793 | Sleep   |    6 |          | NULL
| 4649794 | Query   |    6 | update   | INSERT INTO gallery_SessionMap (drupal_id, drupal_userId, drupal_remoteIdentifier, drupal_creationTimestamp, drupal_mod|
| 4649804 | Sleep   |    4 |          | NULL
| 4649805 | Query   |    3 | update   | INSERT INTO drupalallery_SessionMap (drupal_id, drupal_userId, drupal_remoteIdentifier, drupal_creationTimestamp, drupal_mod|
| 4649819 | Sleep   |    0 |          | NULL

Comments

atuyo60’s picture

atuyo60 commented

Anyone knows what this means and how I should solve the problem?

profix898’s picture

profix898 commented

I never noticed myself, but I will take a look at my server logs trying to confirm this. Can you please provide some details about your configuration (i.e. version of php, mysql, G2, Drupal, etc.)?

lvthunder’s picture

lvthunder commented
Status: Active » Closed (fixed)

Module developer asked a question that has been unanswered for over a year.