[BSD] performance tunning

[Gabor HALASZ]

On 2010.06.16. 11:35, István wrote:
> melyik konfig filet hasznalod?
>

Mire?

> mi a path hozza?

/var/db/mysql

>
> mi a tartalma?
>

Melyiknek?

> milyen stateben van a process?

Mikor? Melyik?

Megegyszer szeretnem leszogezni, ez egy CLUSTER, tobb node-bol all 
(http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster.html), nem egy 
szerver, nem replikalt szerver, igy a fenti kerdesek (is) 
ertelmezhetetlenek az adott szituacioban.
Mivel ertekelem a segitokeszseget, szorgalmas Sziszifuszkent idemasolom 
az osszes konfigfilet:

A manager node altal hasznalt config.ini:

[ndbd default]
NoOfReplicas                            = 2
DataMemory                              = 1536M
IndexMemory                             = 256M
TimeBetweenWatchDogCheck                = 30000
DataDir                                 = /var/db/mysql
MaxNoOfOrderedIndexes                   = 256
MaxNoOfConcurrentOperations             = 16384
RedoBuffer                              = 128M
MaxNoOfLocalOperations                  = 65535
MaxNoOfConcurrentIndexOperations        = 8192
LockPagesInMainMemory                   = 0
Odirect                                 = 1

[tcp default]
SendBufferMemory                        = 2M
ReceiveBufferMemory                     = 2M

[ndb_mgmd default]
DataDir                                 = /var/db/mysql

[ndb_mgmd]
HostName                                = x230-1.nns.hu

[ndbd]
HostName                                = x232-1.nns.hu

[ndbd]
HostName                                = x232-2.nns.hu

[mysqld]
HostName                                = 775i915pl.nns.hu

Az sql node altal hasznalt my.cnf:

[mysqld]
ndbcluster
ndb-connectstring       = x230-1.nns.hu
server-id               = 4
log-slow-queries        = /var/db/mysql/slow-query.log

[mysql_cluster]
ndb-connectstring       = x230-1.nns.hu

# provide connectstring for management server host (default port: 1186)
[ndbd]
connect-string          = x230-1.nns.hu

# provide connectstring for management server host (default port: 1186)
[ndb_mgm]
connect-string          = x230-1.nns.hu

# provide location of cluster configuration file
[ndb_mgmd]
config-file             = /var/db/mysql/config.ini

Az ndb node-ok loader.conf-ja:

kern.maxdsiz="1024M"
kern.dfldsiz="1024M"
vfs.root.mountfrom="zfs:zroot"
vfs.zfs.debug="1"
vfs.zfs.prefetch_disable="0"
vm.kmem_size="512M"
vm.kmem_max="512M"
zfs_load="YES"

A tobbi nod-e:

vfs.root.mountfrom="zfs:zroot"
vfs.zfs.debug="1"
vfs.zfs.prefetch_disable="0"
vm.kmem_size="536870912"
vm.kmem_max="536870912"
zfs_load="YES"


-- 
Gabor HALASZ <halasz.g at freemail.hu>