I had a MySQL database(innodb). It is 8 gigabytes and has more than a million rows. Which is the most suitable database for it?

New contributor
Sakith Karunasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

closed as primarily opinion-based by Akina, a_horse_with_no_name, Laurenz Albe, kevinsky, mustaccio Sep 11 at 15:15

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise. If this question can be reworded to fit the rules in the help center, please edit the question.

  • How much are you willing to pay for database server licensing? – Akina Sep 11 at 13:10
  • 1
    "A million rows" is actually quite small. Any modern relational database can handle that. I would always choose Postgres over MySQL however. – a_horse_with_no_name Sep 11 at 13:10
  • 1
    Not trying to be rude, 8GB is nothing for a database. Any DBMS will be able to manage this. – Yannick Liekens Sep 11 at 13:10
  • 1
    You have 6 GB for the database, or do you have 6GB on the machine. That memory gets used by the operating system as well as any other applications that are running. But 6GB should still be fine. I would guess that your queries and indexes need tuning. – Jonathan Fite Sep 11 at 13:15
  • 1
    @SakithKarunasena RAM is also quite sufficient (infact, more than enough). Most likely, your issue of slowness is due to unindexed tables. Figure out the queries which are slow, and then work on them one by one defining proper indexes – Madhur Bhaiya Sep 11 at 13:16

Browse other questions tagged or ask your own question.