… the high volume applications we assume scaling to larger amount of users, larger systems, larger database size and this is what I… hear “It does not scale” applied to the application on same system as load or database size increases as well as to…. Your application may be performing well and scaling to insane load and data size but If I can do the same with…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… The database is usually the most expensive and hardest-to-scale component in your system — don’t waste resources. Another benefit… rows. That will make the indexes less than half the size. In real life this technique often makes the table+index… of some of the tactics I’ve used to successfully scale large click-processing and other types of event-analysis databases…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… question what happens for blobs larger than 16K – is exact size allocated or also segment based allocation is used. Q18: Innodb… 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…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
… chunks of data. The recent improvements to MySQL make it scale better for this workload when more resources (such as additional… that is could better utilize all available resources (that is, scale better) when running small numbers of queries which examine a… {background-color:white;font-family:arial,sans,sans-serif;font-size:100.0%;font-weight:normal;font-style:normal;color:#000000…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… using ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I could get 1.2GB/sec (80K req… performance was poor with single thread it also did not scale well with increased concurrency even though we had 8 cores….5K queries/sec from MyISAM (double of Innodb already) which scaled to 70.000 queries/sec peaking out at 16 threads…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… tuples fetched, and N is the buffer size. In MySQL 5.6 the buffer size used by MRR can be controlled by… a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6 and… tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). I did not use Scale Factor of 40 (InnoDB dataset size ~95G), because…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | OFF | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE | 10 | 5 | | PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE | 10000 | 100 | | PERFORMANCE_SCHEMA_MAX_RWLOCK… 5.6 but you can see many options can be scaled down compared to MySQL 5.5 default values. Such as performance_schema auto scales to count up to 445 tables and 224 threads in…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… the applications because they are not even remotely close in size and so capacity requirements. Second if this “smart thing” was… typically – Web applications often have significantly prevailing reads so to scale we better have many slaves which we can use to… related to the MySQL redundancy for very high quality/high scale applications. I’ve seen applications having no downtime running for…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… sec) So MEMORY table scales pretty well with query execution time being close to linear dependence of table size, and it can… very good production practice, if your temporary tables are moderately sized). Unfortunately I ran into another bug which means I will… on Linux Performance of Disk MyISAM tables may not scale proportionally with table size, even when all data fits in memory MEMORY…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
I have written before – MyISAM Does Not Scale, or it does quite well – two main things stopping you … MySQL 4.1, and indeed previously it did not even scale with one CPU as global lock was held during IO… key_cache proportional to their size and load, but no more than the index size (assuming table sizes are relatively static) To get…
