Te hanga i te tepu i roto i te MySQL Waihanga raraunga Ripanga

Pātengi Raraunga, ka rite ki rerekē o te kukū o te mōhiohio mea faufaa, a kahore e kore e taea te mahi ia ratou ara he kaupapa iti. Pēhea te tōtika whakaaro i roto i te hanganga, tepu tika hangaia, kōrero whakaritea - tei runga i te auau tauira / tuhituhi ngā mōhiohio, tika raraunga, kī te eita o te kino kōpeka, wātea huriwhakamuri, te faaoti o ia hoko - me te angitu o te katoa.

Ko matua te pātengi raraunga - whakaaro ariā, whakaaturanga o ngā mōhiohio, me te arorau o tona whakamahi i roto i te mahi ngā.

Simple ōwehenga whakatinanatanga whai hua =

whakaaro tūhonohono o te whakahaere raraunga mārama kore te pai, engari he pakari ratou mau ratou tūranga mō ngā tekau tau. Ka rite ki wheketere mo te hanga o te kai me te taonga faufaa ki te kiritaki, e tino hiahiatia ana e ratou.

whakaaro hou i roto i te mōhiohio mau whakaaturia maha nga wa tika ratou ki te ora, engari i rahua ki te whakarato nui taunakitanga o te oraraa o te tika taua ki tenei ra. Ka rite ki nga wa katoa, te ohie - te matua ki te angitu. Heoi, ko te kaupapa o te whanaungatanga, me ngā hononga i waenganui i ngā raraunga - ngā, me ngā pūnaha i roto i te wāhi ngā mōhiohio - tonu ki tonu o wahi ma me hitimahuta ngā.

Hoatu hanganga ohie MySQL hanga tepu arata'i ki te hanganga o ohie, me te watea ki te whakamahi i pinepine o tepu, te whakaōkawa hōkai raruraru. Tīmata te whakamahi i "uaua" Ko te tino māmā, engari i muri i hoatu nga papa o mua o whanaunga tūhonohono kotahi tekau ara ki te huru rerekē ki ngā mōhiohio, whakaaturanga, rokiroki me te whakamahi.

Rangitahi, te mana me te tamau

tōpito: "te whare tefito" ariā pātengi raraunga i waho te whai wāhitanga o MySQL, i haere mai ki te ora ki te hōtaka Ipurangi, me meinga kua ha konga mahu'inga o reira. Kua whakaaetia Dynamic, hangarau hou te pātengi raraunga ki te riro i te ngāwari nohopuku, pono, me te whai hua, ki te ako me te whakamahi.

I tua atu ki te tepu matua hanga rangitahi hoahoa tepu MySQL taea te kaihātepe ki te waihanga rangitahi hanganga raraunga tīariari i roto i te wātū nāianei, te haerenga o te kaiwhakamahi ngā, takanga o te hui motuhake.

Ki te i tukinotia mua ki te tepu, me te whanaungatanga i waenganui i a ratou rite te tahi mea mâro-, e kore kua tenei ra i tangohia noa te pātengi raraunga kaha ki te kōrero ki te taonga faufaa. Ko te taahiraa tika ki he mahara ki te hanganga o te mōhiohio e hiahiatia ana ki te whakaoti i te raruraru tenei.

Na roto i te whakarato i te taputapu ki te waihanga tepu rangitahi, te waihanga ripanga rangitahi, taea MySQL ki a koutou wahia te pātengi raraunga i runga i te wāhanga pateko, me te hihiri. Äta nga momo o mara i roto i te tepu, ka taea e te kaihātepe whakahaere aunoa i te tika o tona hanganga. Mā te MySQL hanga tepu hoahoa Taki, ka taea e te kaihoahoa whakapūtā te tikanga mō te whakakī i te mara. Ahakoa tenei kōwhiringa - kaua he faingamālie ki te whakahaere i te hekenga o whakaaro i te tahi atu reo SQL.

Space Information: ngā me ngā pūnaha

Katoa kaupapa, ahakoa te mea te pae katoa, he whārangi kotahi te hātepe ohie ranei, kei te i roto i te wahi tetahi he tetahi wāhi ngā mōhiohio. "Wāhitau" o te wahi - he mahi motuhake, te tikanga o te oraraa o te hātepe: te hanganga mōhiohio i runga i te kokoru me putanga, hanga tukanga faafariuraa.

Heoi, e kore e whai i tika te ture o MySQL, waihanga ripanga kore e taea te waihanga i roto i runga i tona wetereo.

I roto i tenei tauira, mara code_back, session_code owner_code tautuhi taviri, me te whakaatu i hoki, me te wātū kiritaki. E kore noa te whakamahi o te putanga kore-paerewa o MySQL waihanga ripanga, e kore kī konei e takoto i roto i tona mara o mātau, ka pania i roto i te tikanga: te waehere hoki i roto i te take o te otinga-kore o te hoko, te waehere kaha kiritaki me te waehere wātū, e kia rave rahi mo te kiritaki, engari, tei runga te reira, te wahi i te waehere e haere whakahaere hoki.

He hoki te whakamahi o kore-paerewa mara h_code, a_contents me a_surprise. Here, i roto i te waihanga ripanga MySQL tauira o pehea e taea i roto i tetahi mara raraunga, me semantics. I roto i tetahi āhuatanga i reira i a koutou i te tepu o kiritaki, he reira whakaaro nui ki te hanga i te keteroki o te wahi kaha o te tepu. e kore e tenei tika hanga reira he rawaka hanganga raraunga tuatahi. Hei tauira, a_contents mara tirotiro: ingoa, kupuhipa; ī-mēra, me a_surprise mara - te āhua o te kaiwhakamahi o nāianei.

Ko te a_contents whakaaro a_surprise me / ranei

e kore e taua ahua rapua e uru ki te tepu matua, e taea e nui, me te cumbersome, a ka whakawhāiti te iti, kei roto anake ngā mōhiohio e hāngai ana. Here hanga tepu MySQL - he tauira o te aha e taea te mahi whai wāhi te ingoa kiritaki me te kupuhipa, ranei te ī-mēra kupuhipa me i roto i ngā ohie: (a_contents rite '{$ cUserName}; {$ cUserPass}%') ranei (a_contents rite '% {$ cUserPass}; {$ cUserName} ').

I roto i tenei tauira, whakamahi ona ake Taki mahi o te tepu: scTableExists ( 'rm_cache'), me te mea kahore he te tepu, ka hiahia koe e kore anake ki te waihanga i te reira, engari ano hoki ki te tuhi, hei tauira, ko te torutoru pūkete tuatahi ki te kaiwhakahaere rauemi raraunga.

kē Paerewa waihanga ripanga, ki te kahore te vai horo'a iti MySQL ahua i te wātea o te tepu, me ona whakatū i roto i te take o te ngaro. Ko te tikanga, e kore te mea nui tenei. E kore e tirohia tatou anake mo te tepu, engari ano hoki whakakiia ai ki te kōrero tuatahi.

pūtau momo ohie

Pū o MySQL whakamahi o reo, rawa PHP, whakaiti ngā rongonui te nui o ngā raraunga: te tuatahi, me te tuatahi, netipirovannostyu ona taurangi. Ko te aho tino whakamahia nuitia, rite hiahiatia - te tau, me te rā, i ētahi wā raraunga arorau. whai wāhitanga atu whakaahua raraunga i runga i MySQL waihanga kei onge tepu. Ahakoa takoto te whakamutunga e te raruraru ki te kia faatiti'aifarohia. Ka taea e koe te whakamahi i te o te raraunga whānui katoa mā te waihanga ripanga MySQL, he tauira - tetahi paetukutuku pūnaha whakahaere ihirangi hou.

He aha a pehea ki te whakamahi i - tautuhi i te kaiwhakawhanake. I tenei wāhi i roto i te wa, kia rite ki Wikipedia, te āhuatanga rōrahi me te tere o te MySQL taea te whakatau i te whakaaro tino te horo o te kiritaki, tango ki pūkete te wheako o te kaiwhakawhanake whakamahia. A, no te whakamahia i runga i te waihanga ripanga MySQL taunoa-hanganga tukua ki te waihanga ma (tepu kau) ki ngā pūtau o te roa tāupe me ki te hanga i te ihirangi hihiri i roto i te tukanga.

hanganga raraunga Matatini

Takotoranga ki ngā momo raraunga ohie, raina tuatahi, kua arahina ki nui haere moni i roto i te hoahoa o te mōhiohio matatini ahanoa e ka mahi ki te pātengi raraunga e tahuri ki te rokiroki i nga aho matua, ngā tau (taupū - tino maha), ngā rā, me "raraunga nui" - pikitia , oro, me ētahi atu ihirangi horo. Tenei reo te waihanga i te SQL te tepu te MySQL tata kahore rohe. Hoki te tapatahi katoa me urutanga o "uaua" kaihātepe kua te mana tonu o te SQL tūturu i tona tikanga.

Waho ohie i roto i ngā o te char pātengi raraunga momo pūtau varchar ranei ului hātepe papatono mō te pānui i roto i te ahanoa oti - he hanganga raraunga matatini (āhuatanga, tikanga, wetereo me semantics), a ka tuhi unu ano ki te puka kiato, whakaritea te ngako o nei i te kaiwhakawhanake.

Ko te tepu wae

tīwae anake, ngā rārangi anake me kotahi anake huānga i to ratou pūtahitanga, a kotahi momo anake - pūtau. Ko te taketake tikanga MySQL hanganga "waihanga ripanga" tenei. No momo raraunga MySQL kore he taketake: te tokomaha, string pūāhua, rā ... e kore e whai te reira i te wetereo, engari tahuri te reira i roto i roto i te mahi.

Ka taea e rorohiko pūtau whakamārama aro ki reira ahua o ahanoa tetahi, e tika ana ki te whakaritenga o te mahi. Mai i te tirohanga o te pātengi raraunga e "tetahi momo" - aho anake.

Heoi, ahakoa te aha, me pehea ki te whakamahi i pai te kaiwhakawhanake. He mea nui kia i tenei wāhi i roto i te wa (rite ki Wikipedia) rōrahi me te tere MySQL tawhā taea makona i te whakaaro tino te horo o te kiritaki, tango ki pūkete te wheako o te kaiwhakawhanake whakamahia.

"Tenacious" he tepu tino māmā, whakaritea te ara tino ohie. Ki te homai e te kaiwhakawhanake i nga mara o te tikanga tika, e tapapa i te reira i roto i te char varchar ranei momo i roto i to koutou wetereo MySQL hanga tepu, ka mahi i te tepu.

ripanga tōpū

kia kōrero hoki tatou e pā ana ki taupū roto MySQL. Waihanga ripanga taea ki a koe whakaahua tonu ratou, ka whakamahi ki te uru buka nui o ngā raraunga. Ko te tino mārama, maheni, ka tino rite ki taua taipitopito e tei te arotautanga i runga i te tere CPU tenei huarahi, tauira Keteroki tūtahi hātepe tātai maha tīpakohia raraunga whakatika php.ini, my.ini me httpd.conf.

Na, kahore ārai te kaiwhakawhanake ki te waihanga i tō tirohanga ake "Raraunga" - "mau taviri ki te raraunga" mō te tapatahi tōpū - kahore rarangi i roto i te tepu, tau anake. Ka whakarato te moroiti waihanga ripanga int MySQL te toenga tika katoa o te tepu: uru ngāwari, mahi kuware, taumahinga tonu i te tere pai.

Tau tōpu, whakaritea rite te kāri raraunga tūturu i roto i te papa nui, me te mōmona, ka whakatere i te kōwhiringa, me te whakarerekētanga o te mōhiohio, kahore tetahi raruraru. Te kōwhiri te hanga i tētahi putanga o te matua o te whai wāhi mo te roanga o te mahi, ka taea e koe te whakamahi i te waihanga hanganga tepu rangitahi, hanga MySQL he tepu rangitahi i mua i te whakamahi i te reira. Ranei, mo te tauira, mō ia kaiwhakamahi - he tepu matua.

I roto i tenei horopaki, e kore te te wetereo tohua te whakamahi o waihanga ripanga, ki te kahore te vai MySQL taea ki a koe te hanga i te tepu tika, ara ka he ngaro ohorere, hei tauira, ko te hē tāuru / tāputa rorohiko ranei tukinga, ka fakahohaasi fakahokohoko.

Ko te mau a hautū - MySQL +

Mua, ko te pātengi raraunga ko te hanganga raraunga e whai hua. Hoahoa M ySQL hanga ripanga tīmatanga aru ariā puāwaitanga o ngā raraunga, me ratou wāhi i runga i te mokowā kōpae. hōtaka Ipurangi, a rawa rerekē o hautū me te arorau o te rongonui pūnaha whakahaere ihirangi, hanga ke, i titiro tuatahi, displacement: kia kia kotahi turanga i te huinga o te maha. Ko te wehenga i runga i te ingoa tepu kuhimua.

Kua whakaritea ētahi kaiwhakarato hautū i runga i te pātengi raraunga i te ingoa o to ratou titauraa, pēnei i te ingoa pātengi raraunga haamata ki te ingoa o te hautū rangatira.

Na roto i te a nui, e kore e mea faufaa te reira te mea ki te karanga i te pātengi raraunga, me te pehea, ki te karanga i reira i te tepu. Heoi, ka anga te āhuatanga ki te tohu e kore noa te wetereo MySQL me ngā whakaritenga o te whakahaere wetereo me, arā MySQL +.

He tepu iti, te māmā te whakarite ai, me te iti iho tuhi reira, te apiapi e tanuhia i te reira i roto i te reo papatono roto nei e whakamana te mahi e hiahiatia ana ki te raraunga.

I roto i te parau tumu, he ngāwari ki te peita ki wāhanga māmā tetahi mahi, ko, te nui e utu anake te pātai taua tapatahi.

Ki te hiahia koe i te MySQL ma, ake reira te hautū i tō tūmau ake, te wahi i reira ka kia kore here i runga i te maha o pātengi i nga tikanga o huaina ratou me o ratou tepu mema ranei.

He momo o putanga o Apache / MySQL / PHP

Ti'aturiraa i runga i te taiao e hautū - e kore e pera te nui o te raruraru, hei huru faufaa mo te hōtaka ārai hou. Ka taea e koe te tuhituhi i roto i te PHP 7.0.13, te whakamahi i MySQL 5.7.16, engari ka te kiritaki e hautū, tuku anake putanga o Perl me "uaua" 4.1.1 ranei te putanga tawhito o PHP.

I roto i te whānui (e, ratau kore ko te meka,) hautū e wātea ana i runga i Linux, FreeBSD, Ubuntu me ngā pūnaha ētahi atu rerekētanga yunikosopodobnyh. mahi ratou katoa pai, engari ia o ratou kua ona ake āhuatanga, ratou ake putanga o nga whakaminenga MAORI (Apache, MySQL, PHP). Ehara i nga wa katoa, me te kore e haere nga rōpū ki te mahi i roto i te putanga i muri, ahakoa mahi ia i roto i te kotahi o mua.

he mahi māmā, pēnei i te kaweake pātengi raraunga tetahi putanga o MySQL e kahore raruraru, e rua i Kawemai Kawemai phpMyAdmin, me i te rārangi whakahau. e kore e taea e ngā mahi Whakapā kawemai tango wahi. More maha atu i te kore whai ki te huri i te tahi mea i roto i to koutou PHP, MySQL tūmau Apache ranei. Ki te kore e tauturu i te huringa, he mea e tika ana ki te titiro mō ngā kē.

Te meka kitea, e taea te whakamana i te mahi mā te tautuhi anō i te pātengi raraunga, te reo hōtaka tūmau ranei. e kore ko te otinga pai, engari te nuinga o whai hua tenei.

Te hanga pātengi raraunga tepu / whakamanatanga

Wetereo MySQL hanga tepu uaua hāngai i roto i tona ahua paerewa. Ki te kore te mea whakaaro i roto i te horopaki o te pūnaha whakahaere ihirangi rongonui: i reira ka tonu kia te aronui o te momo. Ko māmā te mahi ia rā ki te whakaaro i te reira i roto i te horopaki o te mahi: e hiahiatia mara i roto i te tepu, i me whai e ratou he momo me te rahi. Me tonu te okiokinga ki whakamahine te tukanga o te whanaketanga: te huinga pūāhua, ahua kia, mau taviri.

Tino arotau ko te putanga o te hātepe, i roto i nei e kore e ara te kore o te pātengi raraunga pokanoa ki te pae, ki te tīmata. Ka taea e koe te tuhituhi koutou ake mahi tirohia te pātengi raraunga, me te / tepu ranei ka hiahia koe ki te waihanga e kore anake nga hanganga mōhiohio, engari ano ki te whakaki i roto i to ratou mōhiohio tuatahi.

Tino maha te whakamahi i te raupapa o whakaaro Waihanga tepu, ki te kahore te vai, kihai i MySQL maere i te rangatira pae te manuhiri ranei e mea ohorere: i reira he he whati kahore pātengi raraunga ripanga ranei hanganga.

I roto i te ture whānui hōtaka hou o "whakawhirinaki engari manatoko" e kore e te mahi, ranei, kaua e whakamahi i te arorau o te "tirohia me te whakamahi i."

Waihanga tepu: kaiwhakamahi MySQL tauira tepu

Rehita o ngā manuhiri hou, me te tomokanga / putanga o ngā kaiwhakamahi pae i whakawhanakehia maha nga wa, engari ko te rohe o te tino i roto i tenei wahi nui o tetahi pae ano.

I roto i te ara maha, kua tautuhi tāuru / putanga me te rēhita i ngā o tohutoro o te pae te whakamahi i te pūnaha whakahaere ihirangi me / ranei, engari maha - te hiahia ki te whakawhanake i te tahi mea haumaru atu, te tiaki pūkete kaiwhakamahi, te ārai hacking pae.

Tikanga, ko te atu haumaru atu i te paetukutuku MySQL pātengi raraunga, engari i roto i te take o te kore e kore e taea te i kingi whakaatu karere hapa pūtirotiro, waehere whirihoranga pae e kei ingoa me kupuhipa ki te pātengi raraunga.

mahi pai - ki te faaite i raraunga i runga i te wāhanga pateko, me te hihiri. I runga i te tauira o te tepu kaiwhakamahi, ka taea e koe te nuinga kaiwhakamahi ripanga me cache_users kaha. anake te hunga e mahi i te ra whakamutunga (hei tauira) - he maha nui o ngā kaiwhakamahi, te tuarua kei te tepu tuatahi. Katoa kaiwhakamahi hou kahore he nei i roto i te tepu tuarua, mai hoki i muri i te tomokanga / fariiraa me rongoa mo etahi wa.

Ko te wehenga ki e rua nga tepu i konei whakarato raraunga tauira auau (ko tonu tere atu i mōmona, me te nui, he tepu iti) kore anake, engari ano hoki i roto i te meka e take te reira i te mōhiohio anake e hiahiatia ana e te atu pinepine ka whakahaere i tetahi kiritaki o te pae ngā. Hoki tīpako huringa raraunga ranei whakamahia noatia te tepu matua.

Memory, ngā mōhiohio, me ngā pātengi raraunga

I roto i te mara o te hangarau mōhiohio e kore kua hopoia whakawhanakehia ki tohu te reo papatono mahara. Reo - te taurangi, taimau me ngā hanganga, tuku te tahi mea, me te hopoia rāwekeweke. Pātengi Raraunga - he te tahi mea rokiroki. Mai i reira ka taea e koe te whiriwhiri tonu te tahi mea i roto i reira ka taea e koe te tuhi i te tahi mea.

e kore te mea pera tino reo ngā me anga mo te whakaaro o te mahi ki te kōrero, ko te arorau o te hononga i roto i tenei topu-, ara i roto i te paihere ohie o MAORI: Apache, PHP, MySQL. Tenei he mea katoa mārama: ko te tūmau, te reo papatono me te pātengi raraunga - katoa e hiahiatia ana e te mo te nuinga o ngā mahi.

reo SQL - te reo hōtaka taua, a pono i roto i te pātengi raraunga e ona ake ngā mahi arorau, ake ariā hōtaka. Tenei to tatou i te hiahia ki te taha hōtaka pātengi raraunga. PHP - he taputapu pai, engari ki te mea te mea kua tukua e ia ki te āta taha pātengi raraunga, ko reira uaua. Heoi, tona hanganga me mahi whakawhanakehia, ka pai ake.

Ki te whakakotahi tatou PHP me MySQL i roto i te kōwae kotahi, whiwhi koe i te taputapu, kua he mahara. Kōwhiringa huinga homai te whakaaro o te hōtaka ahanoa-hāngai: whakaahuatia ahanoa i roto i te reo i te wa o to ratou kahore ona i roto i te mahara (i roto i te pātengi raraunga) i roto i te āhua kiato. A, no te riro te reira e tika ana, kua heke te reira ki te ahanoa tonu, me te mahi i roto i runga i tona mātau.