… MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you… for MySQL now shows error when it’s unable to connect to the MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using identical code… ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… clients was a MySQL connection pool handling system for the application level via a lightweight python app (using multi threading and internal… NDB and 5.5.x clusters with not just simple queries or simple transactions but high concurrency with complex transactions as… aim to show just how far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query…). Dealing with this problem, quite simply, is the tradeoff to multi-node writing in a synchronous replication system with optimistic locking…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
…, though I’ve heard that talk from Seppo (Codership) before. MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov… a hard problem to solve. State of the Art for MySQL Multi-Master Replication - (Robert Hodges, Continuent) – Robert is the master in… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I…
Post: What would make MySQL Multiple Queries Usable ?
September 5, 2007 By 1 Comment
… would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning all queries at once is of course you can run them in parallel. Asynchrnous submission API would be even better but even multi query… in MySQL any time soon – this would require very significant optimizer and execution engine changes to optimize for set of queries and…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… load in the application by aggregating query log with mk-query-digest. When I filtered out only queries of this pattern and got…_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra nge_first,handler::read_multi_range_next,QUICK…,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read _multi_range_next,QUICK_RANGE_SELECT…
Post: Percona XtraDB Cluster Feature 2: Multi-Master replication
January 19, 2012 By 22 Comments
… out-of-sync situation, as it regularly happens with regular MySQL replication if you imprudently write to the wrong server. This… transaction will not check on possible locking conflicts during individual queries, but rather on the COMMIT stage. And you may get… after “COMMIT” query, but I saw many applications that do not do that. So, if you plan to use Multi-Master capabilities…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… of the splitter. It is multi-threaded(actually multi-process) and is able to … from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_…output from the ./run_query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
