…like rsync or mysqldump. So, flow control kicks in when the recv queue gets too big, but how big ….fc_master_slave=YES; gcs.fc_factor=1.0″; Working with flow control What happens during flow control …which is a hash table. A small fc_limit does however keep the certification index smaller in memory. …
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
… use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works… table and rename such temporary table to original name. How does data visibility works in this case ? DDLs are not transactional and as… solutions for this problem ? you can use mysqldump –lock-all-tables instead which does not have this problem at the cost of…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… does not work with Innodb. Backup tools like “mysqlhotcopy” does not work etc. Note Performance also affects Operations aspects a lot – for example using mysqldump… or shadow table but it is important to consider them. How about Mixing Storage Engines ? Sure you can mix storage engines…
Post: Living with backups
November 6, 2008 By 28 Comments
…heavy queries against each table in the database when mysqldump is used or reading a lot of data …also a utility called ionice. It allows to affect how I/O scheduler will be dealing with I/…this application to work is that the system must be using CFQ elevator algorithm, it does not work with others. …
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… add additional node to a cluster (e.g. XtraDB Cluster), how does it affect the response time ? – When we put a load…. Does DROP TABLE, running in separate session, affect a response time of queries that handle user load ? The same for mysqldump, how does it… as 3000 transactions per second (regular sysbench transactions). We vary working threads from 1 to 128. There are results for 16…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…mysqldump or a custom product that does something similar? Is it a filesystem copy? Does…How does the system guarantee that you can perform point-in-time recovery? How does…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… is exactly how it is done in many cases. There is really no gain in dumping table via mysqldump and loading it… mode if you have something substantial to gain. Q: How would Upgrade work if Old Server has Antelope format and New one… binary log events, as described here yet it does not guaranty replication will work for any application. There is just too many…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…: – Transactions only support the SERIALIZABLE isolation level. Beside it TokuDB does not scale well on multi-cores even in only SELECT… a release soon. – The ways to do a backup is mysqldump/mysqlhotcopy. It is not fully transparent backup, as it applied… say how it will work with mix of storage engines. – The Tokutek engine I tested comes in binary form and mysqld binary does…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… with the same name. This is because mysqldump in many cases generates the “DROP TABLE” … “THORA” “TEMPLE” “2006-02-15 04:34:33″ How does the following “CREATE TABLE” make the recovery any…how to deal with tables with binary only values This method has drawbacks: It assumes a lot of manual work…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… propagates via replication (not common, but does happen) You lose your entire SAN …mysqldump … -d -R –skip-triggers, out to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How…store long term backups with little additional work Tips/Tricks: –add-header=x-amz-…
