>> What does SELECT @@wsrep_provider_options\G say?
> mysql> SELECT @@wsrep_provider_options\G
> *************************** 1. row ***************************
> @@wsrep_provider_options: base_port = 4567; evs.debug_log_mask = 0x1;
> evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S;
> evs.info_log_mask = 0; evs.install_timeout = PT15S;
> evs.join_retrans_period
> = PT0.3S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 1;
> evs.send_window = 4; evs.stats_report_period = PT1M;
> evs.suspect_timeout =
> PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version
> = 0;
> evs.view_forget_timeout = PT5M; gcache.dir = /var/lib/mysql/;
> gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name =
> /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size =
> 128M;
> gcs.fc_debug = 0; gcs.fc_factor = 0.5; gcs.fc_limit = 16;
> gcs.fc_master_slave = NO; gcs.max_packet_size = 64500;
> gcs.max_throttle =
> 0.25; gcs.recv_q_hard_limit = 9223372036854775807;
> gcs.recv_q_soft_limit =
> 0.25; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ;
> gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.time_wait =
> PT5S;
> gmcast.version = 0; ist.recv_addr = 173.45.237.153; pc.checksum =
> true;
> pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT2S;
> pc.npvo =
> false; pc.version = 0; protonet.backend = asio; protonet.version = 0;
> replicator.causal_read_timeout = PT30S; replicator.commit_order = 3
> 1 row in set (0.00 sec)
Hm, 77 million of 128Mb pages... something is not right there, but I > Could you post more of the preceding log? especially the line about
>> creation of gcache.page?
> Whoops, I totally forgot to backup that log and it's been logrotated
> out.
> Sorry!
> Which Galera version are you using?
> dpkg -s galera:
> Package: galera
> Status: install ok installed
> Maintainer: Codership Oy
> Architecture: amd64
> Version: 23.2.0
> Replaces: galera
> Provides: wsrep, galera
> Depends: libc6 (>= 2.4), libstdc++6 (>= 4.1.1), libgcc1 (>= 4.1.1),
> libssl0.9.8
> Conffiles:
> /etc/default/garb b50555bd995e118d2f944b64cab0ecab
> Description: Galera Replication Framework
> Copyright: 2007-2011 by Codership Oy, All Rights Reserved
> Replication framework for transactional applications. Implements
> wsrep
> interface.
> dpkg -s mysql-server-wsrep:
> Package: mysql-server-wsrep
> Status: install ok installed
> Maintainer: Codership Oy
> Architecture: amd64
> Version: 5.5.20-23.4
> Replaces: mysql-server-core (<= 5.5.20), mysql-server-core-5.0 (<=
> 5.5.20),
> mysql-server-core-5.1 (<= 5.5.20), mysql-server (<= 5.5.20),
> mysql-server-5.0 (<= 5.5.20), mysql-server-5.1 (<= 5.5.20),
> mysql-server-core-5.5 (<= 5.5.20), mysql-server-5.5 (<= 5.5.20)
> Provides: mysql-server-core, mysql-server, mysql-server-core-5.5,
> mysql-server-5.5
> Depends: psmisc, debianutils (>= 1.6), libc6 (>= 2.4), libdbi-perl,
> libdbd-mysql-perl (>= 1.2202), libgcc1 (>= 4.1.1), libncurses5 (>=
> 5.6),
> libstdc++6 (>= 4.1.1), libwrap0 (>= 7.6), perl, zlib1g (>= 1.1.4),
> libaio1,
> mysql-client
> Conffiles:
> /etc/mysql/conf.d/wsrep.cnf 66200619107be141d9796223ce719884
> Description: wsrep-enabled MySQL server
> Copyright: MySQL AB, Codership Oy, All Rights Reserved
> MySQL server + wsrep patch (https://launchpad.net/codership-mysql)
> Yes, something like that.
> Ok, we'll tweak that.
There have been no related changes in gcache since 2.0, but upgrading