Hardware and performance

**Hi. I need help/advice on tuning my mysql database. Moodles been running fine for a year or so, but I think its finally catching up to itself and needs tuning. Its been sporadically locking up. And Im not a DBA by any means. So any advice is appreciated.

**I've done two things to gather info... First, installed the moodle database plugin. I then went to the page, clicked on "Show mySql runtime information", and found the entries in RED. Here I'll list the RED entries... which I assume need attention....

Innodb_buffer_pool_reads 12 The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.
Handler_read_rnd 716 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 65 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.
Created_tmp_disk_tables 20 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.
Select_full_join 22 k The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
Opened_tables 17 k The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
Table_locks_waited 12 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.

**Also, on the server itself from the command line, I ran Mysqltuner which gave me a nice report, it's findings are...

-------- Recommendations -----------------------------------------------------
General recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
Set thread_cache_size to 4 as a starting value
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (>= 8M)
join_buffer_size (> 128.0K, or always use indexes with joins)
thread_cache_size (start at 4)
table_cache (> 64)


Firstly, how do adjust the variables above?? (the table_cache size, the query_cache_size, etc..)??
How can I "optimize tables" in a single command or click?
How can I "reindex" the database, I think that needs done.
Any other suggestions are welcome! Thanks!