php - Mysql Scaling for small app -

I can not buy more hardware I have 2 Gig RAM mysql

Now my widget is being displayed on 57 websites with an average of 3000 views. My widget needs a 200 views per view for the best user optimization of content. Which means that there are approximately 400 inserts per second on average.

What do you suggest now that I increase the speed of the insert? The data entered is divided into three tables, each of which is 80 in each and 40 are joining each.

I am using mysum, I am not like INODB because I have never used it, nor am I unfortunately now using it, but a good reason persuade me to The problem is that there are approximately 1200 inserts per second in peak time, which is a real obstacle. Mainly questions are updated to increase the impression. So upgrade impression = Impr. + 1, where widget = widget_id

Any suggestions to speed up database queries would be great.

There may be a cache to include it, for example, in the batch, something like that. BTW, incorporates from time to time, bulk inserts etc., I really appreciate it if it can be explained in details, because I am totally noob.

Thanks Guys

It is in your best interest to consider Indobi InnoDB is where MySQL treats like other appropriate relational databases and provides the highest reliability and functionality. In your case, the biggest strength in MySam is that every time a row is inserted or updated, the entire table is locked. Although Maisam is very fast for small-scale projects, if you have a lot of convergence, then it is likely to be an interval if it is not already there. You probably also want to have a proper foreign key, transaction etc., which provides INODB.

To read MySQL documents and articles, read also about buffers and other configurations about optimal configuration of MySQL.

The MySQL tuner can also help in understanding what you really need. This percentage will show figures like inserts and percentage selection, how much memory is being used for different buffers, how your query cache is performing, and so on. It also suggests what to emphasize in order to improve these things, although those tips should be taken with a grain of salt and should actually be researched before doing them.