|
|
|
Issue Links:
|
Relates
|
|
|
|
This issue has been marked as being related by:
|
|
|
MDL-17754 Session improvements and related rewrites
|
|
|
|
|
|
|
Our team (at SFSU) talked to the MySQL support (we have subscribed to their enterprise level support) and they suggested that we look into the codes and remove all attempts to cast sesskey to BINARY, as it will cause MySQL to ignore the preferred index and not use an index at all, resulting in slow response time. So we dig into the codes and did the following changes
in /lib/adodb/session/adodb-session.php (and adodb-session2.php in the same directory)
replace
$binary = $conn->dataProvider === 'mysql' ? '/*! BINARY */' : '';
to
$binary = $conn->dataProvider === 'mysql' ? '' : '';
This has dramatically improved the performance on our production site. However, would like to hear people's opinion about this change (also emailed Martin D, Martin L, and the author of ADODB already, but haven't heard back from them yet). Maybe the core could consider this change too. Also see the discussion thread that our system administrator Taylor posted here for more details:
http://moodle.org/mod/forum/discuss.php?d=106108
|
|
Description
|
Our team (at SFSU) talked to the MySQL support (we have subscribed to their enterprise level support) and they suggested that we look into the codes and remove all attempts to cast sesskey to BINARY, as it will cause MySQL to ignore the preferred index and not use an index at all, resulting in slow response time. So we dig into the codes and did the following changes
in /lib/adodb/session/adodb-session.php (and adodb-session2.php in the same directory)
replace
$binary = $conn->dataProvider === 'mysql' ? '/*! BINARY */' : '';
to
$binary = $conn->dataProvider === 'mysql' ? '' : '';
This has dramatically improved the performance on our production site. However, would like to hear people's opinion about this change (also emailed Martin D, Martin L, and the author of ADODB already, but haven't heard back from them yet). Maybe the core could consider this change too. Also see the discussion thread that our system administrator Taylor posted here for more details:
http://moodle.org/mod/forum/discuss.php?d=106108 |
Show » |
| No commits have yet been performed on this issue.
|
|
Improvement
Reopened
Remove all attempts to cast sesskey to BINARY as it was causing MySQL to ignore the preferred index, resulting in slow response time
