Re: Eventual Slow Performance and Low Load
Posted by:
Rick James
Date: March 20, 2013 07:25PM
> thread_cache_size = 1000
Much too high. Recommend 20.
> query_cache_size =2048M
Much too high. It will actually show you down every time there is an INSERT -- it has to go through that 2G looking for entries relating the the table you are inserting into. Recommend no more than 50M. (Or turn it off!)
> primary index (lon, lat, id)
Any other indexes?
> need to search through over 500k users by mainly radius, using lat and lon, birthday, as well as a few other fields
Here's the solution:
http://mysql.rjweb.org/doc.php/latlng
Subject
Views
Written By
Posted
3778
March 19, 2013 03:17PM
Re: Eventual Slow Performance and Low Load
1698
March 20, 2013 07:25PM
1297
March 26, 2013 03:03PM
1142
March 27, 2013 11:16PM
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.