Re: Solution for slow MySQL database performance
> I have a mysql database of 500.000 records
You mean one table has 500k rows, or all tables in the database have 500k?
If in one table, 500k rows is not large.
For starters, let's see the result of Show Create Table for the database table(s), the slowest queries and results of Explain Extended on them, also the amount of RAM available to MySQL and the innodb_buffer_pool_size setting.
Subject
Written By
Posted
February 05, 2015 02:09PM
Re: Solution for slow MySQL database performance
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