… MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple…-query parallelism, for example. It would be lovely to have those things, if you’re running a data warehouse on MySQL, and…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… a large wait_timeout for the MySQL connection, innobackupex will regularly poll the server, keeping the connection alive while the backup is taking…. Bug Fixed: #687544 (Valentine Gostev) When a password for the MySQL connection was given to innobackupex with the –passwordoption, innobackupex would log…. Bug Fixed: #737569 (Valentine Gostev) xtrabackup would crash if the –parallel option was specified with a value of -1. Bug Fixed…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… and caching them. Persistent Connections Ajax applications with frequent case of one query per request make persistent connections relevant again. Automatic load… like to be able to run multiple queries for multiple MySQL connections at once. For scale out applications data to generate the… query all of them sequentially instead of doing it in parallel. Now people have to do crazy things to work it…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, … developers that they do not understand parallelism. They do. The stacktraces above are …is possible when one connection issues SHOW VARIABLES or equivalent while another connection is just starting…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL 5…=80 innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… the serial version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2… like the MySQL client. This will be a linear operation because Shard-Query has no idea how to add parallelism in this…, 0.0070059299468994s) Why six degrees of parallelism? Because that is how many physical cores are connected to my bus, and because I…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… MySQL boxes. We had prepared well and had measured how fast we could copy the data between servers of these kind connected… I mentioned you can get even better with using fast parallel compression like LZO or QuickLZ but there was no need… 50 servers from backup… in parallel. Will you backup system will be able to restore these in parallel efficiently ? Will there be…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… offer great performance on distributed systems, especially if they are connected via not very fast network you need to come up… do not have much support from MySQL to do so. What is really bad is Parallel query. Reporting with group by over… for query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back to…
Post: What would make MySQL Multiple Queries Usable ?
September 5, 2007 By 1 Comment
… most cases. What would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning… at once is of course you can run them in parallel. Asynchrnous submission API would be even better but even multi… allow having multiple working threads for same transaction within same connection which could possibly allow to implement it. Optimize query set…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…which may not be available, especially for CPU bound MySQL Load. The benefit in this case is less …up on the standard point to point 1Gbit network connection. If we try gzip -1 to get fastest …sec. For all archivers it is possible to use parallel compression to get better speed though this also means…
