…for 1, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run… final result we get a maximal result of three runs. The raw numbers are available here: http://www….(more details with Jim Starkey’s comments in Part 2). There MyISAM shows bad scalability with …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… vs MyISAM vs Falcon (http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1) The difference is I… warm-up run (duration 180 sec), and then run three effective runs (duration of each is 60 sec). As the final result we get a maximal result of three runs. The raw numbers are available here: http://www.mysqlperformanceblog.com/files…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
… to “mysql.com” but links to “www.mysql.com” or “dev.mysql.com/…as “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql…keywords” on the fly. As results we now can pull up results even for youtube.com … for millions of domains. As this part worked pretty well we also decided …
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… a long time (e.g. http://www.mysqlperformanceblog.com/2010/06/15/virident-… RAID. For Virident all 1400GB shows up as one single drive so no … innodb_flush_log_at_trx_commit=1, 2. The results in this post are for …FlashMAX. DISCLOSURE: This review was done as part of our consulting practice for which …
Comment: How to find wrong indexing with glance view
August 23, 2008 By 27 Comments
… Russia as target for investigation and here is results: both conditions – 58, divorced – 623, 18th – 3000 (looks … on this column only. No, if it’s part of compound index. Why? Because more than 70% … those columns, it’s up to you decide what to do. 1. http://www.mysqlperformanceblog.com/2006/08/10/…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…, to try to clear up some of the misconceptions …IN (?” . str_repeat(‘, ?’, count($params) – 1) . “) Good suggestion, Jonathan. Since … flaw. The more difficult part is making sure to …again if you use query results in a subsequent SQL query…September 24-27. See http://www.percona.com/training/ for …
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
…: ERROR 1030 (HY000) at line 1: Got error 139 from … is version specific, see http://www.mysqlperformanceblog.com/2010/02/09…be able to store data up to that fields’ maximum allowed …columns aren’t requested as part of a row-read, …COMPRESS/UNCOMPRESS can yield great results. Finally, let me mention …
