Mysql Index Tables And Queries Fix

[mizmiz]

Hello I have 50K unique site, using phparcadescript.com
I like the script,but I have problem with my script, It cant handle large amount of hits and giving me performance issues.
This Are the what I found out of mysql status to be something to be fixed, maybe more stuff should be fixed:

Handler_read_rnd 782 k 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 22 M 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.
Opened_tables 273 The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
Table_locks_immediate 34 k The number of times that a table lock was acquired immediately.
Table_locks_waited 27 The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication.
Created_tmp_disk_tables 5 k The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.


I'm willing to pay 100$ for the job.
If not tell me your price...
Mark

[jscott]

mizmiz.... did you find anyone to fix this for you?

(sorry for thread bump, i'm looking for a fix for this script too)

Thx