… second is further 3 years of life in “critical bug fixes only” mode with releases available for premium (Silver+) Support offerings. For MySQL… of MySQL 4.1 are followed we’ll soon see stop in MySQL community releases of MySQL 5.0 most likely before MySQL 5.1 will proven MySQL 5.0 replacement. There is no blame on MySQL – it is…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… because of the alignment to a stripe unit. In the second example however every other page spans two disks so there… bigger than stripe element; second – logs are actually written in 512 byte units (in Percona Server 5.1 and 5.5 you can customize this…. Now it may be interesting to see what are real life effects of misalignment, my benchmark results are in the second part.
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth … in terms of CPU usage. In real life workload results are likely to be very …MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… out there that can make your life easy. However, there is one such tool… not just for new connections as in MySQL. This is very helpful for measurement …it to some other value say 0.1 seconds, it will miss all queries shorter …_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film …
Post: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 25 Comments
…theoretically could create 3 node traditional MySQL ring replication, but this … have cluster running in 5 min or less. There …, 4568 ports (see our FAQ why) Second, please take into account …, using it in real life. Now, as we have running… query: INSERT INTO t VALUES (1) Response time on single node…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…mysql, the final result is also represents the throughput (transactions per second in sysbench; NewOrder transactions Per Minute in tpcc-mysql… happens in real life. There are no …1.26, … Or if we represent graphically (point means even arrival): As you see interval is far from being strict 0.5…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…same version of mysql, with this patch applied (we compile mysql from source …just like they were in real life. It’s worth running this… actually runt he queries, the second is used to # avoid fork bombing… = Time::Local::timelocal($6, $5, $4, $3, $2-1, “20″.$1); $dt_min = $datetime if (($datetime < …
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access …Second baseline was selecting from MySQL table. Query vas very simple – lookup by primary cache, so this is kind of peak performance MySQL…memory cache – closest competitor. In real life performance difference can be evel larger…
Post: Countless storage engines
May 3, 2007 By 6 Comments
…load a lot. Second feature – fast index build. Both should be available in 5.2 MySQL. PBXT Interesting engine… applications with compression rate from 10:1 to 30:1 ScaleDB The engine based on special index… because theoretical ideas can be very far from life. Also nobody prohibits to add such index …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…5 different Data Centers via single Replication Relay server in each. Forget the single point of failure for the second…flush_logs_at_trx_commit=1 and only using Innodb …it properly. In the real life environments can be even more …running out of sync) due to MySQL bugs or wrong use. Interesting…
