… the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them… you put too heavy of concurrent load on it the response times will increase and user experience will suffer. So what you can do… and find out doing work from 32 processes is faster than just having one process. This is true if you have system…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
… show what you‘ve said and I do agree that turning off session binlog is the right strategy to go with. But can you… in verbatim on our master / slave pairs? To reiterate, are you suggesting that the actual data would be transferred across the… INFILE command is executed on master? (cuz that’s not what I’m seeing on our systems, with binlog left on…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
This benchmark doesn’t test the IO performance of EBS though as you‘re not flushing to disks on each commit. What numbers do you get when you set innodb_flush_log_at_trx_commit to 1?
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
Benoit, Thank you for sharing. What software do you use to show benchmark results? XFS may have fixed bugs and have performance improvements, but again, I need to have it my kernel to able to test it.
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… correctly to do so ? I saw the article with the concatenate path of each entry but the order is not what I need to put it in html. With the tree traversal, it is easy to do so because you‘re “walking the path”. I’m using MySQL, PHP or Coldfusion (I have to do it in…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… defeat the purpose of the tool. Q: When you say bail out, what does that mean? Does the tool clean up (i.e., remove table / triggers?) About cleanup.. What about manual aborting a run. will that cleanup ? Q: dose… has been that this is a very dangerous thing to do and causes way too many bugs in the server and…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… informative. One question: when you configure MySQL, what portion of it resides on the Fusion-IO card? Do you just have your datadir on…’m new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2…
Comment: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
… 2 Milion registers , so , what i can do , to get randomic result from this table, with best perfomance?!!? Do you want to post about…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… when I need more “power”. Not sure what the MySQLDB performance cracks like Baron recommend you to be on the safe / perfect… to extend at a later time with no trouble if you are not going to choose 64M or more (but e… NOT seem to work if you are going to delete the log files later (or even do not move them). The end…
Comment: Testing Fusion-io ioDrive
May 4, 2012 By 1 Comment
Vadim, Do you have response time distribution for writes ? Also what Model/size of ioDrive is this ?
