…together to produce better talk instead. Hidden Innodb Tuning Options Innodb Storage Engine has a lot of tuning options hardcoded as constants. We … MySQL – Innodb, Falcon, SolidDB, PBXT and analyzing how things have changed since last summer. Using Slave Server Without Breaking User Experience MySQL…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… well as it exercises not so common paths in the MySQL server – in particular Optimizer may have harder time because costs… Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really. MyISAM for…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… to note fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements… time while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its … not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server …. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5… innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…
Page: Consulting for MySQL
July 31, 2006 By
…application workload. Innodb Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb performance … Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help you …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE… guess is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON by default…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users. I found… mention Innodb is being blamed for a lot of “Gotches” while many of them come from MySQL limits at the time when Innodb… properly before really enabling it. Innodb IO Tuning I should also mention Paul Tuckfield Keynote about Scaling Innodb at YouTube. There were many…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… workings of one of the nicest features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we… KEY (`id`), KEY `role_id_note` (`role_id`,`note`) ) ENGINE=InnoDB AUTO_INCREMENT=22187769 DEFAULT CHARSET=utf8; The table had 22… query faster, which means you need more manual care and tuning now. MySQL is conservative about “Using index” -in most cases it…
