Eric Hodel (drbrain) wrote,
Eric Hodel

MySQL 4.1 + FreeBSD 5.4

So last night I tried to switch the database from the FreeBSD 4 box to the FreeBSD 5 box. FreeBSD 5 has a strong dislike to the (seemingly reasonable, but apparently quite objectionable) query load it placed on the box.

So today I set up a test environment using the FreeBSD 5 database box so I can figure out what went wrong.

The most notable difference is that the FreeBSD 4 box has linuxthreads, while the FreeBSD 5 is using libpthread.

The objectionable behavior is an insane amount of context switches and syscalls. Normal operation (3 crawlers) gives between 8-40k context switches, and 4-20k syscalls. Misbehavior is 100k+ context switches and 40k+ syscalls.

  • (no subject)

    I dreamed I was in a grocery store with my mom reading Seattle Weekly from sometime late at night until 11AM. The Seattle Weekly had an article about…

  • Free Microwave! (and stuff)

    I have a convection oven microwave (this means you could bake a cake in a metal pan in it) I'd like to get rid of. If you or anyone you know would…

  • Tools!

    Today I used several of my tools. My new Collector Vehicle plate arrived, so I retired the 948-MPC plates to my closet and attached the new plate.…

  • Post a new comment


    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.