Slow queries from Zebra_Session about zebra_session HOT 5 CLOSED

The SET timestamp query is not from Zebra_Session. Other than that, the queries look fine to me but they take too long...Is there a HUGE amount of rows in the session table? (although, that shouldn't lead to this behaviour).

If you say that there are more GET_LOCK statements it may be that they are failing; replace the die statement in line 470 with error_log to see if that is the case; if this is indeed the problem then it is because you or your users are authenticated, in the same browser, with the same account, multiple times and doing things that take a lot of time to complete; during this time the row is locked and other sessions (same accounts, different tabs) will be unable to get these locks and will hang.

that's all I can come up with, for now.

from zebra_session.

SET timestamp I'm assuming is from MySQL internals for slowquery.log, so I think we can ignore that. There are currently 6,465 rows in session_data. I'll try your suggestions first.

from zebra_session.

I'm now using
error_log('Zebra_Session: Could not obtain session lock!', 1, '/path/to/zebra_log');
(given Apache write access)

And I've also tried
error_log('Zebra_Session: Could not obtain session lock!');

And neither the error_log nor zebra_log ever have any data written to them. Yet I still do see the entries in the mysqld slowqueries.log.

I've tried logging into the app myself and opening many different tabs to try to reproduce the problem, but I've never seen it myself as a result of anything I can do.

There aren't many other slow queries that show up in that log other than the ones produced by the session library, and the load is low enough that something like high processor or memory usage would cause them.

Any other suggestions?

from zebra_session.

I have a system that will be used with similar/same browsers and same accounts.

Will there be problems ?

from zebra_session.

This is most likely because of #16 and therefore should now be fixed

from zebra_session.