May 26, 2012

Post: Heikki Tuuri answers to Innodb questions, Part II

…€™m also wondering if you would recommend using SSD for this purpose, and how much performance …of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main…/ index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may …

Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages

…to the tablespaces. Ultimately this mechanism was an optimization for slow drives:  if you can sequentially …this is still useful if you can use Linux native AIO.  These can also be rendered …’estimate’ (good default) and ‘keep_average’ designed for SSD type storage.  Running Percona Server and using …

Post: Review of Virident FlashMAX MLC cards

…. Performance at full capacity: As we know, SSD-based cards have special characteristics; the throughput … include: Server: Cisco UCS C250, running Oracle Linux 6.1 and Percona Server 5.5.15… sysbench v5 Of course, our Percona Server was optimized for Flash cards, with variations for two settings…