… in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which… about same 10 seconds which gives about 32MB/sec of archive read speed and same 100MB/sec of uncompressed data. Do… and result was generated with 13 MB/sec. For all archivers it is possible to use parallel compression to get better…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
…://bugs.mysql.com/bug.php?id=25412 Also we propose Linux (AMD64 / Intel EM64T) binaries in tar.gz archive (Link removed) The archive contains both mysqld and mysqld-microslow binaries. Source tar.gz with…
Post: Percona Xtrabackup 1.6.2 released!
July 25, 2011 By 1 Comment
…using the –export option. It will fail before applying the archived log without producing a potentially unusable backup. Bug Fixed: #…Gadea) For more information, please see the following links: Downloads: Binary distributions, Percona Software Repositories Consulting, support, training, and custom …
Comment: Living with backups
November 6, 2008 By 28 Comments
Question: you’re archiving mysql binary data *while* mysql is running, and thus the data files are in an … always been under the impression that cold binary backups have to be done with MySQL off in order to get useable data…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… other problems spotted and in the meanwhile we go over binary logs for the last month to see how frequently this… being trivial. This was the best choice as with New MySQL version upgrade involves new Operating System and hardware and any… hard to archive experience. Also problems you encounter during upgrade are very different depending on the upgrade version – upgrade from MySQL 4…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult… might show me things like huge tables that should be archived, tables that I should be aware of if I see….) If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get…
Comment: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 13, 2007 By 37 Comments
… MySQL binary release: ./configure ‘–prefix=/usr/local/mysql‘ ‘–localstatedir=/usr/local/mysql/data’ ‘–libexecdir=/usr/local/mysql/bin’ \ ‘–with-comment=MySQL… ‘–with-big-tables’ \ ‘–with-yassl’ ‘–with-readline’ ‘–with-archive-storage-engine’ ‘–with-innodb’ ‘–with-extra-charsets=complex’…
Post: Life Beyond MySQL
September 27, 2006 By 3 Comments
… be doing some Web projects on my own, besides doing MySQL Consulting. I think some people thought I am just using… interested in more data so if you have some newsgroups archive (non binary) or can peer with us let me know. We… this size is developed on – it uses Linux/Apache/PHP/MySQL of course plus Sphinx for full text search.
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important… data archive storage. On BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL… reliability is desired it might be good idea to keep Binary Logs on the separate volume – you may need them to…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… archive and the patch is. First you should determine how your current MySQL installation was built, so you can have the new binary… extract the archive: (garfield:~/work) % gzip -c -d mysql-5.0.51a.tar.gz | tar -x -v -f – mysql-5.0.51a/ mysql-5… to have the patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql-5.0.51a…
