…reduces dataset and decreases the amount of IO operations. The benefit of small size is also that TokuDB can keep in memory…memory. As benchmark software I tried iiBench, which you can take there https://launchpad.net/mysql… drawbacks, I see a good practical usage of TokuDB for log analyzing and log…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… prefix compression. The downside in gzip is increased usage of CPU time. PZ: We will see how … of the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here… which are not swappable. They also allow to reduce number of TLB cache misses. huge pages along …
Post: Living with backups
November 6, 2008 By 28 Comments
… being read from a storage. It allows to reduce I/O to such devices on frequently accessed …memory should anything ask for the same block again. That happens for as long as it does not get flushed. MySQL…-tools/tar … Please cosult ionice man page for usage details, it’s really very simple to grasp…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…’re running the system without ECC memory chances are your data will melt…and (in particular if you use MySQL Replication for HA) the switch to… power supplies also increase server power usage a bit. Redundant power supplies however…same problem. Proper QA/Stress test reduces the chance of this but you…
