… demonstrate how Shard-Query makes parallel set operations work, I’ll operate in only one dimension for the first example, just like the MySQL… my method. Likely current network technologies can not support such a degree. mysql> select min(id),max(id) from words; +———+———+ | min(id…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Locking was changed, starting MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL 5.5.3 Starting… No matter if a connection accesses a table that is already in the Table Cache, any query to a table that has a DDL operation waiting, will block. Why? Because MySQL…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… it works with existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This set of benchmarks evaluates how well Infobright community edition (ICE) performs in combination with Shard-Query… can’t be added. Q9 is an example of such a query. . Query details: — Q1 SELECT DayOfWeek, count(*) AS c from ontime_fact…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…mysql binary logs for point-in-time recovery after a restoring a backup. Since the backup is a essentially a…query execution time. It may be possible, therefore, to refresh an MV based on a query that takes 45 minutes to execute with a…working with the Flexviews easier, it includes a… how to create a…
Post: How to estimate query completion time in MySQL
April 22, 2008 By 16 Comments
… run a query in MySQL and wondered how long it’ll take to complete? Many people have had this experience. It’s not a big… how fast it’s working, and do the math. As an example, I recently worked on a customer’s site where a typical data-warehousing query needed optimization. It was a fact table joined to two dimension tables — a…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software … expectations about how we’ll work with you, so that we don’t enter into a business …-H benchmark queries and crashes on other queries, we will reveal that to provide a balanced review of…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…a while, use mk-query-digest to convert this into a query log, and examine the log. In MySQL…queries since its inception. That case is still open and I am still stumped as to how a…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… how the query optimizer does what it does, why it does it, and how to make it work for you. These guys are probably a… exactly how it works. These two talks would be an excellent track for anyone who does schema design and writes a lot of queries… sure when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… There is also a load aspect – “random arrivals” tell us the number of work system has to …a lot. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…as simple as how much does it cost to run a query. With Cloud Computing being hot a lot …
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… need to keep into account possible query changes, replication etc. Q: Is it… this option can help creating tables a lot faster. You can also …something substantial to gain. Q: How would Upgrade work if Old Server has Antelope…be making MySQL Replication to work. You might need to inject MySQL 5.0 in…
