|
|
|||||||
| MySQL Veritabanı SQL SQL MySQL Access MSSQL Oracle Veritabani Database |
 |
|
|
LinkBack (3) | Seçenekler | Stil |
2007-01-16, 11:52
|
||||
|
||||
Amd 2400+ 1024 ram var sizce ayarı nasıl olmalı
[MySQLD] port=3306 basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data default-character-set=latin1 default-storage-engine=INNODB query_cache_size=32M query_cache_limit=1M query_cache_type=1 table_cache=1024 tmp_table_size=7M thread_cache=32 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size=2M key_buffer_size=2M read_buffer_size=1M read_rnd_buffer_size=256K sort_buffer_size=1M innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=16M innodb_log_file_size=10M innodb_thread_concurrency=8 max_connections=300 key_buffer=256M max_allowed_packet=1M sort_buffer=256K net_buffer_length=4K wait_timeout=10 connect_timeout=10 Konu Komikdunya.com tarafından (2007-01-16 Saat 11:54 ) değiştirilmiştir.. 
|
|
2007-01-17, 02:05
|
||||
|
||||
|
Alıntı:
Eger sadece innodb kullaniyorsan asagidaki parametrelerde degisiklik yap innodb_buffer_pool_size=256M key_buffer=16M
|
|
2007-01-17, 09:21
|
||||
|
||||
|
evet innodb kullanıyorum.
Bu arada makinam windows makina
|
|
2007-01-23, 22:23
|
||||
|
||||
|
SistemBilgisi : Amd 2800 1536 Ram
Top Çıktısı: top - 23:23:29 up 1 day, 5:57, 1 user, load average: 7.75, 9.88, 13.66 Tasks: 183 total, 9 running, 174 sleeping, 0 stopped, 0 zombie Cpu(s): 89.5% us, 10.2% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.3% hi, 0.0% si Mem: 1554768k total, 1400188k used, 154580k free, 88852k buffers Swap: 2088440k total, 122812k used, 1965628k free, 559792k cached Mevcut Kullandığım my.cnf: [mysqld] set-variable = max_connections=400 safe-show-database query_cache_size=64M connect_timeout=5 thread_cache=100 thread_concurrency=120 thread_stack=512000 key_buffer_size=512K sort_buffer_size=100K read_buffer_size=100K max_allowed_packet=64M Bunlar İlgili Tavsiye Edebileceğiniz ekleri veya düzenlemeleri yazarsanız sevinirim.
|
|
2007-01-24, 05:50
|
||||
|
||||
|
Alıntı:
|
|
2007-01-24, 16:34
|
||||
|
||||
|
benim makinem p4 3.2 2 gb ram i var linux centos plesk 8.1 kurulu ağırlık hep php siteler mysql versiyonu 4.1.20
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 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid buda top Kod:
5:55pm up 4:12, 2 users, load average: 4.55, 3.07, 2.48
130 processes: 126 sleeping, 4 running, 0 zombie, 0 stopped
CPU states: 43.8% user, 11.8% system, 0.0% nice, 44.3% idle
Mem: 2066544K av, 1424700K used, 641844K free, 0K shrd, 103332K buff
Swap: 1510100K av, 0K used, 1510100K free 801728K cached
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
4770 mysql 15 0 143M 39M 4648 S 0 32.4 1.9 57:24 mysqld
15948 apache 16 0 65484 38M 4516 S 0 21.9 1.8 0:02 httpd
15973 apache 15 0 67188 40M 4940 S 0 12.8 1.9 0:05 httpd
17097 apache 16 0 66680 39M 4188 S 0 10.0 1.9 0:01 httpd
17209 apache 17 0 65108 37M 4416 S 0 9.5 1.8 0:01 httpd
16468 apache 16 0 60200 34M 4316 R 0 2.3 1.7 0:00 httpd
15941 apache 16 0 65720 38M 4520 R 0 0.4 1.9 0:02 httpd
15972 apache 15 0 65852 38M 4520 S 0 0.4 1.9 0:02 httpd
17288 root 16 0 2612 1692 1476 R 0 0.4 0.0 0:00 top
1 root 16 0 3544 560 480 S 0 0.0 0.0 0:00 init
2 root 0K 0 0 0 0 SW 0 0.0 0.0 0:00 migration/0
3 root 34 19 0 0 0 SWN 0 0.0 0.0 0:00 ksoftirqd/0
4 root 0K 0 0 0 0 SW 0 0.0 0.0 0:00 migration/1
5 root 34 19 0 0 0 SWN 0 0.0 0.0 0:00 ksoftirqd/1
6 root 5 -10 0 0 0 SW< 0 0.0 0.0 0:00 events/0
Konu {Üstat} tarafından (2007-01-24 Saat 16:52 ) değiştirilmiştir..
|
|
2007-01-25, 02:35
|
||||
|
||||
|
Alıntı:
[mysqld] max_connections=400 safe-show-database query_cache_size=64M query_cache_limit=1M query_cache_type=1 table_cache=1024 connect_timeout=5 key_buffer=256M max_allowed_packet=64M
|
|
2007-01-25, 02:39
|
||||
|
||||
|
Alıntı:
[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-locking skip-innodb key_buffer = 256M table_cache = 1024 max_connections = 500 query-cache-type = 1 query-cache-size = 64M
|
|
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 | |
| Stil | |
|
|
|
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 |
Normal
