Lock contention using ci_session (auth_lib) and MySQL

[eluser][email protected][/eluser]
Hey guys,

I am experiencing some ci_session lock contention using ci_sessions (auth_lib) on MySQL db. Some queries are taking 100+ seconds to execute, and then when the exact queries are rerun they are executed in .005s.

I know this is a database issue, but was wondering if anyone is willing to help me resolve this.

thanks