…are available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on…16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…to other segments, if a 64 page extent becomes totally empty, and also it can release individual pages from its 32…replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL…than 128 pages would require a bit more work. Now it is …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…64 box with 32G with good price/performance value while if you would like to go significantly higher like 32…replication mainly to be able to fail over if there are problems. Over time application still will be limited by MySQL…another server a bit later. However if you have 100 MySQL servers to deal …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…thread normally posts about 64 page read requests…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32…computer, maybe a replication slave. Can …to get large data manageable. MySQL Master Master Manager can help you to automate it a bit. I also like to…
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
…64 threads per chip or 256 threads all together. Now what is about MySQL scaling to use these 32… the CPU performance got a bit better but as I understand…MySQL unless you really really do not care about single thread performance (REPLICATION, ALTER TABLE etc) and willing to run insane number of MySQL…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
…support is lacking. It does support replication which could make some rather…to hit bottlenecks in MySQL/Innodb when I had enough memory but I increased the threads from 64 to… where Tyrant may stumble a bit. Bottom line given a specific… above number were run with 32 Threads, Tyrant was started with…
