… 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… best to eliminate bugs and problems during alpha and beta testing release, but this is a software, so bugs are expected…
Post: MySQL/Innodb scalability tests after fix
January 3, 2007 By 1 Comment
… something obvious in MySQL settings as well as to let them know the fix is now out for Innodb scalability bug and they can rerun the test to see if there are any difference. Recently Tweakers.net published comparison of MySQL… and will be different in other benchmarks) we can see MySQL scalability problem with high number of CPUs and high concurrency is…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only workloads. Workloads which got… that well. This is why it is important to test performance and scalability for your application on your hardware if you really… 12 physical cores and 24 threads, which is almost perfect scalability. So there are workloads where the problem is solved and…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted to look at… multi versioning system ? Test 3: Phantom rows: before test: mysql> select * from test2; +—-+———–+ | id | names | +—-+———–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM | +—-+———–+ Session1: mysql> begin; Query…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… testing to ensure both MySQL does not crash under your load as well s it scales well. There have been number of scalability bugs in MySQL history when issues would only happen at high load. You can do this in test/stress test envinronment…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… model baron has published for example is good for measuring scalability of the system as concurrency growths. In many cases however… which include both latching as well as inevitable application specific scalability restrictions, such as row level locks. There is also a… and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle test system). So 347 and…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
…MySQL history you may think Key Cache scalability was fixed with new Key Cache in MySQL… +——————————————————————————————-+ | CACHE INDEX test.a IN test_a; | | CACHE INDEX test.b IN test_b; | …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… least MySQL 5.1 with row level replication readily available. Speaking about community items the following were most interesting: Further Scalability improvements… we should test them and make binaries with them available. With current MySQL 5.0 I still see Innodb having serious scalability problems… so it is still important. IO Scalability patches Mark Callaghan from Google released so many MySQL patches so we can call patched…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… CPU bound benchmark with working set fitting in memory. MySQL and PostrgreSQL Scalability on Xeon Woodcrest, Opteron and Niagra Pretty interesting to… fix for this scalability problem and it is merged into MySQL 5.0.30 “Enterprise” but according to the tests I’ve done… this test (and in many other MySQL tests), Opteron comes second and older Intel Xeons as well as Niagra being outsiders. Niagra scalability is…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…. The modeling I performed is Universal Scalability Law modeling, which can predict both software and hardware scalability, depending on how it is used. In brief, the benchmarks are sysbench’s read-only and read-write tests, and… of taking 12 cores away from MySQL and giving them to sysbench. That way we could test with 48 cores and see…
