…) Reads though would not be blocked, ie there is no MYISAM like table lock priority problem with pending WRITE query blocks…’re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway… writes to the slave can be done by simply pausing replication.
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
… dirty and Alexey had series of sleepless nights digging into Innodb page and row structure. When few more companies followed, so… data using query log, corrupted binary log and dig into MyISAM tables. You would ask who would ever need such recovery… least replicated. Alexey also has a task to write more details about Innodb data recovery process and release code for our innodb recovery…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
…an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently …log enabled. (It needs to be enabled for replication.) There are workarounds, though. You can use …followed by LOAD DATA INFILE. You can use InnoDB instead. Or you can do something more …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_pages_writtenblogpercona.commanual innodb_purge_batch_sizeblogpercona.commanual innodb_purge_threadsblogpercona.commanual innodb_read_ahead_thresholdblogpercona.commanual innodb_read_io_threadsblogpercona.commanual innodb_replication_delayblogpercona.commanual innodb…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… keep into account possible query changes, replication etc. Q: Is it possible to move MyISAM to Innodb through plain ALTER TABLE statements? Yes… future MySQL versions also MyISAM tables are essentially at the state they were in MySQL 4.1 while Innodb storage engine got… storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… replication, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb… certifying that write. See virtually synchronous replication of the cluster explained here. Q: What about myisam storage? is it safe to use…? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is backed up…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… likely using the InnoDB storage engine, since MyISAM is not transactional and do not sync data to disk. Similarly, MySQL replication is an… MyISAM. The HA solutions that work well with MyISAM are “MySQL replication” and “Master-Master with MMM manager”. Depending on the application, the MyISAM…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool_size=32M innodb_data_home_dir=/home/mysqld/mdmp/data/ innodb_log…innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read… does this have to do with InnoDB? Data clustering. InnoDB‘s primary keys define the physical order…data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB but, depending on your… from “MyISAM-like” to more InnoDB-like. Originally PBXT was conceived as an engine that would be somewhere between MyISAM and InnoDB in both…, fortunately MySQL 5.1. supports row-based replication which makes it possible to do replication while using REPEATABLE READ. PBXT does use…
