Link You Today
Bookmark your Free, Libre software & tech link

data base Chasing a Hung MySQL Transaction: InnoDB History Length Strikes Back

mariadb, mysql, percona

Recently I was helping a customer discover why SELECT queries were running slower and slower until the server restarts (which got things back to normal). It took some time to get from that symptom to a final diagnosis. Please follow me on the journey of chasing this strange MySQL behavior!