Which MySQL storage engine should I use? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

I don't think innoDB could work because I need to trun开发者_开发百科cate often very large tables (some GB) and i need every bit of disk space.

I have 3 tables that contain over 2 millions rows. I need to do a large number of queries for second (>50). I have only one user.

---

InnoDB tables area transactional and only useful where you may need to revert a commit in case something goes wrong specifically in a RDMBS environment. Based on the information you have provided which is not to none, if your only requirement is fast reads and writes I would say go with MyISAM. There are other engines too which are in-memory (definitely not a good idea with GB's of data) and have various other properties, but without more details it's hard to say if one of the others is a better fit.