disclaimer: I'm not a software expert and has been using wordpress to run a website, which attracts decent traffic (around 20k views daily), which causes the site to become slow at peak hours. The hosting company support staff told me that there could be problem with my scripts, as they don't seem to be properly optimized. The staff especially cited the following result from the status report of the MySQL database:
Handler_read_rnd 1,482 M The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler_read_rnd_next 497 G The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
What should I do to properly index the table or use the keys properly, as is suggested above? I thought these issues would be taken care of automatically by Wordpress coding and scripting. Or is it a common problem on a Wordpress based site on shared hosting?