MySQL Forums
Forum List  »  InnoDB

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3778
March 19, 2013 03:17PM
Re: Eventual Slow Performance and Low Load
1698
March 20, 2013 07:25PM


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.