Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Canada
    Posts
    239

    Increase # of mysql threads

    I have a problem. I recently purchased a new server (dual opteron), to replace my pentium 4, which has been struggling. To my surprise, the new servers's load is about 10x of what I was getting on the p4.
    Mysql being the cpu/memory hog. I noticed that there are only 2 mysql threads going. On my old box I usually had 400-500.

    How can I turn off this 2 thread cap? my.cnf files on both servers are identical.

  2. #2
    Join Date
    Mar 2003
    Location
    California USA
    Posts
    13,294
    newer versions of mysql run in threated version so that is 100% normal.
    Steven Ciaburri | Industry's Best Server Management - Rack911.com
    Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
    Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
    FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance

  3. #3
    Join Date
    Oct 2002
    Location
    Canada
    Posts
    239
    I see, so why is this extreme load happening? mysql happens to use over 70% cpu now (vs less than 10% before).

  4. #4
    Join Date
    Jan 2003
    Posts
    38
    How many queries per second do u have?

    Check your /etc/my.cnf and eventualy replace with the big version.
    try to skip innodb if you don't need them
    Check php scripts and try to turn off persistent connections. In my experience that helps a lot.

    If is dedicate only for mysql that could be from network connection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •