Lastest Mysql News

Posted by: Admin  :  Category: Mysql

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

MySQL Upgrade
mysql
Image by jspaw
DL180G5 12-disk 16G RAM

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

Comparing MySQL Statement-Based and Row-Based Replication
There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.
Read more on Database Journal

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

Is Your MySQL Monitoring Tool Cloud Ready?
Cloud, cloud, cloud. Cloud computing has become the phrase du jour, says one analyst from Gartner. But with many moving to cloud for its obvious benefits, it can no longer be ignored. An offshoot of cloud computing is utility computing. What interests us here is Database-as-a-Service, in particular MySQL on cloud. (PRWeb February 03, 2011) Read the full story at http://www.prweb …
Read more on PRWeb

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

16 Responses to “Lastest Mysql News”

  1. Adam Jacob Says:

    Wow, that is hard to believe.

  2. mspin Says:

    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 Says:

    WOW. That is amazing.

  4. kelp Says:

    Hmm…. We may have to test that…

  5. lhl Says:

    gadzooks!

  6. kellan Says:

    Ahhh yeah!

  7. Norby Says:

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

    -//

  8. SheeriSong Says:

    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 Says:

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

  10. Norby Says:

    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 Says:

    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 Says:

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

  13. Norby Says:

    @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 Says:

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

  15. Norby Says:

    good luck!

  16. dathan Says:

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

Leave a Reply

*