… triggers. It is designed to be resumable, although we don’t yet have a “resume” feature implemented. Q: periodically the ALTER… sure this is really happening? I would be extremely surprised for such a bug to be happening. In reply to the second question…: Old version of PT OSC said risk in replication environment, I didn’t see that in the new version, does it mean the tool…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
Thanks for the suggestion. I don’t see anything suspicious in the /var/log/mysqld.log file which i believe is the error log you… writes the file full: wait… InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… are still 5mb. I don’t get what i‘m doing wrong. I‘ve posted this in a few other forums (i think that’s frowned up) but will update with any resolution. I can’t figure out what i‘m overlooking. this seems dead simple. thanks for any help. chris
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
Peter, As I mention, I can’t provide response time graph for async IO, sysbench can’t measure time for each IO in async mode.
Comment: ext4 vs xfs on SSD
April 25, 2012 By 23 Comments
…, thank you for a disagreement, I do not often see discussion in comments, but this is what makes it interesting. I am in open source business myself, so I understand your sentiments, however I can’t agree with your logic. For me it sounds… solved for developers and for ops. For developer – push in source code tree – problem solved. For ops – it should be available on official distribution, in repository…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
Hi Miguel ， I‘ve tried your example “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are…@localhost:test 14:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0.00 sec) root@localhost:test 14… 484616 localhost root update insert into t values(33) ——- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK TO BE GRANTED: RECORD…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…cost of index maintenance. This experiment isn’t measuring the cost of index maintenance. …in the primary table, and so a billion rows is about 30GB. Since we are inserting on an auto-increment key, I…challenge. The URL for iibench is slightly incorrect. The correct URL for version you used is…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
…, but i did not understand where did all of the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or we just don’t need to define it for the cluster. I am new in this field…
Comment: Testing STEC SSD MACH16 200GB SLC
April 26, 2012 By 7 Comments
… observed in the write benchmark? I assume in the worst case, the stall could long for about 4 seconds (40% drop in throughtput, measured in 10 sec intervals). 4 second stall would be quite nasty for any busy MySQL instance. BTW, the graph doesn’t…
Comment: Review of Virident FlashMAX MLC cards
April 24, 2012 By 14 Comments
I‘ve used RAID-0 on the Fusion-IO cards including … drives is written and the other one isn’t written for any operation this results in a corrupt volume. Therefore, even with the…
