--- my-org.ini Fri Nov 11 13:59:26 2011 +++ my.ini Fri Nov 25 00:41:38 2011 @@ -26,14 +26,14 @@ [wampmysqld] port = 3306 socket = /tmp/mysql.sock -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 +key_buffer_size = 64M +max_allowed_packet = 2M +table_open_cache = 128 +sort_buffer_size = 1M +net_buffer_length = 16K +read_buffer_size = 512K +read_rnd_buffer_size = 1M +myisam_sort_buffer_size = 128M basedir=d:/wamp/bin/mysql/mysql5.5.16 log-error=d:/wamp/logs/mysql.log datadir=d:/wamp/bin/mysql/mysql5.5.16/data @@ -127,13 +127,24 @@ #innodb_log_arch_dir = C:\mysql\data/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high -#innodb_buffer_pool_size = 16M -#innodb_additional_mem_pool_size = 2M +innodb_buffer_pool_size = 256M +innodb_additional_mem_pool_size = 10M # Set .._log_file_size to 25 % of buffer pool size -#innodb_log_file_size = 5M -#innodb_log_buffer_size = 8M -#innodb_flush_log_at_trx_commit = 1 -#innodb_lock_wait_timeout = 50 +innodb_log_file_size = 5M +innodb_log_buffer_size = 32M +innodb_flush_log_at_trx_commit = 1 +innodb_lock_wait_timeout = 60 +innodb_file_io_threads = 4 +innodb_file_per_table = 1 +innodb_doublewrite = 1 +innodb_max_dirty_pages_pct = 65 +innodb_support_xa = 0 +innodb_thread_concurrency = 0 +innodb_concurrency_tickets = 1000 +innodb_io_capacity = 500 + +sync_binlog = 0 +sync_frm = 1 [mysqldump] quick @@ -145,13 +156,13 @@ #safe-updates [isamchk] -key_buffer = 20M +key_buffer_size = 32M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] -key_buffer = 20M +key_buffer_size = 32M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M @@ -160,4 +171,4 @@ interactive-timeout [mysqld] -port=3306 \ No newline at end of file +port=3306