… plans to enable tuning of the checkpointing rate? Postgres exposes this data and allows the user …’ (lots of threads waiting for semaphores in SHOW INNODB STATUS), you can try to disable thread throttling …example, if ORDER and ORDERLINE tables are joined to form a single table), it might make sense …
Percona's MySQL & InnoDB performance and scalability blog
Percona Webinars
- June 26, 2013 - Percona XtraDB Cluster Operations
- July 17, 2013 - 5 Proactive Measures to Minimize MySQL Downtime
- July 24, 2013 - Advanced MySQL Query Tuning
- July 31, 2013 - Percona Server 5.6: Enterprise Grade MySQL
Percona MySQL Training
- Moving to MySQL 5.6 - Utrecht, Netherlands on Monday, 01 July 2013
- London, United Kingdom on Monday, 15 July 2013
- Moving to MySQL 5.6 - Orlando, FL on Monday, 15 July 2013
- Moving to MySQL 5.6 - Salt Lake City, UT on Thursday, 18 July 2013
- Boston, Massachusetts, USA on Monday, 22 July 2013
Percona Careers
- Administrative Aide [Uruguay]
- Consultant: Linux and Web System Administration
- Director of Open Source Development
- Perl Programmer [Americas timezone]
- MySQL Instructor [Any Location - US]
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.