Tagged Questions

0
votes
0answers
88 views

Need help! Interpreting INNODB MONITOR OUTPUT for Prestashop performance problems

We use a INNODB MYSQL Engine driven Database for hosting a Prestashop Version 1.5.3.1 on debian with apache2 webserver. We are facing performance problems, maybe some missconfigurations. There is a ...
3
votes
1answer
1k views

How do you read MySQL InnoDB Monitor output?

I am new to DB Administration. I am trying to figure out the cause of deadlock exceptions, but I am unable to make sense of the logs. The log says that "transaction 1 is rolled back". Why is this the ...