Using PHP-MySQL Persistent Connections to Run WordPress Blog Uporaba PHP, MySQL obstojnih Connections to Run WordPress Blog

When connecting to MySQL database, WordPress weblog based on PHP scripting will use non-persistent connection by default. Ko vzpostavljate povezavo z MySQL podatkovno bazo, WordPress weblog temelji na PHP skriptnega bo uporaba brez vztrajnega zvezi privzeto. That is, WordPress will trigger PHP to generate a new connection to MySQL server for each dynamic page request, and subsequently close the database connection once the web page building is completed. To pomeni, da bodo priklicale WordPress PHP, da ustvarite novo povezavo na MySQL strežnik za vsako dinamično stran zahtevo, in nato zaprete povezave baze podatkov, ko je spletna stran zgradbe je končana. Repetitive opening and closing of MySQL connections causes overheads and uses up precious CPU, memory and system resources on the web host. Ponavljajoče se odpiranje in zapiranje MySQL povezav vzrokov režijski in uporabe do dragih CPU, pomnilnika in sistemskih virov na spletni strežnik.

Using persistent connection to connect to MySQL database server is not always a good option. Uporaba obstojnih povezavo za povezavo s podatkovno bazo MySQL strežnika ni vedno dobra izbira. Each connections takes up resources, including memory, buffers, table or thread caches internally in MySQL and sockets, open files or IO activity at OS level. Vsaka povezave traja največ sredstev, vključno s spominom, odbojnikov, tabele ali nit notranje shranjuje v MySQL in vtičnice, odprtih datotek ali IO dejavnost na OS ravni. Thus when a lot of persistent connections are opened but not closed after transactions are completed, the resources on system may drain up and degrade performance of web server, or in worst case, cause HTTP failure. Tako ko veliko obstojnih povezave se odprejo, ne pa tudi zaključila, ko o transakcijah so zaključena, sredstva za sistem možganov in razgradijo uspešnost spletnega strežnika, ali v najslabšem primeru povzroči HTTP neuspeh. Furthermore, if a persistent connection is stalled, inactive or became defunct or no longer in used, it is not terminated, and MySQL server will only close it to release the resource occupied by the connection after about 28800 seconds (8 hours) by default unless changed the timeout parameters in my.cnf configuration files. Poleg tega, če obstojnih povezava zastala, neaktivne ali postala neveljavna, ali niso več v uporabi, se ne ustavi, in MySQL strežnik bo samo zapreti za sprostitev virov, ki jih zaseda povezavo po približno 28800 sekund (8 ur), ki ga privzeto, razen če spremenil timeout parametri v my.cnf konfiguracijo datotek. This few factors may bring troubles such as MySQL refusing new DB connections or slow server if the applications do not properly handle persistent connections. To nekaj dejavniki lahko povzročili težave, kot so MySQL DB povezavah zavrnitev novih ali počasen server, če aplikacije ne ravnajo ustrezno obstojnih povezave. Thus if you're not experience webmasters, please do not attempt to change Wordpress to use persistent connections. Torej, če niste izkušnje webmastere, prosimo, ne poskušajte spremeniti Wordpress do uporabe obstojnih povezave.

However, for bloggers who have busy and large blog, and facing constraints in upgrading web host system specifications, and do not want to use static page caching plugin such as WP-Cache, persistent connection is a available option to tune and optimize the web server to see if the webpage serving can be faster. Vendar pa se za Bloggers, ki so zasedeni, in velik blog, in se soočajo z ovirami pri posodabljanju spletne gostiteljice specifikacijam sistema, in ne želite uporabljati statične strani caching plugin kot WP-Cache, obstojne povezava je na voljo možnost za nastavljanje in optimizacijo spletnega strežnika da vidim, če je spletna stran, ki služi lahko hitreje. Persistent connection allows connection to be open once and will not be closed when the execution of the script ends. Obstojna povezava omogoča povezavo s je odprt enkrat in ne bodo zaprti, če je izvršitev skripta konča. Instead, the link is kept in pool and will remain open for future use. Namesto, da je povezava hranijo v bazenu in bo ostal na voljo za prihodnjo uporabo. Thus, using persistent connections will eliminate the process of opening and closing the connection. Tako uporabljajo obstojna povezave bo odpravila procesu odpiranja in zapiranja povezavo. This will indirectly reduce MySQL connection related server overheads such as authentication to establish connection where only once is needed, saving extra network traffic, and resources used to handle extra connection. To bo posredno zmanjšajo MySQL strežnik povezavo z režijskimi stroški, kot so preverjanje pristnosti vzpostaviti povezavo, kadar je potrebno le enkrat, za varčevanje dodatnega omrežnega prometa, in sredstva, ki se uporabljajo za ravnanje z dodatno povezavo. Beside, there could be some connection level caches, which need to be filled up for proper performance, and potentially reduce the number of connections to the database. Poleg tega lahko nekatere povezave shrani ravni, ki jih je treba zapolniti za pravilno izvajanje in morebitno zmanjšanje števila povezave do podatkovne zbirke.

By default, WordPress is using mysql_connect() function that establishes a new database connection on every page. By default, WordPress uporablja mysql_connect () funkcijo, ki vzpostavlja novo bazo podatkov, povezave na vse strani. The persistent connection feature will require mysql_pconnect() function which uses the exact same API, but has built-in connection pooling to keep connections alive between requests. Nenehni povezavi funkcija zahteva mysql_pconnect () funkcijo, ki uporablja API natanko enak, vendar ima vgrajeno v zvezi združevanje povezav, da živi med zahtevki. So to switch to use persistent connection to run WordPress, the mysql_connect() function has to be replaced with mysql_pconnect(). Tako da preidejo na uporabo obstojnih povezavo teči WordPress je mysql_connect () funkcijo, je treba nadomestiti z mysql_pconnect ().

To enable and use persistent connections with WordPress, simply login to your web host with SSH (or insecure Telnet), and change to the webroot home directory where WordPress blog is installed. Da bi omogočili uporabo obstojne in povezav z WordPress preprosto prijavo na vaš spletni strežnik z SSH (ali negotovo Telnet), in sprememb v Webroot home directory WordPress blog, kjer je nameščen. Then change directory into wp-includes directory. Nato spremenite v imenik wp-vsebuje direktorij. Inside the wp-includes directory, there is wp-db.php file. Znotraj wp-vsebuje direktorij, je wp-db.php datoteko. Use any text editor such as vi to edit wp-db.php. Uporaba katerega koli urejevalnikom besedila, kot vi, da uredite wp-db.php. Search or locate the function of mysql_connect (or @mysql_connect ). Iskanje ali poiščite funkcijo mysql_connect (ali @ mysql_connect). There is only one instance of mysql_connect. Obstaja samo en primerek mysql_connect. Just change the mysql_connect to mysql_pconnect , then save and exit the wp-db.php. Samo spremenite mysql_connect do mysql_pconnect, nato pa shranite in zaprete wp-db.php. WordPress and PHP (as long as you don't turn off the mysql.allow_persistent in PHP.INI) will immediately use persistent connections to connect to MySQL database. WordPress in PHP (dokler ga ne izklopite mysql.allow_persistent v PHP.INI) bo takoj uporabi obstojnih priključki za povezavo s podatkovno bazo MySQL. It's worth to try out which setting is best for your environment. To je vredno poskusiti, katere nastavitve je najbolje za vaše okolje.

IMPORTANT : The page is machine translated and provided "as is" without warranty. POMEMBNO: Ta stran je stroj prevod in če "kot je" brez garancije. Machine translation may be difficult to understand. Strojno prevajanje je lahko težko razumeti. Please refer to Prosimo, da original English article original English članek whenever possible. kadar je to mogoče.

Related Articles Sorodni članki

• How to Move WordPress Blog to New Domain or Location Kako Premakni WordPress Blog v New Domain ali Lokacija
• WordPress MySQL SQL Query Error in WPDB Class WordPress MySQL SQL poizvedbe Napaka v WPDB razred
• Moderate WordPress Blog Comments Via Moderator with Desktop Client Zmerna WordPress Blog Komentarji Via Moderator z Desktop Client
• How to Customize, Modify or Change WordPress Database Connection Error Page Kako Prilagodi, Spremeni ali Spremeni WordPress Database Connection Error Page
• Replace Google Blog Search with Technorati for Incoming Links in Dashboard of WordPress Zamenjaj Google Blog Search z Technorati za dohodne povezave v armaturno ploščo WordPress
• WLWManifest Disabler Plugin to Remove XLM Link in WordPress Blog Header WLWManifest Disabler Plugin za Odstrani XLM Povezava na WordPress Blog Header
• AdSense and Display Banner Ads Rotation in WordPress Blog or Websites AdSense in Display Banner Ads Vrtenje v WordPress Blog ali spletne strani
• Integrate and Display Google AdSense for Search and Co-Op Custom Search Engine Results in WordPress Blog Page Template Vključiti in zaslona Google AdSense za iskanje in Co-Op Custom Search Engine Rezultati v WordPress Blog Page Template
• Change and Reset MySQL root Password Change in Ponast MySQL root geslo
• Paginating or Split WordPress Post or Page with NextPage in WordPress Not Working Paginating ali Split WordPress prepovedati vstop z napisno tablo ali stran s Nextpage v WordPress ne deluje

This entry was posted on Friday, September 14th, 2007 at 11:40 pm and is filed under Ta vnos je bil objavljen na petek, 14. september 2007 ob 11:40 in je vložena v skladu s Webmaster Resources Webmaster Resources . . You can follow any responses to this entry through the Lahko sledenje vseh odzivov na to vstop skozi RSS 2.0 RSS 2.0 feed. You can krme. Lahko leave a response pustite odgovor , or , Ali trackback Sledilnik from your own site. iz vaše strani.