…= 2 innodb_read_io_threads = 16 innodb_write_io_threads = 16 innodb_purge_threads=1 innodb_adaptive_flushing=… in article [1], we will try to limit the percentage of dirty pages and increase … throughput is about 1.33x better than in “MySQL compatible mode”, though it requires 10500MB for checkpoint…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… for your threads. Each thread connecting to MySQL server will needs its own buffers. About 256K is allocated at once even if thread is…. For 32bit envinronment you also should keep 32bit limits into account and probably limit “mysqld” size to about 2.5GB (exact number…: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once for each thread. Consider for example subqueries…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… different replication formats. These are covered pretty well in the MySQL manual here. Put simply, the events can be one of… thread is unable to read fast enough because reads are single threaded. Yes, you got that right – it is reads that are limiting… and this is where it is limited by the single-threaded nature of the replication, because one thread will only ever read from…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… should expect from the system. What I usually look for MySQL is performance in random reads and random writes. Sequential reads…. Using synchronous I/O mode Doing random read test Threads started! Time limit exceeded, exiting… Done. Operations performed: 773835 Read, 0 Write… case there is little difference if we use one thread or multiple threads. As you also can see BBU is helpful even…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… INSERT threads) thread thrashing could be still observed even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number of threads…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… are rather limited but I thought I should try throwing more threads and work at the server until it hit its limit and… started to hit bottlenecks in MySQL/Innodb when I had enough memory but I increased the threads from 64 to 128.Â… 32 Threads, Tyrant was started with 8 threads and 128M of memory, memached was started with 16 threads ( 1.4 memcached ), mysql was…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… engine (also known as HEAP) in MySQL has been one of the long-standing limitations caused by the fact that variable-length… to remove this limitation. In 2008 Igor Chernyshev of eBay implemented true-VARCHAR support for MEMORY tables for MySQL 5.0. Although… seconds: 25949631 (0.05% slower). VmPeak: 6267700 kB Two client threads: FRF: Insertions in 900 seconds: 42946880. VmPeak: 10069040 kB DRF…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… Percona Server or newer MySQL version or doing application/architecture changes. Reducing number of competing threads (such as limiting number of Apache Children) as well as adjusting innodb_thread_concurrency and doing other server…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
…. Using synchronous I/O mode Doing random write test Threads started! Time limit exceeded, exiting… Done. Operations performed: 0 Read, 1343 Write…. Using synchronous I/O mode Doing random write test Threads started! Time limit exceeded, exiting… Done. Operations performed: 0 Read, 33900 Write…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… write up about using MySQL replication. The piece I find missing however is good description of warning about limits of this approach… resources for replication (forget for the second replication being single thread, which just makes things worse), which means only 10% will… load This is needed to avoid scalability problems of single thread and resource waste. I would call load light if it…
