t;From: ?? [mailto:tx...@hotmail.com]
>Sent: Wednesday, June 02, 2010 6:14 AM
>To: mysql@lists.mysql.com
>Subject: RE: large table issue
>
>
>hi huys,
>
>here's the explain of a query on this table
>
>EXPLAIN SELECT COUNT(game_log_id) AS sum2 FROM game_log AS g, playe
Hi,
MySQL Partitioning will help you a lot.
Try it.
Regards,
Krishna
2010/6/2 曹凯
>
> 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.
>
hi huys,
here's the explain of a query on this table
EXPLAIN SELECT COUNT(game_log_id) AS sum2 FROM game_log AS g, player AS p WHERE
g.player_id = p.player_id AND g.game_id=p.game_id=27 AND p.type=1 AND
g.event_id = 32
-> ;
++-+---+++---
给我看看你的表的索引及你的慢查询的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
Hi,
Can you please send us the query along with the explain .
Also , have u thought of partitioning the data.
regards
anandkl
2010/6/2 曹凯
>
> 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( run
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 al
