…can be happening on Unix at a time. On Windows, InnoDB uses native async I/O, and can perform many…the Linux kernel’s buffer pool. In high load situations where INNODB is using most of the system’s … patches are not in the official InnoDB, though. PZ: If your load is CPU bound and you’re scaling …
Post: Internals of InnoDB mutexes
September 7, 2006 By 4 Comments
… becomes from age of dinosaurs and Windows 95, where count of condition variables was limited, so InnoDB had to implement workaround. The… protect cells. With big respect to InnoDB team they still take care of users of Windows 95 I think it is better… dramatically – so you can test it if you have multi-CPU boxes and high-concurrency load on InnoDB.
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… any entries if you’re running in high concurrency envinronment, so Innodb has to fall back to OS … amount of spin waits and spin rounds significant CPU resources may be wasted. It should come to … see 4 helper threads, on Windows it however can be adjusted by innodb_file_io_threads variable. For …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…cache_size = 2000M # Try number of CPU‘s*2 for thread_concurrency thread_… this option without enabling named pipes on Windows # (via the “enable-named-pipe” option)…high innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb…
