… configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or we just don’t need to define it for the cluster. I am new …
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a…: dose the tool exit gracefully while interupted? The tool doesn’t clean up the temporary table or triggers. It is designed to be resumable, although we don’t yet have a “resume” feature implemented. Q: periodically the ALTER…
Comment: Review of Virident FlashMAX MLC cards
April 25, 2012 By 14 Comments
… has nothing to do with the actual drive integrity.- i.e. power failure, controller error, disk timeout, etc.That is true… incomplete stripe, rather than mark the drive as unusable.Haven’t had time to research in more detail.
Comment: Introducing new type of benchmark
March 11, 2012 By 16 Comments
… system response rate (compare to throughput measuring benchmarks: they don’t issue another request until they get a reply from the… * U / ( 1 – U ) where U is the system utilization, i.e. the request intensity divided by the system’s maximum throughput… system response time given the system max throughput. It doesn’t help to reason about what workload mix is going to…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… excited to today announce the first GA (Generally Available; i.e. stable) release of Percona XtraBackup 2.0. We have worked…) compression utilities, which also had a number of other limitations (e.g. could not be used with parallel file copying, it…. Which meant those two feature were mutually exclusive, i.e. one couldn’t do streaming incremental backups. As part of the backup…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…, previous releases might also include them via supplemental repositories i.e. updates on CentOS. If you are using InnoDB, it is… logical volume holding the MySQL data. This way you don’t have to deactivate/activate the original logical volume to start…! However, if you can tolerate the extra IO overhead i.e. development or staging server , then this is still a valid…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… secondary key on col1 would be sorted by col1 i.e. in index order and then the lookup will be performed… time is 48.78s vs 48.91s, so I don’t see Hash Join and Key-ordered Scan making much of…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… (e.g. 5.5.18, 5.5.17, 5.5.16, 5.5.14). Whilst the majority of them aren’t significant…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… was just a guess, as PCI-E market is really attractive so FusionIO can’t stay alone for long time. So I…
Post: Moving Subtrees in Closure Table Hierarchies
February 14, 2011 By 7 Comments
… 0, PRIMARY KEY (ancestor, descendant) ) ENGINE=InnoDB; Because there isn’t much written about using the Closure Table design, I periodically… FROM TreePaths WHERE ancestor = ‘D’); But MySQL complains: “You can’t specify target table ‘TreePaths’ for update in FROM clause.” We… simple example). We also already have D-D and E-E and any other reflexive paths. If we were inserting just…
