I have a production application which uses barcode. It's created using PHP/MySQL on xampp server. When there is more than 50000 data on specific 5 tables then its performance slow on input and fetch data. I have already use indexing on columns. Here are more than 50 users, and give input to 15 users. Its installed on vmware with 14 GB ram and xenon processor server.pc configxampp configNow I want to increase innodb_buffer_pool_size.Now it's 2G. But if I increase it 3G or above then my MySQL stop unexpectedly. Can anyone give me solution how can I increase it
