… the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern… is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable….commanual profiling_history_sizeblogpercona.commanual protocol_versionblogpercona.commanual proxy_userblogpercona.commanual… skip_thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… in a specific one, MYSQL_CLIENT_COMPRESS. This flag tells the client application to enable compression in the network protocol when talking to mysqld. It reduces network traffic but at the cost of some CPU time: server has to compress… client, and client and MySQL are on different boxes, and the connection is 100 Mbit, consider using compression. It’s a matter…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… is highly compressible and light compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in addition to zlib we could stream compressed results directly from storage and only de-compress it…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… write one now. Of course, there are many aspects of MySQL replication, but my main focus will be the logistics – how… different replication formats. These are covered pretty well in the MySQL manual here. Put simply, the events can be one of… want to try to get that fixed is enabling slave compressed protocol. Otherwise, if you are sure it is SQL thread, then…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…] WSREP: Assign initial position for certification: 97, protocol version: 2 120619 13:20:19 [Warning] …atomic builtins 120619 13:21:17 InnoDB: Compressed tables use zlib 1.2.3 …mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
