Tagged Questions
2
votes
3answers
1k views
How can I configure MySQL Innodb to handle 1000s of inserts per hour?
I have a very high traffic website where it is possible that 1000s of new records are inserted every hour.
This one error is crippling the site:
PDOException: SQLSTATE[40001]: Serialization failure: ...
0
votes
1answer
65 views
Keeping an eye on contention
In SQL Server, I am using the following command to see blocked sessions:
select * from sys.sysprocesses where blocked>0
This is super. The problem is I need to see what block sessions there ...
