… compression of data. MySQL‘s Archive storage engine. Tooling The tooling phase consisted of producing scripts to generate representative payloads for comparison, in this… generation and a subsequent 63 minutes for import. Results Size on disk Engine Compression Ratio 7.1M Archive 173.07:1 304M…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…resources which may not be available, especially for CPU bound MySQL Load. The benefit in this case … uncompressed backup. What is about compression tool ? The classical tool used for backup compression is gzip – it … single drive. The file decompresses in 3.7 seconds which gives 105MB/sec read speed …
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
…pt-upgrade This tool lets you test your SELECT queries against multiple MySQL servers and … only differences with query times. # Query 7: ID 0x76323E2525BA457C at byte 0 _______________________________ # Found… is tolerable and can be accounted for other MySQL overhead like network latency. pt-upgrade…
Post: SysBench - benchmark tool
August 18, 2006 By 20 Comments
… @ MySQL AB) – http://sysbench.sourceforge.net/ and I want to write a short intro about this tool … server performance First four is useful for the platform evalution, for example if you want to … notes. Regarding database benchmarks – in 0.4.7 and earlier versions Sysbench supported only predefined …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. We often use tools to gather a lot of the data for us and … tail -n 25 /proc/cpuinfo power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model…MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… not such easy way for the long transaction list, but fortunately there are some alternatives to the limited MySQL command output. First… (deleted) lrwx—— 1 root root 64 Oct 31 18:26 7 -> /tmp/ibsMzkIA (deleted) lrwx—— 1 root root 64 Oct 31… help yourself with lsof tool available for many platforms: garfield fd # lsof -c mysqld | grep deleted mysqld 11886 mysql 5u REG 253,10…
Comment: Slow Query Log analyzes tools
January 12, 2007 By 84 Comments
… use MySQL Community version but does not like to build binaries we decided to publish our build for MySQL …-0.glibc23.x86_64.rpm Headers and libraries 7.3M MySQL-devel-5.0.33-0.glibc23.x86_… the patch http://www.mysqlperformanceblog.com/…nalyzes-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier` char(7) DEFAULT NULL, `AirlineID` int(11) DEFAULT NULL,…sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING …mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to 20 nodes for…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
It is easy for MySQL replication to become bottleneck when Master server is not seriously … capacity is. There is however no tools which can tell us straight what replication capacity is for the given system. It also… 0.14 0 # Tmp table 8.30G 0 2.01M 7.12k 0 117.75k 0 # 0% (5k) Filesort # 0% (5k…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…wp_users | 109 | 1 | 3 | | hosting2.wp_links | 910 | 7 | 21 | | hosting2.wp_term_taxonomy | 729 | 3 | 6 …rows support for prepared statements which all currently fall under Other_commands a few MySQL …query logging, would give the administrator powerful tool to almost effortlessly catch the users …
