… 1 second. Scalability – In the high volume applications we assume scaling to larger amount of users, larger systems, larger database size… I will be speaking about. There is also aspects of scaling down for embeddable systems but it is whole other story… performance on the same system, getting larger box “scaling up” or using multiple systems “scaling out”. Scalability is really funny term because it…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
… you need to squeeze out, and also how your scaling is set up. For smaller systems lets say running couple of MySQL… however implies two things – first you can scale system by adding more servers, because scaling up and purchasing more and more powerful servers will not tall you far, especially as MySQL Server may have trouble scaling itself…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… some benchmarks we did. Q24: INNODB has typically had problems scaling on multicore boxes. The new quad core CPUs from AMD… better. We will continue the scaling improvements. Latest patches of Yasufumi Kinoshita attained very nice scaling up to 8 or 16 cores. These…. PZ: If your load is CPU bound and you’re scaling out you can get better performance by using couple of…
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… changes or query changes instead of a tool to gage scaling limitations of server x. (Kinda a once off exercise vs… at a scale of Facebook or Twitter, and given we’re pretty cashed up its really easy for us to scale up and not… type of information for people that are not at the scale of Facebook and/or have a sharded datastore. A possible…
Comment: Another ingenious piece of Sun Marketing
March 24, 2009 By 20 Comments
…, for the single system tests the results show linear scale-down (rather than scale-up) for throughput. The test determines the max per… concurrency. The same technique can be used to show linear scale-up for just about any server software. Second, it shows great…/init.d/mysql start’ separately for each instance doesn’t scale when there are tens or hundreds of instances on a…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 1, 2006 By 20 Comments
… wrong person to ask the question 
I can confirm Innodb scaling issue was known for years. In fact you can even… up itself as the problem is in mutex competition which is low when IO is happening. Third – MySQL is all about “Scale Out” and it is true Innodb simply was not good about scaling UP. The bottom line is – despite…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…, but for MyISAM xtrabackup is blocking, since it is backed up by the wrapper script called innobackupex, and not xtrabackup itself… would not recommend using MyISAM. Q: How does write performance scale with an increasing number of nodes? A: Since all the nodes has to do all the writes, you can’t scale writes infinitely by adding nodes. I would expect that writing…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got a lot of attention, there can be other quite typical workloads however which do not scale that well. This is why it is important to test… improvements for this workload in Percona Server 5.5 showing up to 2.5 times better performance or 150%, which is…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… a scale-out solution has traditionally been popular for MySQL, it’s interesting to see what room we now have to scale up… storage device for writes. Here’s the benchmark I came up with to confirm if this is the case: Percona-XtraDB…
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
… can come with InnoDB now can scale up to 16 threads pretty well InnoDB can keep load up to 128 threads, and for… in 16 threads If you interested what is issue in scaling over 16 threads, that in current benchmarks – this is concurrency…
