…-machine approach, but for the optimal production deployment you want two …MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables…on to prevent a problem before it occurs. For example, if you see a large number of long-running queries…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… focus will be on the following tools: pt-query-digest, to select the queries you should try to improve to get optimal response times…-schema-change, to run ALTER TABLE statements on large tables without downtime You can reserve your spot for this free MySQL webinar now. If you…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…largely backward-compatible with 2.1, but some tools were changed significantly (e.g. pt-query…table… queries on…query-digest is simpler pt-query-digest 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query…optimal JSON structure. Version check is on…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… have received a large number of questions on why the benchmark …on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…MySQL optimizer…large tables, which is completely disk bound can be very slow. One of the reasons elevating this problem in MySQL…large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by one for query…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…, which can be important for large, heavily written tables. Q: in trick #1 will “WHERE… I also would note there are some MySQL optimizer restrictions in how well it can …query you’re mentioning allowing group by to be performed without temporary table or external sort. Q: How can we manage indexes on…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…table that is already in the Table Cache, any query to a table that has a DDL operation waiting, will block. Why? Because MySQL…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
…large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer…optimizer pluggable and make it possible to stick to old optimizer behavior with new MySQL Version. Make Cost Model Adjustable MySQL Optimizer looks at query…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… impact of MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which… of them would try to optimize throughput before latency, meaning if you have query which is doing full table scan (sequential reads) its…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…MySQL as MySQL optimizer with its nested loops joins does not favor sequential scans even for analytic queries executions. Also lack of parallel query… with multiple MySQL instances on powerful storage…large table and data sizes in MySQL can be painful, lacking online operations to alter table…
