|
|
| |||||||
| Site & Server Administration Server Yönetimi hakkında, .htaccess, Apache configuration ve log analiz, güvenlik |
| |
|
| | | LinkBack | Seçenekler |
| |||
| İyi günler sunucuda mysql cpu kullanımı 100% ü geçtigi oluyor acaba my.cnf ayarlarımda bi sorun olabilirmi ? Sunucu Özellikleri 2 x Intel Xeon Quad-Core Harpertown 2.5GHz 2048 MB of DDR Memory Single 320 HDD Şuanki my.cnf [mysqld] safe-show-database old-passwords = 1 max_connections = 650 max_user_connections=300 key_buffer_size = 512M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 4000 thread_cache_size = 384 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 16 concurrent_insert = 2 #table_lock_wait_timeout only for mysql5 table_lock_wait_timeout = 30 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 7M query_cache_size = 64M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 max_write_lock_count = 16 skip-name-resolve skip-locking [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 384M sort_buffer = 384M read_buffer = 256M write_buffer = 256M |
![]() |
| Bookmarks |
| Seçenekler | |
| |