{"id":1881,"date":"2014-03-29T15:55:09","date_gmt":"2014-03-29T13:55:09","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=1881"},"modified":"2014-03-29T15:59:39","modified_gmt":"2014-03-29T13:59:39","slug":"wampserver-performance-and-tuning-parameters-mysql-and-phpmyadmin","status":"publish","type":"post","link":"http:\/\/www.extradrm.com\/?p=1881","title":{"rendered":"Wampserver performance and tuning Parameters (mysql and phpmyadmin)"},"content":{"rendered":"<p>In php.ini, this is the one:<\/p>\n<p>upload_max_filesize<\/p>\n<p>However, change only this line won&#8217;t help you to restore big db, so you have to setup some other factors as well<\/p>\n<p>Try these different settings in C:\\wamp\\bin\\apache\\apache2.2.6\\bin\\php.ini<\/p>\n<p>Find:<br \/>\npost_max_size = 8M<br \/>\nupload_max_filesize = 2M<br \/>\nmax_execution_time = 30<br \/>\nmax_input_time = 60<br \/>\nmemory_limit = 8M<\/p>\n<p>Change to:<br \/>\npost_max_size = 750M<br \/>\nupload_max_filesize = 750M<br \/>\nmax_execution_time = 5000<br \/>\nmax_input_time = 5000<br \/>\nmemory_limit = 1000M<\/p>\n<p>And add this to C:\\wamp\\bin\\mysql\\mysql5.0.45\\my.ini:<\/p>\n<p>max_allowed_packet = 200M<\/p>\n<p>Then restart wamp<\/p>\n<p>Have fun,<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In php.ini, this is the one: upload_max_filesize However, change only this line won&#8217;t help you to restore big db, so you have to setup some other factors as well Try these different settings in&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":2850,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[275,276,277],"youtube_video":null,"_links":{"self":[{"href":"http:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1881"}],"collection":[{"href":"http:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1881"}],"version-history":[{"count":0,"href":"http:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/1881\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2850"}],"wp:attachment":[{"href":"http:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1881"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}