MySQL CPU Kullanımı my.cnf optimizasyonu

[MadDriver]

innodb kullanmýyorum MyIsam kullanýyorum. Bunlarýn hangisinini en iyi performansý verdiði hakkýndada bilgim yok doðrusu.

[iyinet]

MadDriver´isimli üyeden Alıntı

innodb kullanmýyorum MyIsam kullanýyorum. Bunlarýn hangisinini en iyi performansý verdiði hakkýndada bilgim yok doðrusu.

Bu sekilde bir dene bakalim, eski dosyayi bir yere saklamayi unutma!

[MySQLD]
port=3306
basedir=C:Program FilesSWsoftPleskDatabasesMySQL
datadir=C:Program FilesSWsoftPleskDatabasesMySQLData
default-character-set=latin5
max_connections=800
old_passwords=1
max_user_connections=400
skip-locking
skip-innodb
join_buffer_size=2M
key_buffer_size=384M
max_allowed_packet = 3M
myisam_sort_buffer_size = 8M
query_cache_type=1
query_cache_size= 32M
read_buffer_size = 1M
read_rnd_buffer_size = 1M
sort_buffer_size = 1M
table_cache=1024

[client]
port=3306

[MadDriver]

iyinet admin yardýmýn için teþekkürler. þimdi verdiðin ayarlarla kullanýyorum. Bakalým yarýn öðlen ne olacak. son durumu buradan bildiririm tekrar.

[MadDriver]

iyinet admin yardýmlarýn için çok teþekkürler. Bu saatlerde yaþanan sitenin açýlmama problemi giderildi. Suan rahat bir þekilde eriþim var. Hatta þuan smurfing saldýrýsý yapýlýyor siteye fakat yinede eriþim gayet düzgün çalýþýyor.

[GNeRaL]

Iyinet tekrar yazýyorum buraya, ilk ayarlarýmý ve deðerleri sunucuyu ilk aldýðým an vermiþtim ve sunucuda hiçbirþey kurulu deðildi.

Son deðerler,

[root@teklan-tr ~]# free
             total       used       free     shared    buffers     cached
Mem:       2066780    2038868      27912          0     165036    1292256
-/+ buffers/cache:     581576    1485204
Swap:      2031608          8    2031600
[root@teklan-tr ~]#

top - 14:11:29 up 7 days, 19:55,  1 user,  load average: 0.00, 0.03, 0.01
Tasks: 112 total,   1 running, 111 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.8% us,  0.3% sy,  0.0% ni, 98.9% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:   2066780k total,  2038796k used,    27984k free,   165036k buffers
Swap:  2031608k total,        8k used,  2031600k free,  1292256k cached

/etc/my.cnf dosyasýný ilk dediðin gibi yaptýðýmda Plesk CP'nin çalýþmasýna izin vermemiþti..

Tekrar bu deðerlere göre bir yanýt verirsen memnun kalýrým..

(Çalýþan 5-6 tane kendi sitem var, üç tanesi vbulletin forum, diðerleri de hep php+mysql)

[iyinet]

GNeRaL´isimli üyeden Alıntı

Iyinet tekrar yazýyorum buraya, ilk ayarlarýmý ve deðerleri sunucuyu ilk aldýðým an vermiþtim ve sunucuda hiçbirþey kurulu deðildi.

Son deðerler,

[root@teklan-tr ~]# free
             total       used       free     shared    buffers     cached
Mem:       2066780    2038868      27912          0     165036    1292256
-/+ buffers/cache:     581576    1485204
Swap:      2031608          8    2031600
[root@teklan-tr ~]#

top - 14:11:29 up 7 days, 19:55,  1 user,  load average: 0.00, 0.03, 0.01
Tasks: 112 total,   1 running, 111 sleeping,   0 stopped,   0 zombie
Cpu(s):  0.8% us,  0.3% sy,  0.0% ni, 98.9% id,  0.0% wa,  0.0% hi,  0.0% si
Mem:   2066780k total,  2038796k used,    27984k free,   165036k buffers
Swap:  2031608k total,        8k used,  2031600k free,  1292256k cached

/etc/my.cnf dosyasýný ilk dediðin gibi yaptýðýmda Plesk CP'nin çalýþmasýna izin vermemiþti..

Tekrar bu deðerlere göre bir yanýt verirsen memnun kalýrým..

(Çalýþan 5-6 tane kendi sitem var, üç tanesi vbulletin forum, diðerleri de hep php+mysql)

Sorun nedir anlamadim.
Verdigin bilgilere bakinca server gayet bos durumda, bir problem yok gorunuyor. Makina %99 idle (bos) durumda.

[GNeRaL]

1 sayfa geride dediklerini yapýnca;

[root@teklan-tr etc]# service psa start
DB error (mysql41 compatible query) 1017: Can't find file: 'misc.MYI' (errno: 2)
System error 11: Resource temporarily unavailable
Unable to connect to mysql database

System error 25: Inappropriate ioctl for device
Starting psa-spamassassin service:                         [FAILED]
ERROR 1017 (HY000) at line 1: Can't find file: 'DomainServices.MYI' (errno: 2)
ERROR 1017 (HY000) at line 1: Can't find file: 'sessions.MYI' (errno: 2)
DB error (mysql41 compatible query) 1017: Can't find file: 'misc.MYI' (errno: 2)
System error 11: Resource temporarily unavailable
DB error (mysql41 compatible query) 1017: Can't find file: 'misc.MYI' (errno: 2)
System error 11: Resource temporarily unavailable
Database connection failed, keys will not be updated
Processing config directory: /usr/local/psa/admin/conf/httpsd.*.include
/usr/local/psa/admin/bin/httpsdctl start: httpd started
...
...

çýkýyor. Orijinal(yukarýdaki þekilde) my.cnf kullanýnca da herþeyi sonuna kadar kullanýyor sanýrým?

[iyinet]

GNeRaL´isimli üyeden Alıntı

1 sayfa geride dediklerini yapýnca;

[root@teklan-tr etc]# service psa start
DB error (mysql41 compatible query) 1017: Can't find file: 'misc.MYI' (errno: 2)
System error 11: Resource temporarily unavailable
Unable to connect to mysql database

System error 25: Inappropriate ioctl for device
Starting psa-spamassassin service:                         [FAILED]
ERROR 1017 (HY000) at line 1: Can't find file: 'DomainServices.MYI' (errno: 2)
ERROR 1017 (HY000) at line 1: Can't find file: 'sessions.MYI' (errno: 2)
DB error (mysql41 compatible query) 1017: Can't find file: 'misc.MYI' (errno: 2)
System error 11: Resource temporarily unavailable
DB error (mysql41 compatible query) 1017: Can't find file: 'misc.MYI' (errno: 2)
System error 11: Resource temporarily unavailable
Database connection failed, keys will not be updated
Processing config directory: /usr/local/psa/admin/conf/httpsd.*.include
/usr/local/psa/admin/bin/httpsdctl start: httpd started
...
...

çýkýyor. Orijinal(yukarýdaki þekilde) my.cnf kullanýnca da herþeyi sonuna kadar kullanýyor sanýrým?

Orijinal my.cnf ile sorun cikaran my.cnf leri buraya koyarmisin.
Karsilastirma yapalim.

[GNeRaL]

Orijinal:

[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

[mysql.server]
user=mysql
basedir=/var/lib

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

Sizin verdiðiniz:

[mysqld]
skip-innodb
skip-locking
max_connections = 500
key_buffer = 128M
table_cache = 1500
query_cache_size = 32M
query_cache_type = 1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[iyinet]

GNeRaL´isimli üyeden Alıntı

Orijinal:

[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

[mysql.server]
user=mysql
basedir=/var/lib

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

Sizin verdiðiniz:

[mysqld]
skip-innodb
skip-locking
max_connections = 500
key_buffer = 128M
table_cache = 1500
query_cache_size = 32M
query_cache_type = 1
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Bu sekilde bir dene bakalim

[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-innodb
skip-locking
max_connections = 500
key_buffer = 128M
table_cache = 1500
query_cache_size = 32M
query_cache_type = 1

[mysql.server]
user=mysql
basedir=/var/lib

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