Muaj pes tsawg cores tuaj yeem siv MySQL?
Muaj pes tsawg cores tuaj yeem siv MySQL?

Video: Muaj pes tsawg cores tuaj yeem siv MySQL?

Video: Muaj pes tsawg cores tuaj yeem siv MySQL?
Video: Nco Txog Hmoob - Xf. Txawj Pes Vaj & Fishermen's Project (Live Session) [Lyric Video] 2024, Kaum ib hlis
Anonim

38) mus rau tus nqi siab tshaj plaws ntawm 64. Qhov no yuav tsum koom nrog ntau dua cores . MySQL yuav txiav txim siv ntau cores , yog li koj qhov load ntawm 25% yog coincidence1 los yog muaj peev xwm tsis raug teeb tsa ntawm Solaris.

Tib neeg kuj nug, muaj pes tsawg txoj xov tuaj yeem ua MySQL?

Tom qab ntawd nws loj hlob mus rau 70 microseconds rau 128 tus neeg siv khoom, 140 microseconds rau 256 tus neeg siv khoom, thiab 300 microseconds rau 512 tus neeg siv khoom. MySQL ncav cuag qhov ua tau zoo tshaj plaws rau 128 tus neeg siv xov , nrog nws max TPS (1.8 lab) thiab qis latency (70 microseconds).

yog MariaDB multithreaded? MariaDB thov tias qhov kev txhim kho loj tshaj plaws ntawm nws cov tshiab version yog scalability ntawm loj heev multithreaded kho vajtse, ncav cuag ntau tshaj 1 lab queries ib ob ntawm ib tug yooj yim OLTP benchmark. Nyob rau sab MySQL, tib hom kev txhim kho tau ua tiav ntawm kev sib xyaw OLTP_RO benchmark.

Xav txog qhov no, puas yog MySQL multi threaded?

MySQL yog ib txheej txheem nrog ntau threads . Tsis yog tag nrho cov databases yog architected li no; qee muaj ntau cov txheej txheem uas sib txuas lus los ntawm kev sib koom nco lossis lwm txoj kev. Nws yog pheej yig los tsim kev sib txuas rau MySQL vim nws tsuas yog yuav tsum tau tsim ib xov (los yog noj ib qho ntawm ib lub cache).

Threads_connected hauv MySQL yog dab tsi?

Xov khiav txhais tau tias tag nrho cov neeg siv cov txheej txheem (xov) tam sim no ua rau ntawm tus neeg rau zaub mov database. Tus neeg rau zaub mov tuav cov kev sib txuas no thaum tus neeg siv khoom tos kom teb. Cov xov no yuav tau noj IO / CPU, thaum lwm tus yuav ua tsis tau dab tsi thaum tos lub rooj xauv kom tso tawm.

Pom zoo: