I am sorry to say that I am not able to tell what the problem was or were it came from, but in the end a my MySQL Server upgrade did the job. So I went for an MySQL Server upgrade to 5.7, did the db upgrade and suddenly my problem was gone.Īn EXPLAIN on the query now, showed number of examined ROWS "2" and testing with a few thousend UPDATEs is running as fast as usual, now. As I am still new to MySQL and not the creator of the db, nor have I any detailed clue about the keys, indices and overall structe. Later I was able to reproduce the slow behavoir when using the UPDATE query on my test system. Therefore I decided to concentrate more on the faulty DB instead of the Server System itself, wich was running fine, as I described earlier. The number of examined ROWS, on the fault system was way to high, in the "90000" region versus on the test system only "2". Thanks to neilstrong, pointing me to EXPLAIN! I will set up another machine on monday serving solely my DB but thats no long term solution.Īfter some more testing in my test environment and on the productive system I was ables to spot a huge difference in the output of the EXPLAIN command. I could't find more info regarding query profiling and cpu_system duration time so here I am,Īnd as you can see I am out of ideas, I have no clue at all. My last guess would be an OS misbehavior of some kind
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |