给我看看你的表的索引及你的慢查询的sql语句
在 2010-6-2，下午5:08， 曹凯 写道：
>
> Hi all,
>
> do you guys know how to deal with the large tables?
>
> here's my problem:
>
> I have two web servers( running Nginx ) , two DB servers( running MySQL 5.1.35 ) and
> a server for load balancing.
>
> What I'm maintaining is a game data tracking system. There's a game_log table which
> will record all detail info from many games.
>
> here's the structure:
>
> `game_log_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> `game_id` int(10) unsigned NOT NULL,
> `event_id` int(10) unsigned NOT NULL,
> `player_id` int(10) unsigned NOT NULL,
> `session_id` varchar(128) NOT NULL COMMENT 'flash session id',
> `score` int(10) unsigned DEFAULT NULL,
> `handle_statu` int(1) unsigned NOT NULL DEFAULT '1' COMMENT '1:not handle 2:been
> handle',
> `game_end` bigint(20) DEFAULT NULL,
> `game_start` bigint(20) unsigned NOT NULL DEFAULT '0',
> `event_time` float DEFAULT '0',
> PRIMARY KEY (`game_log_id`),
> KEY `game_id` (`game_id`),
> KEY `event_id` (`event_id`),
> KEY `player_id` (`player_id`)
>
> it currently has about 12200000 records( 2 or 3 of the other tables have around a
> million records for each ). now, it's very slow to query this table even I just query this
> single table. most of the time it failed.
>
> do you guys know what the problem is? or how to make it more efficient and faster?
>
> thanks in advance
>
> CK
>
> _________________________________________________________________
> 一张照片的自白——Windows Live照片的可爱视频介绍
> http://windowslivesky.spaces.live.com/blog/cns!5892B6048E2498BD!889.entry
