… “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 48 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-…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…in compressed file size. Though in this example we used MySQL…and result was generated with 13 MB/sec. For all archivers it is possible to use parallel…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…run on many pieces of input, and this is a very expensive process unless the work can be done in parallel…mysql> select min(id),max(id) from words; +———+———+ | min(id) | max(id) | +———+———+ | 1 | 3088896 | +———+———+ 1 row in set (0…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
… in parallel and updates to the sbtest table and sbtest2 table can be done in parallel (…mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads=1 –init-rng=on –max-requests=0 –max-time=300 run… Settings for Version: ‘5.5.29-55-log’ socket: ‘/var/run/mysqld/mysqld.sock’ port…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…running Percona-Server-5.1.57-rel12.8 (will be in…in parallel, so let’s load in 16 tables in 16 parallel threads, 25,000,000 rows in…0 97 1 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 7 0 93 0 0 With regular tables CPU is utilized 85% and…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…1 | 341.1 0.1 0.1 0.7 0.0 1693.7 | 1357.2 0.1 73.6 1480.5 87.1 | 336.5 0.1 0.1 2.1 0.0 1696.2 | 1355.7 0.1 73.8 1520.0…in vxfs and in xfs – I use a mount option allocsize=1g). The second problem is the level of parallelism…MySQL is doing so we are currently testing xfs with MySQL…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
…1“); } } # Run queries in parallel: foreach ($all_links as $linkid => $link) { $link->query(“SELECT something FROM tableN WHERE “, MYSQLI_ASYNC); } $processed = 0…5 MySQL asynchronous queries in parallel against 5…
