… scores 778.14 JOPS on 12 cores. This seems to show….0.27 which has Innodb scalability issues, which were …can well be used as MySQL alternative. However such general transactional application (general so it can work… features – non transactional MyISAM, Multi Value inserts, Query Cache, Merge …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…Can you afford to lose data? Obviously, if you are concerned about loss of data, you are most likely using the InnoDB…work well with MyISAM are “MySQL replication” and “Master-Master with MMM manager”. Depending on…on the slave can handle the write operations. If the replication master is multi-cores …
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…62744142, 62744144, 62744146) With secondary key defined on (group_id,deleted) This …work need to be done and where you still can’t get use of more than 8 cores…read_range_first,handler::read_multi_range_next,QUICK_RANGE_SELECT::…worse in this workload and innodb_adaptive_hash_index_partitions=16…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…and CPU cores. The replication replay process executes in a single thread on the…read traffic, so a single primary can delegate the read workload across several… work in all cases; the most common cases will require use of InnoDB…currently does, and only enable the multi-threaded behavior if the user …
Post: 3 ways MySQL uses indexes
September 12, 2009 By 28 Comments
… common problem I see is multi column indexes which are used…sorting things like this would work A=5 ORDER BY B …on. There are some workarounds you can use though. Using index to read data Some storage engines (MyISAM and Innodb included) can…These are the main “core” use for indexes. You can also see …
