Makina özelliklerim :
Windows 2003 Server St Sp2
Plesk 8.4.x Panel
İntell R Xeon R Cpu X3220 2.40 Ghz 2.40 Ghz 2 gb Ram..
Hat çıkışım 10 mbit
Panelim plesk olduğu içinmidir nedir 2 adet My.ini dosyası var..
1. My.ini Serverdeki tüm sitelerin Databaselerin olduğu yerdeki my.ini
C:\Program Files\Parallels\Plesk\Databases\MySQL\Data içindeki..
[MySQLD] port=3306 basedir=C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL datadir=C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL\\Data default-character-set=latin1 default-storage-engine=INNODB read_buffer_size=1M read_rnd_buffer_size=256K sort_buffer_size=256K 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=400 old_passwords=1 max_user_connections=30 thread_cache_size=4 thread_stack=196608 binlog_cache_size=32768 net_read_timeout=30 net_retry_count=10 net_write_timeout=30 thread_concurrency=10 open_files_limit=0 [client] port=3306
2. My.ini dosyası
C:\Program Files\Parallels\Plesk\MySQL\Data dizinindeki my.ini
[client] port=8306 [PleskSQLServer] port=8306 basedir=C:\\Program Files\\Parallels\\Plesk\\MySQL datadir=C:\\Program Files\\Parallels\\Plesk\\MySQL\\Data default-character-set=latin1 default-storage-engine=INNODB query_cache_size=8M table_cache=32 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=256K 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=4M max_allowed_packet=1M sort_buffer=256K net_buffer_length=4K old_passwords=1 tmpdir=C:\\Program Files\\Parallels\\Plesk\\admin\\dbMakinamın özelliğine göre en iyi performans sağlıcak ayarlar lazım siteler çok geç geliyor..
Not : server Vps