{"id":130,"date":"2010-01-27T16:55:01","date_gmt":"2010-01-27T15:55:01","guid":{"rendered":"http:\/\/blog.websupport.sk\/?p=130"},"modified":"2025-03-11T21:06:04","modified_gmt":"2025-03-11T20:06:04","slug":"tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql","status":"publish","type":"post","link":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/","title":{"rendered":"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL"},"content":{"rendered":"Doba \u010d\u00edtania:<\/b><\/span> 3<\/span> min.<\/span><\/span>

V tomto blogu vam prin\u00e1\u0161ame nieko\u013eko tipov ako vylep\u0161i\u0165 v\u00fdkonnos\u0165 slu\u017eieb (web, maily, db) bez potreby zh\u00e1\u0148a\u0165 v\u00fdkonej\u0161ie \u017eelezo. A to v\u0161etko iba jednoduch\u00fdmi nastaveniami. Berte a vychutn\u00e1vajte :).<\/p>\n


\nZl\u00e1 \u0161k\u00e1lovatelnos\u0165 MySQL<\/strong><\/p>\n

MySQL datab\u00e1za m\u00e1 v niektor\u00fdch pr\u00edpadoch ve\u013emi zl\u00fa \u0161k\u00e1lovatelnos\u0165. Ned\u00e1 sa jednoducho v\u017edy zv\u00fd\u0161i\u0165 kapacita v\u00fdkonu iba upgradom hardwaru na ktorom be\u017e\u00ed.
\nV na\u0161om pr\u00edpade m\u00e1 MySQL probl\u00e9m s ve\u013ek\u00fdm mno\u017estvom tabuliek, ktor\u00e9 sa pou\u017e\u00edvaj\u00fa a zamykan\u00edm table_cache v MySQL. Thready \u010dakaj\u00fa ve\u013ea \u010dasu na otvorenie tabuliek (k\u00fdm neuvo\u013en\u00ed z\u00e1mok in\u00fd thread). Ke\u010f\u017ee nastaveniami MySQL sa to vyrie\u0161it ned\u00e1, jedin\u00e9 rie\u0161enie je rozlo\u017eenie z\u00e1\u0165a\u017ee na viac MySQL serverov na virtu\u00e1lnych serveroch.
\nPostup je jednoduch\u00fd: reboot serveru do XEN verzie kernelu. S XEN verziou m\u00e1me mo\u017enos\u0165 dynamicky sp\u00fa\u0161ta\u0165 virtu\u00e1lne servery z\u00e1rove\u0148 s hlavn\u00fdm syst\u00e9mom. N\u00e1sledne m\u00f4\u017eme po \u010dastiach popres\u00fava\u0165 datab\u00e1zy z hlavnej MySQL na dal\u0161ie virtu\u00e1lne servery.<\/p>\n

Jeden z probl\u00e9mov ktor\u00e9 sa vyskytli, bola chyba v XEN kerneli debianu, ktor\u00e1 e\u0161te nebola opraven\u00e1 v hlavnom repozit\u00e1ri.
\nhttp:\/\/bugs.debian.org\/cgi-bin\/bugreport.cgi?bug=516479<\/a><\/p>\n

Odlah\u010denie z\u00e1\u0165a\u017ee datab\u00e1z<\/strong><\/p>\n

<\/strong>Monitorujeme sql query be\u017eiace na MySQL serveroch a h\u013ead\u00e1me neoptimalizovan\u00e9 query ktore zbyto\u010dne za\u0165a\u017euj\u00fa server. Ak objav\u00edme\u00a0nejak\u00fd\u00a0probl\u00e9m, kontaktujeme z\u00e1kazn\u00edka. V niektor\u00fdch pr\u00edpadoch aj pom\u00f4\u017eeme s optimaliz\u00e1ciu sql query.\u00a0Na grafe je vidie\u0165 klesnutie z\u00e1\u0165a\u017ee na datab\u00e1zovom serveri po oprave query nad ve\u013ekou tabu\u013ekou s probl\u00e9mom ORDER BY RAND(). Graf ilustruje ako m\u00f4\u017ee z\u00e1\u0165a\u017e na serveroch ovplyv\u0148ova\u0165 zl\u00fd k\u00f3d aplik\u00e1cie (query do db).<\/p>\n

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

\n

Bli\u017e\u0161ie inform\u00e1cie o probl\u00e9me ORDER BY RAND()\u00a0http:\/\/www.titov.net\/2005\/09\/21\/do-not-use-order-by-rand-or-how-to-get-random-rows-from-table\/<\/a><\/p>\n

\u010casto sa n\u00e1s p\u00fdtaju klienti, \u010di ich server unesie vysok\u00fa n\u00e1v\u0161tevnos\u0165, tis\u00edcky zobrazen\u00ed a podobne. N\u00e1v\u0161tevnos\u0165 je d\u00f4le\u017eit\u00e1, ale ke\u010f je aplik\u00e1cia zle naprogramovan\u00e1, nepom\u00f4\u017eu v\u00e1m ani najv\u00fdkonej\u0161ie servery. A plat\u00ed to aj presne naopak. Pri pekne odladenom a vychovanom k\u00f3de, v\u00e1m bude sta\u010di\u0165 aj virtual s p\u00e1r MB Ram.<\/p>\n

Email slu\u017eby<\/strong><\/p>\n

<\/strong>D\u00e1vnej\u0161ie v lete sa n\u00e1m podarilo zn\u00ed\u017ei\u0165 za\u0165a\u017eenie emailov\u00e9ho serveru zmenou I\/O schedulera z CFQ na DEADLINE.\u00a0CFQ scheduler ktor\u00fd rovnomerne rozde\u013euje diskov\u00e9 oper\u00e1cie, ktor\u00e9 volaj\u00fa procesy za\u010dal robi\u0165 probl\u00e9my pri ve\u013ekom po\u010dte procesov v syst\u00e9me,\u00a0ktor\u00e9 \u010d\u00edtali\/zapisovali ve\u013ea mal\u00fdch s\u00faborov.\u00a0Po zmene schedulera na DEADLINE sa v\u00fdrazne zlep\u0161ila r\u00fdchlos\u0165 emailov\u00fdch slu\u017eieb.\u00a0DEADLINE scheduler pou\u017e\u00edva 4 I\/O fronty a zora\u010fuje \u010dakaj\u00face requesty aby zv\u00fd\u0161il I\/O priepustnos\u0165. Je v\u00fdhodn\u00e9 ak prevl\u00e1da jeden typ z\u00e1\u0165a\u017ee. Na grafe je pekne vidno, ako to zn\u00ed\u017eilo za\u0165a\u017eenie.<\/p>\n

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

Moment\u00e1lne u\u017e emailov\u00e9 slu\u017eby obsluhuje in\u00fd, v\u00fdkonnej\u0161\u00ed server.<\/p>\n

Web slu\u017eby<\/strong><\/p>\n

<\/strong>R\u00fdchlos\u0165 webov\u00fdch slu\u017eieb unlimited a custom hostingu sa zlep\u0161ila po ugprade webserverov z distrib\u00facie debian etch na\u00a0verziu lenny a kernelu na verziu 2.6.31, ten prin\u00e1\u0161a lep\u0161\u00ed readahead algoritmus pre I\/O oper\u00e1cie. Taktie\u017e bola opraven\u00e1\u00a0chyba v driveri pre raid radi\u010d, ktor\u00e1 sp\u00f4sobovala spomalenie diskov\u00fdch oper\u00e1ci\u00ed pri vy\u0161\u0161ej z\u00e1\u0165a\u017ei. Na grafe m\u00f4\u017eete vidie\u0165 zn\u00ed\u017eenie loadu na webserveroch po aplikovn\u00ed novej verzie kernelu.<\/p>\n

\"web\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

V tomto blogu vam prin\u00e1\u0161ame nieko\u013eko tipov ako vylep\u0161i\u0165 v\u00fdkonnos\u0165 slu\u017eieb (web, maily, db) bez potreby zh\u00e1\u0148a\u0165 v\u00fdkonej\u0161ie \u017eelezo. A to v\u0161etko iba jednoduch\u00fdmi nastaveniami. Berte a vychutn\u00e1vajte :).<\/p>\n","protected":false},"author":84,"featured_media":5579,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8],"tags":[142,186,359,526,760,956,974],"class_list":["post-130","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technologie","category-tipy-a-triky","tag-cfq","tag-databaza","tag-io","tag-mysql","tag-skalovatelnost","tag-websupport","tag-xen"],"yoast_head":"\nTipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL - Websupport.sk Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL - Websupport.sk Blog\" \/>\n<meta property=\"og:description\" content=\"V tomto blogu vam prin\u00e1\u0161ame nieko\u013eko tipov ako vylep\u0161i\u0165 v\u00fdkonnos\u0165 slu\u017eieb (web, maily, db) bez potreby zh\u00e1\u0148a\u0165 v\u00fdkonej\u0161ie \u017eelezo. A to v\u0161etko iba jednoduch\u00fdmi nastaveniami. Berte a vychutn\u00e1vajte :).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport.sk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2010-01-27T15:55:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T20:06:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"290\" \/>\n\t<meta property=\"og:image:height\" content=\"380\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"T\u00edm Websupport\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"T\u00edm Websupport\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\"},\"author\":{\"name\":\"T\u00edm Websupport\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/d3f3517a180f66130801edb710ffb6b3\"},\"headline\":\"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL\",\"datePublished\":\"2010-01-27T15:55:01+00:00\",\"dateModified\":\"2025-03-11T20:06:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\"},\"wordCount\":625,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png\",\"keywords\":[\"CFQ\",\"datab\u00e1za\",\"I\/O\",\"MySQL\",\"\u0161k\u00e1lovate\u013enos\u0165\",\"websupport\",\"XEN\"],\"articleSection\":[\"Technol\u00f3gie\",\"Tipy a triky\"],\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\",\"url\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\",\"name\":\"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL - Websupport.sk Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png\",\"datePublished\":\"2010-01-27T15:55:01+00:00\",\"dateModified\":\"2025-03-11T20:06:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage\",\"url\":\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png\",\"contentUrl\":\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png\",\"width\":290,\"height\":380},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.websupport.sk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/#website\",\"url\":\"https:\/\/www.websupport.sk\/blog\/\",\"name\":\"Websupport.sk Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.websupport.sk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/#organization\",\"name\":\"Websupport.sk Blog\",\"url\":\"https:\/\/www.websupport.sk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2021\/08\/websupport-logo.svg\",\"contentUrl\":\"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2021\/08\/websupport-logo.svg\",\"width\":153,\"height\":48,\"caption\":\"Websupport.sk Blog\"},\"image\":{\"@id\":\"https:\/\/www.websupport.sk\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/d3f3517a180f66130801edb710ffb6b3\",\"name\":\"T\u00edm Websupport\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b5d757310f1c96028f399a2fa799c213?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b5d757310f1c96028f399a2fa799c213?s=96&d=mm&r=g\",\"caption\":\"T\u00edm Websupport\"},\"description\":\"Sme slobodn\u00e1 a otvoren\u00e1 firma. Rob\u00edme to, \u010do n\u00e1s bav\u00ed a chceme ka\u017edou na\u0161ou \u010dinnos\u0165ou pos\u00fava\u0165 \u0161tandardy vy\u0161\u0161ie.\",\"url\":\"https:\/\/www.websupport.sk\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL - Websupport.sk Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/","og_locale":"sk_SK","og_type":"article","og_title":"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL - Websupport.sk Blog","og_description":"V tomto blogu vam prin\u00e1\u0161ame nieko\u013eko tipov ako vylep\u0161i\u0165 v\u00fdkonnos\u0165 slu\u017eieb (web, maily, db) bez potreby zh\u00e1\u0148a\u0165 v\u00fdkonej\u0161ie \u017eelezo. A to v\u0161etko iba jednoduch\u00fdmi nastaveniami. Berte a vychutn\u00e1vajte :).","og_url":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/","og_site_name":"Websupport.sk Blog","article_published_time":"2010-01-27T15:55:01+00:00","article_modified_time":"2025-03-11T20:06:04+00:00","og_image":[{"width":290,"height":380,"url":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png","type":"image\/png"}],"author":"T\u00edm Websupport","twitter_card":"summary_large_image","twitter_misc":{"Written by":"T\u00edm Websupport","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#article","isPartOf":{"@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/"},"author":{"name":"T\u00edm Websupport","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/d3f3517a180f66130801edb710ffb6b3"},"headline":"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL","datePublished":"2010-01-27T15:55:01+00:00","dateModified":"2025-03-11T20:06:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/"},"wordCount":625,"commentCount":10,"publisher":{"@id":"https:\/\/www.websupport.sk\/blog\/#organization"},"image":{"@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png","keywords":["CFQ","datab\u00e1za","I\/O","MySQL","\u0161k\u00e1lovate\u013enos\u0165","websupport","XEN"],"articleSection":["Technol\u00f3gie","Tipy a triky"],"inLanguage":"sk-SK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/","url":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/","name":"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL - Websupport.sk Blog","isPartOf":{"@id":"https:\/\/www.websupport.sk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png","datePublished":"2010-01-27T15:55:01+00:00","dateModified":"2025-03-11T20:06:04+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#primaryimage","url":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png","contentUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2015\/01\/fialova_1.png","width":290,"height":380},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/blog\/2010\/01\/tipy-na-zrychlenie-emailovych-a-webovych-sluzieb-skalovatelnost-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/blog\/"},{"@type":"ListItem","position":2,"name":"Tipy na zr\u00fdchlenie emailov\u00fdch a webov\u00fdch slu\u017eieb + \u0161k\u00e1lovatelnos\u0165 MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/blog\/#website","url":"https:\/\/www.websupport.sk\/blog\/","name":"Websupport.sk Blog","description":"","publisher":{"@id":"https:\/\/www.websupport.sk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"},{"@type":"Organization","@id":"https:\/\/www.websupport.sk\/blog\/#organization","name":"Websupport.sk Blog","url":"https:\/\/www.websupport.sk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2021\/08\/websupport-logo.svg","contentUrl":"https:\/\/www.websupport.sk\/blog\/app\/uploads\/sites\/2\/2021\/08\/websupport-logo.svg","width":153,"height":48,"caption":"Websupport.sk Blog"},"image":{"@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/d3f3517a180f66130801edb710ffb6b3","name":"T\u00edm Websupport","image":{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b5d757310f1c96028f399a2fa799c213?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b5d757310f1c96028f399a2fa799c213?s=96&d=mm&r=g","caption":"T\u00edm Websupport"},"description":"Sme slobodn\u00e1 a otvoren\u00e1 firma. Rob\u00edme to, \u010do n\u00e1s bav\u00ed a chceme ka\u017edou na\u0161ou \u010dinnos\u0165ou pos\u00fava\u0165 \u0161tandardy vy\u0161\u0161ie.","url":"https:\/\/www.websupport.sk\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts\/130","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/users\/84"}],"replies":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/comments?post=130"}],"version-history":[{"count":1,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions"}],"predecessor-version":[{"id":33369,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/posts\/130\/revisions\/33369"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/media\/5579"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/media?parent=130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/categories?post=130"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/blog\/wp-json\/wp\/v2\/tags?post=130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}