… size. On my system I set to 128M, which does not 100% accurately reflect log file size x 4 … to 256M when I need more “power”. Not sure what the MySQLDB performance cracks like Baron recommend you to … later (or even do not move them). The end result was: I could only use mysqldump to import all the …
Comment: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
What does mysqldump have to do with creating indexes? It doesn’t create indexes at all….do you mean when importing an export made by mysqldump? And is that different regardless of Also, how big was this table on disk? I’m in the middle of doing…
Post: Living with backups
November 6, 2008 By 28 Comments
… contrary, it’s more like doing very heavy queries against each table in the database when mysqldump is used or reading a…. What does it all mean? There is a clear conflict between the regular database activities, which need fast response times, and doing backups… the incoming queries quick enough. What can be done about it? Nothing really when you are using mysqldump. You can play some…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… authors have moved on and nobody is exactly sure what application does or does not do with the database. Database is production critical with… 5.1 As the database size is relatively small we do mysqldump and load which is a safest way, considering we’re… replication was running properly but does data match ? (This also would cover data improperly loaded with mysqldump if there is such). We…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…What does it give to us? It allows to see: What is the response time we may expect having a given arrival rate What… improve the response time ? – Do we need to …Does DROP TABLE, running in separate session, affect a response time of queries that handle user load ? The same for mysqldump, how does…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…a failed and crash with assertion failure. So what can you do to recover such a table ? There are …more later. Another alternative is to dump table with MySQLDump and load it back. It is all pretty much…some buffering taking place and as MySQL crashes it does not store all data it could recover to …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…does not fit in the buffer pool. We’re running uniform sysbench OLTP on the small table and mysqldump… when heavy mysqldump is running concurrently. mysqldump itself also slows down about 2x. What is going … “young” sublist. However when you’re doing mysqldump (or running some complex batch job query…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…column and see what execution time … | test.t | optimize | note | Table does not support optimize, doing recreate + analyze instead | | …mysqldump in Percona Server supports the new option –innodb-optimize-keys which does…
Post: Predicting how long data load would take
May 24, 2007 By 12 Comments
… Innodb tables for optimal performance, but effect does not end here. If indexes are built …use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE (–tab mysqldump output). Generally LOAD DATA … on what other cases were “similar” As the data load goes I usually tend to do something…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… stopper for them move until it is worked around. Operations What is good for MyISAM kills Innodb, such as copying binary… tools like “mysqlhotcopy” does not work etc. Note Performance also affects Operations aspects a lot – for example using mysqldump as a backup… start taking way too much time to do restore for Innodb. On large scale installations mysqldump does not work anyway but it may…
