New answers tagged

1

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?


0

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 ...


0

From the EXPLAIN and table structure it can be seen that you are missing some indexes so some queries need to check million rows to return ~20. SELECT * FROM ooo_video_serie WHERE id_episode='96652' AND active=1 ORDER BY langue,lorde ASC; this would benefit from index on (id_episode, active) or even (id_episode, active, langue, lorde) but if expected ...



Top 50 recent answers are included