MySQL issues | How to optimize ?

Hello,

Pages of sites are very slow to load, I think it's due to MySQL.
Do you have some tricks or tips to optimize my MySQL ?

Thanks.

Machine hardware
-----------------------
Dual Xeon 2,4 Ghz
2 GB RAM
36GB SCSI HDD (SEAGATE ST336607LC 0006)

Mysql status
---------------
Uptime: 1492 Threads: 47 Questions: 142350 Slow queries: 0 Opens: 507 Flush tables: 1 Open tables: 256 Queries per second avg: 95.409

Top (extract)
----------------
Code: 
last pid: 33928;  load averages:  2.57,  2.72,  2.55            up 10+00:34:19  17:17:28
620 processes: 3 running, 617 sleeping
CPU states: 77.7% user,  0.0% nice, 14.1% system,  2.7% interrupt,  5.5% idle
Mem: 728M Active, 424M Inact, 266M Wired, 55M Cache, 199M Buf, 536M Free
Swap: 2048M Total, 2048M Free

  PID USERNAME      PRI NICE  SIZE    RES STATE    TIME   WCPU    CPU COMMAND
31891 mysql          64   0   337M 28584K RUN      1:35 42.77% 42.77% mysqld
32938 www             2   0 12016K  9952K poll     0:03  0.83%  0.83% httpd2
33141 www             2   0 11416K  9268K poll     0:02  0.63%  0.63% httpd2
33895 www             2   0 11704K  9580K poll     0:00  0.54%  0.54% httpd2
33360 www             2   0 10792K  8716K poll     0:02  0.49%  0.49% httpd2
33924 www             2   0 11260K  9152K poll     0:00  0.59%  0.49% httpd2
33553 www             2   0  7652K  5656K poll     0:00  0.15%  0.15% httpd2
32486 www             2   0  8044K  6032K poll     0:01  0.10%  0.10% httpd2
32747 www             2   0  7652K  5660K RUN      0:01  0.10%  0.10% httpd2
32968 www             2   0  8044K  6032K sbwait   0:01  0.10%  0.10% httpd2
33233 www             2   0  8044K  6028K sbwait   0:01  0.05%  0.05% httpd2
33575 www             2   0  8044K  6020K sbwait   0:00  0.05%  0.05% httpd2
33390 www             2   0  8044K  6024K poll     0:00  0.05%  0.05% httpd2
33574 www             2   0  8044K  6024K poll     0:00  0.05%  0.05% httpd2
33427 www             2   0  8044K  6020K poll     0:00  0.05%  0.05% httpd2
  161 root            2   0  2524K  1924K select   1:17  0.00%  0.00% named
 7226 root            2   0  6964K  4556K select   1:01  0.00%  0.00% httpd2
  199 root           10   0  3316K  2672K nanslp   0:55  0.00%  0.00% perl
39691 qmails          2   0   956K   500K select   0:39  0.00%  0.00% qmail-sen
 7245 root            2   0  8156K  4580K select   0:23  0.00%  0.00% lt-httpd
 7261 root            2   0  8140K  4556K select   0:17  0.00%  0.00% lt-httpd
  197 root            2   0  6816K  5636K select   0:13  0.00%  0.00% perl
   74 root            2   0   992K   628K select   0:13  0.00%  0.00% syslogd
uptime
------
5:17PM up 10 days, 34 mins, 1 user, load averages: 2.40, 2.67, 2.53

my.cnf (extract)
--------------------
set-variable = key_buffer=300M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = join_buffer_size=262144
set-variable = thread_concurrency=8
set-variable = max_connections=700

 

 

 

 

Top