{"id":2351,"date":"2018-06-08T11:57:37","date_gmt":"2018-06-08T10:57:37","guid":{"rendered":"https:\/\/www.webhostingsrbija.rs\/?p=1272"},"modified":"2018-06-08T11:57:37","modified_gmt":"2018-06-08T10:57:37","slug":"optimizacija-baze","status":"publish","type":"post","link":"https:\/\/www.webhostingsrbija.rs\/en\/optimizacija-baze\/","title":{"rendered":"Database optimization"},"content":{"rendered":"

U ovom \u010dlanku \u0107emo uraditi minioptimizaciju baze koja mo\u017ee da ubrza u\u010ditavanje admin dela wordpress-a.<\/p>\n

Revisions<\/h3>\n

Prva stvar koju \u0107emo uraditi jeste obrisa\u0107emo revision postova, to je zapravo da pogledate izmene koje ste vr\u0161ili u wordpressu. Malo smo napravili mini istra\u017eivanje sa na\u0161im klijentima i \u010dak 70% nije znalo da to ima, ostalih 30% je znalo ali niko nije ni pogledao ni jednu izmenu unazad.<\/p>\n

\"revision\"<\/a><\/p>\n

Ovo je stvarno korisna opcija koju daje wordpress da ukoliko se desi neka gre\u0161ka da mo\u017ee da se vidi unazad i ispravi. Me\u0111utim ovo va\u017ei samo za one koji ne koriste tu opciju.<\/p>\n

Zapravo svaka izmena koju napravite i sa\u010duvate sa „update“ prethodna kopija se sa\u010duva kao originalan post.<\/p>\n

Ugasi\u0107emo tu opciju tako \u0161to \u0107emo u wp-config.php fajlu da dodamo:<\/p>\n

\n
define<\/span>(<\/span>'WP_POST_REVISIONS'<\/span>,<\/span> false<\/span>);<\/span><\/code><\/pre>\n<\/blockquote>\n
Mo\u017eete da dodate bilo gde. Ovo \u0107e ugasiti bilo kakav revision na wordpressu, me\u0111utim ukoliko vam je potrebna ta opcija mo\u017eete da defini\u0161ite koliko verzija \u0107e \u010duvati slede\u0107im kodom:<\/p>\n
\n
define<\/span>(<\/span>'WP_POST_REVISIONS'<\/span>,<\/span> 3<\/span>);<\/span><\/code><\/pre>\n<\/blockquote>\n
Ovim ste ograni\u010dili broj na 3 \u0161to je mo\u017eda \u010dak i bolja opcija jer se nikad ne zna kada \u0107e zatrebati pregled prethodne verzije. Ali ukoliko ste sigurni da nemate potrebe za ovim jednostavno ugasite time \u0107ete dosta smanjiti te\u017einu baze.<\/p>\n
Autosave<\/h3>\n
Jedna opcija koja \u0107e pomo\u0107i da smanjite zauze\u0107e na svom hosting nalogu i time ubrzate sajt jeste da autosave kada pi\u0161ete post pove\u0107ate.<\/p>\n
Autosave sada je na 60 sekundi kao podrazumevano vreme, to zna\u010di da se va\u0161 post sa\u010duva svakih 60 sekundi i to zna\u010di da se upisuje u bazu svakih 60 sekundi i to plus posete posetioca i ako rade vi\u0161e urednika to je zaista puno upisa i \u010ditanja iz baze \u0161to podi\u017ee CPU na hostingu i zbog koga mo\u017eete da imate problema na hostinzima gde je cpu ograni\u010den CloudLinuxom.<\/p>\n
Da bi ste definisali autosave potrebno je da u wp-config.php fajlu dodate slede\u0107e:<\/p>\n
define('AUTOSAVE_INTERVAL', 300 );<\/code><\/p>\n
Ovim ste definisli da je autosave pomeren na 300 sekundi umesto na podrazumevanih 60.<\/p>\n
 <\/p>\n
Brisanje revision<\/h3>\n
Nakon \u0161to smo ograni\u010dili ili onemogu\u0107ili novo upisivanje i dupliranje, sada je potrebno da prethodne i obri\u0161emo. To \u0107emo uraditi tako \u0161to se ulgojemo u phpmyadmin (ulogujte se na cPanel (vasdomen.rs\/cpanel) zatim imate ikonicu phpmyadmin) otvori\u0107e vam se u novom tabu i pojavi\u0107e vam se baza podataka sa leve strane, kliknite na nju levim klikom.<\/p>\n
Nakon toga \u0107e vam se izlistati tabela sa leve strane u sivom delu odmah gde ste kliknuli, a sa desne strane pojavi\u0107e vam se opcije, kao \u0161to su „Structure“, „SQL“, „Search“ tu je potrebno da kliknete na SQL.<\/p>\n
\"phpmyadmin<\/a><\/p>\n
Zatim u polje za unos unesite slede\u0107e:<\/p>\n
 <\/p>\n
DELETE FROM [Ovde_Ide_Prefix]_posts WHERE post_type = „revision“;<\/p><\/blockquote>\n
Nakon toga kliknite na dugme „Go“ u donjem desnom uglu.<\/p>\n
Nakon toga ste obrisali revisie. Sjajno!<\/p>\n
Optimizacija<\/h3>\n
Poslednja stvar koju \u0107emo uraditi u vezi sa optimizacijom jeste koristi\u0107emo opciju optimize u phpmyadminu koja tako\u0111e poma\u017ee da se smanji te\u017eina baze.<\/p>\n
Otvorimo phpmyadmin ukoliko ste zatvorili na na\u010din isti kao u prethodnom koraku.<\/p>\n
\"php<\/a><\/p>\n
Zatim kliknimo na svoju bazu u desnoj strani da vam se tabele izlistaju i sa desne strane, zatim na dnu imate „Check all“ i odmah pored sa desne strane je klikom na „With selected“ imate „Optimize table“. Kada kliknete na to aplikacija \u0107e automatski optimizovati tabelu sa\u010dekate da zavr\u0161i.<\/p>\n
Kada se to desi u donjem delu isto \u0107ete videti kolika je baza bila u ovom na\u0161em test slu\u010daju 6.4MB i 3.4MB A nakon optimizacije je 2.8MB i 0B (ovo zna\u010di nula bajta zna\u010di ni\u0161ta).<\/p>\n
\"optimizzovano\"<\/a><\/p>\n
Vide\u0107ete i sami koliko \u0107e zapravo da se smanji baza razlike su jako jako velike.<\/p>\n
 <\/p>\n
Kao \u0161to ste videli nije bilo uop\u0161te te\u0161ko i nije bio potreban bilo kakav plugin koji DODATNO optere\u0107uje va\u0161 sajt ili bazu pa onda napravite kontra efekat.<\/p>\n
Izbegavajte pluginove koliko god je to mogu\u0107e jer oni dodatno optere\u0107uju va\u0161 sajt.<\/p>\n","protected":false},"excerpt":{"rendered":"
U ovom \u010dlanku \u0107emo uraditi minioptimizaciju baze koja mo\u017ee da ubrza u\u010ditavanje admin dela wordpress-a. Revisions Prva stvar koju \u0107emo uraditi jeste obrisa\u0107emo revision postova, to je zapravo da pogledate izmene koje ste vr\u0161ili u wordpressu. Malo smo napravili mini istra\u017eivanje sa na\u0161im klijentima i \u010dak 70% nije znalo da to ima, ostalih 30% je […]<\/p>\n","protected":false},"author":1,"featured_media":1286,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[18,19],"tags":[],"class_list":["post-2351","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-kako","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/2351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/comments?post=2351"}],"version-history":[{"count":0,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/posts\/2351\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/media?parent=2351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/categories?post=2351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhostingsrbija.rs\/en\/wp-json\/wp\/v2\/tags?post=2351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}