• upgrade happened here

MySQL Upgrade

Newer Older

DL180G5 12-disk 16G RAM

Two sides of a single shard, taking the same traffic.

Dave Wongillies, lhl, kellan, and 7 other people added this photo to their favorites.

  1. Adam Jacob 65 months ago | reply

    Wow, that is hard to believe.

  2. mspin 65 months ago | reply

    Incredible. I'm running an earlier percona build, but I hadn't tried the highperf variants. Sure it's actually writing data to disk?:)

  3. mike.panchenko 65 months ago | reply

    WOW. That is amazing.

  4. kelp 65 months ago | reply

    Hmm.... We may have to test that...

  5. lhl 65 months ago | reply

    gadzooks!

  6. kellan 65 months ago | reply

    Ahhh yeah!

  7. Norby 65 months ago | reply

    Yeah, that's what I'm talking about!

    -/\/

  8. SheeriSong 65 months ago | reply

    If you look at SHOW ENGINE INNODB STATUS for Percona high perf builds, you'll see a difference in the File I/O section. The MySQL manual says that on Unix, there are always 4 threads:

    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for i/o request (insert buffer thread)
    I/O thread 1 state: waiting for i/o request (log thread)
    I/O thread 2 state: waiting for i/o request (read thread)
    I/O thread 3 state: waiting for i/o request (write thread)

    But on percona high performance versions:

    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for i/o request (insert buffer thread)
    I/O thread 1 state: waiting for i/o request (log thread)
    I/O thread 2 state: waiting for i/o request (read thread)
    I/O thread 3 state: waiting for i/o request (read thread)
    I/O thread 4 state: waiting for i/o request (read thread)
    I/O thread 5 state: waiting for i/o request (read thread)
    I/O thread 6 state: waiting for i/o request (read thread)
    I/O thread 7 state: waiting for i/o request (read thread)
    I/O thread 8 state: waiting for i/o request (read thread)
    I/O thread 9 state: waiting for i/o request (read thread)
    I/O thread 10 state: waiting for i/o request (write thread)
    I/O thread 11 state: waiting for i/o request (write thread)
    I/O thread 12 state: waiting for i/o request (write thread)
    I/O thread 13 state: waiting for i/o request (write thread)
    I/O thread 14 state: waiting for i/o request (write thread)
    I/O thread 15 state: waiting for i/o request (write thread)
    I/O thread 16 state: waiting for i/o request (write thread)
    I/O thread 17 state: waiting for i/o request (write thread)

    (this is from 5.1.36-percona-log, specifically).

    So, that to me is probably why the performance is way better.....more threads that can read and write in parallel.

  9. : Nils 65 months ago | reply

    This has something to do with databases, right? Sherioushly though, great shot.

  10. Norby 65 months ago | reply

    SheeriSong: I thought you had to bump the innodb_file_io_threads variable up to take advantage of that, but apparently the highperf build opens up 16 r/w threads by default...

    -/\/

  11. Timmy 65 months ago | reply

    The File IO threads are fixed at 4 in standard builds, but adjustable in the Percona release. They just handle asynchronous IO, though. The majority of IO is done synchronously by the InnoDB threads handling the queries. (See innodb_thread_concurrency) The read threads above handle page pre-fetch and read-ahead operations, and write threads handle buffer pool flush operations.

  12. SheeriSong 65 months ago | reply

    Norby, Timmy -- this was on a server that had innodb_thread_concurrency set to 0, which I believe is "unlimited".

  13. Norby 65 months ago | reply

    @SheeriSong: Yeah, turns out I had manually set the number of read and write threads on this box with some variables Timmy supplied (without actually reading what I was adding) ... c'est la vie! More wood for the fire!

    -/\/

  14. dathan 64 months ago | reply

    upgrading myself, hope to see the same effect since I am having aio problems at the moment.

  15. Norby 64 months ago | reply

    good luck!

  16. dathan 64 months ago | reply

    works great, I upgraded to 5.1.34 XTRADB for my lookup servers.

keyboard shortcuts: previous photo next photo L view in light box F favorite < scroll film strip left > scroll film strip right ? show all shortcuts