Forum Discussion

serrioal's avatar
serrioal
Regular Visitor
6 years ago

Error Code= 2147467259 MySql Timeout

I have a number of queries that have been running completely fine for months and about a month or so ago, they simply stopped refreshing in PowerQuery inside Excel. I could see the tables and transfo...
Need Help
lbendlin's avatar
lbendlin
Super User
6 years ago

Talk to your MySQL database people about index maintenance and ask them for the query plan for your queries.

serrioal's avatar
serrioal
Regular Visitor
6 years ago

Just checked with him and the indexes are good. Any other suggestions?

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    what about the query plan?

    • serrioal's avatar
      serrioal
      Regular Visitor
      6 years ago

      A-OK. Next step? Database adminstrator thinks there's something more fundamental happening. Thank you for the assistance and ideas.