Long running SQL queries
atuyo60 - July 16, 2008 - 05:39
| Project: | Gallery |
| Version: | 5.x-2.0 |
| Component: | Code / API |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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
#1
Anyone knows what this means and how I should solve the problem?
#2
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.)?
#3
Module developer asked a question that has been unanswered for over a year.