Hi,
2004-12-30 kl. 07.31 skrev NiCK:
> Hi Mikael Ronström,
>
> I am new to mysql,thank you for your suggestion.However,I don't know
> how to get information about indexes,keys and record size. Can you
> help me?
>
You get the information from the CREATE TABLE statements of your 31
tables.
Size of record is the sum of the max size of each attribute in the
table. Size of primary
key is 8 bytes if no primary key is provided and otherwise the sum of
the max size of
the attributes in the primary key.
Rgrds Mikael
> -----Original Message-----
> From: Mikael Ronström [mailto:mikael@stripped]
> Sent: 2004年12月28日 18:05
> To: NiCK
> Cc: cluster@stripped
> Subject: Re: Cluster planning problem
>
> Hi,
>
> 2004-12-28 kl. 07.29 skrev NiCK:
>
>> Hi,expert,
>>
>> 3 databases , 31 tables , 3,000,000 records
>
> Some additional info is needed
> 1) Number of indexes on tables (Most likely default is ok, but a check
> is needed)
> 2) Size of primary keys (affects how much IndexMemory is needed)
> 3) Size of records in tables, mean record size is ok (affects how much
> DataMemory is needed)
>
> If you are doing large transactions you also need to know the maximum
> amount of records involved in a transaction.
>
> Some kind of hint on if you are doing high update load is also
> beneficial.
>
> Then some calculations can be applied to figure out most of the
> appropriate configuration parameters.
>
> Rgrds Mikael
> PS: The config file you supplied in a previous email looks fairly ok
> given that your machines are equipped with 2 GB of memory. The
> problems you got looked like bugs, so supplying the important parts of
> the tracefile for the crash can usually give a pointer to the problem
> and sometimes even a pointer to the solution.
>
> The important parts of the trace log is around where the line number
> logs end and the signal logs start.
> DBLQH 3045 here means that line 3045 in DblqhMain.cpp was passed. So
> in the example below the crash occurred while executing ATTRINFO (sent
> to Dblqh) in Dbtup on line 442 (Dbtup is a block with many files and
> the translation from 32292 to line and file is provided by a list in
> Dbtup.hpp, same with Dbtux).
>
> DBTC 002070 002104 001984 002149 003296 003342
> DBLQH 003200 003372 016091
> DBTUP 000162
> DBLQH 003509 003539
> DBLQH 002900 003068 002920
> DBTUP 000162 000136
> DBLQH 003045
> DBACC 001630 004547 004585 004597
> DBLQH 003774
> DBTUP 000661 000075 000075 014127 014127 014127 014127 014127
> 014127 014127 014131 032285 032292 000442
>
> --------------- Signal ----------------
> r.bn: 247 "DBLQH", r.proc: 2, r.sigId: 268393 gsn: 4 "ATTRINFO" prio: 1
> s.bn: 245 "DBTC", s.proc: 2, s.sigId: 268391 length: 4 trace: 1 #sec: 0
> fragInf: 0
> H'00008a38 H'000004bf H'00200300 H'00050000
> --------------- Signal ----------------r.bn: 247 "DBLQH", r.proc: 2,
> r.sigId: 268392 gsn: 316 "LQHKEYREQ" prio: 1s.bn: 245 "DBTC", s.proc:
> 2, s.sigId: 268391 length: 19 trace: 1 #sec: 0 fragInf: 0
> ClientPtr = H'00008a38 hashValue = H'27adbca7 tcBlockRef = H'00f50002
> transId1 = H'000004bf transId2 = H'00200300 savePointId = H'00000000
> Op: 0 Lock: 1 Flags: ScanInfo/noFiredTriggers: H'6a
>
>
>
>> 2 intel base servers
>> how organize is the best? and how to configure config.ini?
>> Who have experience for this environment?
>>
>>
>>
>>
>>
>> --
>> MySQL Cluster Mailing List
>> For list archives: http://lists.mysql.com/cluster
>> To unsubscribe:
>> http://lists.mysql.com/cluster?unsub=1
>>
>>
> Mikael Ronström, Senior Software Architect MySQL AB, www.mysql.com
>
> Clustering:
> http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html
>
> http://www.eweek.com/article2/0,1759,1567546,00.asp
>
>
>
>
>
Mikael Ronström, Senior Software Architect
MySQL AB, www.mysql.com
Clustering:
http://www.infoworld.com/article/04/04/14/HNmysqlcluster_1.html
http://www.eweek.com/article2/0,1759,1567546,00.asp
