… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… of memory. Do not do this. If using Linux setup LVM for database directory to get more efficient backup. EXT3 file… (try to be easy on indexes). With these basic innodb performance tunings you will be better of when majority of Innodb users…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… to serve so many use cases it is not tuned to exploit full performance potential of any given storage engine. Synchronization The… some in memory so even OS level approaches such as LVM backup may not work in all cases. We also get… deal with balancing – allocating resources to different storage engines and performance tuning becomes more complicated. Now what is interesting for probably 95…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? … systems that are at any level of tuning, from completely untuned to a system that…three commands are for giving me information about LVM devices, volume groups, and logical volumes. At …
Comment: Tokyo Tyrant - The Extras Part I : Is it Durable?
August 20, 2010 By 5 Comments
…. The table bloats more quickly but the performance gains are readily had. Basically all tuning tricks for a file-based DBMS are… to the rescue – the hotspots can spread out across a LVM on RAID10 – the writes will be appreciably faster & if you… the pace of the IO controller’s ability to safely perform writes. This requires understanding what parameters to set in sysctl…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…the Tokutek storage engine), and run some benchmarks. Tuning of TokuDB is much easier than InnoDB, there…given incoming data rate, enabling much higher query performance. Beside iiBench we run benchmarks of SELECT queries… I guess it will be possible to run LVM backup. Actually I would say backup is …
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 21, 2010 By 25 Comments
… use capacity of storage it has available (probably self tuning based on IO performance it is getting) as there are many ways… vary a lot during run time. Think shared SAN storage, LVM snapshots or cloud for example.
