… nothing stops you from running many Redis instance on single server to get advantage of multiple cores. I call Redis semi-persistent because…/sec. This was using about 5 cores so you could probably get 4 MySQL instances on this server and get up to….000 updates/sec with about 1.5 core being used. I have not tried running multiple instances and I’m not sure the…
Comment: Scaling to 256-way the Sun way
November 12, 2008 By 13 Comments
… as multiple boxes, however I think for medium-large scale applications this happens because we have to because of limited single instance… to see some relatively small number of instances running. For example running 2 instances on 16 core box, not 16. Now about performance… is highly application specific. Some people are able to saturate multiple cores with 2GB worth of data some would have much more…
Comment: MySQL Performance on Memory Appliance
June 19, 2008 By 23 Comments
… have an HP DL380 with 20GB RAM, dual socket, quad core 3.0GHz Xeons attached via a single interface card to… Violin. Our database(s) total roughly 350GB and we have multiple application servers hitting it to produce a virtually infinite database…) activities. We are running multiple MySQL instances, so it is difficult to get the oprofile running for all instances, but I may do…
Post: Beware of MyISAM Key Cache mutex contention
August 12, 2008 By 10 Comments
…. Hundreds of millions rows are loaded daily into single MySQL instance with bursts up to 100K of records/sec which need… using multiple thread to do inserts in multiple tables would not be bound by table locks and would be able to use multiple cores… the thread local space. Happily MyISAM allows you to create multiple key caches . We use “keycache per table” this case and…
Post: Cache Miss Storm
September 10, 2010 By 30 Comments
… and close to zero IO) would spike to have hundreds instances of threads running at the same time, causing intense utilization… is just one execution unit). Because we normally have multiple cores and multiple drives it can be less than that but it is…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… almost 10 years, with very little changes done to the core of original implementation which appeared in MySQL 4.0 Query… 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query hash. It would help to… well with queries containing dynamic comments as well as simply multiple instances by the same query typed in by different developers. Supporting…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…available on 64 bit instances. MySQL will fail to start on a micro instance, simply decrease the values… possible to distribute splitting and/or loading among multiple nodes as well. Note that in the …_workers 80 I normally start (2 * TOTAL_CLUSTER_CORES) workers. That is, if you have 20 machines…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… current state of Innodb scalability with multiple threads and multiple concurrent transactions ? HT: The scalability in…in the system tablespace when an InnoDB instance is created. PZ: Sequential “dump” of buffer…here? INNODB was originally written on single core CPUs. HT: Users have reported lots of…
Comment: Scaling to 256-way the Sun way
November 12, 2008 By 13 Comments
… to 24 instances on Linux server because there is really little need for that. Single instance perfectly works with several cores and there are no x86 systems with same amount of cores as there are threads in Sun systems.” Are you saying that scale-out to multiple instances is not important…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores with 3.25 EC2 Compute Units each) 1690 GB of instance storage 64-bit platform I… to reduce the size of the B+tree, having multiple buffer pool instances to reduce contention problems caused by buffer pool mutexes…
