… see, MySQL 5.5.8 comes with great improvements and scalability fixes. Adding up all the new features, you have a great… block size for logs files. Default is 512 bytes, in test with FusionIO I use 4096 bytes, to align IO with… having several buffer pool instances that are supposed to fix the buffer pool scalability issue. Let’s see how MySQL performance changes…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… affected or if you are you are capable of implementing fixes quickly, and what is most important your users will forgive… of scalability bugs in MySQL history when issues would only happen at high load. You can do this in test/stress test envinronment…. Adding the slave with new version for testing is also a safe way to test things out – you can move read traffic…
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… impact and are most applicable to all workloads first: CPU scalability fixes – XtraDB improves performance on systems with multi-cpus (see docs… backing up the .ibd file with Xtrabackup (see docs). IO scalability fixes – A lot of the internal algorithms of InnoDB are based…_size), which is worse for performance. Â In a simple test, XtraDB recovered ten times faster (see docs). InnoDB Plugin Features…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…size=128M prepare And when we can run the test: ./sysbench –test=fileio –max-time=60 –max-requests=1000000 –… ago though I hoped this issue is long fixed since that time… Though this box is running …threads was 2334.63 Requests/sec which is perfect scalability to 6 hard drive this array has. We …
Post: Percona Server 5.1.54-12.5
January 11, 2011 By 9 Comments
…” to system variable adaptive_checkpoint in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita) Added new value “ALL_O_DIRECT” to system…_method in Improved InnoDB I/O Scalability. (Yasufumi Kinoshita) Bugs Fixed Bug #689830 – The development environment tests of show_slave_status_nolock work…
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 my opinion… out. Q14: Are there any plans to fix Innodb so it unlocks (or never locks) … What are your suggestions here? HT: According to tests by Peter Zaitsev, O_DIRECT works well …
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…the process we work on generation test database of significant size as testing your application on table … with multiple value INSERTs etc. This can be fixed by increasing net_write_timeout variable on …on the same server which can limit your scalability. Using FEDERATED Tables can work for some cases…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… has as benefits as and drawbacks. We are going to test PBXT in write workload, though currently comparison with InnoDB will… commit and fully rely to OS. The developers promise to fix it soon. Falcon The Storage Engine which is developed in…. The developers promises ultimate speed and scalability for index access operations. It’s interesting to test it in real situations, because theoretical…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 27, 2011 By 11 Comments
… InnoDB results at high core counts there may be some scalability bottlenecks in Linux kernel affecting InnoDB scaling (there was a… paper about Linux scalability bottlenecks on 4CPU 48core AMD server; suggested fixes most likely weren’t in Oracle Linux used for WP tests).
Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 16, 2009 By 16 Comments
…dataset could/should decrease performance, however in my tests I went up to 6 million rows and…million set. The point about memcached not always fixing issues, is you need to understand your … do very similar PK lookups. In terms of scalability… There are many options here ( this article was…
