search for: innodb_log_file_size

...e... I then wanted to restore one of the backups to a different named database so I did: mysql myNewDatabaseName -u root < myBackupFile.sql I got some errors about logfile size so I stopped Mysql and removed the logfiles and set the following parameters in the my.ini file and restarted mysql. innodb_log_file_size=64M innodb_log_buffer_size=8M The restore now completes with no errors but one of the three tables which contains blobs is never restored. My max-allowed-packet is set to 32M The database backup size is about 2.2 GB the majority of that size being in the table that does not restore. If I run a my...

...| | general_log_file | pdone-prod.log | | innodb_flush_log_at_trx_commit | 1 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_block_size | 512 | | innodb_log_buffer_size | 8388608 | | innodb_log_file_size | 5242880 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | ./ | | innodb_mirrored_log_groups | 1 | | innodb_recovery_update_relay_log | OFF | | innodb_use_global_flush_log_at_trx_commi...

...e_per_table innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2048M innodb_data_home_dir = /data/mysqldata3/innodb_ts innodb_data_file_path = ibdata1:256M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 0 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 512M innodb_log_files_in_group = 5 innodb_log_group_home_dir = /data/mysqldata3/innodb_log innodb_max_dirty_pages_pct = 20 innodb_lock_wait_timeout = 120 innodb_doublewrite=0 ... Is there any one can help me, why fsync on zfs is so bad? or other problem? -- Sky.Jian iMySQLer ?????http://www...

Hi. I started mysqld.exe using Wine and it seems to work. But when I try to connect the server seems to answer somehow (connection is established, telnet works) but it seems that no communication takes place. mysql freezes and in telnet no response is shown. Any idea what this could mean? Running in Windows without an installer works so it has to be some problem with wine somehow. Using Ubuntu