… with many tables. The read performance, which is the main measurement for this benchmark suffered quite as expected – with 10000 tables… suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well) – Innodb suffers fragmentation less if it stores…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… virtual memory gets fragmented. A while ago I measured over 10 times slow down over time as memory becomes fragmented with 50.000… to use large pages. These already can be used for Innodb Buffer Pool and Key Buffer but could be used for…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… around between MySQL boxes. We had prepared well and had measured how fast we could copy the data between servers of… RAID is powerful enough. This applies to large Innodb tables with not overly fragmented tablespace, or it is easy to become IO…
