Hello,

I have done nearly everything I can to make queries and table structures. I'm not saying that pages don't load fast, just at peak times the page process time can get pretty high and you can notice a lagging of the page loading.

The problem is, I couldn't find the server my.cnf (and a whereis my-large.cnf found nothing so I am wondering where those files have gone?). That is the first problem, which is fairly big being it is the file I need to edit the varibles I need to.

Now, which varibles should I change to fit my requirements. I run mySQL on the same server as apache but currently most processing is done by mySQL. The server is a Dual 2.0 Ghz Xeon with 1GB RAM and 73GB SCSI HDD.

Here are some stats that may help in helping me:

top (not really a peak time for my site, actually pretty much off-peak:
Code:
 16:37:35  up 18:08,  1 user,  load average: 1.34, 1.36, 1.36
162 processes: 159 sleeping, 3 running, 0 zombie, 0 stopped
CPU0 states:  25.1% user   3.4% system	0.0% nice   0.0% iowait  70.4% idle
CPU1 states:  26.2% user   2.3% system	0.0% nice   0.0% iowait  70.3% idle
Mem:  1030800k av,  998344k used,   32456k free,	   0k shrd,  163160k buff
	   341948k active,			 543984k inactive
Swap: 1052216k av,	 512k used, 1051704k free				  568828k cached
SHOW STATUS; (pretty long but may help)
Code:
+--------------------------+------------+
| Variable_name			| Value	  |
+--------------------------+------------+
| Aborted_clients		  | 0		  |
| Aborted_connects		 | 0		  |
| Bytes_received		   | 954119967  |
| Bytes_sent			   | 737214165  |
| Com_admin_commands	   | 459808	 |
| Com_alter_table		  | 2		  |
| Com_analyze			  | 0		  |
| Com_backup_table		 | 0		  |
| Com_begin				| 0		  |
| Com_change_db			| 474576	 |
| Com_change_master		| 0		  |
| Com_check				| 0		  |
| Com_commit			   | 0		  |
| Com_create_db			| 0		  |
| Com_create_function	  | 0		  |
| Com_create_index		 | 0		  |
| Com_create_table		 | 0		  |
| Com_delete			   | 11864	  |
| Com_delete_multi		 | 0		  |
| Com_drop_db			  | 0		  |
| Com_drop_function		| 0		  |
| Com_drop_index		   | 0		  |
| Com_drop_table		   | 0		  |
| Com_flush				| 0		  |
| Com_grant				| 0		  |
| Com_ha_close			 | 0		  |
| Com_ha_open			  | 0		  |
| Com_ha_read			  | 0		  |
| Com_insert			   | 35897	  |
| Com_insert_select		| 0		  |
| Com_kill				 | 0		  |
| Com_load				 | 0		  |
| Com_load_master_data	 | 0		  |
| Com_load_master_table	| 0		  |
| Com_lock_tables		  | 578		|
| Com_optimize			 | 0		  |
| Com_purge				| 0		  |
| Com_rename_table		 | 0		  |
| Com_repair			   | 0		  |
| Com_replace			  | 0		  |
| Com_replace_select	   | 0		  |
| Com_reset				| 0		  |
| Com_restore_table		| 0		  |
| Com_revoke			   | 0		  |
| Com_rollback			 | 0		  |
| Com_savepoint			| 0		  |
| Com_select			   | 8900177	|
| Com_set_option		   | 0		  |
| Com_show_binlog_events   | 0		  |
| Com_show_binlogs		 | 0		  |
| Com_show_create		  | 12		 |
| Com_show_databases	   | 9		  |
| Com_show_fields		  | 99		 |
| Com_show_grants		  | 3		  |
| Com_show_keys			| 69		 |
| Com_show_logs			| 0		  |
| Com_show_master_status   | 0		  |
| Com_show_new_master	  | 0		  |
| Com_show_open_tables	 | 0		  |
| Com_show_processlist	 | 217		|
| Com_show_slave_hosts	 | 0		  |
| Com_show_slave_status	| 0		  |
| Com_show_status		  | 1		  |
| Com_show_innodb_status   | 0		  |
| Com_show_tables		  | 290		|
| Com_show_variables	   | 1		  |
| Com_slave_start		  | 0		  |
| Com_slave_stop		   | 0		  |
| Com_truncate			 | 1		  |
| Com_unlock_tables		| 578		|
| Com_update			   | 806824	 |
| Connections			  | 15038	  |
| Created_tmp_disk_tables  | 0		  |
| Created_tmp_tables	   | 16577	  |
| Created_tmp_files		| 0		  |
| Delayed_insert_threads   | 0		  |
| Delayed_writes		   | 0		  |
| Delayed_errors		   | 0		  |
| Flush_commands		   | 1		  |
| Handler_commit		   | 4		  |
| Handler_delete		   | 494		|
| Handler_read_first	   | 559130	 |
| Handler_read_key		 | 36660014   |
| Handler_read_next		| 927249102  |
| Handler_read_prev		| 0		  |
| Handler_read_rnd		 | 4714124	|
| Handler_read_rnd_next	| 2079797312 |
| Handler_rollback		 | 13867	  |
| Handler_update		   | 22123	  |
| Handler_write			| 148418924  |
| Key_blocks_used		  | 3024	   |
| Key_read_requests		| 33469	  |
| Key_reads				| 3024	   |
| Key_write_requests	   | 3180	   |
| Key_writes			   | 2190	   |
| Max_used_connections	 | 149		|
| Not_flushed_key_blocks   | 0		  |
| Not_flushed_delayed_rows | 0		  |
| Open_tables			  | 64		 |
| Open_files			   | 6		  |
| Open_streams			 | 0		  |
| Opened_tables			| 20181	  |
| Questions				| 10246654   |
| Qcache_queries_in_cache  | 0		  |
| Qcache_inserts		   | 0		  |
| Qcache_hits			  | 0		  |
| Qcache_lowmem_prunes	 | 0		  |
| Qcache_not_cached		| 0		  |
| Qcache_free_memory	   | 0		  |
| Qcache_free_blocks	   | 0		  |
| Qcache_total_blocks	  | 0		  |
| Rpl_status			   | NULL	   |
| Select_full_join		 | 0		  |
| Select_full_range_join   | 0		  |
| Select_range			 | 442169	 |
| Select_range_check	   | 0		  |
| Select_scan			  | 574917	 |
| Slave_open_temp_tables   | 0		  |
| Slave_running			| OFF		|
| Slow_launch_threads	  | 0		  |
| Slow_queries			 | 218		|
| Sort_merge_passes		| 0		  |
| Sort_range			   | 113207	 |
| Sort_rows				| 4714425	|
| Sort_scan				| 68045	  |
| Table_locks_immediate	| 9754712	|
| Table_locks_waited	   | 1		  |
| Threads_cached		   | 0		  |
| Threads_created		  | 15037	  |
| Threads_connected		| 51		 |
| Threads_running		  | 2		  |
| Uptime				   | 65285	  |
+--------------------------+------------+
I use INNODB table types as this has proven faster for me.

If you need me to get any other information so you can help please ask.

Thanks.