…, another open-source column-oriented database I’ve been meaning to take a look at? What follows is not a realistic benchmark… statements. I wanted to see how fast MyISAM vs. MonetDB would interpret really large INSERT statements, the kind produced by mysqldump. But MonetDB choked and told me the number of columns mismatched. I found reference to this on the…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… you will need to look into it more later. Another alternative is to dump table with MySQLDump and load … buffering taking place and as MySQL crashes it does not store all data it could recover to MyISAM … after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…_sandbox5516.sock prepare Running Sysbench and MySQLDump. Note we run them in the loop to see how result stabilizes. [root@localhost msb_ps… reaches steady state we get about 2 req/sec and mysqldump takes about 180 seconds. Yes you get it right. Performance of… heavy mysqldump is running concurrently. mysqldump itself also slows down about 2x. What is going on here ? To understand it we should take a…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…can take advantage of the fast index creation feature even when it has to copy the entire table. To…set (0.00 sec) Now let’s see how performance is affected when turning expand_fast_…be indexed, so it is impossible to temporarily drop the corresponding index; mysqldump –innodb-optimize-keys ignores …
Comment: Using LVM for MySQL Backup and Replication Setup
August 18, 2011 By 53 Comments
… in , now taking a mysqldump is a long process and can’t afford the slave shutdown so we need to pursue other avenues… are the options of using that snapshot and how ? the purpose is to use this snapshot or the tar backup data and… volume in any way ?> what could be other solution to this mess that i haven’t thought about apart from mysqldump ??? Tariq
Post: Living with backups
November 6, 2008 By 28 Comments
…, but also such large I/O requests take significant time to complete and the way typical disks work … to the incoming queries quick enough. What can be done about it? Nothing really when you are using mysqldump… also a utility called ionice. It allows to affect how I/O scheduler will be dealing with I…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…to keep this into account. We move database to MySQL 5.1 As the database size is relatively small we do mysqldump…traffic replicates properly to the new setup. It was the time to check how read traffic behaves…. to check only limited number of samples for each query type – otherwise it can take a…
Post: Percona XtraDB Cluster Feature 1: High Availability
January 17, 2012 By 20 Comments
… have to go on all nodes. You have several duplicates of data. For 3 nodes – 3 duplicates This basically defines how Percona… to use our source code repository). The downside of mysqldump and rsync is that your cluster becomes READ-ONLY for time that takes to copy data from one node to another…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…from Sun – he agreed with our cons and with how we had tuned our system. > As for restores, … doing a mysqldump and splicing out what you need when maybe a critical table of data needs to be … take us hours of time costing us hundreds of thousands of dollars potentially. The point being, I have to…
Comment: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
What does mysqldump have to do with creating indexes? It doesn’t create indexes at … mean when importing an export made by mysqldump? And is that different regardless of Also, how big was this table on disk…, they take 3 hours for a 57G .ibd file; after they’re done I’ll try this method. According to my calculations…
