…MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL…MySQL 5.1 could only complete 10 out of 22 queries within 3hours run time allowed for each query and MySQL 6.0…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…So Galera 0.8 comes with many nice features: Works with MySQL 5.1 and MariaDB 5.1. The … With parallel applying on slaves, the latency of round-trip transactions should be in…run different benchmarks, I expect that for simple master-slave setups the response time and throughput will be affected (and…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… have patched mysql-test-run.pl …MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and… understand parallelism. They …9090== Location 0x6e29da8 is 0 bytes inside global…and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there is no need for workarounds in…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…of taking SQL constructs like IN and BETWEEN and making these queries execute in parallel on a each host…:normal;letter-spacing:0;word-spacing:0;background-color:#fff;z-index:1;border-top:…in one query, it runs many smaller queries each requesting significantly less data. On the other hand, MySQL 5.5…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…and make binaries with them available. With current MySQL 5.0 I still see Innodb having serious scalability problems in…MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or parallel…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…MySQL has very good stability track record, with exception of MySQL 5.0 it was typically safe to run it in…in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0 and…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… “what kinds of queries do you have to run?” and they say “we can’t decide, so we… is the chance to parallelize. As you know, MySQL doesn’t do intra-query parallelization, so ETL jobs…can save that work by either using MySQL 5.1‘s row-based replication, or in MySQL 5.0 and earlier, doing the work on…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, Percona Server 5.1.59-13.0 and Percona Server 5.5.16-22.0 and…and previous data. Bug Fixed: #737569 (Valentine Gostev) xtrabackup would crash if the –parallel option was specified with a value of -1…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…MySQL replication instead. So assuming you have innodb_flush_log_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0…in case of “data journaling” this can be done with single log write with actual modifications performed parallel…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…in systems ( I run benchmark on 8 cores box), and it allowed to load data faster than other engines. Though LucidDB and…25 sec) 2763.464 sec Q2.1 1 hour 54 min 27.74 sec… sec Q4.2 5 hours 38 min 7.60 sec / 5 hours 36 min… http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-…
