… no 3396, OS thread id 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id… threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For each helper thread you can see thread state – if thread is ready – waiting for…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…innodb_file_io_threads InnoDB will use 1 insert buffer thread, 1 log thread, N/2-1 read thread, N/2-1 write thread. You can start from “innodb_file_io_threads = 10″ for…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file…Innodb to bypass OS buffering Innodb TableSpace IO will wipe out cache because it typically makes most of the IO on the system. On Windows…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… of the file address, then InnoDB schedules the…thread. Only one read-ahead can be happening on Unix at a time. On Windows, InnoDB…gain significantly with multiple IO threads on systems with …for additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
…confident running Innodb with both default (fsync based) or O_DIRECT innodb_flush_…file using SysBench on Ubuntu, ext4 running on VirtualBox 4.0.4 running on Windows…threads: 1 Extra file open flags: 16384 1 files, 1Mb each 1Mb total file size Block size 16Kb Number of random requests for random IO…
