mysql BIG issue

Alles, was MySQL betrifft, kann hier besprochen werden.

mysql BIG issue

Postby quali74 » 04. January 2011 14:22

hi

I have setup mysql and everything seemed to be working until I reached the 10MB size. My tables are myIsam.

+ I tried to convert my MyIsam tables to InnoDB tables but the InnoDB type is not available although I have:

Code: Select all
# Comment the following if you are using InnoDB tables
#skip-innodb
innodb_data_home_dir = "C:/xampp/mysql/"
innodb_data_file_path=ibdata1:1000M:autoextend:max:800M
innodb_log_group_home_dir = "C:/xampp/mysql/"
innodb_log_arch_dir = "C:/xampp/mysql/"
## You can set .._buffer_pool_size up to 50 - 80 %
## of RAM but beware of setting memory usage too high
innodb_buffer_pool_size=256M
innodb_additional_mem_pool_size=20M
## 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
quali74
 
Posts: 4
Joined: 12. October 2006 15:05

Re: mysql BIG issue

Postby greno » 15. January 2011 20:31

innodb_log_arch_dir

This option is not supported in newer MySQL and may stop MySQL from starting.
greno
 
Posts: 54
Joined: 04. October 2006 19:25


Return to MySQL

Who is online

Users browsing this forum: No registered users and 4 guests