Check Performance When Change Parameter On Oracle Database 40/sec to 500/sec

You are searching about Check Performance When Change Parameter On Oracle Database, today we will share with you article about Check Performance When Change Parameter On Oracle Database was compiled and edited by our team from many sources on the internet. Hope this article on the topic Check Performance When Change Parameter On Oracle Database is useful to you.

40/sec to 500/sec

Mawu Oyamba

Kudabwa, ndi mutu? Chabwino, uwu ndi ulendo wa momwe tidasokoneza scalability jinx kuchokera pakugwira zolemba zochepa za 40 pa sekondi imodzi mpaka zolemba 500 pamphindikati. Chenjerani, mavuto ambiri omwe tidakumana nawo anali olunjika kutsogolo, kotero kuti anthu odziwa zambiri atha kupeza izi kukhala zosafunikira.

Zamkatimu

* 1.0 Kodi tinali kuti?

1.1 Memory imagunda mlengalenga

1.2 Low processing rate

1.3 Kutayika kwa data 🙁

1.4 Mysql imatikokera pansi

1.5 Slow Web Client

* 2.0 Msewu wopita ku Nirvana

2.1 Kuwongolera kukumbukira!

2.2 Kuwongolera kuchuluka kwa ma process

2.3 Kodi kutayika kwa data bwanji uh-uh?

2.4 Kukonza Mafunso a SQL

2.5 Tuning database schema

2.5 Mysql imatithandiza kupita patsogolo!

2.6 Mofulumira…Mwachangu Wogwiritsa Ntchito Webusaiti

* 3.0 Mzere wapamwamba

Kodi tinali kuti?

Poyamba tinali ndi dongosolo lomwe limatha kupitilira ma 40 ma rekodi / sec. Ndikhoza kukumbukira zokambiranazo, za “zolembazo ziyenera kukhala zotani?”. Pomaliza tidaganiza kuti 40/sec ndiye mulingo woyenera wa firewall imodzi. Chifukwa chake tikayenera kutuluka, tifunika kuthandizira ma firewall atatu. Chifukwa chake tidaganiza kuti 120/sec ndiye mulingo woyenera. Kutengera zomwe zachokera kwa omwe timapikisana nawo tinafika potsimikiza kuti, atha kuthandizira mozungulira 240/sec. Tinkaganiza kuti zili bwino! monga kunali kutulutsa kwathu koyamba. Chifukwa onse opikisanawo adalankhula za kuchuluka kwa ma firewall omwe adathandizira koma osati pamlingo.

Memory ikugunda kumwamba

Kukumbukira kwathu nthawi zonse kumagunda mlengalenga ngakhale pa 512MB! (OutOfMemory kupatula) Tidadzudzula cewolf (ma) memory caching wa zithunzi zopangidwa.Koma sitinathawe kwa nthawi yayitali! Ziribe kanthu kaya tidalumikiza kasitomala kapena ayi timakonda kugunda mlengalenga masiku angapo max 3-4 days flat! Chosangalatsa ndichakuti, izi zidathekanso pomwe tidatumiza zidziwitso pamitengo yokwera kwambiri (ndiye), pafupifupi 50 / mphindi. Munaganiza bwino, chotchinga chopanda malire chomwe chimakula mpaka kukafika padenga.

Low processing mlingo

Tinkakonza zolemba pamlingo wa 40 / sec. Tinali kugwiritsa ntchito zosintha zambiri za dataobject(s). Koma sizinapereke liwiro loyembekezeka! Chifukwa chake, tidayamba kusungitsa deta mu kukumbukira zomwe zimapangitsa kukumbukira kukumbukira!

Kutayika kwa Data 🙁

Pothamanga kwambiri tinkaphonya paketi (mapaketi) ambiri. Tinkawoneka kuti tinali ndi vuto lochepa la data, koma izi zidapangitsa kuti tikumbukire. Pakusintha kwina kuti tichepetse kukula kwa buffer tidayamba kutayika kwa data pafupifupi 20% pamitengo yokwera kwambiri.

Mysql imatikokera pansi

Tinkayang’anizana ndi nthawi yovuta pamene tidaitanitsa fayilo ya chipika pafupifupi 140MB. Mysql inayamba kugwedezeka, makinawo anayamba kukwawa ndipo nthawi zina amasiya kuyankha. Koposa zonse, tinayamba kupeza deadlock (s) ndi transaction timeout (s). Zomwe pamapeto pake zidachepetsa kuyankha kwadongosolo.

Slow Web Client

Apanso tinadzudzula chiwerengero cha ma graph omwe tidawonetsa patsamba ngati botolo, kunyalanyaza mfundo yakuti pali zinthu zina zambiri zomwe zikukokera dongosololi pansi. Masamba omwe ankakonda kutenga masekondi a 30 kuti alowetse tsamba lomwe lili ndi ma graph 6-8 ndi matebulo pambuyo pa masiku 4 pa Internet Data Center.

Njira Yopita ku Nirvana

Kuwongolera Memory!

Tinayesa kuyika malire pa kukula kwa buffer kwa 10,000, koma sizinakhalitse. Cholakwika chachikulu pamapangidwewo chinali choti tinkaganiza kuti chotchinga cha 10000 chikhala chokwanira, mwachitsanzo, tidzakhala ma rekodi osungidwa asanafike 10,1000. Mogwirizana ndi mfundo yakuti “Chinachake chikhoza kulakwika chidzalakwika!” zinalakwika. Tinayamba kutaya deta. Pambuyo pake tidaganiza zopita ndi fayilo yokhazikika yokhazikika, momwe datayo idatayidwa mufayilo lathyathyathya ndikuyika mu database pogwiritsa ntchito “load data infile”. Izi zinali mwachangu nthawi zambiri kuposa kuyika kochulukira kudzera pa driver wa database. mungafunenso kuyang’ana kukhathamiritsa kotheka ndi load data infile. Izi zidakonza vuto lathu lokulitsa kukula kwa ma buffer a mbiri yakale.

Vuto lachiwiri lomwe tidakumana nalo linali kuchuluka kwa ma cewolf (ma) mu makina osungira kukumbukira. Mwachikhazikitso idagwiritsa ntchito “TransientSessionStorage” yomwe imasunga zithunzizo m’makumbukidwe, zikuwoneka kuti pali vuto pakuyeretsa zinthuzo, ngakhale zolozerazo zitatayika! Chifukwa chake tidalemba kachitidwe kakang’ono ka “FileStorage” komwe kumasunga zinthu zazithunzi mufayilo yakomweko. Ndipo pempho lidzaperekedwa ngati pempho likubwera. Komanso, tinakhazikitsanso njira yoyeretsera zithunzi zakale (zithunzi zakale kuposa mphindi 10).

Chinthu chinanso chosangalatsa chomwe tapeza apa chinali chakuti Wotolera Zinyalala anali wocheperako kwambiri kotero kuti zinthu zomwe zidapangidwa pa mbiri iliyonse, sizinayeretsedwe. Nawa masamu pang’ono kuti afotokoze kukula kwa vutolo. Nthawi zonse tikalandira cholembera timapanga ~ zinthu 20 (hashmap, zingwe zojambulidwa ndi zina) kotero pamlingo wa 500/sec kwa sekondi imodzi, kuchuluka kwa zinthu kunali 10,000(20*500*1). Chifukwa cholemera processing Wotolera zinyalala sanakhale ndi mwayi woyeretsa zinthuzo. Chifukwa chake zomwe tidayenera kuchita ndikusintha pang’ono, tidangopereka “null” pazofotokozera zachinthu. Voila! wotolera zinyalala sanazunzidwepo ndikuganiza 😉

Kuwongolera mtengo wa processing

Mlingo wowongolera unali wochepera 40 / sec zomwe zikutanthauza kuti sitingathe kupirira ngakhale kuphulika kwakung’ono kwa zolemba zamalogi! Kuwongolera kukumbukira kunatipatsa chitonthozo, koma vuto lenileni linali kugwiritsa ntchito zosefera zochenjeza pamarekodi. Tinali ndi katundu pafupifupi 20 pa mbiri iliyonse, tinkafufuza malo onse. Tidasintha kukhazikitsa kuti zigwirizane ndi zomwe tinali nazo! Komanso, tidakhalanso ndi kutayikira kwa kukumbukira pakusefera chenjezo. Tinasunga mzere womwe unakula mpaka kalekale. Chifukwa chake tidayenera kusungitsa fayilo yathyathyathya kutaya chinthu kuti tipewe kubwerezanso zolemba kuti tipange zinthu! Kuphatikiza apo, tinkakonda kufunafuna chofananira chilichonse mwazinthuzo ngakhale tinalibe njira zochenjeza zomwe zidakhazikitsidwa.

Kutayika kwa data bwanji uh-uh?

Titakonza zovuta zamakumbukiro pakulandila deta mwachitsanzo, kutaya mu fayilo yosanja, sitinataye data! Kuphatikiza apo, tidayenera kuchotsa ma index angapo osafunikira patebulo laiwisi kuti tipewe kupitilira apo tikutaya deta. Tidakhala ndi zolozera zamagawo omwe amatha kukhala ndi miyeso itatu yotheka. Zomwe zidapangitsa kuti kuyikako kuchepe komanso sikunali kothandiza.

Kukonza Mafunso a SQL

Mafunso anu ndi makiyi anu kuti mugwire ntchito. Mukangoyamba kukhomerera zovutazo, mudzawona kuti mungafunike kusintha ma tebulowo. Tinachita! Nazi zina mwa mfundo zazikuluzikulu:

* Gwiritsani ntchito “Analyze table” kuti muwone momwe funso la mysql limagwirira ntchito. Izi zikupatsani chidziwitso cha chifukwa chomwe funsolo likuchedwa, mwachitsanzo, ngati likugwiritsa ntchito ma index olondola, kaya akugwiritsa ntchito sikelo ya tebulo ndi zina.

* Osachotsa mizere mukamachita ndi data yayikulu motsatana ndi ma 50,000 patebulo limodzi. Nthawi zonse yesetsani kupanga “drop table” momwe mungathere. Ngati sizingatheke, konzaninso schema yanu, ndiyo njira yanu yokha yotulukira!

* Pewani kujowina (ma) osafunikira, musaope kusintha (mwachitsanzo kubwereza zomwe zili mgawoli) Pewani kujowina (ma) momwe mungathere, amakonda kukukokerani pansi. Ubwino umodzi wobisika ndikuti amakupatsirani kuphweka kwamafunso anu.

* Ngati mukulimbana ndi deta yochuluka, nthawi zonse gwiritsani ntchito “load data infile” pali njira ziwiri apa, zapafupi ndi zakutali. Gwiritsani ntchito kwanuko ngati mysql ndi kugwiritsa ntchito zili mumakina omwewo mwina gwiritsani ntchito kutali.

* Yesani kugawa mafunso anu ovuta kukhala awiri kapena atatu osavuta. Ubwino munjira iyi ndikuti gwero la mysql silinasungidwe panjira yonseyi. Amakonda kugwiritsa ntchito matebulo osakhalitsa. M’malo mogwiritsa ntchito funso limodzi lomwe limadutsa magome 5-6.

* Mukamachita ndi kuchuluka kwa data, mwachitsanzo, mukufuna kukonza ma rekodi 50,000 kapena kupitilira apo mufunso limodzi yesani kugwiritsa ntchito malire kuti muwerenge zolembazo. Izi zidzakuthandizani kukulitsa dongosolo kuti likhale lokwera

* Nthawi zonse gwiritsani ntchito ma transaction ang’onoang’ono m’malo mokhala akulu, mwachitsanzo, kudutsa matebulo “n”. Izi zimatseka zida za mysql, zomwe zingayambitse kuchedwetsa kwadongosolo ngakhale pamafunso osavuta

* Gwiritsani ntchito majowina pamizere yokhala ndi ma index kapena makiyi akunja

* Onetsetsani kuti mafunso omwe amafunsidwa ali ndi njira kapena malire.

* Onetsetsaninso kuti gawo lazofunikira lalembedwa

* Mulibe mtengo wamawerengero a sql mkati mwa mawu, chifukwa mysql imakhala ndi mtundu wa cast

* gwiritsani ntchito matebulo osakhalitsa momwe mungathere, ndikugwetsa …

*Kuyika kwa sankhani/kufufuta ndi loko lokho la pawiri… dziwani…

* Samalani kuti musapweteke nkhokwe ya mysql ndi kuchuluka kwa zosintha zanu pankhokwe. Tinali ndi vuto lomwe tinkakonda kutaya ku database pambuyo pa zolemba 300 zilizonse. Ndiye titayamba kuyesa 500 / sec tinayamba kuwona kuti mysql imatikokera pansi. Apa ndipamene tidazindikira kuti zomwe zimachitika pamlingo wa 500 / sec pali pempho la “load data infile” sekondi iliyonse ku database ya mysql. Chifukwa chake tidayenera kusintha kuti titayire zolembazo pakatha mphindi zitatu m’malo molemba ma 300.

Kusintha schema ya database

Mukamachita ndi kuchuluka kwa data, nthawi zonse onetsetsani kuti mumagawa deta yanu. Uwu ndiye njira yanu yopita ku scalability. Gome limodzi loti 10 lakhs silingathe kukula. Pamene mukufuna kuchita mafunso kwa malipoti. Nthawi zonse khalani ndi magawo awiri a matebulo, matebulo aiwisi imodzi ya data yeniyeni ndi ina ya matebulo a lipoti (matebulo omwe wogwiritsa ntchito amafunsapo!) Onetsetsani kuti nthawi zonse zomwe zili pamatebulo anu a lipoti sizikula mopitilira malire. Ngati mukukonzekera kugwiritsa ntchito Oracle, mutha kuyesa magawowo potengera zomwe mukufuna. Koma mwatsoka mysql sichigwirizana ndi izi. Chotero ife tiyenera kuchita zimenezo. Khalani ndi meta tebulo momwe muli ndi mutu wamutu mwachitsanzo, tebulo loti muyang’ane, pamiyeso yoperekedwa nthawi zambiri.

* Tidayenera kudutsa mu schema yathu yankhokwe ndipo tidawonjeza kuti tiwonjezere ma index, kufufuta ena ngakhalenso magawo obwereza kuti tichotse majowina okwera mtengo.

* Kupita patsogolo tidazindikira kuti kukhala ndi matebulo osaphika monga InnoDB kunali kopitilira muyeso, chifukwa chake tidasintha kukhala MyISAM.

* Tinapitanso kumlingo wochepetsera kuchuluka kwa mizere m’matebulo osasunthika ophatikizidwa ndi majowina

* NULL m’matebulo a database ikuwoneka kuti imapangitsa kuti magwiridwe antchito agwire, chifukwa chake apeweni

* Musakhale ndi zolozera pamndandanda womwe walola 2-3

* Onani kufunikira kwa index iliyonse patebulo lanu, ndizokwera mtengo. Ngati matebulo ali a InnoDB ndiye kuti muwonenso zosowa zawo. Chifukwa matebulo a InnoDB akuwoneka kuti akutenga nthawi pafupifupi 10-15 kukula kwa matebulo a MyISAM.

* Gwiritsani ntchito MyISAM nthawi iliyonse pakakhala zambiri, mwina mwa (sankhani kapena ikani) mafunso. Ngati kuyika ndi kusankha kudzakhala kochulukirapo ndiye kuti ndibwino kukhala nayo ngati InnoDB

Mysql imatithandiza kupita patsogolo!

Sinthani seva yanu ya mysql POKHALA mutakonza bwino mafunso/machitidwe anu ndi ma code anu. Pokhapokha mutha kuwona kusintha kowoneka bwino kwa magwiridwe antchito. Nawa ma parameter omwe ali othandiza:

* Gwiritsani ntchito kukula kwa dziwe komwe kungathandize kuti mafunso anu azichita mwachangu –innodb_buffer_pool_size=64M ya InnoDB ndikugwiritsa ntchito –key-bufer-size=32M ya MyISAM

* Ngakhale mafunso osavuta adayamba kutenga nthawi yayitali kuposa momwe amayembekezera. Tinadabwa kwenikweni! Tidazindikira kuti mysql ikuwoneka kuti ikukweza mndandanda wa tebulo lililonse lomwe imayamba kuyikapo. Chifukwa chake zomwe zimachitika nthawi zambiri zinali, funso lililonse losavuta patebulo yokhala ndi mizere 5-10 limatenga pafupifupi mphindi 1-2. Pakuwunika kwina tidapeza kuti funso losavuta lisanachitike, “load data infile” idachitika. Izi zinasowa pamene tidasintha matebulo aiwisi kukhala mtundu wa MyISAM, chifukwa kukula kwa buffer kwa innodb ndi MyISAM ndi masinthidwe awiri osiyana.

kuti mudziwe zambiri zosinthika onani apa.

Langizo: yambani mysql yanu kuti muyambe ndi njira yotsatirayi –log-error izi zipangitsa kuti pakhale zolakwika

Mwachangu…mwachangu Wokasitomala Wapaintaneti

Mawonekedwe ogwiritsira ntchito ndi chinsinsi cha mankhwala aliwonse, makamaka liwiro la tsamba ndilofunika kwambiri! Pano pali mndandanda wa mayankho ndi maphunziro omwe angakhale othandiza:

* Ngati deta yanu sisintha kwa mphindi 3-5, ndi bwino kusunga masamba am’mbali mwa kasitomala wanu

* Amakonda kugwiritsa ntchito Iframe(ma)pa ma graph amkati etc. amapereka kufulumira kwamasamba anu. Bwino kugwiritsabe ntchito javascript potengera zomwe zili munjira. Izi ndi zomwe mungafune kuchita mukakhala ndi ma graph 3+ patsamba lomwelo.

* Wofufuza pa intaneti amawonetsa tsamba lonse pokhapokha zonse zikalandiridwa kuchokera pa seva. Chifukwa chake ndikofunikira kugwiritsa ntchito iframes kapena javascript pakutsitsa zomwe zili.

* Osagwiritsa ntchito zambiri/zobwereza za fayilo ya CSS patsamba la html. Internet Explorer imakonda kutsitsa fayilo iliyonse ya CSS ngati cholowera padera ndipo imagwiranso ntchito patsamba lathunthu!

Pansi

Mafunso anu ndi schema imapangitsa dongosolo kukhala lodekha! Akonzeni kaye ndiyeno muimbe mlandu database!

Onaninso

* Kuchita Kwapamwamba kwa Mysql

* Funso Magwiridwe

* Fotokozani funso

* Konzani Mafunso

* Kusintha kwa InnoDB

* Kusintha Mysql

Categories: Firewall Analyzer | Malangizo Othandizira

Tsambali lidasinthidwa komaliza 18:00, 31 Ogasiti 2005.

Video about Check Performance When Change Parameter On Oracle Database

You can see more content about Check Performance When Change Parameter On Oracle Database on our youtube channel: Click Here

Question about Check Performance When Change Parameter On Oracle Database

If you have any questions about Check Performance When Change Parameter On Oracle Database, please let us know, all your questions or suggestions will help us improve in the following articles!

The article Check Performance When Change Parameter On Oracle Database was compiled by me and my team from many sources. If you find the article Check Performance When Change Parameter On Oracle Database helpful to you, please support the team Like or Share!

Rate Articles Check Performance When Change Parameter On Oracle Database

Rate: 4-5 stars
Ratings: 3391
Views: 34152203

Search keywords Check Performance When Change Parameter On Oracle Database

Check Performance When Change Parameter On Oracle Database
way Check Performance When Change Parameter On Oracle Database
tutorial Check Performance When Change Parameter On Oracle Database
Check Performance When Change Parameter On Oracle Database free
#40sec #500sec

Source: https://ezinearticles.com/?40/sec-to-500/sec&id=65578

Related Posts

default-image-feature

When My Parents Arrive For A Visit Tomorrow Scheduling Youth Baseball Practice – Sample Schedule For Middle-School Aged Baseball Teams

You are searching about When My Parents Arrive For A Visit Tomorrow, today we will share with you article about When My Parents Arrive For A Visit…

default-image-feature

Check New Data When Load A New Data In Unity Christian Counseling

You are searching about Check New Data When Load A New Data In Unity, today we will share with you article about Check New Data When Load…

default-image-feature

When It Saw The Dog By The Water What You Need to Know About Pets and Feng Shui

You are searching about When It Saw The Dog By The Water, today we will share with you article about When It Saw The Dog By The…

default-image-feature

Check Macbook Pro When To Buy Second Hand Coming Soon to a Bed Near You – Bed Bugs Are on the Rise!

You are searching about Check Macbook Pro When To Buy Second Hand, today we will share with you article about Check Macbook Pro When To Buy Second…

default-image-feature

When It Is Dark Enough You See The Stars Winter Vacation Ideas – Visit Iceland For Northern Lights and Wintry Snorkeling

You are searching about When It Is Dark Enough You See The Stars, today we will share with you article about When It Is Dark Enough You…

default-image-feature

Check Login When Go To Controller In Asp Cutting Edge Software for Embedded Systems

You are searching about Check Login When Go To Controller In Asp, today we will share with you article about Check Login When Go To Controller In…