How to improve mysql when the table is larger than 4G

[Zhiyi Zhao]

I installed the cactiez on a server, setting up the syslog server. The total amount of syslogs is huge.
describe syslog_incoming;
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| facility | varchar(10) | YES | | NULL | |
| priority | varchar(10) | YES | | NULL | |
| date | date | YES | | NULL | |
| time | time | YES | | NULL | |
| host | varchar(128) | YES | | NULL | |
| message | text | YES | | NULL | |
| seq | int(10) unsigned | NO | PRI | NULL | auto_increment |
| status | tinyint(4) | NO | MUL | 0 | |
+----------+------------------+------+-----+---------+----------------+

select max(seq) from syslog_incoming;
+----------+
| max(seq) |
+----------+
| 85775637 |

-rw-rw---- 1 mysql mysql 8.8G Feb 26 09:59 syslog.MYD
-rw-rw---- 1 mysql mysql 3.5G Feb 26 09:59 syslog.MYI


The server has stored 160.5 million syslog message.
I have to store all of the message for 3 months at least.

So, my syslog page is badly slow. I have to wait for 3 mins before the syslog page can display syslog information.

My server hardware information is that:
1G memory, Intel(R) Xeon(TM) CPU 2.80GHz

Anybody can give me some suggestions, whereis the Bottleneck?The hardware or the architecture of syslog-ng+mysql can not support the huge amount of syslog.