Aaron, No particular reasons, it doesn‘t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
…/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
I have innodb tables in my production database and i have set files_…(free space) after this I executed alter table abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND… not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… (HY000): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:38:03>insert into t values(23); ERROR 1205 (HY000): Lock wait timeout exceeded; try…came out my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…: Isn’t it possible to take all the locks required in the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that… ? Q: dose the tool exit gracefully while interupted? The tool doesn‘t clean up the temporary table or triggers. It is designed…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn‘t work, because since mysql 5.5 the statement “CHANGE MASTER TO… fail. Yesterday, I fix this up very dirty and it works.
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
… trouble getting the monitores working – i created the different tables for the innodb (Standard, Lock,Tablespace,Table) and the server doesn‘t report the data as described every 15 seconds instead it doesn‘t create any…
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?
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… script with multiple level of concurrency and find out doing work from 32 processes is faster than just having one process…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… ext4 worked really well out of the box, while XFS required poorly documented knobs to be turned and still couldn’t beat… all our MySQL DBs with ext4, and it’s been working great for the past 7 months. I recently had an… to indicate that XFS had some bottleneck internally, maybe the lock contention issue that Dave was referring to above. Disclaimer: I…
