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.
  • 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.