…MySQL client. This will be a linear operation because Shard-Query has no idea how to…to divide, and you want to use 1024 way parallelism: select min(result) == 0 is_prime from ( select mod({$NUMBER_TO…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… http://www.maatkit.org/trunk/fifo”). So how did it work? Did it speed up the load? Not appreciably….terminal: while [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql… think to use iostat to see how much the device was actually used, so this isn’t a scientific measurement of how…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…to profile MySQL…to /tmp/massif.out. If you prefer to use another location (and are therefore bound to set proper file rights etc.) use…speed rather than debugging). If the binaries you have are stripped, you have a few options to…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…We could implement API which would allow one to use local memory, Memcache or for example local …speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in addition to… is available which makes it hard to understand how exactly MySQL Query Cache is working in many …
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… thinking today of how people tend to use MySQL in modern applications and it stroke me in many cases MySQL is not used to process the data… as a lot of other personalized services they may not use MySQL (and SQL at all). In many cases you would see… to relational data structure to well, but also because of lack of build in parallel processing. When you need high data processing speed…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…file size. Though in this example we used MySQL binary log file which often contains plenty… UPDATE: It looks like people are wondering how BZIP2 compares so I should check …to use parallel compression to get better speed though this also means a higher load which can be the issue if you’re not using…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… terms of size and spindle speed. I need to know how many physical spindles are under the box, and how fast they are. I… logs in the stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has… it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the…
Post: How number of columns affects performance ?
September 28, 2009 By 12 Comments
… when it comes to MyISAM. The common workaround working with such wide tables is to use covering indexes. I added one to t99v1 table and repeated the query: mysql [localhost] {msandbox} (test) > select… speed is very similar to full table scan speed – this is rather expected as table data is stored in BTREE index very similarly to how…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…. The goal was to see how MySQL 5.6 performs out-of-the-box as compared to 5.5.30 …the queries to use ANSI JOIN syntax. No other changes to the queries were made. Test Environment The MySQL versions used at …, I pointed the MySQL 5.6.10 at the MySQL 5.5.30 data directory. Tthe speed was essentially …
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 8 Comments
… as it shows how much overhead you have by using mysql stored routines interface. So anyway, I asked my colleague Sasha to help me… – 12 times if comparing to stored function or 2 times comparing to just using available functions. With that speed I could even scan the whole table of 7 million records: mysql> select count…
