W dniu 2011-11-24 22:39, Xavier Perseguers pisze:
Hi,
Some tuning of MySQL 5.5.16 and loading extensions takes 1:19 min.
Maybe you could give some hints here to help the next person having
similar problems? Not all little tiny details, but basically what is
worth having a look at...
Glad you could make it work!
Firstly I was increasing buffers and so on.
Then I realized that some of configuration options was changed between
MySql 5.1 and 5.5 like key_buffer -> key_buffer_size, table_cache ->
table_open_cache.
In the MySql 5.5 from the WampServer 2.2 InnoDB is a default engine and
some of the innodb settings was commented out in my.ini.
I also changed some of default values.
I send diff from my current my.ini and original.
regards
Tomasz
--- 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
_______________________________________________
TYPO3-english mailing list
[email protected]
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
