Tagged Questions
3
votes
1answer
57 views
How can I get this query to use it's index?
Queries matching this query below shows up in the slow log (with different contentVersionId & modifiedDateTime).
As I don't really know what I'm doing I tried adding indexes to all columns in ...
2
votes
1answer
125 views
Innodb Slow queries since convert from MyISAM
a few days ago we converted some write intensive tables from MyISAM to InnoDB hoping to have a better performance due the better locking system of InnoDB, but instead of gain performance, we start to ...
5
votes
1answer
101 views
What is the expected performance impact when dropping a large table
I have a 100G+ innodb table that needs to be dropped in a production environment. I am trying to do this without interruption to service.
The table is no longer being written to, and needs to be ...
