…in single tablespace mode showed following results: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql…Insert performance is close, the difference is perhaps explained by the fact files needed to be constantly extended (meta data updates) and reopened for…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…master, and each slave would “specialize” by serving read queries for only specific databases. In this …intended for cases where the query load is too high for a single database instance, and …write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split only read queries (…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…INSERT-only workloads, and their are other optimizations that can be applied to views that are based on only a single…for a simple query with aggregation, a JOIN, and a WHERE clause that uses an IN…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…query for…and if the many rows don’t match completely, the single one doesn’t know what data should live in it. And…for the database server. If you do it on the master with INSERT..SELECT queries, it will propagate to the slaves and…MySQL 5.1′s row-based replication, or in MySQL 5.0 and…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…MySQL bugs but corruption may happen and go for long unnoticed with MyISAM storage engine. This hidden corruption may later cause crashes wrong query…updated, and you might not know which ones. Concurrency. MyISAM uses table locks and has concurrent inserts…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…and 1/3 (33%) on the single one. In…insert in both nodes without any problem when the connection between the nodes is gone: percona1 mysql> insert into percona values (0,’percona1′,’jaime’); Query…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for…Query Cache also could use this feature. low_priority_updates If enabled selects will get higher priority than updates and waiting update…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…MySQL goes through more rows than it needs to requires look at the queries and…single query is executed for Innodb storage engine to be more specific. Lets look at update queries (from replication thread for example). When update…and possibly index pages you’re to modify) – even if you’re doing INSERT…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…and index definitions and related stuff, double write buffer, insert buffer which temporary stores records to be inserted in the index tree and…single transaction may modify single row and so be responsible for…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…and 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance sorting to the MySQL queries…for each keyword. Jessy B. asked: Q: With respect to Solr and Sphinx, do indexes stay up to date with changes (inserts, updates and… index isn’t in sync, …on a single machine and a common…
