Quick update to the website theme to add a slogan we’re trying on. Needed a bit of styling to fit in.
Tagged: website Toggle Comment Threads | Keyboard Shortcuts
-
Elmer Masters
-
Elmer Masters
Correcting spelling errors in the CALI Courses module. Committing changes to git, pushing to GitHub, and cross committing to SVN. All because I can’t remember “i” before “e”…
-
Elmer Masters
MySQL server CPU usage fall off at point that LOWER() was removed from user.module
-
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.
