Displaying 2 results from an estimated 2 matches for "innodb_lock_wait_timeout".
2009 Apr 15
3
MySQL On ZFS Performance(fsync) Problem?
...le_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.jianzhaoyang.com
BBS???http://iMySQLer.com
????http://groups.google.com/group/mysqler
-------------- next part --------------
An HTML attachment was...
2011 Feb 26
9
No connection to mysqld
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