… 7480227.7355MYSQLParse(void*) 2197022.2720my_pthread_fastmutex_lock 2056062.1262make_join_statistics(…) 1982342.0500btr_search_guess_on_hash 1807311.8690JOIN….1.56) samples%symbol name 180544.1415String::copy(…) 142233.2627make_join_statistics(…) 119342.7376JOIN::optimize() 101402.3261my_wc_mb_latin1 71521…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… table grouping technology allowing to dramatically increase performance of complicated join queries. MySQL users are always hungry for better performance as… for Flash storage showing it is not only rotating media where Fractal Trees technology can show significant performance gains. CoderShip the…
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
September 30, 2009 By 30 Comments
…). The effect is even more dramatic when the queries have joins in them; taking the engine behavior and knowledge grid structure… joins can be extremely quick (not as quick as avoiding them, though). The more you have rows, and the more the join/where…
Comment: Why MySQL could be slow with large tables ?
May 1, 2008 By 141 Comments
…. As for Joins, its always best practice not to use joins over Large Tables. Instead use alternate Sub-queries to Joins where possible and…
Post: Join me for 'MySQL 5.6: Advantages in a Nutshell.' Webinar. March 6 at 10 a.m. PST
March 4, 2013 By Leave a Comment
… more and try it out. Reserve your spot now and join me on Wednesday by registering for this free webinar. Please… view it again, please visit the Percona MySQL Webinars page, where all of our past sessions are also available for playback…
Comment: A common problem when optimizing COUNT()
September 25, 2008 By 19 Comments
Heck knowing where a sql query is coming from is half the battle. … popularity of people doing stuff like: SELECT $fields FROM $table $join $where $order_by figuring out context is a real pain in…
Post: Joining Peter for MySQL Consulting
September 4, 2006 By 2 Comments
… need to know how MySQL performs on different platforms and where bottlenecks are to be able to offer leading experience in…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…_datekey join customer on lo_custkey = c_customerkey join supplier on lo_suppkey = s_suppkey join part on lo_partkey = p_partkey where c…_datekey join customer on lo_custkey = c_customerkey join supplier on lo_suppkey = s_suppkey join part on lo_partkey = p_partkey where c…_datekey join customer on lo_custkey = c_customerkey join supplier on lo_suppkey = s_suppkey join part on lo_partkey = p_partkey where s…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…) t JOIN (SELECT Carrier, count(*) AS c2 from ontime_fact join dim_date using(date_id) join dim_flight using(flight_id) WHERE Year…) JOIN dim_airport origin on ( origin_airport_id = origin.airport_id) JOIN dim_date using (date_id) JOIN dim_flight using (flight_id) WHERE…) JOIN dim_airport origin on ( origin_airport_id = origin.airport_id) JOIN dim_date using (date_id) JOIN dim_flight using (flight_id) WHERE…
Post: EXPLAIN EXTENDED can tell you all kinds of interesting things
June 15, 2010 By 7 Comments
… | 1003 | select ’0′ AS `c1` from `test`.`j1` join `test`.`j2` join `test`.`j3` where 0 | +——-+——+——————————————————————————-+ 1 row in set (0.00 sec… | 1003 | select ’1′ AS `c1` from `test`.`j1` join `test`.`j2` join `test`.`j3` where 1 | +——-+——+——————————————————————————-+ 1 row in set (0.00 sec…
