… a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=…max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max…
Comment: New variable slave_max_allowed_packet for slave servers
April 30, 2013 By 2 Comments
Seems to be a bug, if you have binlog_format=STATEMENT (and probably MIXED as well) MySQL still looking to max_allowed_packet but it report on slave_max_allowed_packet http://bugs.mysql.com/bug.php?id=69104
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-…= 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_…
Post: New variable slave_max_allowed_packet for slave servers
July 24, 2012 By 2 Comments
… log events can still be bigger than max_allowed_packet. During the recovery process the slave_max_allowed_packet is not going to help us and… than max_allowed_packet) and the second one, upgrade to a version that has slave_max_allowed_packet. Training In September I’m going to deliver MySQL…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | MAX_ALLOWED_PACKET | 1048576 | 4194304 | | JOIN… though shifting to sort merge much sooner. max_allowed_packet is 4MB instead of 1MB now allowing MySQL to handle larger queries. Makes sense as…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…max_allowed_packetblogpercona.commanual max_binlog_cache_sizeblogpercona.commanual max_binlog_dump_eventsblogpercona.commanual max_binlog_sizeblogpercona.commanual max_binlog_stmt_cache_sizeblogpercona.commanual max…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… event entry exceeded max_allowed_packet; Increase max_allowed_packet on master; the first event ‘mysql-bin.000002′ at 74416925, the last event read from ‘./mysql-bin.000004… than the max_allowed_packet 
Therefore, a read_buffer_size value larger than max_allowed_packet can break your replication while importing data to MySQL. This bug…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…. In my opinion MySQL Security should be treated the following way – if you do not allow any access to MySQL Server you are… Side Variables – Each server side can hold value up to max_allowed_packet in size (1M by default) but there does not seems… using parse tree inside MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL optimizations such as…
