deepakchezhian

Thanks for your reply. I am planning to create to create multi shop so i am expecting atleast 300 concurrent users at a time and that does not mean they are hitting at the same time(testing is done for 100 spread over 50 seconds and each have some think time also). I tried Local MySql server and also remote one, both of them having the same problem. At present, we are evaluating various open source frameworks and the performance is our major criteria, so we have to rely load test find out which framework is good performant. I want to understand whether the problem is expected in prestashop or i am missing some configuration? Thanks, Deepak

Hi, I am evaluating the performance of prestashop for one of my ECommerce project. I have used JMeter for doing the test. Prestashop is working fine till 100 users, but if i increase the user count above 100, some requests getting failed with the following error. PHP Fatal error: Uncaught Link to database cannot be established: SQLSTATE[HY000] [2002] Resource temporarily unavailable Prestashop is deployed in a Redhat Linux machine(Core i5, 8gb ram) using Xampp server(1.8.1) and connecting to a remote MySql(5.5.27) in a Redhat Linux machine(Core i5, 2gb ram) I have configured the following parameters in Apache and mysql. httpd-mpm.conf <IfModule mpm_prefork_module> StartServers 5 MinSpareServers 5 MaxSpareServers 30 MaxRequestWorkers 250 MaxConnectionsPerChild 0 </IfModule> my.cnf [mysqld] user = root port = 3306 socket = /opt/lampp/var/mysql/mysql.sock skip-external-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M max_connections = 500 query_cache_type = 1 query_cache_size = 64M query_cache_limit = 4M max_connect_errors = 30 connect_timeout = 300 net_read_timeout = 300 net_write_timeout = 300 Am i missing any configuration or is this an expected behavior? Thanks in advance Deepak

Hi, When I went through prestashop source code, i didnt find any transaction management code on the business logic level(For example, if a functionality involves two updates queries then if either of the queries fails or some exception occurred in between then the executed queries should be rolled back). Is prestashop doing any transaction management? If so, can you point me to a code snippet where i can find that? Thanks in advance. Regards, Deepak