… heavy queries are ran in background or backup is done with mysqldump – a lot more than you would expect from simple resource… inner join innodb_sys_indexes as i using(table_id) inner join innodb_buffer_pool_pages_index as p using(index_id) where… 100 seconds for mysqldump which is a dramatic improvement of over 150x for sysbench and results now going inline with what you…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… did this preprocessing with the MyISAM storage engine, then I dumped the data to tab delimited flat files using mysqldump. I started…) 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…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…’s developers may not agree with that ) with some serious limitations (like using mysqldump for node propagation). The Galera…for MySQL users as Free / Open Source Software. “Where is the catch?”, you may ask. Yes, there… finalize this post, let me invite you to join me in testing MySQL/Galera 0.8, …
