… am not mistaken it is 25W, however Virident to provide full write performance requires 28W. And while many servers can handle…, and Virident by default uses 25W (turbo=0). To force full power, I load a driver with turbo=1. I also… are getting close. Response time: In the conclusion, from all tested cards, Virident FlashMAX shows the most stable results and the…
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… card. So I decided to run the same series of tests I did for other Flash devices. This is ioDrive2 Duo…), which can be connected together via software RAID. So I tested in two modes: single drive, and software RAID-0 over… power, which is not enough for ioDrive2 Duo to provide full performance. I mention this, as it may be challenge for…
Comment: Percona XtraDB Cluster 5.5.20 - Beta release
February 25, 2012 By 10 Comments
We’ll I’m not going to wait for 5.6, just wishing it was out already. The thing I want most is the built in Full Text indexing, of course I would probably use Sphinx for larger projects. I will be testing out 2.x (I have 1.x in production now) when I get some time (3 or 4 weeks from now).
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… number of working threads when we add nodes ? Beside cluster testing, it will also help to see an affect of having… to ~30 sec, where benchmark stops, because the queue is full. I am looking for your comments, do you find it…
Post: eWeek tests OpenSource stacks and .NET
July 17, 2006 By 7 Comments
Have you seen recent eWeek benchmarks which test OpenSource stacks and compare them to .NET ? Here is what … be doing different things internally – some could be doing live full text search indexing on update, page access statistics storage etc… of the stacks were configured, what hardware was used etc. Full disclosure report is very important component of any serious benchmark…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
As we know build in full text search is currently limited only to MyISAM search engine … was released which now provides fast and easy to use full text search solution for all storage engines. This version also… FullText search and Mnogosearch. I guess I should soon repeat tests, adding Lucene to the list for complete picture. And if…
Comment: Percona Toolkit 2.0.1 and 1.0.2 released
January 5, 2012 By 5 Comments
…, and that introduced a bug where we didn’t have full test coverage. We’ve just prepared a hot-fix release to…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 30 Comments
… (by hinting optimizer to ignore combined index) mysql [localhost] {msandbox} (test) > explain select avg(length(val)) from idxtest ignore index (combined… because there is no correlation statistics available. mysql [localhost] {msandbox} (test) > explain select avg(length(val)) from idxtest ignore index(i2… index on the second column we get a full table scan: mysql [localhost] {msandbox} (test) > explain select avg(length(val)) from idxtest…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… on replication that handles GIS indexes. HA solutions Need MyISAM Full text or GIS indexes “MySQL replication” and “Master-Master with… of concept of the technology with the hardware tested, the data imported and basic testing and documentation. A proof of concept setup… a test environment. The other type of setup we will consider is a full production setup that includes extensive testing, fire drills, full documentation…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… test I was not interesting in the full text search performance, we already know Sphinx is much faster than MySQL build in full… which means results may be approximate – this is geared towards full text search applications when exact number is not important. Sphinx… using Native API more feature full at this point but command line language is very helpful for testing and debugging purposes as…
