… from this spherical read-only cow and throw some data updates into the mix, limitations of read-only transactions become obvious. In… innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
…_TABLES\t’ (`NAME`, `ID`, `N_COLS`, `TYPE`, `MIX_ID`, `MIX_LEN`, `CLUSTER_NAME`, `SPACE`); SYS_TABLES “sakila/…_id. In revision 69 of Percona Data Recovery Tool for InnoDB two tools are added: s… disk. InnoDB pages are modified in memory first and only after some time InnoDB writes them permanently …
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…size (especially if data size is close to memory size), generally slower writes, slower blob handling, …consider them. How about Mixing Storage Engines ? Sure you can mix storage engines but I suggest… as 10-50 times for Innodb tables in particular for write intensive workloads. Check here for details…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… affect how InnoDB works internally? Let me show some details. Internally, InnoDB uses two lists for flushing (writing pages from the Innodb buffer pool… when InnoDB tries to read data from disk, but there are no free pages. In this case, InnoDB has to flush some data to… and observe intensive writes, InnoDB is using LRU list flushing. So why is it important to know what the mix of InnoDB flushing types…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
…servers not only the fact you can’t well mix SELECTs and UPDATEs but also the fact only … Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is …of contention on the writes. In this case you can just rebuild the table from Innodb source on regular basics…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…data propagation latency. It was interesting to see whenever I can get stale data reads from other cluster nodes after write… are actually better than if we put mixed load as we can observe any delay…_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…, table_name, page_type, count(*) from information_schema.innodb_buffer_pool_content group by 1, 2, 3 … fill the buffer pool with the most recent data; a mixed workload will usually have some different hot … the buffer pool that gets skewed with a write-only workload! The insert buffer can also cause …
Post: Percona Server with XtraDB Case Study, Behind the Scenes
October 21, 2010 By 13 Comments
… their previous version. I thought I’d write a few notes that didn’t seem … sporadically and/or mixed together. You really need to be disciplined and collect data, data, data. If you … different things. Sometimes GDB stack traces showed InnoDB mutex contention, sometimes oprofile showed the query …
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… writes and the standard hard drives are excellent at sequential writes which is what most of the writes to the log files are. innodb_log_group_home_dir=/var/lib/mysqlnonssd/ innodb_log… this on a 43.4GB data set constituting 161,000,000 data rows (details of the table mix was stated above) Obiously this…
