Peda Posted January 24, 2012 Share Posted January 24, 2012 Hi, Server information Prestashop version: 1.4.6.2 > friendly URL enabled Server information: Linux #1 SMP Wed Jul 20 19:47:12 MSD 2011 x86_64 Server software version: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP version: 5.2.17 MySQL version: 5.1.56 In Phpmyadmin some table sizes: ps_product_lang: 183 Mb / Rows:213,519 ps_search_index: 143 Mb / Rows:3,205,165 ps_product_tag: 71 MB / Rows:610,164 ps_search_word: 64 MB / Rows:665,284 ps_category_product: 18 Mb / Rows:186,405 ps_product: 15 Mb / Rows:37,352 For instance, ps_product_lang: in Prestashop I activated two languages in back office. Others disabled. 37.000 products published in one language. As you see, the table size 183 Mb. and runs 213,519 rows. ps_search_index, table 143 Mb and have more than 3 million rows I think in e-commerce, 37.000 product is not a big number for Prestashop. But website working too slow, giving 500 internal server errors (mostly importing .csv), Server Overload, cpu has been maxed out, reached 100% of the memory errors... They occured maybe because of these table sizes, cache sizes ... Do you think these table sizes normal? Could someone inform me whats wrong about these tables? Regards Aybars Note:In my website Prestashop collecting everything.Sample; my tools/smarty/cache folder 8.7 Gb. After cleaning up, a few days later its again 8,9,10 ... gigabyte. ((( (Force compile: No / Cache: Yes / Use cache: No) Link to comment Share on other sites More sharing options...
ilovekutchi.com Posted June 12, 2012 Share Posted June 12, 2012 Hi, Server information Prestashop version: 1.4.6.2 > friendly URL enabled Server information: Linux #1 SMP Wed Jul 20 19:47:12 MSD 2011 x86_64 Server software version: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP version: 5.2.17 MySQL version: 5.1.56 In Phpmyadmin some table sizes: ps_product_lang: 183 Mb / Rows:213,519 ps_search_index: 143 Mb / Rows:3,205,165 ps_product_tag: 71 MB / Rows:610,164 ps_search_word: 64 MB / Rows:665,284 ps_category_product: 18 Mb / Rows:186,405 ps_product: 15 Mb / Rows:37,352 For instance, ps_product_lang: in Prestashop I activated two languages in back office. Others disabled. 37.000 products published in one language. As you see, the table size 183 Mb. and runs 213,519 rows. ps_search_index, table 143 Mb and have more than 3 million rows I think in e-commerce, 37.000 product is not a big number for Prestashop. But website working too slow, giving 500 internal server errors (mostly importing .csv), Server Overload, cpu has been maxed out, reached 100% of the memory errors... They occured maybe because of these table sizes, cache sizes ... Do you think these table sizes normal? Could someone inform me whats wrong about these tables? Regards Aybars Note:In my website Prestashop collecting everything.Sample; my tools/smarty/cache folder 8.7 Gb. After cleaning up, a few days later its again 8,9,10 ... gigabyte. ((( (Force compile: No / Cache: Yes / Use cache: No) Did you find any solution for this? I'm having similar problem, altough my database is much smaller! Link to comment Share on other sites More sharing options...
developette Posted December 9, 2012 Share Posted December 9, 2012 same here, please help Link to comment Share on other sites More sharing options...
matigemelli Posted December 22, 2012 Share Posted December 22, 2012 (edited) same here Edited December 22, 2012 by matigemelli (see edit history) Link to comment Share on other sites More sharing options...
AnnaM Posted May 21, 2013 Share Posted May 21, 2013 Same here 27,5 MB, only in the ps_search_index can I just "clear" and start the indexation in the search in the Back Office. I work with prestashop 1.5 Link to comment Share on other sites More sharing options...
tczaude Posted May 21, 2013 Share Posted May 21, 2013 You have VPS , dedicate or simple hosting ?? Link to comment Share on other sites More sharing options...
AnnaM Posted May 21, 2013 Share Posted May 21, 2013 Helo I believe it´s a simple hosting, "master linux plan" from arsys.es... Link to comment Share on other sites More sharing options...
tczaude Posted May 21, 2013 Share Posted May 21, 2013 Ok to let's go. I give some suggestions from my little knowledge. Some values always look that for me i think You have low sizes for this quantity of products. Master plan i think is expensive for this what the give. If you simple plan without any vps or dedicate You don't have many ways. Sometimes check in panel and You can set Apache Compresion then you give more load for cpu but all take less time. You have more products can You merge some products with attributes ?? Ok the best way and for my pratice buy VPS solutions.Then You have more tools for tweaks. A lot size of this tables make big Joins and You can administrative with Mysql parameters for tweaks with simple programs. You cat set memcache in optymalization in presta this buffered some sql code. And automatic ask arsys maybe they somewhere have host with memcache. You can move database to another server (VPS). Apache is slow . The best if use nginx. For Apache tell me What You can set in Your hosting provider. If You have enabled module cache_dir make cache with htacces to directory but this take more hdd space yet Ask whitch mpm use Your provider prefork is slowest more stability but is yet worker etc thay can take more Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts