New answers tagged sorting
You possibly need something along the lines of groupwise max.
What you want is a SQL statement of select * from users order by points desc limit 10 You order the users table by points descending, then take the top 10 results, which will be the users with the most points. The inclusion of the password column raises a red flag for me - I hope you have the password stored in a secure manner?
How much RAM? key_buffer_size, if using only MyISAM, should be about 20% of available RAM. Switch to InnoDB and change some of the settings. Are you never using AUTO_INCREMENT? You seem to have commented out auto_increment* settings. slave-skip-errors=1062 -- Do you understand how fast your Masters can be corrupted? table_open_cache=10000 ...
Top 50 recent answers are included