MySQL Forums
Forum List  »  Optimizer & Parser

How to improve mysql when the table is larger than 4G
Posted by: Zhiyi Zhao
Date: February 25, 2010 08:19PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
How to improve mysql when the table is larger than 4G
3559
February 25, 2010 08:19PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.