June 18, 2013

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

… the downsides to mysqldump is the need to scan the full tables and in turn, load that data into and pollute…’ AND ENGINE=’InnoDB’; EOF For full disclosure, here are the versions I was using on my test VM: Percona Server 5.5…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

March 29, 2013 By 10 Comments

… (search results, recent users, recent posts, etc) Full page output (relatively static pages) Full objects (user or cart object built from several… running the memcached plugin.  Here are some details about the test: Minimal hardware (vBox instances on MacBook Pro) Centos 6.4… average fetch time.  Here are the raw results from this test run (100,000 store operations, 1,000,000 fetch operations…

Filed Under: MySQL Tagged With: , , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… TokuDB. I have a particular workload I’m interested in testing – it is an insert-intensive workload (which is TokuDB’s… can’t make 5h run. After 3h the disk is full, and InnoDB data size is about 210GB with 234.238…-tk/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Is Synchronous Replication right for your app?

May 14, 2013 By 18 Comments

… still get the deadlock error. This is not implemented for full BEGIN … COMMIT multi-statement transactions since it cannot be assumed… about the tradeoffs, but we’re making them (anyone obsessively testing slave position to ensure it’s caught up with the…

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: , , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…: SELECT id, full_name, MATCH(full_name, details) AGAINST (‘+james +peterson +arizona’ IN BOOLEAN MODE) AS score FROM dir_test_myisam ORDER BY…: SELECT id, full_name, MATCH(full_name, details) AGAINST (‘+james +peterson +arizona’ IN BOOLEAN MODE) AS score FROM dir_test_innodb ORDER BY…: SELECT id, full_name, MATCH(full_name, details) AGAINST (‘+james +peterson arizona’ IN BOOLEAN MODE) AS score FROM dir_test_myisam ORDER BY…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…_test_innodb` ( `id` int(10) unsigned NOT NULL, `full_name` varchar(100) DEFAULT NULL, `details` text, PRIMARY KEY (`id`), FULLTEXT KEY `full_name` (`full….00 sec) mysql> insert into dir_test_innodb (full_name, details) SELECT reverse(full_name), details FROM dir_test_innodb WHERE id < 500000; Query…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… database changes.  This is an important consideration for choosing a full-text solution, because updating the index can become quite complex…, MemSQL supports hash indexes and skip list indexes, but not full-text indexes, so comparisons would not be meaningful. Since MemSQL… the functionality all these solutions had in common, so I tested only simple queries without customizing the indexing. Jeffrey S. asked…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Testing Virident FlashMAX 1400

May 4, 2012 By 4 Comments

… 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…

Filed Under: Benchmarks, Hardware and Storage, MySQL

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…

Filed Under: Benchmarks, Insight for Developers Tagged With:

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…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts