…which is really constructed behind the scenes from the name-value tables in a complex query with many joins…is clearly better for some workloads out-of-the-box than MySQL is, especially for more complex queries. Percona is not tied to MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…is 42GB, which is…mysql> use ontime1; Database changed mysql…better than a row store for queries which access a significant amount of data. One big reason for this is…use are shown in the EC2 console. That the “private ip” field is selected…or two nodes. You should start two…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is…SELECT traffic, these same queries were responding nicely on the passive master, too. Is that all? “Buffer pool warmed up, performance is better…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…MySQL even includes a SQL statement that makes this perfectly clear: CREATE TABLE .. AS SELECT (CTAS). The results of the SELECT…or other conditions must be fully computed and stored in a temporary table before they can be accessed, which is very expensive. What is…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…is much better to use…mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select…is ALTER TABLE or similar statement, or if LOCK TABLES was used. In addition to Innodb specific information, there is generic statement information which is…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…MySQL always uses Nested Loop Join to join two or more tables. What this means is that, select rows from first table participating in the joins…Join as compared to Nested Loop Join, but for now it looks like Nested Loop Join is a much better general purpose join…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…which allows to do > $dbcon->query(“Select email from user where name=%s”,$name) – > wrapper will detect query is…using > Join. This is typical error. On other hand in MySQL you might be > better of using…
Post: Joining on range? Wrong!
May 17, 2010 By 10 Comments
…joins only. When you use a range condition on the first (or the only) table, it works as expected: EXPLAIN SELECT…Using where; Using index In this case MySQL does not print ref at all, because there is no join, however you can notice key_len is…better…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…or scan the slow log live, but that is a bit ugly solution. That is where this patch can be very useful. With simple MySQL…SELECT query transformations, joins and better filtering for the statistics Also combining these new commands with our msl patch, which…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…or recovers in some other way which is slow. This can seriously impair your performance! My only wishes for mysql…Select_full_join and 0 Sort_merge_passes though finally. What is most confidence inspiring is…
