Solution for slow MySQL database performance
I have a mysql database of 500.000 records, that has a size of 42 Mb. It takes about 4 seconds to search in this large database. For my purpose this is very long.
My question: Is there a maximum number of records for a mysql database? I would also like to know if there is a number of records that, once reached, starts to slow down things significantly.
I also noticed that all the databases that I have on this server are located in one big database (ibdata1)-file, with a total size of 3.5 gb. Can it be that this slows down the search process of the database that I am talking about, and if so, is there a solution for this, in order to speed things up, without having to delete all other databases in the ibdata1 file?
Subject
Written By
Posted
Solution for slow MySQL database performance
February 05, 2015 04:31AM
February 17, 2015 10:32AM
February 19, 2015 01:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.