MySQL server CPU usage fall off at point that LOWER() was removed from user.module
Updates from Elmer Masters Toggle Comment Threads | Keyboard Shortcuts
-
Elmer Masters
-
Elmer Masters
By removing the LOWER() functions from the validation routines in the core users.module, the system now uses the indexes on name and mail to check for uniques. The result is searches that run in the 10-20 millisecond range instead of 5-7 seconds. No more bottle neck. When dozens of bad registrations attempts happen at once the system just plows right through. It can handle upwards of 750 queries per second right now
-
Elmer Masters
So, Drupal makes extensive use of the LOWER() function in MySQL. The problem is that LOWER() ignores any indexes on columns and iterates through each row looking for a match. This is a problem if your user table has >600K rows. The problem was under discussion several years ago (see: http://drupal.org/node/181625; and this: http://drupal.org/node/83738; and is ultimately ignored at http://drupal.org/node/279851) but no solution was put in place for Drupal 6.
That means I’ll need to hack core to get this in. -
Elmer Masters
Back to chasing bugs http://www.cali.org. Seeing weird errors from member contacts detail pages. Database is not resetting as it should.
-
Elmer Masters
Creating project in Manymoon to deal with ECR websites.
-
Elmer Masters
Using PodPress on Classcaster
1: Activate PodPress
2: Configure (needs more info)
——-
Creating posts
1: Once media is ready, visit the media library and upload your media files for the podcast.
2: Create a new post
3: Get the URLs for the media, add them to the PodPress fields at the bottom of the new post form.
4: Write the post.
6: Rinse and repeat.Pretty straight forward actually.
-
Elmer Masters
Working on using PodPress for audio and video on a Classcaster blog. Plugin has been available but using it has not been properly documented.
-
Elmer Masters
ECR sites will include Lessons, podcasts, chapters, cases, and questions. Maybe even a crossword puzzle or 2.
-
Elmer Masters
Sorting out the best way to pull essay questions from Lessons to included them into the eLangdell Course Resource blogs
-
Elmer Masters
Copied the Supplement theme that Emily Barney and the CK team did for their WordPress based casebook supplement to a new eLangdell theme so that I can make some changes. The idea is to have a theme we can use for standard course resource collection sites.
