Re: mysql集群的疑问

2009-07-05 Thread Yi Wang
2009/7/3 xiaolongnvo : > > mysql集群 > 有四个数据节点1 2 3 4,有大量的数据,前3000w条存在节点1中,以后的存在节点3上,1 2一组,3 4一组,能实现吧?怎么实现啊? > 还有就是现在有三个表,想在节点1上存着表1 ,2的数据,节点三上存着表3的数据,怎么实现啊? > 发这里要用英文啊。不然别人怎么看得懂哦。 Please use English. Translation: We have lots of data on four data node: 1, 2, 3, 4. The formerly 300 million data s

Re: How many key buffer size should be allocate?

2008-09-07 Thread Yi Wang
On Mon, Sep 8, 2008 at 12:47 PM, Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Sep 08), Yi Wang said: >> According to the mysql manual, I changed key_buffer_size from 8M to >> 512M. But In mysql administrator, key buffer hitrate seems stay >> unchanged.

How many key buffer size should be allocate?

2008-09-07 Thread Yi Wang
Hi, According to the mysql manual, I changed key_buffer_size from 8M to 512M. But In mysql administrator, key buffer hitrate seems stay unchanged. And key buffer usage always below 4M. The total db size is about 200M. And the system's load is slight. key buffer size is 8M before changing. And the

Re: freebsd 7

2008-06-04 Thread Yi Wang
use ports please. On Tue, May 27, 2008 at 11:57 AM, kalin m <[EMAIL PROTECTED]> wrote: > hi all.. i cant see a package > for freebsd 7 on the mysql site. which onw should i build 6 or 5.1? > > thanks... > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To uns

design online lottery system

2008-05-07 Thread Yi Wang
Hi, I am designing an online lottery system. There is two-lottery type: 1. The lottery number cannot be repeated (the order is not important), For example, pick three num in num 1 to 8. If I selected 235, 546 and 3458(which actually is combination), the table should like: