…-10-179 For SST we use xtrabackup. This means at startup time, the new node will connect to an existing node in… can be done, but because of optimistic locking at commit time, rollbacks can happen if we have conflicting writes. In the…-onenode, so we will only use one node at a time (to avoid rollbacks bcause of optimistic locking). If that node…
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages … process, it will just go through the recovery phase on startup, which can be even slower in stock InnoDB than the… a variety of reasons. One way to decrease the shutdown time is to pre-flush the dirty pages, like this: mysql…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… transactions kill the database performance resulting in very long execution times for even simplest queries, or a huge deadlock. In such…> file located in MySQL data directory. Unfortunately this is a startup time parameter, so unless you set it early, it will not… by simply dropping the table. The problem I faced many times is that people do not configure their error log at…
Comment: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… a 128 bit UUID MAC address of eth0 + process startup time in ms + current time in ms + counter that resets every ms Then…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… always asked me to make NDB Cluster starts automatically upon startup of the servers. For the ones who know NDB Cluster… NDB startup, ndb-initializer and from Johan configurator www.severalnines.com. If all the nodes come up at about the same time… Pacemaker recently, a Clone resources set, that allows an optional startup if only one of 2 similar resources starts. I use…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… development & test box You’re a Internet startup that just needs a tiny startup database server without all the added costs So… setup information, please read…] [Optional] Set Percona server to startup at boot time [root@alarmpi ~]# systemctl enable mysqld ln -s ‘/usr/lib…/mysql/my.cnf If you setup Percona Server to startup at boot time (step 12), give your little server a reboot (type…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… TABLE is executed. #857590 (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option….e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). Fixed assertion failure in…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
….e. InnoDB waits until it is complete before reporting successful startup to the server. #785489 (Alexey Kopytov). Behavior changes The Fast… TABLE is executed. #857590 (Alexey Kopytov). QUERY_RESPONSE_TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option…
Comment: KISS KISS KISS
March 1, 2009 By 7 Comments
… proven rather than imagined needs. Few startups warrant complex distributed database systems; this engineering time is better spent building something their customers… exotic configuration of the next few years, where startups spend lots of time building systems that will scale to the billions of…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… use –init-file to make sure it is run on startup. The other approach is to prime server with real servers… honest “try again later” message, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not… it computes them on first table access after startup. This may take significant time if you have very large number of tables…
