0

As you could see on picture, saving data for users is very slow. Queries run fast, but for some reason it takes up to 2 minutes to save user data. The same happens with logging in.

What is more strange, I have DB versions of this site and have a previous version where this works normally and all of a sudden this started to happen.

  • I checked errors in log
  • Disabled modules
  • Cache reseting
  • Exported DB tables from working DB (user, user_roles, variables) to non working
  • Checked for missing modules
  • Tried older version of drupal (7.33).
  • Disabled some custom code modules

Tried everything I could come up, but still user_save is slow like on image and no errors or warnings appear. Really don't have a clue anymore what could be wrong, something in DB level must been wrong, not sure what to try anymore and where to look?

enter image description here

2
  • XHProf would prove to be quite useful here in identifying script responsible for affecting the performance or whether it's the database.
    – Beebee
    Commented Nov 26, 2014 at 13:29
  • Thanx on suggestion. I am planning to do that tomorrow, hopeing it will help. Something in DB is making system hang, but queries are fast so must be some script that hangs because of particular data in DB. As I tested the same code base with different DB and DB is the one making the differnce.
    – Blissful
    Commented Nov 26, 2014 at 14:10

1 Answer 1

1

I found the answer, well the reason. I had a in a module hook_user_update()

that has a CURL that connects to remote site and beacuse of it took much time to save, well to connect and then to save. Need a way to make this CURL connection not affect the user save.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.