MySQL CPU Kullanımı my.cnf optimizasyonu - Sayfa 32

**mrtcbks** · #**311** (**permalink**) 2008-03-09, 11:04

HTML-Kodu:

[mysqld]
set-variable = max_connections= 750
safe-show-database
skip-locking 
skip-name-resolve
thread_cache_size = 128
key_buffer = 128M
query_cache_type = 1
query_cache_size = 32M
query_cache_limit = 4M
table_cache = 3000 
low_priority_updates = 1
innodb_buffer_pool_size=384M
innodb_additional_mem_pool_size=96M
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT

Bu şekilde my.cnf conf Xcache de kurdum iyinet teşekkürler şimdiden.

Intel Xeon-Harpertown 5420-Quadcore
4 işlemci 2.5ghz ve her işlemcide 6mb cache var 4 GB ram centos 4.4 işletim sistemi ve Cpanel bulunmakta

**Murat** · #**312** (**permalink**) 2008-04-01, 12:48

-rasgele veri çekmekde mysql u yorar mı hit bir site için?
-Sunucuda 10 site aktif diyelim 20 de mysql db si kurulu 10 u kullanılmıyor script deneme amaçlı açılmış olsun. diğer aktif 10 sitenin mysql kullanımını etkilermi yavşlatırmı kullanılmayan dbler?
- En çok merak ettiğim hangi domainin db sinin ne kadar cpu tukettiği mysql ı zorladığı bunu nasıl %100 tesbit ederiz?

**ENVER** · #**313** (**permalink**) 2008-04-10, 13:20

vps kullanıyorum bunun için yardımcı olabilir misin

top - 14:21:16 up 2 days, 3:41, 1 user, load average: 64.13, 39.98, 40.46
Tasks: 291 total, 11 running, 276 sleeping, 3 stopped, 1 zombie
Cpu(s): 66.8% us, 29.1% sy, 0.0% ni, 2.7% id, 1.4% wa, 0.0% hi, 0.0% si
Mem: 786432k total, 513020k used, 273412k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

my.cnf içeriğide

[mysqld]
set-variable = max_connections=500
safe-show-database

teşekkürler

**bloodyking** · #**314** (**permalink**) 2008-04-11, 02:56

Merhaba

VPS kullanıyorum 768 mb ram var ancak bazen ram kullanımı aşırı artıyor.

my.cnf içeriği bu şekilde. Nasıl optimize edebiliriz yardımcı olabilir misiniz?

Kod:

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2

**Pehepe** · #**315** (**permalink**) 2008-04-28, 22:07

Bu bir vps sadece bır forum var ve konu acarken cok bekliyor sayfa acılışları hızlı fakat dedim gıbı konu acarken cok bekliyor (çok düşünüyor)

load average: 0.73, 0.76, 0.82

Tasks: 68 total, 1 running, 67 sleeping, 0 stopped, 0 zombie

Cpu(s): 6.7% us, 1.3% sy, 0.0% ni, 91.9% id, 0.2% wa, 0.0% hi, 0.0% si

Mem: 1048576k total, 348164k used, 700412k free, 0k buffers

Swap: 0k total, 0k used, 0k free, 0k cached

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

**yunuss** · #**316** (**permalink**) 2008-05-02, 00:03

selamlar

linux ve plesk 8.3 yüklü vps hesabı aldım ve 20 basit site 5 de database attım daha ağır siteleri taşımadım fakat sunucu günede 4-5 defa nerdeyse durma noktasına geliyor
my.cnf ve bir kaç teknik döküm aşağıda sizce ne yapmam gerek

my.cnf

Kod:

[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb

set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2

top -n1

Kod:

[root@linux ~]# top -n1
top - 00:24:13 up 2 days,  7:36,  1 user,  load average: 0.02, 0.01, 0.12
Tasks:  59 total,   1 running,  58 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.1% us,  0.0% sy,  0.0% ni, 93.1% id,  6.7% wa,  0.0% hi,  0.0% si
Mem:    524288k total,   210252k used,   314036k free,        0k buffers
Swap:        0k total,        0k used,        0k free,        0k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
    1 root      15   0  1700  488  464 S    0  0.1   0:00.11 init
 3938 root      18   0  8576 2548 1980 S    0  0.5   0:00.03 sshd
 5140 apache    15   0 27776 4540 2700 S    0  0.9   0:00.43 httpd
 5148 apache    15   0 27300 4212 2672 S    0  0.8   0:00.43 httpd
 5403 root      16   0  5380 1400 1176 S    0  0.3   0:00.02 bash
 7507 root      19   0  4444  616  588 S    0  0.1   0:00.03 couriertcpd
 7513 root      17   0  3476  780  744 S    0  0.1   0:00.03 courierlogger
 7559 root      21   0  4440  588  584 S    0  0.1   0:00.00 couriertcpd
 7561 root      25   0  3344  596  592 S    0  0.1   0:00.00 courierlogger
 7593 root      15   0  4440  652  604 S    0  0.1   0:00.58 couriertcpd
 7597 root      16   0  3476  808  752 S    0  0.2   0:00.46 courierlogger
 7619 root      24   0  4440  588  584 S    0  0.1   0:00.00 couriertcpd
 7621 root      20   0  3340  596  592 S    0  0.1   0:00.00 courierlogger
 8191 root      18   0 27072 2164 2080 S    0  0.4   0:00.58 httpd
 9231 apache    18   0 17928  548  520 S    0  0.1   0:00.14 httpd
 9287 named     24   0 46576 1540 1140 S    0  0.3   0:01.00 named
 9362 root      22   0  5380  904  900 S    0  0.2   0:00.00 mysqld_safe
 9396 mysql     15   0 99.6m 4820 2780 S    0  0.9   0:13.32 mysqld
10170 apache    16   0 37024 5140 3152 S    0  1.0   0:06.46 httpd
10239 apache    15   0 27400 4004 2768 S    0  0.8   0:00.63 httpd
11287 apache    15   0 34068 4984 3228 S    0  1.0   0:00.81 httpd
11389 apache    15   0 27400 4172 2788 S    0  0.8   0:00.62 httpd
11391 apache    15   0 33328 5040 3288 S    0  1.0   0:00.59 httpd
11392 apache    15   0 27360 4816 2944 S    0  0.9   0:00.48 httpd
11534 postgres  18   0 19948 1228 1112 S    0  0.2   0:00.27 postmaster

iptables --list -n |wc -l

Kod:

[root@linux ~]# iptables --list -n |wc -l
8

ps -ef

Kod:

[root@linux ~]# ps -ef
UID        PID  PPID  C STIME TTY          TIME CMD
root         1     0  0 Apr29 ?        00:00:00 init [3]
root      3938 30027  0 00:14 ?        00:00:00 sshd: root@pts/0
apache    5140  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache    5148  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
root      5403  3938  0 00:15 pts/0    00:00:00 -bash
root      7507     1  0 Apr29 ?        00:00:00 /usr/lib/courier-imap/couriertcp
root      7513     1  0 Apr29 ?        00:00:00 /usr/sbin/courierlogger imapd
root      7559     1  0 Apr29 ?        00:00:00 /usr/lib/courier-imap/couriertcp
root      7561     1  0 Apr29 ?        00:00:00 /usr/sbin/courierlogger imapd-ss
root      7593     1  0 Apr29 ?        00:00:00 /usr/lib/courier-imap/couriertcp
root      7597     1  0 Apr29 ?        00:00:00 /usr/sbin/courierlogger pop3d
root      7619     1  0 Apr29 ?        00:00:00 /usr/lib/courier-imap/couriertcp
root      7621     1  0 Apr29 ?        00:00:00 /usr/sbin/courierlogger pop3d-ss
root      8191     1  0 Apr29 ?        00:00:00 /usr/sbin/httpd
apache    9231  8191  0 Apr29 ?        00:00:00 /usr/sbin/httpd
named     9287     1  0 Apr29 ?        00:00:01 /usr/sbin/named -u named -c /etc
root      9362     1  0 Apr29 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --d
mysql     9396  9362  0 Apr29 ?        00:00:13 /usr/libexec/mysqld --defaults-f
apache   10170  8191  0 Apr29 ?        00:00:06 /usr/sbin/httpd
apache   10239  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   11287  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   11389  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   11391  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   11392  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
postgres 11534     1  0 Apr29 ?        00:00:00 /usr/bin/postmaster -p 5432 -D /
postgres 11632 11534  0 Apr29 ?        00:00:00 postgres: stats buffer process
postgres 11633 11632  0 Apr29 ?        00:00:00 postgres: stats collector proces
root     12226     1  0 Apr29 ?        00:00:01 /usr/bin/spamd --username=popuse
popuser  13614 12226  0 Apr29 ?        00:00:00 spamd child
root     13785     1  0 Apr29 ?        00:00:00 /usr/local/psa/admin/bin/httpsd
psaadm   13828 13785  0 Apr29 ?        00:00:04 /usr/local/psa/admin/bin/httpsd
psaadm   13888 13785  0 Apr29 ?        00:00:05 /usr/local/psa/admin/bin/httpsd
qmails   14111     1  0 May01 ?        00:00:00 qmail-send
qmaill   14113 14111  0 May01 ?        00:00:00 splogger qmail
root     14114 14111  0 May01 ?        00:00:00 qmail-lspawn | /usr/bin/deliverq
qmailr   14115 14111  0 May01 ?        00:00:00 qmail-rspawn
qmailq   14116 14111  0 May01 ?        00:00:00 qmail-clean
psaadm   14183 13785  0 Apr29 ?        00:00:03 /usr/local/psa/admin/bin/httpsd
drweb    14228     1  0 Apr29 ?        00:00:19 /opt/drweb/drwebd
root     14289     1  0 Apr29 ?        00:00:00 crond
root     14302     1  0 Apr29 ?        00:00:00 /usr/sbin/saslauthd -m /var/run/
apache   16368  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   18212  8191  0 Apr30 ?        00:00:04 /usr/sbin/httpd
apache   19983  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   19989  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   19990  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   20000  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   20001  8191  0 May01 ?        00:00:01 /usr/sbin/httpd
apache   20003  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
root     20152  5403  0 00:28 pts/0    00:00:00 ps -ef
apache   21568  8191  0 Apr30 ?        00:00:03 /usr/sbin/httpd
apache   24262  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   24267  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
apache   24268  8191  0 May01 ?        00:00:00 /usr/sbin/httpd
root     29948     1  0 Apr29 ?        00:00:02 syslogd -m 0
root     30027     1  0 Apr29 ?        00:00:01 /usr/sbin/sshd
root     30052     1  0 Apr29 ?        00:00:01 xinetd -stayalive -pidfile /var/

LinkBacks (?) LinkBack to this Thread: http://forum.iyinet.com/mysql-veritabani-sql/29477-mysql-cpu-kullan-m-my-cnf-optimizasyonu.html
Konuyu Başlatan	For	Type	Tarih
Load sorunu yaşayanlar için genel tartışma konusu - vBulletin SEO Forums	This thread	Pingback	2007-12-05 17:27
Vbseo işlemciyi çok kasıyor - Page 2 - vBulletin SEO Forums	This thread	Pingback	2007-06-14 21:38
Vbseo işlemciyi çok kasıyor - vBulletin SEO Forums	This thread	Pingback	2007-04-13 23:00

Seçenekler
Yazdırılabilir şekli göster Sayfayı E-Mail olarak gönder
Stil
Normal Hybrid-Şeklinde gösterime geç Ağaç şeklinde gösterime geç

Benzer Konular
Konu	Konuyu Başlatan	Forum	Cevaplar	Son Mesaj
mysql in visual basic ile kullanılması	Anonymous	MySQL Veritabanı SQL	5	2007-08-29 23:00
2 Ay Öde 3 Ay Kullan Kampanyaları	Uzak444	Dedicated CoLocation	0	2007-01-17 16:33
$50 lık adwords hesapları 13 ytl kullanıma hazır..	firar	Google Adwords	4	2006-10-31 07:59
2 Ay Öde 3 Ay Kullan Kampanyası	Uzak444	Dedicated CoLocation	0	2006-10-20 00:00
3 Ay Peşin Öde, 1 ay ücretsiz kullan! Dedicated ve VPS	LNWServers	Dedicated CoLocation	17	2006-06-09 20:14

Konuyu Toplam 1 Üye okuyor. (0 Kayıtlı üye ve 1 Misafir)