… multiple CPU cores can be used for encryption (with the –encrypt-threads option). You can also combine compression and encryption, each using multiple CPU…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… new cluster especially if you are planning to write on multiple nodes. Have PRIMARY KEYS If you still have tables without…, other factors affecting async replication like if your workload is CPU or IO bound. Peter wrote some good details about it…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… many CPU cores. Happily there is solution, or at least half of it. If you have chosen a way of using Multiple Tables to solve Table Locks problem you can also use multiple Key Caches to reduce or… set (0.00 sec) So going through complex or not multiple key cache creation exercise you probably wonder how much performance…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… me IO is IO bound workload – disks are moving and CPU sits idle. With such terminology there is instantly much smaller… point of the article. In original article I mentioned having multiple hard drives does not help if you have single query… operations issued by the thread and so can result in multiple outstanding requests to the disk. Though this does not help…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…’ll see where this leads us but I believe on multiple CPU systems you need some spinning done, at least for some… it can be the problem – if transaction spawns multiple databases you need multiple log flushes on commit, plus ether you use XA… position or in another location ? Does row ever split into multiple parts like with MyISAM or always stored as single piece…
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… since 5.0.19, more about default values). For Multiple CPU boxes (4+ CPU) situation is different. In theory you could use 2… workload you could only account number of disks and for CPU bound only number of CPUs. In practice however this values… sleeping waiting to enter the queue. The scalability problems with multiple CPUs is well known bug 15815 so do not think…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… mind frequency is what defines performance. No one measures their CPU with SpecInt results or something like that. This strategy however… need people to understand you want to pay more for multiple cores and threads, not only for Ghz. Also AMD with… family. This article also has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… file when all transaction engines have their own ! Quality Assurance Multiple storage engines are much more complicated to test. And I… enough. In fact people already do not love to mix multiple storage engines very actively because of potential complications involved. Now…, it does not matter). We could save a lot of CPU cycles by having storage format same as processing format. We…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… comes from its ability to scale almost linearly using multiple CPU cores and multiple nodes in the system. The raw scan speed was… millions of rows per second (this is on rather outdated CPU I used for testing) – this means you should be able…
Post: Multiple MySQL instances on Fusion-io ioDrive
October 7, 2011 By 6 Comments
… not able to utilize all CPU and IO resources available on modern hardware. Idea is to run multiple instances of MySQL to…-up influence on results. In conclusion I can highlight: Running multiple instances shows good improvement in throughput. 1.4x-1.8x… you have sharding environment which allows you separate database into multiple instances you may try 2-4 instances setup to get…
