High Lock Wait ratio in MySQL
- by FunkyChicken
on my site I log every pageview (date,ip,referrer,page,etc) in a simple mysql table.
This table gets very little selects (3 per minute), but a lot of inserts. (about 100 per second)
Today I changed this table from an InnoDB table to a MEMORY table, this made sense to me to prevent unnecessary hard disk IO. I also prune this table once per minute,…