Tagged: website Toggle Comment Threads | Keyboard Shortcuts

  • Elmer Masters 7:13 pm on August 29, 2012 Permalink
    Tags: , , website   

    Quick update to the website theme to add a slogan we’re trying on. Needed a bit of styling to fit in.

     
  • Elmer Masters 2:05 pm on August 29, 2012 Permalink
    Tags: , , source control, website   

    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 8:54 pm on August 27, 2012 Permalink
    Tags: , , website   

    MySQL server CPU usage fall off at point that LOWER() was removed from user.module

     
  • Elmer Masters 8:10 pm on August 27, 2012 Permalink
    Tags: , , website   

    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 7:00 pm on August 27, 2012 Permalink
    Tags: , , website   

    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 3:20 pm on August 27, 2012 Permalink
    Tags: , website   

    Back to chasing bugs http://www.cali.org. Seeing weird errors from member contacts detail pages. Database is not resetting as it should.

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel