…how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY…you need enough concurrency to utilize multiple hard drives and with 50 drives…can make. One application can become CPU bound even with 5% of …optimize swap performance. I also fully support Matt in his views of black …
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
… fact MySQL Replication is single threaded so in reality it is only able to use only single CPU… is other possible solution it is to allow multiple threads inside the server to share same transactional… to come quite soon. On other hand if support for Multi-Master is implemented for many applications…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… home test box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0… other benefits of Memcache – distributed caching, support of time to live (so you …multiple query results) MySQL Query Cache may improve performance of your application. Multiple layers of caching may do well Same as CPUs have multiple…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…assess current state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: The scalability in my… it that if you disable the new XA support (which we don’t use) then you’ll… is CPU bound and you’re scaling out you can get better performance by using couple of MySQL…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…too is the output of a SQL statement. MySQL even includes a SQL statement that makes … CPU and memory usage may be reduced compared to computing the results. You can often generate multiple …work. And some drawbacks: Not all SQL syntax supported (no outer join), no non-deterministic functions, etc…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…greater than the join_buffer_size, then multiple hash tables would be created. For …CPU configuration: 2xIntel(R) Core(TM)2 CPU 6600 @ 2.40GHz. The amount of memory installed is 8G and the MySQL…support the possibility of existence of different join algorithms. So what does that mean to MariaDB/MySQL…
