… the result should be (in my case) sorted by date and not by relevance. If you sort by relevance and pick up say top 200 hits you will most likely miss newer posts which… want the result to be top 200 sorted by date. For mysql fulltext that means that if each of the 10 common words…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…developers improve documentation), but finally I ended up with next load statement: /usr/local/…, 193 ] [ 1996, 221 ] [ 1997, 191 ] [ 1998, 193 ] [ 1999, 200 ] [ 2000, 231 ] [ 2002, 163 ] [ 2003, 153 ] [ 2004, 192 … 10.000 distinct values. I tried that, and it affected only these queries. Results with…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…is its flexibility but flexibility may results in complexity. With the help …vip_2_dislike_reader_vip_3 -200: reader_vip_2 reader_vip_3…=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|… The user to use when setting up replication. It is also currently used…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… in the benchmark. I got some strange results, however, which showed MySQL 5.6.10 to be much slower than MySQL 5.5.30 even with only a single connection. I felt these results warranted… 179.07 5.5.30 4G 200.87 20.53 20.36 20.35 5.6.10 4G 195.33 14.41… per run. I then rebooted the machine and fired up 5.6.10. I ran the test, and to my surprise MySQL…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…io_capacity = 200 port = 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache =… reduced single-thread performance by 5-10%. Sequential write results were a bit more interesting. With …-back cache gave an incredible performance boost – up to 33x in single-threaded workload. …
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… slower than LIMIT 0,10. It is true most users will not go further than 10 page in results, however Search Engine Bots may very well do so. I’ve seen bots looking at 200+ page… … LIMIT is – it provides scary explain statements and may end up in slow query log as query which does not use…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…localhost tpcc500w root “” 500 32 10 1800. For better understanding the results for each run, I will…200. I also enabled innodb_doublewrite. As will appear later, it is quite a critical parameter. So, the results…? This is a bummer. Throughput again jumps up and down. The dirty pages percentage is …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…have rather interesting relationship between “effort” and “result” typical application would have number of … low hanging fruits are fixed you end up with either fine tuning which gives …200 per server (space/power/admin overhead) if you have just one server optimizing your application very modest 10…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… `test2` ( -> `c` char(255) DEFAULT NULL, -> `id` int(10) unsigned NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (`id`) -> )… first corrupted row and get result in MyISAM table ? Unfortunately test2 ended up to be empty after the … we can expect this is the row between 200 and 300 and we can do bunch of…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…Dell-class server. The disks are six OCZ-VERTEX2 200-GB drives in a RAID10 array, with an …year in disk cost (up to $3000 per year now that they’ve added 10 more volumes), and is …customers running databases in various cloud services with great results. In particular, it can be made to work really…
