…size comparison, I used the du utility: InnoDB file size on disk: 42GB (with indexes…change … php…innodb-io-capacity=1000 innodb-log-buffer-size=32M innodb-log-file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes… http://bugs.mysql.com/bug.php?id=29560 Concerning a … may need to increase size of your Innodb log files to be able …run to show any table / index fragmentation, without having to run …
