…MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used…4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0… an obvious choice. But for those applications that are write mostly or that…
Post: Percona XtraDB Cluster 5.5.20 - Beta release
February 23, 2012 By 10 Comments
…released Galera 2.0 GA The main focus in this release: Incremental State Transfer, especially useful for …with databases created in MySQL / Percona Server Application compatibility. There is no or minimal application changes required to start…y’;fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…VALUES(31); Query OK, 1 row affected (0.00 sec) After running the delete…LOCKS space id 19 page no 4 n bits 80 index `age` of ….mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE…consistent Statement based replication. If your application can deal with phantom reads and…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… obvious and easy to use. How to fix the problem ? Assuming getting back to MySQL 4.1 is not … problem is of course to work on the application – in large amount of cases the problem happens … stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… done to the core of original implementation which appeared in MySQL 4.0 Query Cache was designed to work with single core systems… with MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL… large set of applications. Many applications in MySQL have very large number of queries doing updates through primary key and use primary key for…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… MySQL 4.0 But now get back to the question of using MySQL. I’m obviously biased and focused more on Web applications rather than Enterprise applications… successful MySQL users would use few new technologies besides Stock MySQL 4.0 toolset. For example Google still has a lot of stuff on MySQL 4.0… looking…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…use this approach if you’re using some widely used application…use MySQL Replication for upgrade. Once you have setup slave with new version and made it to caught up you can use…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… include both latching as well as inevitable application specific scalability restrictions, such as row level …. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, …0 1 0.94 0.99 0.24 0.99 # Rows examine 4 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows affecte 0 0 0 0 0 0 0 0…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… serious bugs are. Large Team, Tricky Code During MySQL 3.23 and MySQL 4.0 team the small tight knit team was working on… of them use 5.1 vs row level replication or events. I think less than 5% are using both features. MySQL 4.1 was… run MySQL in production. MySQL as it is now works for a lot of applications, in particular because most of them use only small…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… conceptually similar to using mysql binary logs for…| 6543 | 754138 | 3740 | | 3 | 5337 | 742034 | 3674 | | 4 | 5825 | 738420 | 3593 | | 5 | 5803 | 733495 | … | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql> select sum(total_lines) …times in your application by…
