…concurrency handling and other optimization. Should we take Innodb from MySQL 5.4 and merry it with unique Percona patches (…plugin 1.0.3 got some Google changes for CPU scalability but not IO patches. I expected Innodb to announce …excited. We will look into the changes and adopt the best to XtraDB.
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores… say anything about CPU efficiency. The RW-Lock patch is best in this case. It shows increased performance while decreased CPU…
Page: Consulting for MySQL
July 31, 2006 By
…, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server installation and configuration, working out Operations practices – MySQL Security, MySQL Upgrades, Backup… you with performance and scalability you’re looking for. Remote DBA Services for MySQL We act as your remote MySQL DBA – manage users…. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
… Cluster. Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5… talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New… table This is an General Availability release. We did our best to eliminate bugs and problems during alpha and beta testing…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
…- Limited write scaling. As Brian writes this works best for read intensive envinronments. Write scaling …really this is great solution which offers great MySQL Performance in many cases. It is good… Light write load This is needed to avoid scalability problems of single thread and resource waste….
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
… 160ms). Of course, I wanted to know more about how MySQL executes this query. So I used commands you’re probably… for the lock. Of course, the question was: why did MySQL need so many accesses to the query cache lock? The… queries. The best solution was simply to turn off the query cache. Conclusions: Once again, the query cache revealed bad scalability, but…
Post: All thouse new MySQL Storage Engines
April 17, 2008 By 8 Comments
MySQL Users Conference 2008 has number of Storage Engines presented which … makes it especially hard to get a product which performs best for ALL cases, and keep in mind performance is not… does a lot of primary key lookups and MySQL Cluster promises good performance and scalability. But if at the same time you…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
…which causes problems if you would like to use MySQL Slave as it can contain stale data. It … master for certain period of time. It is best to use this technique with assigning visitor to …read from the slaves, reducing master load and improving scalability by use of simple replication. If using this …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database, I believe different applications work best on…_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…id = %d In this case Falcon is the best, because Falcon uses a tricky technic to retrieve…comments in Part 2). There MyISAM shows bad scalability with increasing count of thread. I think …
