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 02:09PM
February 05, 2015 03:56PM
February 05, 2015 07:18PM
February 06, 2015 06:18AM
February 06, 2015 07:01AM
February 06, 2015 01:34PM
February 06, 2015 11:52AM
February 09, 2015 04:23AM
February 09, 2015 09:21AM
February 10, 2015 08:09AM
February 10, 2015 12:19PM
February 11, 2015 04:36AM
February 11, 2015 12:32PM
February 13, 2015 05:39AM
February 13, 2015 02:20PM
February 16, 2015 08:38AM
February 16, 2015 09:08AM
February 12, 2015 11:12PM