…innodb primary keys on the MV. mysql…performance…parameter reflects the refresh type. This parameter can take the options: ‘BOTH’,'COMPUTE’,'APPLY’, or ‘COMPLETE’. I specified ‘BOTH’ for the second parameter…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Page: Presentations
May 3, 2006 By
…delivering high performance for large databases. We look at performance properties of MySQL …MySQL/Innodb Performance Optimization OSCON 2004, Portland, OR Performance optimization in numbers. Presentation shows how changing various MySQL Server OS and Hardware parameters affect MySQL Performance…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…performance, future performance, scalability, ability to recover from disasters? We also want to know what the operating parameters…s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in …are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…was the reason for the high write performance of earlier versions. …supports the MySQL Backup API which was originally implemented in MySQL 6.0….parameters for installations that need to extract maximum performance from the hardware. This work is ongoing. Morgan notes: There are more in InnoDB…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
InnoDB has an oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood. From the docs: “The number of threads that can enter InnoDB…innodb_concurrency_tickets too high can have startlingly negative performance…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…Innodb performance counters, statistics, information about transaction processing and all kinds of other things. In MySQL 5 number of Innodb performance… you’re running in high concurrency envinronment, so Innodb has to fall … as computed averages. This is parameters which is great for graphing and …
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
…performance is not good. MySQL is scanning the entire table to produce the result: mysql…innodb; Query OK, 0 rows affected (0.10 sec) Notice that MySQL… parameters into the params table using the REPLACE statement: mysql> replace … convenience sometimes comes with high cost though, particularly when …
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…performance bottleneck. This is exactly the case with LVM Number of customers have reported the LVM gives very high…IO performance in this case – it is not something MySQL… did is emulating how Innodb would do buffer pool … some LVM performance tests yourself or will be repeating mine (parameters …
Post: Friday challenge: ibd recovery
May 15, 2009 By 8 Comments
… CREATE TABLE `tryme` ( `email` mediumblob, `content` mediumblob ) ENGINE=InnoDB … (SOME PARAMETERS SKIPPED) …; and I inserted one record into this table …(meaningful English sentence) to given email – will receive our book “High Performance MySQL” 2nd edition, or if he has already this book …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…parameters > and will perform needed checks and query rewriting. You also can > use pretty much direct path to mysqli extension to performance… InnoDB table can have very serious and negative performance … Things are different with MySQL. Good design will… has very high cardinality (as high as the …
