…MySQL installations or managed hosting provider. For large MySQL web MySQL…to other database systems. MySQL has to do more than one fsync() for the log because it internally implements XA to…build…
Page: Consulting for MySQL
July 31, 2006 By
…to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to…
Page: Presentations
May 3, 2006 By
…contact us if you’d like us to present at yours! We can also …in database focusing on delivering high performance for large databases. We look at performance properties of MySQL build …. Presentation shows how changing various MySQL Server OS and Hardware parameters affect MySQL Performance in DBT2…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…database more than just prefix compression. The downside in gzip is increased usage of CPU time. PZ: We will see how…to set this value to a LARGE value (somewhat like 200) for additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… STATUS output and how to use this info to improve MySQL Performance. To start with … output will not grow too large. Transaction id is current transaction identifier …is hash index Innodb builds for some pages to speed up row lookup … in this case database pages will not be equal to total size of…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…large innodb_log_file_size to perform load effectively Load Options There two main ways to load data in MySQL… and enabling them back – helpful to make sure MyISAM build indexes via sorting not by BTREE … to do something like “du -sh; sleep 3600; du -sh” in the database data directory to see how …
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…how it is happening and how to prevent it. Cache Wiping This is first reason for this to happen – query which crunches large…MySQL Itself employs various strategies to attempt to…database location and in this case single query really can keep it always busy. As drive gets busy requests have to wait to…
Post: Living with backups
November 6, 2008 By 28 Comments
…MySQL, but also such large I/O requests take significant time to…database server it may turn out that running a simple copy operation from MySQL…to do that with –bwlimit=KBPS option. The problem with rsync is that it needs to build a list of files to… ionice. It allows to affect how I/O scheduler will…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…to implement. Might not work with transactions – Different transactions may see different states of the database…large value of Qcache_free_blocks relatively to…MySQL to add caching but you can enable query cache so it works faster. Low load applications – If you’re building…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
…how you are using MySQL. MySQL often recommends (if possible) doing an upgrade by doing a MySQL dump of the databases…to do the dump you need to downgrade again to 5.0…. If the table is large you are back to… have already been upgraded. To avoid this it’s often best to build a new master (originally…
