… like you don’t need an extra network roundtrip because of a loadbalancer and scalability … atomic builtins 120619 13:21:17 InnoDB: Compressed tables use zlib 1.2.3 120619 …mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… performance when using compressed tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita… to an unappropriated network error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… later mounted same as original file system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot… to Integrate Do you want to compress backup ? Backup it to tape, FTP or any network backup software – it is easy as…) Extract/Copy database to the slave database directory. 10) Start MySQL Server. Wait for it to perform recovery. 11) Use CHANGE…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… formats. These are covered pretty well in the MySQL manual here. Put simply, the events can be… element of the replication. There could be a network delay, causing a steady delay of few hundred … try to get that fixed is enabling slave compressed protocol. Otherwise, if you are sure it is …
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… outline of improvements available in MySQL 5.6 which I thought …Persistent Statistics for Innodb – Improvements to Innodb Compression – Fast Page Checksums (CRC32) – 4K … – - Stages Instrumentation – - Aggregations by User, Host etc – - Network IO Instrumentation – - Show Host Cache Contents – …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…shipping, as only aggregated sets are sent over the network. In the future you will be able to … resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies …* Detected an IN list with 2 items * IN list compression is not required — 2 items is less than …
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… world “cloud” test to show that this works over the network, in a real world environment. There is a slight performance… 55GB before converting to a star schema (21GB) and being compressed by ICE to 2.5GB. Many of these queries examine…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 47 Comments
…. well, until your intuition changes from your experience… As for compression — it typically is better done on the application end. If… also mean less network traffic. And the server could do it if the client version was old. Unfortunately, MySQL‘s compress/uncompress puts…. The Drizzle folk are welcome to my suggestion to have compressed columns and integrate it at the client/server api level…
Post: xtrabackup-0.9.5rc
October 24, 2009 By 13 Comments
…. Barracuda file format as well as compressed tables are supported. We thank a well known Social Network site for the sponsorship. Windows… of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.9.5rc/. The Debian package is also available…
